E1: 52: An unexpected -0.01 retainage amount shows under the “Retainage Amount Current” column on the Batch Review - Contract Billing Line Inquiry (P5222 version ZJDE0004), after running Contract Billing Invoice Generation (R52121) report (Doc ID 3028060.1)

Last updated on JUNE 13, 2024

Applies to:

Symptoms

When running R52121 Contract Billing Invoice Generation UBE, the report is generating the invoice records with an unexpected -0.01 penny value under the "Retainage Amount Current" column displayed on the grid of Batch Review - Contract Billing Line Inquiry (P5222 version ZJDE0004).

Steps:

1. On P5204 Retainage Rule do set the retainage rule to be used for testing, as Cumulative, Percent Complete Source as Schedule of Values, the Percent Retainage as 5% and Percent Complete as 999.99.
2. On P5201 Contract Master do create a new contract.
3. On P5202 Billing Line Details do set the billing lines to be of type 2 Unit Price, as follows:
   - on the billing line 1 do set the Schedule of Values as 291732.20, Unit Price as 48.85 and Quantity as 5972
   - on the billing line 2 do set the Schedule of Values as 720921.60, Unit Price as 67.05 and Quantity as 10752
   - on the billing line 3 do set the Schedule of Values as 3200, Unit Price as 1600 and Quantity as 2
   - on the billing line 4 do set the Schedule of Values as 3200, Unit Price as 1600 and Quantity as 2
   - on the billing line 5 do set the Schedule of Values as 1, Unit Price as 1 and Quantity as 1
4. Go to BV to set the Processing Options of R52121 Contract Billing Invoice Generation to run it on January 2024.
5. Go to G52 > Contract Billing > Periodic Processing > Invoice Processing > Batch Review (P48221, version ZJDE0004). Select the A/R batch for review, to launch Batch Review - Work With Invoices (P48222 version ZJDE0004). Then select once again, to see the invoice billing line details on Batch Review - Contract Billing Line Inquiry (P5222 version ZJDE0004) and notice there are no amounts shown under the “Retainage Current Amount” column.
6. Then do update the activity for billing lines 1, 2, 3 & 4, by entering some quantities under the Amounts tab. Notice that after applying the modifications, the “Retainage Current Amount” is still blank.
7. To calculate the corresponding retainage values, go to Form exit available on the Batch Review - Contract Billing Line Inquiry (P5222 version ZJDE0004) and select the Retainage Recalc option. After that the system is populating the corresponding retainage amounts under the “Retainage amount current” column, and the “Retainage amount prior” column still has no amounts, that is fine.
8. Return to Batch Review (P48221, version ZJDE0004) – Work With Batches, select the A/R Batch, go to Row exit and run Create A/R, that is using version XJDE0001 set with # 1. Retainage Pay Status  blank to use ‘H’ to hold the retainage and is calling the R48300 version XJDE0001 set with # 1. Summarize A/R Entries by Invoice = 1 to summarize. After running R48199 Create A/R, the A/R Batch is getting cleared from Batch Review (P48221, version ZJDE0004, and the invoice is getting successfully created in A/R module
9. Go again to BV and run the R52121 Contract Billing Invoice Generation with the Processing Options set for February 2024, and with logs activated. Then go to G52 > Contract Billing > Periodic Processing > Invoice Processing > Batch Review (P48221, version ZJDE0004) and double check on the new A/R Batch and notice the R52121 has generated an unexpected -0.01 amount under the “Retainage 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.