Home / Accounts Payables / AP invoice import program error (REP-0004, MSG-00001,MSG-00002,MSG-00003,MSG-00007,MSG-00008,MSG-00009)

AP invoice import program error (REP-0004, MSG-00001,MSG-00002,MSG-00003,MSG-00007,MSG-00008,MSG-00009)

ERROR

REP-0004: Warning: Unable to open user preference file.
MSG-00001: (Import_purge 1) Check control table for the purge process
MSG-00001: (Check_control_table 1) Lock the control table 


MSG-00003: (Check_control_table 2) Fetch import_requests
MSG-00007: (Check_control_table 5) Insert record into control table
MSG-00008: (Check_control_table 6) Commit
MSG-00002: (Import_purge 2) Updating Org Id to value if Operating Unit is not Null But Org Id is null
MSG-00003: (Import_purge ) Deleting records in interface tables…
MSG-00009: (Import_purge 6) Commit to the database

SOLUTION

Copy the prefs.ora file from your Reports Builder Home  $ORACLE_HOME/tools/admin/ directory into the Oracle Home directory /home/oracle.

$ cp ORACLE_HOME/tools/admin/pref.ora   /home/oracle/

 

 

About Syed Saad Ali

As a certified and experienced Oracle Database Administrator with Almost 10 Years of Experience I am able to perform all levels of database maintenance and am fully qualified to do Oracle updates as well. Capitalizing on my interest in Business & IT both, I chose to navigate my career towards Enterprise Solutions, which has enabled me to excel in the combination of both. I have developed exceptional analytical skills that allow me to diagnose and take care of issues immediately. Extremely skilled in planning and execution of special projects in time- critical environments. Extensive knowledge in directing, coordinating and exercising concern authority for planning, organization, control and successful completions. Very skilled at solving customer relations issues by seeking first to understand and then to be understood. Effectively able to communicate with customers, vendors and management.

Check Also

An Introduction to Financial Statement Generator (FSG)

An Introduction to Financial Statement Generator (FSG) Financial Statement Generator The Financial Statement Generator (FSG) …

Leave a Reply