Wednesday, May 15, 2013

Unable to query Invoices from Invoice work bench and getting the error "FRM-40735: WHEN-VALIDATE-ITEM trigger raised unhandled exception ORA-01403"




Unable to query Invoices from Invoice work bench and getting the below errors


1."FRM-40735: WHEN-VALIDATE-ITEM trigger raised unhandled exception ORA-01403"



2. FRM-40350:Query caused no records to be retrieved.



Data fix need apply to resolve the above errors.

Please apply the GDF Patch 13857555:R12.IBY.B
Steps to follow:(Run the scripts with "Apps" User)

1) Run $IBY_TOP/patch/115/sql/iby_dup_payee_sel.sql
2) Verify the log file to find out if duplicate payees exist.
3) Log File will be created in the following directory:

              SELECT decode(instr(value,','),0,value,
                   SUBSTR (value,1,instr(value,',') - 1))

               FROM   v$parameter
                WHERE  name = 'utl_file_dir';
4)Customer will review and update the RFC to run the next step

5) Follow the action plan provided in the log file to fix the corrupted data.






No comments:

Post a Comment