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.
