R12: Generic DataFix (GDF) Patch to identify with wrong base amounts,rounding amounts and variances

(Doc ID 1276043.1)

Last updated on FEBRUARY 22, 2018

Applies to:

Oracle Payables - Version 12.0.0 and later
Information in this document applies to any platform.


a. To handle the sign difference in amount and base amount in EB Tax.
b. To describe what the Generic Data Fix (GDF) Patch 22297430 does, why it is needed, when and how to use it. Moreover what code fix patches are available to prevent this issue from recurring.


Below script identifies whether the sign difference issue is due to EBtax or AP.
Based on the Outcome of Identification query different action plan is to be performed

FROM zx_rec_nrec_dist dist
WHERE dist.trx_id = &trx_id -- Provide the problametic Invoice_id
AND dist.application_id = 200
AND dist.entity_code = 'AP_INVOICES'
AND SIGN(dist.rec_nrec_tax_amt) <> SIGN(dist.rec_nrec_tax_amt_funcl_curr);


Scenario 1
Above mentioned query returns count > 0 i.e. sign difference in amounts is due to EB Tax Root Cause.

Recommended solution is to apply the RCA <patch 20132902> (details available in Doc ID 2003653.1) and then the data fix for the existing Invoices.

Data-Fix : Log a Service Request with Payables to obtain Datafix from support for the issue mentioned in here.

Scenario 2
Above identification script returns count = 0 i.e. sign difference in amounts is due to Payables Root Cause.

Recommended Solution : Follow the action plan as mentioned in Solution section below


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms