===================
The cause of the issue is invalid / incorrect data in ap_invoice_lines_all
and ap_invoice_distributions_all .
CAUSE JUSTIFICATION
===================
The following bug was logged for this specific customer to receive a datafix
from Oracle Development:
Bug.8357578: UNABLE TO CANCEL INVOICE DUE TO TAX DISTRIBUTION VARIANCE
Oracle Development stated that the issue is due to invalid / incorrect data.
The AP List identified the issue data.
PROPOSED SOLUTION(S)
====================
Apply a datafix to correct invalid / incorrect data in ap_invoice_lines_all
and
ap_invoice_distributions_all.
PROPOSED SOLUTION JUSTIFICATION(S)
==================================
The following bug was logged for this specific customer to receive a datafix
from Oracle
Development:
Bug.8357578: UNABLE TO CANCEL INVOICE DUE TO TAX DISTRIBUTION VARIANCE
Oracle Development stated that the issue is due to invalid / incorrect data.
Oracle Development provided a datafix.
The datafix will do the following:
1. correct the data in ap_invoice_lines_all and
ap_invoice_distributions_all.
SOLUTION / ACTION PLAN
======================
-- To implement the solution, please execute the following steps::
Execute the below SQL and commit the changes:
create table aid_bkp as
select *
from ap_invoice_distributions_all
where invoice_id = 10490
and line_type_lookup_code like '%TAX%';
create table ail_bkp as
select *
from ap_invoice_lines_all
where invoice_id = 10490
and line_type_lookup_code like '%TAX%';
delete
from ap_invoice_distributions_all
where invoice_id = 10490
and line_type_lookup_code like '%TAX%';
delete
from ap_invoice_lines_all
where invoice_id = 10490
and line_type_lookup_code like '%TAX%';
commit;
No comments:
Post a Comment