ORA- 00904: "A"."PRODUCT_IDA"."ISO_CURRENCY_CD": Invalid Errors Running Allocation
Last updated on NOVEMBER 11, 2015
Applies to:Oracle Financial Services Funds Transfer Pricing - Version 5.6 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
On Oracle Financial Services Profitability Management (PFT) 5.6, when running percent distribution Ledger to Instrument allocations, these allocations are now failing with errors:
Module Logging OFS errors: (203105) Oracle drv_oci error: OCI Function:  - oexec(),
oexn() SQL Function:  - SQL function not found! Oracle Error:
ORA- 00904: "A"."PRODUCT_IDA"."ISO_CURRENCY_CD": invalid
identifier Driver Function: drv_oci::Execute()
The allocation engine is generating an incorrect merge statement.
The issue can be reproduced at will with the following steps:
1. Run allocation allocating non interest expenses/incomes from products to accounts within that product.
The details of the rules are as follows:
Source: Product wise, branch wise, non interest incomes and expenses in all currencies (from Ledger_Stat table).
Driver: Account wise, product wise, branch wise minimum balance in all currencies (from instrument tables e.g. FSI_D_CASA etc.).
Debit: Account wise, product wise, branch wise allocated income/allocated expenses in all currencies (in instrument tables e.g. FSI_D_CASA etc.).
Credit: No Credit.
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