ECA 9.2 : When Triggering the “Process Fixed Amount Revenue” Process (CA_LOAD_GL1) To Process Revenue Accounting, The Message Log Shows an Incorrect Number of Rows Processed. (Doc ID 2941766.1)

Last updated on APRIL 13, 2023

Applies to:

Symptoms

When triggering the “process fixed amount revenue” process (CA_LOAD_GL1) To process revenue accounting, the message log shows an incorrect number of rows processed. Irrespective of the number of entries generated in the accounting line table, it is always showing an entry of 1 in the message log. This is incorrect.

Replication Steps:

1. Create a Contract with Amount based contract lines.
2. Associate a Bill Plan and revenue plans with multiple events.
3. Complete all necessary requirements associated with the contract and make the contract active.
4. Make 4 revenue plan events active for the revenue plan associated with the contract.
5. Run the CA_LOAD_GL1 process (Customer Contracts > Schedule and Process Revenue > Process Fixed Amount Revenue).
6. Notice that there are more rows inserted in the CA_ACCTG_LINE table and yet the message log for the process shows the message as "There were 1 Revenue Row(s) created in the accounting line table".

Replication document

Cause

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