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

MOSC Banner

Patch 17839156 fails on paupg114.sql

edited Nov 10, 2014 3:38AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 2 commentsAnswered

Hi All

The above patch fails with


sqlplus -s APPS/***** @/oraapp/UPATCH/apps/apps_st/appl/pa/12.0.0/patch/115/sql/paupg114.sql &un_pa &batchsize 1 16
Connected.
  set legal_entity_id     = PA_UTILS.GetLegalEntityId((select carrying_out_organization_id FROM pa_projects_all pa WHERE pa.PROJECT_ID = pdr.project_id),pdr.org_id)
                                                *
ERROR at line 59:
ORA-06550: line 59, column 49:
PLS-00302: component 'GETLEGALENTITYID' must be declared
ORA-06550: line 61, column 18:
PL/SQL: ORA-00904: "LEGAL_ENTITY_ID": invalid identifier
ORA-06550: line 58, column 11:
PL/SQL: SQL Statement ignored


Please helps


Vikas

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