Monday, March 17, 2014

Identifying Locked Objects in Oracle Applications

At my site, we have a custom program to print invoices. That program prints invoice and updates printing_count, printing_last_printed columns of ra_customer_trx_all table. Sometime user were modifying the invoice using transaction workbench and they submit invoice print program without committing the changes in transaction workbench. So Invoice printing program would keep on waiting for lock on ra_customer_trx_all to be released. If that happened, user would call us to find what is happening and the following query was helpful to find out out who is locking the transaction table

No comments:

Post a Comment