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