E1: 52: Contract Billing Invoice Generation (R52121) not Including Missed Prior Retainage Using Cumulative Retainage on Billing Lines With No Current Amount (Doc ID 2972084.1)

Last updated on FEBRUARY 22, 2024

Applies to:

Symptoms

When running Contract Billing Invoice Generation (R52121) either in batch or interactively (P48221, P48222, P52121) and where a Cumulative Retainage Rule is used, the system will calculate missed prior retainage only if there is a current net amount. If a Billing Line has a prior amount where retainage was missed but the current application has no current amount, the system will not perform a cumulative retainage calculation.

Steps
1. Create a Contract Master (P5201) that has a Retainage Rule (e.g., 10% retainage).
2. Create a Lump Sum Billing Line (P5202) with a Schedule of Values
3. Create an interactive batch and invoice for the contract (P48221, P48222, P52121).
4. Select the detail line in Work with Invoices (P48222) and select the line in Billing Line Inquiry (P5222, P52221).
5. In Billing Line Revisions, enter a Net Amount but do not enter retainage.
6. Create A/R for the invoice batch
7. Run Contract Billing Invoice Generation (R52121) over the contract where amounts are initialized to zero.
8. Inquire on the invoice in Billing Line Inquiry (P5222). Notice that the system did not calculate Retainage Amount Current based on the Amount to Date for cumulative retainage.
9. Select the Billing Line (P5222 to P52221) and enter a small current amount (e.g, 0.01).
10. Take the form exit to Retainage Recalc. Notice that the system calculates retainage cumulatively now that there is a non-zero value in Net Amount Current.

Changes

Cause

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