How to Get Detail of Locks with Object Locked

SELECT VLO.OS_USER_NAME “OS USERNAME”, VLO.ORACLE_USERNAME “DB USER”,
VP.SPID “SPID”, AO.OWNER “OWNER”, AO.OBJECT_NAME “OBJECT LOCKED”,AO.OBJECT_TYPE,
DECODE (VLO.LOCKED_MODE,
1, ‘NO LOCK’,
2, ‘ROW SHARE’,
3, ‘ROW EXCLUSIVE’,
4, ‘SHARE’,
5, ‘SHARE ROW EXCL’,
6, ‘EXCLUSIVE’,
NULL
) “MODE OF LOCK”,
VS.STATUS “CURRENT STATUS”
FROM V$LOCKED_OBJECT VLO, ALL_OBJECTS AO, V$SESSION VS, V$PROCESS VP
WHERE VLO.OBJECT_ID = AO.OBJECT_ID
AND VS.STATUS <> ‘KILLED’
AND VLO.SESSION_ID = VS.SID
AND VS.PADDR = VP.ADDR;

How to Call Customized Function in Personalization

How to Call Customized Function in Personalization

Tables Used in Auto Invoice Master Program

When the Auto invoice program is run, data is populated into the tables listed below.

1. RA_BATCHES_ALL

2. RA_CUSTOMER_TRX_ALL

3. RA_CUSTOMER_TRX_LINES_ALL

4. RA_CUST_TRX_LINE-GL_DIST_ALL

5. RA_CUST_TRX_LINE_SALESREPS_ALL

6. AR_RECEIVABLE_APPLICATIONS_ALL

7. AR_PAYMENT_SCHEDULES_ALL

8. AR_PAYMENT_SCHEDULES_ALL

9. RA_INTERFACE_ERRORS_ALL

Query to check Invoices in Error

SELECT ria.line_type, ria.description, ria.currency_code, ria.amount,

ria.trx_date, ria.quantity, ria.quantity_ordered, ria.sales_order,

ria.sales_order_line, ria.sales_order_date, ria.inventory_item_id,

riea.interface_line_id, riea.MESSAGE_TEXT, riea.org_id

FROM ra_interface_errors_all riea, ra_interface_lines_all ria

WHERE riea.interface_line_id = ria.interface_line_id

AND riea.org_id = ria.org_id