OBIA12c After Upgrading from OBIA11g Variables and User Functions Syntax Have Changed (Doc ID 2879916.1)

Last updated on JULY 05, 2022

Applies to:

Symptoms

On : 11.1.1.10.3 - PB1 - Patch Bundle 1 version, DataWarehouse

OBIA 12c user variables/syntax in ODI 12C is failing

BIAPPS.CURRENT_DATE syntax behind OBIA 12c fails.
The code in OBIA 12c, ODI 12C is
SELECT TO_CHAR_FORMAT(NOW(), 'YYYY-MM-DD HH24:MI:SS')
FROM_DUAL()

The code in OBIA 11G, ODI 11g is
SELECT TO_CHAR_FORMAT(%NOW%, 'YYYY-MM-DD HH24:MI:SS')
FROM_DUAL()

The difference is (%NOW%, vs (NOW()

Detail Error:
ODI-1519
Error Message ODI-1519: Serial step "Start Load Plan (InternalID:34918)" failed because child step "Global Variable Refresh (InternalID:34919)" is in error.
ODI-1529: Refresh of variable "BIAPPS.CURRENT_DATE" failed :
SELECT TO_CHAR(NOW(), 'YYYY-MM-DD HH24:MI:SS')
FROM DUAL
904:42000:java.sql.SQLSyntaxErrorException: ORA-00904: "NOW": invalid identifier

java.sql.SQLSyntaxErrorException: ORA-00904: "NOW": invalid identifier

ERROR
-----------------------
ODI-1519 Error Message ODI-1519: Serial step "Start Load Plan (InternalID:34918)" failed because child step "Global Variable Refresh (InternalID:34919)" is in error. ODI-1529: Refresh of variable "BIAPPS.CURRENT_DATE" failed : SELECT TO_CHAR(NOW(), 'YYYY-

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.