Error While Compiling Seeded DFF "Qualifer Context". ORA-06512: At "SYSTEM.AD_DDL", Line 165 (Doc ID 2680874.1)

Last updated on JUNE 15, 2020

Applies to:

Symptoms

On : 12.1.3 version, Pricing Object Security

Application: Advanced Pricing
Title: "Qualifer Context" DFF
Getting the Error. (Attached Log File and Output File of the Request).

ERROR
-----------------------
'View generation has failed. Check log file for error messages'
VIEW_HAS_FAILED_CHECK_LOG_FILE
 FROM SYS.DUAL
Oracle error 1403: ORA-01403: no data found
ORA-06512: at "SYSTEM.AD_DDL", line 165
ORA-06512: at line 1 has been detected in afuddl() [3_xdd].
do_ddl(APPLSYS, QP, 2, $statement$, QP_ATTRIBUTE_DEFNS1_DFV): private_do_ddl(APPS,
APPLSYS, QP, 2, $statement$, QP_ATTRIBUTE_DEFNS1_DFV): do_cd_view(1, APPS, 2,
QP_ATTRIBUTE_DEFNS1_DFV, $statement$): : get_apps_schema_name(1,APPS): c_statement=select
oracle_username from APPS.fnd_oracle_userid where (install_group_num = :install_group_num or
install_group_num = (select min(install_group_num) from APPS.fnd_oracle_userid where 1 =
decode (:install_group_num,0,1,2) and read_only_flag = 'U')) and read_only_flag = 'U' : :
substr($statement$,1,255)='CREATE OR REPLACE VIEW QP_ATTRIBUTE_DEFNS1_DFV
 AS SELECT 'View generation has failed. Check log file for error messages'

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Via the Order Management Super User Responsibility
2. Navigate: Setup-> Financials -> Flexfields -> Descriptive -> Segments


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot compile qualifier context flexfield

Cause

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