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

MOSC Banner

After migrating from11.5.10.2 to 12.1.3 - AR_LOCATION_VALUES1_DFV invalid

edited Aug 14, 2014 5:35PM in Install, Upgrade, Clone, Patch - EBS (MOSC) 1 commentAnswered ✓

Hi,

Apps 12.1.3

View, AR_LOCATION_VALUES1_DFV is invalid after migrating to 12.1.3

SOURCE VIEW

CREATE OR REPLACE FORCE VIEW "APPS"."AR_LOCATION_VALUES1_DFV" ("ROW_ID", "CONTEXT_VALUE", "IBGE_CODE", "CONCATENATED_SEGMENTS") AS
SELECT ROWID, GLOBAL_ATTRIBUTE_CATEGORY, GLOBAL_ATTRIBUTE1, 
(DECODE (GLOBAL_ATTRIBUTE_CATEGORY, 
     'JL.BR.ARXLOCVS.Additional', GLOBAL_ATTRIBUTE_CATEGORY || '.' || GLOBAL_ATTRIBUTE1, NULL))
FROM AR_LOCATION_VALUES;


Erro:
ORA-00904: "GLOBAL_ATTRIBUTE1": identificador inválido
00904. 00000 -  "%s: invalid identifier"
*Cause:   
*Action:

Erro na linha: 11 Coluna: 71


Regards!

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