Purchase Request Data Standard (PRDS) Integrated SOA Gateway (ISG) Inbound Import Errors: "EGO_USER_ATTRS_DATA_PVT"."Process_User_Attrs_Data" "ORA-01403: no data found"
(Doc ID 2922090.1)
Last updated on MARCH 03, 2023
Applies to:
Oracle Contract Lifecycle Management for Public Sector - Version 12.2.10 and laterInformation in this document applies to any platform.
Symptoms
On : 12.2.10 version, Requisition
When running Purchase Request Data Standard (PRDS) Integrated SOA Gateway (ISG) Inbound Import the concurrent request is failing in error
ERROR
-----------------------
po.plsql.POR_UDA_IMPORT_PKG.IMPORT_UDA_ATTRS.0 NAME at index : 1 is : REQUISITION_HEADER_ID
po.plsql.POR_UDA_IMPORT_PKG.IMPORT_UDA_ATTRS.0 VALUE at index : 1 is : 569766
po.plsql.POR_UDA_IMPORT_PKG.IMPORT_UDA_ATTRS.300 l_class_code_name_value_pairs is as follows :
po.plsql.POR_UDA_IMPORT_PKG.IMPORT_UDA_ATTRS.0 NAME at index : 1 is : UDA_TEMPLATE_ID
po.plsql.POR_UDA_IMPORT_PKG.IMPORT_UDA_ATTRS.0 VALUE at index : 1 is : 502
po.plsql.POR_UDA_IMPORT_PKG.IMPORT_UDA_ATTRS.320 After VALIDATE_ROW U
po.plsql.POR_UDA_IMPORT_PKG.IMPORT_UDA_ATTRS.320 l_failed_row_id_list is :
po.plsql.POR_UDA_IMPORT_PKG.IMPORT_UDA_ATTRS.320 x_errorcode
po.plsql.POR_UDA_IMPORT_PKG.IMPORT_UDA_ATTRS.320 x_msg_count 1
po.plsql.POR_UDA_IMPORT_PKG.IMPORT_UDA_ATTRS.320 x_msg_data Executing - "EGO_USER_ATTRS_DATA_PVT"."Process_User_Attrs_Data" "ORA-01403: no data found"
po.plsql.POR_UDA_IMPORT_PKG.HANDLE_ERROR.0 IN HANDLE ERROR : There was an error in EGO Validate code ERROR_EGO_VALIDATE_ERROR for attr grp id
po.plsql.POR_UDA_IMPORT_PKG.HANDLE_ERROR.0 IN HANDLE ERROR : There was an error in EXECUTE_IMPORT_UDA_FUNCTION (XV) code ERROR_EXECUTE_IMPORT_UDA_FUNCTION_XLE for attr grp id
po.plsql.POR_UDA_IMPORT_PKG.HANDLE_ERROR.0 IN HANDLE ERROR : There was an error in loading UDA Attributes code ERROR_EGO_LOAD_ERROR for attr grp id
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Locate the PRDS Inbound Rest service
2. Process the PRDS Inbound service to create Military Interdepartmental Purchase Request (MIPR)
3. Concurrent Request fails in error
Changes
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 |
Changes |
Cause |
Solution |
References |