My Oracle Support Banner

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 later
Information 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


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