Allocation Fails with 'ORA-30926: Unable to Get a Stable Set of Rows' (Doc ID 1620262.1)

Last updated on JANUARY 17, 2024

Applies to:

Symptoms

In Oracle Financial Services Profitability Management (PFT) 6.1.0.1 and higher, when running an Allocation that worked in a lower version, the Allocation fails and an ORA-30926 error like the following is output to the logs in $FIC_DB_HOME/log/FusionApps:

Module Logging OFS errors: (203105) Oracle drv_oci error: OCI Function: [4] - oexec(),
    oexn() SQL Function: [189] - SQL function not found! Oracle
    Error: ORA- 30926: unable to get a stable
set    of rows in the source tables Driver Function:
    drv_oci::Execute() SQL Statement: MERGE INTO FSI_D_MORTGAGES
    TARGET USING (
SELECT    IDENTITY_CODE, ID_NUMBER, NVL(COST, 0) * 1 TARGET_AMOUNT
from    FSI_D_MTG_TEST a
where    a.as_of_date='12/ 31/ 1999' ) SOURCE ON
    (SOURCE.IDENTITY_CODE = TARGET.IDENTITY_CODE
AND    SOURCE.ID_NUMBER = TARGET.ID_NUMBER
AND    TARGET. AS_OF_DATE = '12/ 31/ 1999' ) WHEN MATCHED THEN
UPDATE    
SET    IDENTITY_CODE_CHG = 10106.000000 , TARGET.ALLOCATED_EQUITY =
    NVL(TARGET.ALLOCATED_EQUITY, 0) + DECODE (ISO_CURRENCY_CD, 'JOD',
    1/ 1.333333333, 'JPY', 1, 1) * (SOURCE.TARGET_AMOUNT * 1)

The error prevents the Allocation from generating results.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.