My Oracle Support Banner

Autoreconciliation Fails With Error ORA-01002 ORA-06512 (Doc ID 1983000.1)

Last updated on FEBRUARY 12, 2019

Applies to:

Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Reconciliation and Clearing

When attempting to run the process Autoreconciliation ,
the following error occurs.

ERROR
-----------------------
ORACLE error 1002 in FDPSTP
Cause: FDPSTP failed due to ORA-01002: fetch out of sequence
ORA-06512: at "APPS.CE_AUTO_BANK_REC", line 499
ORA-06512: at line 1

The SQL statement being executed at the time of the error was: SELECT R.Conc_Login_Id, R.Requ

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Responsibility: Cash Management - 12.1.3
Patch applied:
19149948:R12.CE.B - R12.1: Cash Management Recommended Patch Collection (RPC), August, 2014

2. Path: Other -> Requests -> Run
3. Run the AutoReconciliation (ARPLABRC)

After trying to run the process Autoreconciliation for the last 5 dates,
the following error occurs:

ARPLABRC module: AutoReconciliation

ORACLE error 1002 in FDPSTP

Cause: FDPSTP failed due to ORA-01002: fetch out of sequence
ORA-06512: at "APPS.CE_AUTO_BANK_REC", line 508
ORA-06512: at line 1


The user cannot reconcile receipts miscellaneous and take a lot of time to reconcile manual payments and receipts.


4. Detected the issue occurs when there is a GLcombination deactivated matched to Bank transaction code - AR Activity.
Need an error message when run AutoReconciliation request related with GL combination deactivated.



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
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
References


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