Support Article
Smart Investigate fails creating trigger TRIGGER TRPAF_RULE_INS
SA-8530
Summary
When trying to run create_paf_rule_and_add_triggers.sql script that comes with Smart Investigate for Payments v7.11 media on a split schema system, it throws "table not found" error for trigger trpaf_rule_Ins.
Error Messages
SQL> show errors
Errors for TRIGGER TRPAF_RULE_INS:
LINE/COL ERROR
-------- ---------------------------------------------------
40/1 PL/SQL: SQL Statement ignored
40/13 PL/SQL: ORA-00942: table or view does not exist
Steps to Reproduce
Run create_paf_rule_and_add_triggers.sql file.
Root Cause
The script that you get with the media is not schema qualified.
Resolution
Open an SR with Global Customer Support to get an updated script that is schema qualified correctly.
Tags:
Published June 12, 2015 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.