OCR Invoice - import and quickmatch
Date: Wed, 18 Aug 1999 14:51:25 -0400 (EDT)
From: Leanne Andre CMCILMA@NJTRANSIT.STATE.NJ.US
To: OraApps-L@cpa.qc.ca
Subject: AP: Importing OCR Invoices / Automatic Matching
Hello everyone,
My client has a requirement "to automatically clear an invoice for payment
if
the invoice total equals the fully receipted PO total (line item entry not
required)". To meet this requirement, we demonstrated the "QuickMatch"
invoice
type which automatically fully matches an invoice to all shipments on a
specified PO.
The client is not totally happy with this solution since they had envisioned
a
solution with NO human intervention after the invoice information is
entered.
The Quickmatch solution, however, requires that they hit the Match button
twice. This does not seem like a substantial effort so we are sticking with
that solution.
Now the problem we are facing is that they also want this solution to apply
to
invoices which are processed through OCR. I have a few questions in this
regard:
1. First of all, when we import invoices from the OCR system, I assume that
we
will just be importing the invoice information and that the distribution
information will have to be keyed in once the invoice is in Oracle. Is that
a
correct assumption? Is anyone using OCR? How does it work for you?
2. When we import the invoices from the OCR system, I believe we can only
import them as Standard invoice types. Is there any way to import them as
"QuickMatch" type?
3. Is there any way to kick off the "QuickMatch" process automatically when
invoices are imported?
We are trying to minimize the customization used to meet this requirement.
I
realize that a huge customization could be used but we are trying to find a
simple solution...if it exists...
Any ideas or feedback are greatly appreciated.
Thanks,
Leanne
Cheque printing and Patch S
Date: Tue, 17 Aug 1999 19:47:00 +0100
From: "Walsh, Patrick" walshpj@NAVCANADA.CA
To: "'OraApps-L@cpa.qc.ca'" OraApps-L@cpa.qc.ca
Subject: Cheque printing and Patch S
We have just installed Patch S on Character 10.7 Accounts Payable (for EDI
Gateway patches). We are now unable to produce cheques on our Certex
Cheque-Writer. There seems to be a problem with the Set up in AP. Has anyone
seen this before and do you have a fix?
Thanks
Patrick J. Walsh
Manager Service Delivery (Applications)
NAV CANADA
walshpj@navcanada.ca
613-563-5865
Organization setup problem in AP
Date: Fri, 20 Aug 1999 09:46:16 +0530
From: arindam.sarkar@in.pwcglobal.com
To: oraapps-l@cpa.qc.ca
Subject: Problem with Organisation setup in AP
Hi,
we are using Oracle Apps Release 11.01 on Sun OS. I am facing some problem
in setting up Organisation in AP. The default Oracle Organisation "Setup
Business Group" is not defaulting on the screen though data exists in the
HR_ALL_ORGANISATION_UNIT. We are setting up AP under multiorg environment,
so this is a necessary step in setup. Any help will be highly appreciated.
regards
Ari.
Approvals - run multiple Payables
Date: Mon, 23 Aug 1999 02:36:00 -0400
From: "Ribeiro, Alan" aribeiro@deloitte.ca
To: "\"Multiple recipients of list\" " oraapps-l@cpa.qc.ca
Subject: Payables Approval
Is it possible to run multiple Payables Approval jobs concurrently in
10.7NCA or Version 11? Work arounds? or other suggestions are
appreciated.
In our implementation we import approximately 300,000 payables
invoices a day. We are currently incurring a significant bottleneck
due to the inability to run the approval of multiple batches
concurrently.
Thanks
Alan
Set of Books - AP in multiple
Date: Mon, 23 Aug 1999 13:38:01 +0500
From: fariha afreen fafreen@ora-tech.com
To: Multiple recipients of list oraapps-l@cpa.qc.ca
Subject: AP: Multiple set of books
Hi,
We have eight set of books at one of our clients (release 11). Now,they
want Payables as well.As far as my knowledge is concerned,only one set
of books can be attached to Oracle Payables.
My question is, is it possible to attach payables to all set of books
(especially if there is no centralised disbursement).Has anyone come
across this scenario before???
Any help would be greatly appreciated.
regards,
fariha
Date: Mon, 23 Aug 1999 02:56:11 PDT
From: "ravi chandran" johnny_ravi@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: Re: AP: Multiple set of books
fariha,
you have to create 8 responsibilties and attach each set of books to them.
ravi
Date: Mon, 23 Aug 1999 10:02:17 GMT
From: ksanjay@punjlloyd.com
To: oraapps-l@cpa.qc.ca
Subject: Re: AP: Multiple set of books
We can attach multiple no. of books in GL only, not in Oracle Payables.
K.Sanjay
Date: Mon, 23 Aug 1999 12:01:40 +0200
From: Gorre Richard GorreR@fnherstal.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Multiple set of books
Hi
Are you using Multi org ?
If yest AP is defining at Operating unit level and you have to define =
at
this level other modules (AP, AR, INV, GL, etc..)
The set up must be done for each operating unit
Richard
LOV for sites not defaulting to Inv entry screen
Date: Mon, 23 Aug 1999 16:38:30 +0530
From: arindam.sarkar@in.pwcglobal.com
To: OraApps-L@cpa.qc.ca
Subject: LOV for sites not defaulting to Invoice entry screen of AP.
Hi.
We are using Oracle R11.0.1 on Sun OS. I have setup Accounts Payables with
the following options:
1 Supplier Numbering is automatic and numeric.
2Invoices to be entered in batches.
Next when I am trying to enter Invoice in a new batch, after I have entered
supplier name and navigated to the Supplier Sites field, system is giving
me an error "FRM 40502: Oracle Error: unable to read list of values".
History of the error gives the following : "ORA 00904: invalid column
name". I am unable to enter invoices in AP. Can anybody shed light on the
problem?
regards
arindam
Date: Mon, 23 Aug 1999 10:23:00 EDT
From: "Senthil Anand" sa272@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: Re: LOV for sites not defaulting to Invoice entry screen of AP.
Hi,
where r u in - tseting or production? If ur set up is incomplete u get this
problems.. particularly in Multi Org if ur accounts are not defined properly
in setup
Senthil
Date: Tue, 24 Aug 1999 09:37:54 +0530
From: arindam.sarkar@in.pwcglobal.com
To: oraapps-l@cpa.qc.ca
Subject: Re: LOV for sites not defaulting to Invoice entry screen of AP.
We are in testing instance. Do you have any idea regarding what the problem
might be and possible solution?......
ari.
Date: Tue, 24 Aug 1999 09:17:33 EDT
From: "Senthil Anand" sa272@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: Re: LOV for sites not defaulting to Invoice entry screen of AP.
Hi,
I am not about in R11. But in 10.7 , If in Multi Org, when we model the
system, similar problems could be because improper setups or if repliacte
seed data program of Multiorg is not run from sysadmn.
Try and check that all the previous steps in the setups are done properly
Senthil
Invoice Import thru interface - Lookup codes fields
Date: Wed, 25 Aug 1999 01:50:46 MYT-8
From: philip@aleytys.pc.my
Subject: AP: (10.7SC) Invoice Import through interface tables:
Dear List members,
My programmer is trying to bring in invoices from our legacy system into
the AP system through the documented interface tables:
AP_EXPENSE_REPORT_HEADERS_ALL and AP_EXPENSE_REPORT_LINES_ALL.
We are populating all the required columns as documented in the Open
Interface manual. However we are getting "Missing Expense Account"
errors on ALL our interface lines. We are sure we are populating all the
required CCIDs.
Customer support claims that this error message indicates that the
structure of the lookup code fields have changed since 9.4. What lookup
codes? I can't see any required lookup codes in the interface manual.
Suggestions anybody?
Philip
Date: Tue, 24 Aug 1999 12:32:55 -0700 (PDT)
From: Andy Schindler aschindl@yahoo.com
Subject: Re: AP: (10.7SC) Invoice Import through interface tables:
Philip, There are two CCID's that must be filled in.
Column ACCTS_PAY_CODE_COMBINATION_ID in the headers
table should be the AP liability account as setup in
AP.
Column CODE_COMBINATION_ID in the lines table is the
actual expense account.
I have had problems with the AP Invoice import because
of misspellings in the LINE_TYPE_LOOKUP_CODE column in
the lines table. It should be "MISCELLANEOUS" to
match the seeded lookup code in 10.7. This may be
what support was referring to.
Andy Schindler
NRC, Inc
Date: Tue, 24 Aug 1999 12:58:58 PDT
From: "Prasanna Kumar Jena" pk_jena@hotmail.com
Subject: Re: AP: (10.7SC) Invoice Import through interface tables:
Dear Philip,
I hope, you are sure that either
EMPLOYEE_CCID or
ACCTS_PAY_CODE_COMBINATION_ID
is populated for all the records in
AP_EXPENSE_REPORT_HEADERS_ALL table.
Prasanna Jena
Date: Wed, 25 Aug 1999 08:52:00 -0500
From: Oracle - Kathy Farmer oracleadmin@co.scott.mn.us
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: AP: (10.7SC) Invoice Import through interface tables:
Philip:
We are also 10.7SC and import invoices daily. I discussed your problem with
our tech person. She suggested the following questions:
Can invoices be successfully keyed in AP?
Does the code combo exists AND is it enabled for the dates of the data? If
no code combinations exists in the table (even if you have dynamic insertion
turned on), the lines will fail.
Is the expense account also filled in at the line level?
Another thought is to close your TAR and re-open it - you might get a more
knowledgable and helpful support person.
Kathy Farmer
Scott County
Date: Thu, 26 Aug 1999 00:15:25 MYT-8
From: philip@aleytys.pc.my
Subject: RE: AP: (10.7SC) Invoice Import through interface tables:
On 25 Aug 99 at 8:10, Oracle - Kathy Farmer wrote:
Can invoices be successfully keyed in AP?
Yes
Does the code combo exists AND is it enabled for the dates of the data?
Yes
Is the expense account also filled in at the line level?
Yes
I think Andy is on to something when he mentioned the line type. I
escalated it to Oracle World Wide and they had me do a select from
AP_LOOKUPS.
Another thought is to close your TAR and re-open it - you might get a more
knowledgable and helpful support person.
Oracle Malaysia's Customer Support are good people, but they are a rather
small pool and by now we know them all (The financials team anyway) by
name. Closing the TAR and calling up again gets you the same person 9
out of 10 times. I think when you key in your CSI number the system
routes you to your favourite support person or something. And when the
inventory expert goes on leave or for training, your questions get
unanswered for a few days (unless you escalate it).
Mercy from support just emailed to tell me she will be away for most of
September. Since we are going live with 10.7 on the 1st, my heart just
went THUMPTHUMPTHUMP.
Philip
Data entry in NCA very slow
Date: Wed, 25 Aug 1999 14:14:05 -0600
From: Alex Waddell alex.waddell@shaw.ca
Subject: AP: Solutions to data entry issues within NCA
Hi members
I am wondering if anyone has come up with some clever solutions to
the not-so-simple problem of data entry within NCA. We have been live on
10.7 NCA for one year now and I fear we are becoming apathetic to the
performance issue for our data entry users since implementing Oracle
Financials.
We are operating on mid-generation Pentiums with 64MG of ram - well
above Oracle's minimum requirements, but still below what a power user would
ideally like to run Oracle. However, due to cost, we would like to leave PC
upgrading as a very last resort.
I am hoping that someone has seen customized forms (or
even....Oracle supported forms...) that speed data entry - perhaps something
where invoice header and distributions are on the same screen (would reduce
significantly the delays in waiting for forms to refresh). Even within the
same form though, we find that NCA is not condusive to allowing 'key ahead'
data entry.
So at the risk of opening a can of worms, or getting my head bitten
off for casting any aspersions on NCA technology - my hope is that, even
recently, someone has come up with a "better form" or a better system for
getting their invoices into their Java based Financials. It just seems plain
dumb for us to have 15 data entry people, each with the capacity to key over
30,000 keystrokes an hours, but instead them having to stop for a sip of
coffee after each invoice line.
hmmmm...used to be that our data entry people had the piece of junk
computers....what went wrong?????
Any ideas?
Alex
PS. - Is anyone still using character forms for their data entry and GUI for
their accounting/operational users?
Alex Waddell
Financial System Administrator
Shaw Communications Inc.
Phone: (403) 750-4709
Fax: (403) 750-4505
Date: Wed, 25 Aug 1999 15:50:44 -0500
From: "Stobbe, John" jstobbe@MarkAndy.com
Subject: RE: Solutions to data entry issues within NCA
I hope someone has a solution. We cannot get response time even close to
character mode with 450 PIII's with 128 MB Ram and 100mbs Network Interface
at the client. We are trying to migrate from 10.7 character to 10.7 NCA in
preparation to move to 11.0 next year. Most of our people are dragging
their heels because of the productivity hit
Date: Wed, 25 Aug 1999 17:02:33 -0400
From: "Maliszewski, Joseph" Joseph.Maliszewski@FMR.COM
Subject: RE: Solutions to data entry issues within NCA
I was waiting for someone else to reply but no one seems to be dong that. So
I'll go out on a limb and try.
I would NOT recommend modifying the Invoice Workbench.
I have seen this form take forever to load and process and I have also seen
it fly. The biggest factors are hardware and network performance.
To address the hardware, Pentium 200 should be sufficient. 64mb or RAM is
marginal. It depends if you are NT or 95/98. It also depends if you are
running other applications and how many Oracle windows the user has open.
Remember, hardware is cheap. I am sure you can do a cost justification if
the system is really that slow. How much are you paying in overtime each
month??
Network? Well, only your engineers can figure out the problem there. That
certainly is not my expertise. It makes a HUGE difference though.
10.7 is your last chance at character. In 11 it goes away all together.
But yes, people do use character and NCA in 10.7.
What went wrong? well, that's technology for you. There are ways to
increase the efficiency. You just need more technology. And a better way
is getting suppliers to use EDI.
Regards,
Joe Maliszewski
Consultant
Date: Wed, 25 Aug 1999 17:08:29 -0400
From: "Maliszewski, Joseph" Joseph.Maliszewski@FMR.COM
Subject: RE: Solutions to data entry issues within NCA
As I said in the previous email, network performance means a lot.
Just because you have 100mbs NIC does not mean the rest of the network is up
to snuff. Check the network first. As I said in the last email. I have
seen it as slow as molasses in winter and I have seen it fly. Now, I have
never seen it as fast as character but that is just a price you pay.
As far as productivity goes, train your users not to use the mouse as much
as possible. That is a big slow down. I have done a good amount of
training and it really slows things down.
Cheers,
Joe Maliszewski
Consultant
BACS - using
Date: Wed, 25 Aug 1999 08:54:29 +0200
From: Noga Oppenheim NOGAO@Amdocs.com
Subject: BACS
Hi,
Can anybody help us with using Bacs (UK) with Oracle Application, AP. Ver.
11.0.2 ?
Thanks,
Date: Wed, 25 Aug 1999 08:30:21 +0200
From: Gorre Richard GorreR@fnherstal.com
Subject: RE: BACS
HI
Bacs is in the globalization a payment format to create bank file in the
rigth format.
Is part of the standard
We are currently implementing AP in UK, but bacs is not yet tested
Best regards
Richard
Date: Wed, 25 Aug 1999 20:32:37 -0700
From: "Mohan Iyer" miyer@fortuna.com
Subject: RE: BACS
What help do you require we are using Apps vr 11.0.2 and have a custom EFT
for the UK. This is because the standard one in Oracle is not acceptable by
the Bank that the company I work for uses!
Thanks,
Mohan Iyer
Financials Consultant
Sunnyvale, CA
Date: Thu, 26 Aug 1999 09:06:35 +0200
From: Gorre Richard GorreR@fnherstal.com
Subject: RE: BACS
Hi Mohan
I saw your answer regarding the BACS EFT format.
We are currently implementing financial in UK and as we need Bacs payment,
we checked globalization
and the conclusion was: not an issue; standard feature.
Could you please provide more information to help us to analyze if BACS
format will be convenient or not for
our bank.
Thanks
Richard
Cancellation of AP Batch - errors
Date: Thu, 26 Aug 1999 12:48:07 PDT
From: "prince suthakar" prince_sutha@hotmail.com
Subject: AP-error
Hello,
I am gettting error when i cancel the ap-batch.
App-1000: ORA-20001 :- Occurred in
AP_conc_prog_pkg.Pay_batch_requests_finished- APXPAWKB
with parameters(CHECKRUN_NAME= AP-TEST-ACH)
while performing the following operation:
Get payment batch concurrent request status;
we are in 10.7 sc
Any one face this error, please help me out.
Thanks
prince
Date: Fri, 27 Aug 1999 21:47:30 PDT
From: "ravi chandran" johnny_ravi@hotmail.com
Subject: Re: AP-error
prince,
while creating the payment batch did you specify the payment method as
check??
Ravi
Date: Mon, 30 Aug 1999 06:22:00 PDT
From: "prince suthakar" prince_sutha@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: Re: AP-error
Thanks, This problem solved by oracle. some Patch problem.
AP - PA interface gives Burdening Inv Item error
Date: Fri, 27 Aug 1999 17:26:26 -0700
From: Padma Ayyadurai payyadur@etec.com
Subject: Transfer Vendor Inv Exceptions
All:
When I do the Ap to PA interface, there are records rejected with mesg
' Error while burdening invoice item'.
I checked the pr/task status. They are active(no end dates).
Could anyone of you tell me what are the other places I need to look
into?
Any help would be appreciated.
Thanks in advance.
Padma