My Oracle Support Banner

R12: AP: Several Hundred Payments Will not Account Because of Error: will not be acctd due to (else stmt): ORA-20001: APP-SQLAP-10000: ORA-06511: PL/SQL: cursor already open occurred (Doc ID 2503371.1)

Last updated on JUNE 09, 2023

Applies to:

Oracle Payables - Version 12.1.3 to 12.2.8 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

On :  12.1.3 version, Accounting Issues in Accounts Payable

When attempting to account payments the following error occurs.
Several hundred payments are not getting accounted.

ERROR
-----------------------
"sid:XXXXXXX: Transaction_Type AP_PAYMENTS Transaction_id =XXXXXXXXX Event_id =XXXXXXXX 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_Eventswith parameters (&PARAMETERS)
while performing the following operation:
&DEBUG_INFO"


The issue can be reproduced at will with the following steps:
1. Run Create Accounting
2. View output

Due to this issue, users cannot account several hundred payments

Changes

 

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
Changes
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.