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

MOSC Banner

Patch 9220206 : fails on cstgirmw.sql with ORA-942: table or view does not exist ORA-6512: at "APP

edited Nov 29, 2012 9:43PM in Install, Upgrade, Clone, Patch - EBS (MOSC) 3 commentsAnswered

Hi All


Error while applying the patch 9220206 post installation script  cstgirmw.sql


following error occurs

ERROR at line 1:
ORA-942: table or view does not exist
ORA-6512: at "APPS.FND_CORE_LOG", line 45
ORA-6512: at "APPS.FND_CORE_LOG", line 456
ORA-6512: at "APPS.FND_PROFILE", line 110
ORA-6512: at "APPS.CST_UPD_GIR_MTA_WTA", line 6

None of the following suggestion helps - >

+ A] 1. Run the following command to disable the trigger:

Alter TRIGGER APPS.ALR_FND_PROFILE_OPTIONS_UAR disable;

 Re-test the issue

B] Connect as APPLSYS user

GRANT ALL ON FND_PROFILE_OPTIONS TO APPS;
  GRANT ALL ON FND_PROFILE_OPTION_VALUES TO APPS;
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