Hi Team,
we are facing an error while running DBMS_SCHEDULER job. that DBMS_SCHEDULER job contains update statement. please find the below update statement.
===================================================
UPDATE PET_DAILY_SCHEDULE
SET QB_UPDATED ='Y'
WHERE (CLIENT_ID,SCH_ID) IN (SELECT CLIENT_ID,SCH_ID
FROM PCS_QUICKBOOKS_EXPORT_TRANS
WHERE CLIENT_ID= V_CLIENT_ID
AND QUICKBOOKS_BATCH_NO = V_BATCH_NO)
AND SCH_ID NOT IN ( SELECT ORDER_NUMBER
FROM OP_HEAD
WHERE CLIENT_ID= V_CLIENT_ID
AND ORDER_NUMBER=PET_DAILY_SCHEDULE.SCH_ID
AND NVL(INVOICE_COMPLETED,'N')='N'
=====================================================
ORA-12838: cannot read/modify object after modification in parallel
Thanks & Regards
Krishna.