My Oracle Support Banner

Build Attribute Mapping Rules Error in creating QP_BUILD_SOURCING_PVT ORA-20000 ORA-01403 (Doc ID 2125913.1)

Last updated on FEBRUARY 07, 2018

Applies to:

Oracle Advanced Pricing - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

 On : 12.1.3 version, Reports & Concurrent Requests

When attempting to run build attribute mapping rules, the following error occurs.

ERROR
-----------------------
Error in creating QP_BUILD_SOURCING_PVT ORA-20000: ORA-01403: no data found create_package(APPLSYS, QP, QP_BUILD_SOURCING_PVT_TMP, TRUE, 1, 8327): create_plsql_object(APPLSYS, QP, QP_BUILD_SOURCING_PVT_TMP, 1, 8327, TRUE): c_statement=select oracle_username from APPS.fnd_oracle_userid where install_group_num = 1 and read_only_flag = 'U':: : substr($statement$,1,255)='': : substr($statement$,1,255)=''

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Responsibility = Oracle Pricing Manager
2. Navigate: Reports
3. Select 'single request' then 'OK'
4. Name: Build Attribute Mapping Rules
5. Submit Request
Error is shown in the concurrent request log file.

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


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