Updating Award Lines Via Modification Errors - You Have Encountered an Unexpected Error - PO_UDA_DATA_UTIL.CHECK_CONTEXT_VALID40.EXCEPTION 4 false;SQLERRM = ORA-01403: no data found (Doc ID 2954300.1)

Last updated on JUNE 10, 2023

Applies to:

Symptoms

Using Purchasing, Version 12.2.10


Actual:
Create Award Modification > Navigate to Lines > Click Pencil (Update) Icon for any available lines > Results in Error > Contact System Administrator

Error:

You have encountered an unexpected error. Please contact your system administrator for assistance.

FND Logging shows:.

oracle.jbo.NoDefException: JBO-25058: Definition IgtStatus of type Attribute not found in PoLinesMergeVO
oracle.jbo.NoDefException: JBO-25058: Definition IgtStatus of type Attribute not found in PoLinesMergeVO
Event Name:oracle.apps.fnd.framework.OAFatalError Event Key:274434
Event Name:oracle.apps.fnd.framework.OAFatalError Event Key:274434Maximum nested raise count:100Nested raise count: 0
Dispatching event oracle.apps.fnd.framework.OAFatalError
Getting event details for {oracle.apps.fnd.framework.OAFatalError}
Last upload time {} Last cache time {}
Cache is not created for EVENTS index {1}
Event not found in cache. Loading from Database



  po.common.server.PoCallableStatement.execute.BEGIN 2 this = Module:
 oracle.apps.po.extfwk.server.PoUdaRegionSvrCmd.validateContext.; SQL: BEGIN PO_UDA_DATA_UTIL.CHECK_CONTEXT_VALID ( p_template_id => :1, p_usage_code => :2, x_valid_status => :3); END; ; Statement: weblogic.jdbc.wrapper.CallableStatement_oracle_jdbc_driver_OracleCallableStatementWrapper@432db0
po.extfwk.server.PoUdaRegionSvrCmd.validateContext.0.0 1 Executing: BEGIN PO_UDA_DATA_UTIL.CHECK_CONTEXT_VALID ( p_template_id => :1, p_usage_code => :2, x_valid_status => :3); END;
po.plsql.PO_UDA_DATA_UTIL.CHECK_CONTEXT_VALIDBEGIN 2 Start of subprogram.
po.plsql.PO_UDA_DATA_UTIL.CHECK_CONTEXT_VALIDBEGIN 2 p_template_id = 23 po.plsql.PO_UDA_DATA_UTIL.CHECK_CONTEXT_VALIDBEGIN 2 p_usage_code = CHAIN
po.plsql.PO_UDA_DATA_UTIL.CHECK_CONTEXT_VALID40.EXCEPTION 4 false;SQLERRM = ORA-01403: no data found po.plsql.PO_UDA_DATA_UTIL.CHECK_CONTEXT_VALIDEND 2 End of subprogram. po.common.server.PoCallableStatement.execute.RETURN 2 Return value = false po.common.server.PoCallableStatement.getVarchar.BEGIN 2 parameterIndex = 3.0 po.extfwk.server.PoUdaRegionSvrCmd.validateContext.0.0 1 :outbind:3 = false
po.common.server.PoCallableStatement.getVarchar.RETURN 2 Return value = false
po.extfwk.server.PoUdaRegionSvrCmd.validateContext.150.0 1 validStatus = false
po.common.server.PoCallableStatement.close.BEGIN 2 stmt = Module:
 oracle.apps.po.extfwk.server.PoUdaRegionSvrCmd.validateContext.; SQL: BEGIN PO_UDA_DATA_UTIL.CHECK_CONTEXT_VALID
 ( p_template_id => :1, p_usage_code => :2, x_valid_status => :3); END; ; Statement:
 weblogic.jdbc.wrapper.CallableStatement_oracle_jdbc_driver_OracleCallableStatementWrapper@432db0

po.extfwk.server.PoUdaRegionSvrCmd.validateContext.0.0 1 Closing statement for SQL: BEGIN PO_UDA_DATA_UTIL.CHECK_CONTEXT_VALID
 ( p_template_id => :1, p_usage_code => :2, x_valid_status => :3); END;

po.common.server.PoCallableStatement.close.END 2 End of method.
po.extfwk.server.PoUdaRegionSvrCmd.validateContext.END 2 End of method.

po.extfwk.server.PoUdaRegionSvrCmd.getAttrOrPageId.EXCEPTION 4 Error (Exception stack trace follows.) oracle.apps.fnd.framework.OAException:
 Application: PO, Message Name: PO_UDA_TEMP_USG_ENTITY_INVALID.

Replication Steps:
The issue can be reproduced at will with the following steps:
1. Award Modification
2. Navigate to the lines - click pencil to update it
3. Error occurs - contact the system administrator

Changes

 Multiple patches were applied, and the error has surfaced.

Cause

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