EAR9.2: When Saving Payment Worksheet Received "Item <Business Unit, Customer, Item, Line> is not yet available for payment processing(6040,903)" Error (Doc ID 2639330.1)

Last updated on JULY 22, 2024

Applies to:

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

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