R12: Generic DataFix (GDF) Patch to identify with wrong base amounts,rounding amounts and variances
(Doc ID 1276043.1)
Last updated on MAY 12, 2020
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 EBTax.
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 dist.event_class_code IN ('STANDARD INVOICES','PREPAYMENT INVOICES','EXPENSE REPORTS')
AND SIGN(dist.rec_nrec_tax_amt) <> SIGN(dist.rec_nrec_tax_amt_funcl_curr);
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.
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
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
|What does it do?|
|Why is it needed?|
|When to use it?|
|How to use it?|
|Known Root Cause Bugs/Notes for this Issue|
|Standard Patching Process|
|Have more questions?|