ORA-00904 "DRV"."PRODUCT_ID" or ORA- 00918: column ambiguously defined Errors Running Dynamic Driver Allocation with Transaction Table Source (Doc ID 1943458.1)

Last updated on NOVEMBER 10, 2014

Applies to:

Oracle Financial Services Profitability Management - Version 6.1.0.3 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Profitability Management (PFT)

Symptoms

On PFT 6.1.0.3, running a Dynamic Driver allocation with Transaction table source * Ledger Stat and output to Transaction table creates incorrect merge SQL which triggers errors:

ERRORS
ORA-00904 "DRV"."PRODUCT_ID"

or

ORA- 00918: column ambiguously defined

ORA-00904 "DRV"."PRODUCT_ID" is triggered if setting Output PRODUCT_ID =
ORA- 00918: column ambiguously defined if setting Output PRODUCT_ID =

The issue can be reproduced at will with the following steps:

1. Create a new Transaction table Dynamic Driver allocation with source transaction table * ledger_stat output to source transaction table
2. Run the allocation

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