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

Last updated on JULY 13, 2017

Applies to:

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

Goal

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.

IDENTIFICATION SCRIPT:


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

SELECT COUNT(1)
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);

 

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

Solution

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