Italy Localization: Cash report accounting program not showing eligible cash reports as accounted (Doc ID 2833345.1)

Last updated on JUNE 12, 2023

Applies to:

Symptoms

Problem Statement
---------------------

CLE Cash report accounting program though completed successfully find that the relevant cash reports are still showing with status as "Approved" instead of "Accounted".
These cash reports stands accounted and equally transferred to GL as well.
Because of this issue, this is preventing other cash reports to get accounted successfully though ran for different cash boxes.
When this program is ran for a new month for different cash boxes it is completing with error.
Because of this issue, unable to close the AR period.

Error message 
----------------
Note: This is observed if this program is run for subsequent month for different cash boxes.

Cause: FDPSTP failed due to ORA-20007:
ORA-06512: at "APPS.CLE_F246_CASHRPT_ACCOUNT_PKG", line 4339
ORA-06512: at "APPS.CLE_F246_CASHRPT_ACCOUNT_PKG", line 5198
ORA-06512: at line 1
.
The SQL statement being executed at the
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
This cash report cannot be accounted until the previous cash report is accounted.

Steps to replicate
--------------------
This issue cannot be replicated at will owing to data corruption.
Whereas observed when following below steps:
a. Run CLE : Cash report accounting program
b. Completed successfully and no error observed.
c. From log file find below snippet (giving sample data)
    Total number of cash documents accounted in this cash report : 74
    Number of accounting lines transferred to general ledger : 148
d. Above message in log file indicates that there are no "unaccounted" transactions.
e. But status is showing as "Approved".
f. When ran the same program again for subsequent months it is failing with above error.

Expected Behavior
---------------------
Expectation is such that upon successful completion of this program, status should get changed to "Accounted".

Changes

Cause

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