AP invoice interface
Date: Mon, 14 Jun 1999 01:41:34 PDT
From: Krishna Bangalore vkkrish@hotmail.com
Subject: reg : AP invoice interface, Urgent help needed
Hi everybody,
We are working Oracle Applications 11.0.2,Windows NT 4.0 and service pack
3.
We executed our custome built interface to load AP INTERFACE tables. ).
We have put in 9 Invoices into the AP_INVOICES_INTERFACE table.
Then we tried running the PAYABLES OPEN INTERFACE IMPORT(APXIIMPT), for the
first run it produced a DR.WATSON ERROR ON R25RUN32.EXE ACCESS VIOLATION
ERROR.
We noticed that after the Dr. watson error, even though PAYABLES OPEN
INTERFACE IMPORT(APXIIMPT) is completed normal, the locks are not
released(Ref 1.0). Any subsequent run of PAYABLES OPEN INTERFACE
IMPORT(APXIIMPT) gives the following message in the log file and output
file respectively(Ref 2.0). Our assumption is that, Since the Dr. Watson
error is caused on the R25RUN32.EXE, the report(APXIIMPT.rdf) is not
executed to completion,terminated abnormally the invoices are not getting
created and also the locks are not released.
We saw the locks placed on the following tables, when the PAYABLES OPEN
INVOICE IMPORT(APXIIMPT).
SID----Username---Type--Mode------Wait--Details
---- ------------ ---- ---------- ---- -------------------------------------
13-- APPS----DML--Row-S----No---APPLSYS.FND_CONCURRENT_REQUESTS
19-- APPS----DML--Row-X----No---APPLSYS.FND_CONC_REQ_STAT
20-- APPS----DML--Row-X----No---APPLSYS.FND_CONC_REQ_STAT
21-- APPS----DML--Row-X----No---APPLSYS.FND_CONC_REQ_STAT
24-- APPS----DML--Row-S----No---AP.AP_INVOICES_ALL
24-- APPS----DML--Row-S----No---AP.AP_INVOICE_DISTRIBUTIONS_ALL
25-- APPS----DML--Row-X----No---APPS.OLAM_22002
(1.0)
Logfile
MSG MSG-00999: ORA-00054: resource busy and acquire with NOWAIT specified
MSG MSG-00999: (Import_invoice:Exception) The invoices to be selected by
this process are locked
Outputfile
Fatal Error: Program Completed with Error.
User-Defined Exception
(2.0)
v
Questions
Why is the Dr. Watson error caused on the R25RUN.EXE() , only when we run
PAYABLES OPEN INTERFACE IMPORT(APXIIMPT).
This is causing a major problem. Can any of you help us on this issue.
Any help is greatly appreciated.
Regards
Krishna
vkkrish@hotmail.com
AP-Reconciliation Manually..?
Date: Tue, 15 Jun 1999 14:43:27 -0700 (PDT)
From: Prasanna Ramam sukkuv@yahoo.com
Subject: AP-Reconciliation Manually..?
Hi
Can anyone pls solve the follwoing problem ?
1. Trying to reconcile the payments( checks) manually
thru reconciliation manual form
2. Chose the option 'NO' ( for range reconcialiation )
3. entered the required values in the header block
4. In the detail block I want to clear one check,
so entered the range as for ex : 1300 to 1300 and pressed entered..
Its giving the following msg : 'APP-10166 Validating accounting period
status.. pls wait..'
What does it mean ? Is it error msg ?
When I run 'Payment exceptions report' the previously entered check
should not appear in the report . But its still appearing ..
6. What fields are updated if I do "reconciliation Payments"?
Can anyone pls help me to solve these issues!
Rgds
Prasanna
ZERO CHECKS
Date: Wed, 16 Jun 1999 11:01:22 -0400
From: Melanie Jubinville Melanie.Jubinville@future.ca
Subject: AP*** ZERO CHECKS
Hi,
We are currently running on 10.7 Character.
In the Bank Account setup, we have the ALLOW ZERO CHECK to Yes.
When we do a checkrun and if for a particular vendor, we have more credits
than invoices, the system changes the amount of the credits to equal to
amount of the invoices so it can cut a zero check.
Does anybody know why it does that ??? Now, we have a problem
because when we ran the AP Transfer to the GL, we do not balance by 4620.68.
My GL is higher by this amount, it looks like it does take in consideration
that I still have an outstanding credit of 4620.68. When I query this
credit, it shows as Partially Paid.
Any idea ???
Thank you
Melanie Jubinville
Financial System Analyst
Problem with quick payments
Date: Thu, 17 Jun 1999 09:13:09 +0200
From: Warwick Gill WarwickG@langeberg.co.za
Subject: AP: Problem with quick payments
Hi
We are having a problem creating quick payments using a customised EFT
payment format. The problem is that sometimes the quick payment works
without a hitch and at other times it errors out with the following message:
"APP-10056: Payables is unable to submit your concurrent request. Contact
the system administrator." I have tried changing the way in which the
payment format is set up within Oracle and this sometimes has the effect of
correcting the problem for one or two payment batches but then it recurs.
I have used this customised payment format at more than one site and it
causes problems at all of them some of the time. As an example of how
totally unpredictable the quick payments are: At the current site, we have
eight bank accounts requiring an EFT payment format. The formats for each
account are identical except for the bank account they reference. They have
been set up identically within Oracle and some work for quick payments while
others don't.
If you have experienced problems like this or have any suggestions, please
let me know.
Thanking you in advance.
Warwick
Autoselect on Payment Batches
Date: Fri, 18 Jun 99 15:55:07 -0700
From: oracleapps oracleapps@leco.com
Subject: AP Autoselect on Payment Batches
Hello all, 10.7NCA, Prod16.1
We have entered, distributed and approved an Invoice batch (ABC6-18-99).
Then we created a payment batch (XYZ6-18-99) with a pay through of
03-JUL-99, all pay groups and 1-99 priorities, computer generated form feed
checks (reserves ok)...
When we run the Select and Build (Standard Oracle Build Process) processes under
the actions function our Autoselect job completes normal but reports the
following meesages "No payment batch exists with the name (XYZ6-18-99)".
It does not select any of our invoice batches.
Any direction as to what settings we may have wrong? Our is this a known Oracle
problem.
All the terms are Net 30, and the supplier settings look correct.
Thanks in advance.
Jody R. Michaels
LECO Corporation
616-982-2288
Jody_Michaels@Leco.com
Date: Fri, 18 Jun 1999 15:32:07 -0500
From: "Puchniak, Stan" Stan_Puchniak@standardaero.ca
Subject: Re:AP Autoselect on Payment Batches
Have you reviewed the payment chedule for a sample of invoices? Please post
your findings to the listserver. This may shed some light on your problem.
Stan
Correction in approved and posted inv. batch
Date: Mon, 21 Jun 1999 13:07:55 -0600
From: Beth.Gonzalez@Level3.com
Subject: AP: Invoice Batch
Last month we had several accounts payable invoice batches that were input,
approved, paid, and transferred to gl with the incorrect liability account.
Our analyst over-wrote the liability account at the batch level.
We would like to correct the account in AP to insure that the subsidiary
ledger and the general ledger remain in balance. (Our last resort is a GL
entry.) Does anyone know if this can be corrected through AP? If so, how?
Thank you,
Beth Gonzalez
ERP Support Manager
Level 3 Communications
beth.gonzalez@level3.com
Check printing
Date: Thu, 24 Jun 1999 16:05:56 -0500
From: Oracle Help OracleHelp@infousa.com
Subject: help
I am new to this forum and need some help. I have created a batch of
recurring payments. Everything is fine till we go to print the checks. In
the invoice section of the check it is pulling the template definition name
followed by a dash and attaching the system name from the special calendar,
it looks like this kell1-JUN-99 For some reason the checkguard
system that we use (Bottom Line) does not recognize this and the checks will
not print (for the recurring only). Is there a was in Oracle to change the
dashes to underscores? We are running on 11.0.1
Any help is appreciated
Steph
infoUSA
email oraclehelp@infousa.com
Global Attribute Cols Validation on Inv. Import
Date: Fri, 25 Jun 1999 09:26:46 -0400
From: "Devulapally, Sridhar, CFCTR" sdevul0458@att.com
Subject: GLOBAL ATTRIBUTE COLUMNS VALIDATION on Invoice Import
Hi
Can someone help me with this. The new patch set Q for Payables Open
Interface Import (APXIIMPT.rdf) has
Validations on the global_attribute categories for both the
AP_INVOICES_INTERFACE and AP_INVOICE_LINES_INTERFACE.
My client has to use some global_attribute categories for carrying
additional data. However with the new package
JG_GLOBE_FLEX_VAL.CHECK_ATTR_VAL the import program is failing.
If anybody has any suggestions on how to make this work, without commenting
out the validation code, which I already did and am overlooking the code and
that works fine. However I need any quick FIXES for the global_attribute
columns.
Thanks in advance for your help in this matter.
Regards,
Sridhar Reddy
(407) 858-7610
dev_sri@hotmail.com mailto:dev_sri@hotmail.com
sdevul0458@att.com mailto:sdevul0458@att.com
Withholding Tax - Tax Authority Remittance Advice
Date: Fri, 25 Jun 1999 13:08:40 -0400 (EDT)
From: Leanne Andre CMCILMA@NJTRANSIT.STATE.NJ.US
Subject: AP: Tax Authority Remittance Advice
Hello everyone:
Is anyone using the standard "Tax Authority Remittance Advice" in Oracle for
withholding taxes?
We are on 10.7 NCA. I have set up a new payment format with the "Tax Authority
Remittance Advice" selected in the "Separate Remittance Advice" field. I am
able to format the payments properly, but the Withholding Tax Authority
Remittance Advice process ends in error. The log file contains the following
error messages:
+-----------------------------|
Starting concurrent program execution...
+-----------------------------
Arguments
------------
P_CHECKRUN_NAME="Quick Payment: ID=10519"
------------
Execution options
P_AWT_Report="AWT4"
GetFileName: error querying HKEY_PERFORMANCE_DATA
usdgpios: error getting process file name for id: 1287:
The data area passed to a system call is toosmall.
usdipe: error getting current process information
usdsop: Error inserting into FND_CONC_NT_PROCESSES:
The data area passed to a system call is toosmall.
LOG :
Report: e:\applr107\ap\8.0\srw\APXWTGNR.rdf
Logged onto server:
Username:
LOG :
Logged onto server: FMCC
Username: APPS
MSG MSG-00001: After SRWINIT
MSG MSG-00000: After Custom_Init placed in AFTER FORM
ERR REP-1212: Object 'M_AWT1' is not fully enclosed by its enclosing object
'Body'.
APP-00931 Program exited with status 1
APP-01125 Concurrent Manager got error running Oracle Reports for request 16013
Has anyone else encountered this problem? Thanks in advance for any help,
Leanne
Invoice Audit Listing by Voucher Number Report
Date: Sat, 26 Jun 1999 11:57:28 +0400
From: Chetan Banglorewala ChetanB@allied-medical.co.ae
Cc: Hariharaprsad hariharaprasa7@hotmail.com
Subject: Re - AP Invoice Audit Listing by Voucher Number Report
Hi All,
We are working on 10.7 SC16.1 . I have the following query regarding AP
Standard Reports;
I have enabled document sequences for the Payables Module. The system is
generating the voucher number when I enter the invoices/payments using the
sequences defined and assigned to various categories.
I want to generate the Standard report - Invoice Audit Listing by Voucher
Number. One of the required parameter for this report is the Sequence Name,
to be selected from List of Values. However, when I press the LOV, the
system prompts as ' NO ENTRIES FOUND FOR LIST OF VALUES'.
I checked the Sequence definition form and no field exists for enabling
audit, etc. Am I missing any
set up anywhere.
Regards,
Chetan Banglorewala
System crash during batch pmnt confirmation
Date: Wed, 30 Jun 1999 14:57:04 +0200
From: Warwick Gill WarwickG@langeberg.co.za
Subject: URGENT: System crash during payment batch confirmation
Hi all
We are having a problem confirming two payment batches at the moment. It
appears that what has happened is that they were being confirmed at the time
that the server went down. As a result, the payment status has been set to
confirming. There seems to be no record of the request for the batch
confirmation and we cannot cancel the batch. This means that the payables
documents that were being used for the payments are being held by the
batches and cannot be re-used. We need to get these payments off as soon as
possible.
Thanks in advance
Warwick
Journal with GL details report
Date: Tue, 6 Jul 1999 18:46:12 +0200
From: Mike Bennet MikeB@langeberg.co.za
Subject: AP: Journal with GL details report
Hi
We are on 10.7 NCA
We have run a report in Payables called "Journal with GL details" report for
a particular vendor. (in GL transaction date sequence)
I note that the report includes Journal totals after groups of entries to a
particular General Ledger account which sometimes do not tie into the total
of the transactions preceding the Journal totals.
Has anyone had such an experience with this report?
Regards
Mike
Report - true outstanding of issued checks
Date: Wed, 7 Jul 1999 14:34:14 -0400
From: Ann_Whiting@ncci.com
Subject: Accounts Payable R10.7SC
When we reconcile the Bank statement to the general ledger for our Operating
Account we run a payment exception report which lists all the outstanding checks
issued. This report seems to be a point in time report and can not be reran for
prior months. The report changes every time you void a check that is in a prior
period. Is there another report that can be run to provide a true outstanding
of issued checks for a particular time period? We are on R10.7 SC.