Deployment to SOA Server During Financial Close Management Configuration

Issue: This error message is displayed in the Summary section of the RCU configuration wizard:

ORA-01450 maximum key length exceeded

Solution: Increase the DB_BLOCK_SIZE setting.

Issue: The SOA log includes error messages about missing columns or a table or view that does not exist. These errors indicate that the SOAINFRA database schema generated by RCU is incompatible with the version of SOA Suite server that is installed.

Solution: Ensure that you have installed compatible versions of RCU and SOA Suite.

Tip:

Oracle recommends that you download RCU and SOA Suite from the “Oracle Enterprise Performance Management System” Media Pack from Oracle® E-Delivery (http://edelivery.oracle.com/) and install them. The media pack contains the correct versions of RCU and SOA Suite.

To compare your SOA Suite and RCU versions, check the version.properties files in these folders:

Issue: If you run the Deploy to SOA task from Oracle Hyperion Enterprise Performance Management System Configurator when applying a maintenance release, the task fails with this error message:

Failed deploying composite, status is: 500, error: Error during deployment: Deployment Failed: Unable to find a WSDL that has a definition for service  

Solution: Consult the Oracle Hyperion Enterprise Performance Management System Certification Matrix (http://www.oracle.com/technology/software/products/ias/files/fusion_certification.html), and install the correct SOA server for Release 11.1.2.1.

Note:

Ensure that the prerequisites for a maintenance release installation are met. See “Maintenance Release Installation Checklist” in the Oracle Hyperion Enterprise Performance Management System Installation and Configuration Guide.

Issue: You cannot configure SOA Server for SQLServer.

Solution: Enable XA Transactions at the operating system and SQLServer levels.

For more information, see “Financial Close Management Installation and Configuration Prerequisites and Roadmap” in Chapter 3, “Installing EPM System Products,” in the Oracle Hyperion Enterprise Performance Management System Installation and Configuration Guide.