EAR9.2: When Saving Payment Worksheet Received "Item 'BU value', 'Customer ID', 'Item ID', 'Item Line', does not have a corresponding revenue row in contracts. (6040,903)" Error
(Doc ID 2639330.1)
Last updated on SEPTEMBER 16, 2024
Applies to:
PeopleSoft Enterprise FIN Receivables - Version 9.2 to 9.2 [Release 9]Information in this document applies to any platform.
Symptoms
When attempting to save a Payment Worksheet having an item generated from an Amount-based Contract line with Revenue method selected as 'Billing Manages Revenue', following error occurs
Steps to replicate:
1. Create a proposal.
2. Generate an award.
3. Contract should be fixed price with revenue as billing manages revenue.
4. Create an event on the billing plan.
5. Run process other billing method.
6. Run interface id obtained from the above step.
7. Approve temporary invoice generated.
8. Run single action job to finalize the invoice. The single action should include load to GL and load to AR. IF not included run them separately.
9. In AR go to payments and then apply payments.
10. Create worksheet.
11. Build worksheet.
12. Select the fixed price invoice created in the above steps and change the amount if needed.
13. Try to save the worksheet and reproduce the error.
For detailed replication steps please refer attachment.
Note:- This issue does not happen if Item is generated from a rate-based contract line (revenue is stored in the CA_ACCTG_LN_PC table).
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 |