Patch 6678700 - Oracle Application Install: 12.1.1- Patch failed at apstca01.sql
Hi Team,
(Patch 6678700) Patch failed at apstca01.sql
ATTENTION: All workers either have failed or are waiting:
FAILED: file apstca01.sql on worker 1.
FAILED: file apstca01.sql on worker 2.
Customer in the in the middle of r12 upgrade from 11i.
adworker error detail:
sqlplus -s APPS/***** @/deoa3i/applmgr/1200/ap/12.0.0/patch/115/sql/apstca01.sql &un_ap &batchsize 6 16
Connected.
DECLARE
*
ERROR at line 1:
ORA-01400: cannot insert NULL into ("AR"."HZ_LOCATIONS"."COUNTRY")
ORA-06512: at line 931
for the above issue following solution has been provided.
1. Please restore the system before upgrade status.
2. Log on to the Applications.
3. Navigate to 'System Administrator-> Profile-> System'.