JAVA and SQL Based Batches Have Conflict For ORACLE_HOME Requiring to Have Two Separate Profiles
Last updated on MARCH 30, 2016
Applies to:Oracle Retail Price Management - Version 14.0.3 and later
Information in this document applies to any platform.
Retail Price Management (RPM) batches have conflicts for $ORACLE_HOME between JAVA and SQL Plus profiles.
Batches that utilize the ‘rpmbatch’ user and java, will use Oracle Middleware as $ORACLE_HOME (for example /opt/oracle/middleware).
Whereas batches that use SQL Plus and no java, will use $ORACLE_HOME as Oracle DB Client home (/opt/oracle/product/...)
Because of this, it requires switching of $ORACLE_HOME value based on the type of batch to be run.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms