FDFVGN module: Flexfield View Generator errors after Applying Patch 18439778 (Doc ID 1665170.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Financials for EMEA - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, French Localizations for AP

When attempting to run FDFVGN module: Flexfield View Generator
the following error occurs:

ERROR
-----------------------
CREATE OR REPLACE VIEW HZ_CUST_ACCT_SITES_ALL1_DFV=20
 (ROW_ID, "VALEUR_CONTEXTUELLE", TAXABLE_PERSON, =
INDUSTRY_CLASSIFICATION, INDUSTRY_SUB_CLASSIFICATION, CONTRIBUTOR_CLASS, =
USE_CUST_SITE_PROF, INSCRIPTION_TYPE, INSCRIPTION_NUMBER, =
INSCRIPTION_BRANCH, INSCRIPTION_DIGIT, STATE_INSCRIPTION, =
MUNICIPAL_INSCRIPTION, SUFRAMA_INSCRIPTION_NUMBER, WTH_NATURE_INDICATOR, =
_FTZ_FLAG, COMPANY_NAME, =20
 CONCATENATED_SEGMENTS) =20
 AS SELECT ROWID, GLOBAL_ATTRIBUTE_CATEGORY, (DECODE =
(GLOBAL_ATTRIBUTE_CATEGORY, 'JA.KR.ARXCUDCI.VAT', GLOBAL_ATTRIBUTE1, =
NULL)), (DECODE (GLOBAL_ATTRIBUTE_CATEGORY, 'JA.KR.ARXCUDCI.VAT', =
GLOBAL_ATTRIBUTE8, NULL)), (DECODE (GLOBAL_ATTRIBUTE_CATEGORY, =
'JA.KR.ARXCUDCI.VAT', GLOBAL_ATTRIBUTE3, NULL)), (DECODE =
(GLOBAL_ATTRIBUTE_CATEGORY, 'JL.CO.ARXCUDCI.Additional', =
GLOBAL_ATTRIBUTE8, 'JL.BR.ARXCUDCI.Additional', GLOBAL_ATTRIBUTE8, =
'JL.AR.ARXCUDCI.Additional', GLOBAL_ATTRIBUTE8, NULL)), (DECODE =
(GLOBAL_ATTRIBUTE_CATEGORY, 'JL.CO.ARXCUDCI.Additional', =
GLOBAL_ATTRIBUTE9, 'JL.BR.ARXCUDCI.Additional', GLOBAL_ATTRIBUTE9, =
'JL.AR.ARXCUDCI.Additional', GLOBAL_ATTRIBUTE9, NULL)), (DECODE =
(GLOBAL_ATTRIBUTE_CATEGORY, 'JL.BR.ARXCUDCI.Additional', =
GLOBAL_ATTRIBUTE2, NULL)), (DECODE (GLOBAL_ATTRIBUTE_CATEGORY, =
'JL.BR.ARXCUDCI.Additional', GLOBAL_ATTRIBUTE3, NULL)), (DECODE =
(GLOBAL_ATTRIBUTE_CATEGORY, 'JL.BR.ARXCUDCI.Additional', =
GLOBAL_ATTRIBUTE4, NULL)), (DECODE (GLOBAL_ATTRIBUTE_CATEGORY, =
'JL.BR.ARXCUDCI.Additional', GLOBAL_ATTRIBUTE5, NULL)), (DECODE =
(GLOBAL_ATTRIBUTE_CATEGORY, 'JL.BR.ARXCUDCI.Additional', =
GLOBAL_ATTRIBUTE6, NULL)), (DECODE (GLOBAL_ATTRIBUTE_CATEGORY, =
'JL.BR.ARXCUDCI.Additional', GLOBAL_ATTRIBUTE7, NULL)), (DECODE =
(GLOBAL_ATTRIBUTE_CATEGORY, 'JL.BR.ARXCUDCI.Additional', =
GLOBAL_ATTRIBUTE10, NULL)), (DECODE (GLOBAL_ATTRIBUTE_CATEGORY, =
'JL.BR.ARXCUDCI.Additional', GLOBAL_ATTRIBUTE11, NULL)), (DECODE =
(GLOBAL_ATTRIBUTE_CATEGORY, 'JL.BR.ARXCUDCI.Additional', =
GLOBAL_ATTRIBUTE12, NULL)), (DECODE (GLOBAL_ATTRIBUTE_CATEGORY, =
'JL.BR.ARXSURMT.Additional', GLOBAL_ATTRIBUTE1, NULL)), =20
 (DECODE (GLOBAL_ATTRIBUTE_CATEGORY, =20
  'JA.KR.ARXCUDCI.VAT', GLOBAL_ATTRIBUTE_CATEGORY || '.' || =
GLOBAL_ATTRIBUTE1 || '.' || GLOBAL_ATTRIBUTE8 || '.' || =
GLOBAL_ATTRIBUTE3, =20
  'JL.AR.ARXCUDCI.Additional', GLOBAL_ATTRIBUTE_CATEGORY || '.' || =
GLOBAL_ATTRIBUTE8 || '.' || GLOBAL_ATTRIBUTE9, =20
  'JL.BR.ARXCUDCI.Additional', GLOBAL_ATTRIBUTE_CATEGORY || '.' || =
GLOBAL_ATTRIBUTE2 || '.' || GLOBAL_ATTRIBUTE3 || '.' || =
GLOBAL_ATTRIBUTE4 || '.' || GLOBAL_ATTRIBUTE5 || '.' || =
GLOBAL_ATTRIBUTE6 || '.' || GLOBAL_ATTRIBUTE7 || '.' || =
GLOBAL_ATTRIBUTE8 || '.' || GLOBAL_ATTRIBUTE9 || '.' || =
GLOBAL_ATTRIBUTE10 || '.' || GLOBAL_ATTRIBUTE11 || '.' || =
GLOBAL_ATTRIBUTE12, =20
  'JL.BR.ARXSURMT.Additional', GLOBAL_ATTRIBUTE_CATEGORY || '.' || =
GLOBAL_ATTRIBUTE1, =20
  'JL.CO.ARXCUDCI.Additional', GLOBAL_ATTRIBUTE_CATEGORY || '.' || =
GLOBAL_ATTRIBUTE8 || '.' || GLOBAL_ATTRIBUTE9, NULL))=20
 FROM HZ_CUST_ACCT_SITES_ALL

Oracle error 911: ORA-00911: invalid character
ORA-06512: at "SYSTEM.AD_DDL", line 165
ORA-06512: at line 1 has been detected in afuddl() [3_xdd].
do_ddl(APPLSYS, JG, 2, $statement$, HZ_CUST_ACCT_SITES_ALL1_DFV): =
private_do_ddl(APPS, APPLSYS, JG, 2, $statement$, =
HZ_CUST_ACCT_SITES_ALL1_DFV): do_cd_view(1, APPS, 2, =
HZ_CUST_ACCT_SITES_ALL1_DFV, $statement$): : do_apps_ddl(APPS, =
$statement$): : substr($statement$,1,255)=3D'CREATE OR REPLACE VIEW =
HZ_CUST_ACCT_SITES_ALL1_DFV=20
 (ROW_ID, "VALEUR_CONTEXTUELLE", TAXABLE_PERSON, =
INDUSTRY_CLASSIFICATION, INDUSTRY_SUB_CLASSIFICATION, CONTRIBUTOR_CLASS, =
USE_CUST_SITE_PROF, INSCRIPTION_TYPE, INSCRIPTION_NUMBER, =
INSCRIPTION_BRANCH, IN'
CREATE OR REPLACE VIEW HZ_CUST_ACCT_SITES_ALL1_DFV=20
 AS SELECT 'View generation has failed. Check log file for error =
messages' VIEW_HAS_FAILED_CHECK_LOG_FILE=20
 FROM SYS.DUAL


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Run FDFVGN module: Flexfield View Generator


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms