Install, Upgrade, Clone, Patch - EBS (MOSC)

MOSC Banner

Patch 6678700 - Oracle Application Install: 12.1.1- Patch failed at apstca01.sql

edited Oct 5, 2013 5:50AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 7 commentsAnswered

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

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center