R12: AP: AD Worker Failed- Patch 37237393 ORA-00001: Unique Constraint(AP.AP_INCOME_TAX_REGIONS_U2)violated
(Doc ID 3063246.1)
Last updated on JANUARY 13, 2025
Applies to:
Oracle Payables - Version 12.1.3 to 12.1.3 [Release 12.1]Information in this document applies to any platform.
Symptoms
Release 12.1.3 1099 Patch 37237393 application failing.
AD Worker Failed- Patch 37237393 ORA-00001: unique constraint(AP.AP_INCOME_TAX_REGIONS_U2)violated
Patch application log file show:
Patch 37237393 failed
Restarted: file ap37237393.sql on worker 3 for product ap username AP.
FAILED: file ap37237393.sql on worker 3 for product ap username AP.
ATTENTION: All workers either have failed or are waiting:
FAILED: file ap37237393.sql on worker 3.
ATTENTION: Please fix the above failed worker(s) so the manager can continue.
Restarted: file ap37237393.sql on worker 3 for product ap username AP.
FAILED: file ap37237393.sql on worker 3 for product ap username AP.
ATTENTION: All workers either have failed or are waiting:
FAILED: file ap37237393.sql on worker 3.
ATTENTION: Please fix the above failed worker(s) so the manager can continue.
ADWorker Log file shows:
sqlplus -s APPS/***** @/u01/install/APPS/apps_st/appl/ap/12.0.0/patch/115/sql/ap37237393.sql
Connected.
1 row updated.
update ap_income_tax_regions
*
ERROR at line 1:
ORA-00001: unique constraint (AP.AP_INCOME_TAX_REGIONS_U2) violated
Connected.
1 row updated.
update ap_income_tax_regions
*
ERROR at line 1:
ORA-00001: unique constraint (AP.AP_INCOME_TAX_REGIONS_U2) violated
File ap37237393.sql executes the following SQLs:
Steps to reproduce:
- Apply patch 37237393:R12.AP.B
- Review the ADPatch log.
- Review the corresponding AD Worker Log file
Changes
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 |
| Changes |
| Cause |
| Solution |
| References |