ECA: Revenue Is Not Generated For Amount Based Contract Lines. CA_LOAD_GL1 Process Message Log Says = 'Contract XXXXX, revenue plan R101 excluded from processing due to invalid accounting distributions' (Doc ID 2805024.1)

Last updated on SEPTEMBER 22, 2022

Applies to:

Symptoms

When CA_LOAD_GL1 (Customer Contracts > Schedule and Process Revenue > Process Fixed Amount Revenue) process is run for a contract that has valid accounting distributions, the process did not process the expected revenue rows. The message log shows the following message

Replication Steps:

1. Enable combination edits for the GL BU associated with the contract. In Demo - US004 Business unit for example.
2. In demo testing, the REV W/DF2 and DFR REV distribution codes are updated with invalid combinations.
3. Navigate to Customer Contracts -> Create and Amend -> General Information. Create a new contract for this BU.
4. Add a contract line with the amount based in the demo "BUILDING 2" product was used. The contract liability on the contract line is checked automatically.
5. Complete the revenue plan, bill plan, and amount allocation for the contract.
6. Go to Accounting distribution for the contract line. (Click on Distribution under the Details tab).
7. See Revenue and Distribution code are marked as Error. This is due to incorrect combinations for those distribution codes that are set up that way in Step 2.
8. Now go back to Contract Line. Under the Contract Liability tab, uncheck the Contract Liability check box.
9. The Accounting distribution now only shows the Revenue Section and Contract Asset sections. The contract liability is not applicable.
10. Correct the Revenue accounting string so that there are no combination errors. On this page, all the distributions now show as valid.
11. Check the PS_CA_DTL_DFR_SB. There are errors in this contract. This is incorrect.
12. Activate the Contract.
13. Run CA_LOAD_GL1 process.
14. Review that the process did not process any rows with a message saying that the accounting distributions are invalid. This is incorrect.

Replication Screenshots in Demo

Cause

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