E1: 52: Retainage not Calculated on Contract Billing Line (P5202) Where Schedule of Values is Exceeded (P5222/R52121/P5204) (Doc ID 2969911.1)

Last updated on AUGUST 23, 2023

Applies to:

Symptoms

After entering billing applications with retainage on a Contract Billing line (P52221), if a new application is entered that exceeds the Balance to Finish, the Retainage Recalc form exit in Billing Line Inquiry (P5222) will not calculate retainage as expected.

Steps
1. Create a Contract Master (P5201) with a Retainage Rule set with 10% retainage.
2. Create a unit price Billing Line (P5202).
3. In Batch Review (P48221), create a manual batch.
4. Select the batch, then form exit to create an invoice for the contract.
5. Select the invoice record (P48222), then select each billing line and enter a value below the Schedule of Values quantity (P5222/P52221).
6. In Contract Billing Line Inquiry (P5222), take the form exit to Retainage Recalc. Notice that the system calculates 10% retainage as expected.
7. In Batch Review, take the row exit to Create A/R.
8. Create a new manual batch and invoice (P48221/P48222).
9. Drill into the billing line in Billing Line Revisions. Enter a current quantity that is greater than the Balance to Finish.
10. In Contract Billing Line Inquiry (P5222), take the form exit to Retainage Recalc.
11. Select the billing line where the Balance to Finish was exceeded. Click on the Retainage tab and notice that the system did not calculate retainage at 10%.

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.