Skip to main content

I have created a background job that add x days to the Promised Delivery Date, however when the user is in the customer order record when the background job is triggered they receive notification that they cannot save the record as the record has been changed.   Also, the background job reports that a record was FND_LOCKED sometimes.  

 

Is there a table /view where I can view FND_LOCKED items?

 

Where can I go to get information relating to Customer Orders current in use so that I can ‘miss’ out any orders currently in use and then they will be picked up next time the job runs.

Hello @johnw66,

 

Since this is related to a failure of a transaction, you can use below query to check.

select * from TRANSACTION_SYS_LOCAL_TAB t

Please refer below community post as well.

 

Cheers!

@Imal Thiunuwan Thank you for your reply I will check that out.

Terms & ConditionsCookie settings