My Oracle Support Banner

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

Last updated on MARCH 18, 2019

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 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.

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

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
Goal
 IDENTIFICATION SCRIPT:
Solution
 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
 Patch Wizard
 Have more questions?
References

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