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) $FIC_DB_HOME/log/FusionApps when logging is on:
Module Logging OFS errors: (203105) Oracle drv_oci error: OCI Function:  - oexec(),
oexn() SQL Function:  - SQL function not found! Oracle Error:
ORA- 00904: "RW": invalid identifier Driver Function:
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:
- Go to Profitability Management
- Go to Rule Specification > Allocation Specification
- 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
- Run the Allocation
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!