Not Able To Execute Patch Upgrade Scripts Automatically
(Doc ID 2125127.1)
Last updated on FEBRUARY 28, 2018
Applies to:Oracle Insurance Policy Administration J2EE - Version 22.214.171.124 and later
Information in this document applies to any platform.
The SQL statements in Patch upgrade scripts, ex. OIPA_DB2.sql, are in reverse order and cannot be executed twice in succession.
The script is ordered newest to oldest. But users are expected to run it oldest to newest.
This means users cannot run this script as is in an automated way without manual intervention.
Users are advised:
“Due to the nature of the SQL script updates, duplicate records or tables may exist. Errors associated with those can be ignored.”
Can the scripts be revised to automatically check for duplicate records and tables?
That way users can terminate the deployments on any errors generated without manual intervention.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!