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:
Oracle Advanced Pricing - Version 12.1.3 and laterInformation in this document applies to any platform.
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |