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

MOSC Banner

Patches 13891576 and 10253909 Have Caused Numerous Invalid Objects

edited Jun 22, 2018 3:28PM in Install, Upgrade, Clone, Patch - EBS (MOSC) 5 commentsAnswered

VPC Team member opened this thread for the customer.

Invalid Objects after applying the patches


After applying the suggested patches we are having following Invalid objects

Name                           Type        Error                                                                 
============================== =========== =======================================================================

OE_SCH_ORDER_LINES_V           VIEW        ORA-04063: view "APPS_MRC.OE_SYSTEM_PARAMETERS" has errors

OE_SYSTEM_PARAMETERS           VIEW        ORA-00904: "SP"."CREDIT_HOLD_LEVEL_CODE": invalid identifier

POR_FAVORITE_LISTS_V           VIEW        ORA-00904: "POR_UTIL_PKG"."REQ_TEMPLATE_PRICE_TYPE": invalid identifier

POR_PUBLIC_LIST_ITEMS_V        VIEW        ORA-04063: view "APPS_MRC.ICX_POR_SEARCH_TEMPLATES_V" has errors

PO_TAX_HEADERS_DETAIL_V        VIEW        ORA-06553: PLS-306: wrong number or types of arguments in call to 'GET_HEAD

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

EBS LCM Tags

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center