Solved

Background Job and FND_LOCKED advice

  • 18 May 2021
  • 2 replies
  • 504 views

Userlevel 7
Badge +18

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.

icon

Best answer by Imal Thiunuwan 18 May 2021, 09:25

View original

This topic has been closed for comments

2 replies

Userlevel 6
Badge +16

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!

Userlevel 7
Badge +18

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