Dynamic Driver Allocation Remains in Ongoing Status & Gets ORA-00904: "RW": Invalid Identifier (Doc ID 1393172.1)

Last updated on APRIL 27, 2016

Applies to:

Oracle Financial Services Profitability Management - Version: 5.6 to 5.6 - Release: 5 to 5
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

In Oracle Financial Services Profitability Management (PFT) 5.6, if you create a Dynamic Driver Allocation that distributes balances from Ledger Stat to an instrument table with a dimension on the Debit screen set to <Same As Driver> and all dimensions in the Credit screen set to <Same As Source>, the Allocation hangs in the "Ongoing" status and uses 100% CPU utilization when executed.  Additionally, the following error exists in the ofspa.xxxxxxx.log in $FIC_DB_HOME/log/FusionApps when logging is on:

Module Logging OFS errors: (203105) Oracle drv_oci error: OCI Function: [4] - oexec(),
oexn() SQL Function: [0] - SQL function not found! Oracle Error:
ORA- 00904: "RW": invalid identifier Driver Function:
drv_oci::Execute()

You can work around the issue by setting one dimension in the Credit screen to <Same As Driver> or <Match Source & Driver>.  You expect either the Allocation to run successfully with the current setup or you expect the Allocation interface to give an error during Allocation setup if you do not select <Same As Driver> or <Match Source & Driver> for at least one dimension in the Credit screen if it is required.

Steps to Reproduce:
  1. Go to Profitability Management
  2. Go to Rule Specification > Allocation Specification
  3. Create a new Ledger Stat to Instrument Dynamic Driver Allocation with <Same As Driver> selected in the Debit screen and all <Same As Source> macros selected in the Credit screen
  4. Run the Allocation
The Allocation remains in the Ongoing status and the ORA-00904 error appears in the log file.

Cause

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