My Oracle Support Banner

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:

  1. Log into Oracle Applicaitons using a Payables responsibility.
  2. Open the Standard Request Submission (SRS) form
    (N) Other > Requests > Run
  3. Submit the Create Accounting Program for Payment
  4. 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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.