My Oracle Support Banner

E1: 43: Unable To Verify R434201 Contract Analysis Report Results Against Related Table Data - As Of Date Processing Option Not Working As Expected (Doc ID 2775785.1)

Last updated on AUGUST 18, 2021

Applies to:

JD Edwards EnterpriseOne Procurement and Subcontract Management - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

R434201 Contract Analysis Report As of date processing option is not working as expected.

The As of Date processing option in R434201 does not appear to be working correctly.  Expecting that the report returns all records with existing amounts in F43121T.RETA up to the Date set in the As of Date processing option.  So if the current date is entered, the total of all RETA values that meet the data selection criteria should match to the report Retainage Amount total, but the values do not match.  In addition, there are no ‘Date’ fields in the F43121T so how are records from this table validated against the As of Date value?

Focusing on Retained Amount, Per E1: 43: Procurement Reports (Doc ID 1613152.1) the Retainage Amount values come from the sum of all the Retained Amounts retrieved from the Purchase Order Receiver Tag File (F43121T.RETA) for the specific Branch Plant, Supplier and G/L Account.

Databrowser over F43121T showing all MT2 records, (114 records returned) as of current date (05/10/2021).  Total RETA = 39327.19.  Does not correlate to the total amount values shown on the example report.

05/10/2021 as of date report:  39327.19 in table (as of 05/10/2021) vs 38045.77 on report

Steps To Reproduce:

  1. Run the R434201 report for specific document types.
  2. Using Databrowser, export the related data from the related table(s).
  3. Attempt to validate the report amounts against the related table data.
  4. Create additional report(s) using various As of Dates in the processing option.
  5. Attempt to validate the report amounts against the related table data.

 

Changes

 

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
Changes
Cause
Solution
References


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