Discrete Manufacturing - EBS (MOSC)

MOSC Banner

Unable to update or delete error record in Pending Resource transaction form

edited Mar 9, 2020 5:08AM in Discrete Manufacturing - EBS (MOSC) 3 commentsAnswered

Hello,

We are in 12.2.8 and use avg costing method. There is one errored record in Pending transaction form which we are unable to update or delete. When trying to resubmit by clicking on Resubmit checkbox or populate any field in the record, getting below  error.

FRM-40735: ON-LOCK trigger raised unhandled exception ORA-01403.

There are two message error record is showing

1.  EMPLOYEE_NUM              You can only enter an employee number for Person resources

2. TRANSACTION_UOM       Alternate unit of measure not valid. Please re-enter.

Attached screenshot also.

Any pointers   on how to fix the issue in terms of any front end fix or some datafix  script  to delete the record from wip_cst_trxn_interface table.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center