My Oracle Support Banner

ECA: When Adjusting Accounting Distribution, The CA_LOAD_GL1 (Customer Contracts > Schedule and Process Revenue > Process Fixed Amount Revenue) Is Not Processing Revenue Due to Rounding. Revenue Plans Are Stuck in "In Progress" Status. (Doc ID 2813661.1)

Last updated on OCTOBER 12, 2021

Applies to:

PeopleSoft Enterprise FIN Contracts - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

When adjusting Accounting Distribution for an Amount-based contract line, the CA_BP_SCHEDULE is not in sync with respect to REV and UAR rows for all the events. They don't net to 0. Due to this the Revenue Plans are not getting processed and are stuck in "In Progress" status.

Replication Steps:

  1. Create a contract with an amount-based contract line. Navigation: Customer Contracts > Create and Amend > Define Contract General Info.
  2. The Amount associated with the contract is $123923.06.
  3. Do Amount allocation.
  4. Assign a milestone revenue plan and assign 13 events. For the first 12 rows, the event amount is $9532.54 and the last one has an event amount of $9532.58. Make event 3 ready.
  5. Accounting distribution for contract line is allocated to one account for 100% for revenue, contract liability, and contract assets.
  6. Activate the contract and process revenue by running CA_LOAD_GL1 (Customer Contracts > Schedule and Process Revenue > Process Fixed Amount Revenue) and then CA_LOAD_UPD (Customer Contracts > Schedule and Process Revenue > Retrieve GL Updates).
  7. Now adjust the accounting for revenue with the following percentages. Previously it was allocated to 100% for one account. Now use the percentages (100% (earlier account value), -100%(reverse), 50%, 25%, 15%, 10% for other accounts ) and save.
  8. Notice that the CA_BP_SCHDULE does not net to 0. The SQL below returns -0.01 instead of 0. This is incorrect. Please see the replication screenshots.

select sum(amount) from PS_CA_AP_SCHEDULE where CONTRACT_NUM ='XXX' and EVENT_NUM ='13'; --- The amount is not 0.

The distribution of amount for this event in PS_CA_BP_SCHEDULE is as noted below. See that they don't net to 0. This is incorrect.
-9532.58
9532.58
-953.26
-2383.15
-1429.89
-4766.29

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.