ORA- 00904: "A"."PRODUCT_IDA"."ISO_CURRENCY_CD": Invalid Errors Running Allocation (Doc ID 2076643.1)

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)

Symptoms

On Oracle Financial Services Profitability Management (PFT) 5.6, when running percent distribution Ledger to Instrument allocations, these allocations are now failing with errors:

ERROR

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: "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.

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