Error Message :
The RA Oracle Retail version 2.0 manual states:
"Run the aw_retail_recovery.sql script in the Oracle Retail database as the Oracle Retail user. The aw_retail_recovery.sql script is provided as part of the Oracle Retail agent distribution."
There is no script called aw_retail_recovery.sql included in the distribution, instead the script that should be included is called Retail_recovery_proc.sql. However, Retail_recovery_proc.sql was omitted in version 2.0.0 and is not part of the Agent's distribution package.
Root Cause: 1) Documentation references a script called aw_retail_recovery.sql which does not exist, this should reference Retail_recovery_proc.sql.
2) The Retail_recovery_proc.sql script not included in version 2.0.0's distribution package.
OS Version: N/A
Update to a fix version listed below or a newer version if available.
The Oracle Retail Agent documentation has been corrected in the fix versions and above and now refers to the correct script, Retail_recovery_proc.sql and the file is available in the Agent's distribution package.
RA Oracle Retail – Agent Guide: