R12: E-Business Tax / Payables Cause and Action Plan For Frozen Tax Distributions Deleted Errors
(Doc ID 1152029.1)
Last updated on AUGUST 07, 2023
Applies to:
Oracle Payables - Version 12.2.6 to 12.2.6 [Release 12.2]Oracle E-Business Tax - Version 12.0.0 to 12.1.3 [Release 12.0 to 12.1]
Oracle Payables - Version 12.1.2 to 12.1.2 [Release 12.1]
Oracle Payables - Version 12.1.3 to 12.1.3 [Release 12.1]
Oracle Payables - Version 12.2.10 to 12.2.10 [Release 12.2]
Information in this document applies to any platform.
Symptoms
E-Business Tax (EBTax) Information Center > EBTax Integration With EBS Modules > Payables > Note 1152029.1
Cause
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
Symptoms |
E-Business Tax (EBTax) Information Center > EBTax Integration With EBS Modules > Payables > Note 1152029.1 |
Cause |
Solution |
Generic Action Plan |
Step 1a - Ensure RCA Patches are applied: |
Step 1b - Ensure these Undo Accounting patches are applied (regardless if undo accounting is required or not): |
Step 2 - Execute script zx_frzn_dist_crt.sql to create the following tables: |
Step 3 - Execute script zx_frzn_dist_pop.sql to populate the driver tables created in Step 2. |
Step 4 - Check if Undo Accounting is required: |
Step 5 - Execute script zx_ap_undo_pop.sql |
Step 6 - Execute script zx_ap_undo_wrapper.sql |
Step 7 - Execute script zx_frzn_dist_fix.sql |
Step 9 - Apply the data-fix for orphan events: |
Step 10: Run 'TRANSFER JOURNAL ENTRIES TO GL' concurrent program to transfer the reversal accounting entries to GL created during undo process. |
Step 11: Make a final screen for data issues: |
References |