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

MOSC Banner

Package body APPS.JG_ZZ_AR_AUTO_INVOICE invalid after patch 14182626 ----- View APPS.CLE_NL_AR_BANK_

edited Jun 25, 2018 2:39PM in Install, Upgrade, Clone, Patch - EBS (MOSC) 5 commentsAnswered ✓
1. After applying path 14182626, package body APPS.JG_ZZ_AR_AUTO_INVOICE became invalid with the message 296/12 PLS-00201: identifier 'JE_COMMON_PKG.NULLIFY_GLOBALCOLUMNS' must
be declared

2. After applying path 7503583, view APPS.CLE_NL_AR_BANK_ID_USAGES_V turned invalid, with message
ERROR at line 3:
ORA-00936: missing expression. **>>IT SEEMS TO BE VERY SIMPLE, BECAUSE THERE ARE TWO CONSEQUITIVE COMMA'S IN THE TEXT OF THE VIEW!<<**

This is de text of the view as per now:

create or replace view cle_nl_ar_bank_id_usages_v as

select CBIU."BANK_ID_USAGE_ID",CBIU."BANK_IDENTIFIER_ID",CBIU."BANK_ACCOUNT_ID",CBIU."CREATED_BY",CBIU."CREATION_DATE",

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