R12: AP: Payment Accounting Error:ORA-20001: APP-SQLAP-10000: User-Defined Exception occurred in AP_Acctg_Pay_Dist_Pkg.Primary_Pay_Events<- AP_Accounting_Pay_Pkg
(Doc ID 2213956.1)
Last updated on AUGUST 30, 2023
Applies to:
Oracle Payables - Version 12.1.3 to 12.1.3 [Release 12.1]Information in this document applies to any platform.
Symptoms
The Create Accounting Program is not generating accounting for Payment Event Class.
The program gets completed successfully however log file from Accounting Program is giving below error:
Transaction_Type AP_PAYMENTS Transaction_id = CCCCC Event_id =xxxx will not be acctd due to (else stmt): ORA-20001: APP-SQLAP-10000: User-Defined Exception occurred in
AP_Acctg_Pay_Dist_Pkg.Primary_Pay_Events<- AP_Accounting_Pay_Pkg.Do_Pay_Accounting<- AP_SLA_PROCESSING_PKG.EXTRACT
Transaction_Type AP_PAYMENTS Transaction_id =yyyy Event_id =yyy will not be acctd due to (else stmt): ORA-20001: APP-SQLAP-10000: ORA-06511: PL/SQL: cursor already open occurred in AP_Acctg_Pay_Dist_Pkg.Primary_Pay_Events<- AP_Accounting_Pay_Pkg.Do_Pay_Accounting<- AP_SLA_PROCESSING_PKG.EXTRACT
Master GDF Analyzer (MGDF) can not find any records about first check_ID CCCCC, mentioned in the error message.
EBS AP and eBTax Analyzer generates No data for Check_ID CCCCC.
Steps to reproduce:
- Log into Oracle Applicaitons using a Payables responsibility.
- Open the Standard Request Submission (SRS) form
(N) Other > Requests > Run - Submit the Create Accounting Program for Payment
- Requests completes successfully but Log file shows the error outlined.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |