FTP Process with 'Unpriced Account' Method Gets ORA-00001 on Insert into FSI_D_MANAGEMENT_LEDGER
(Doc ID 2668984.1)
Last updated on JULY 06, 2021
Applies to:
Oracle Financial Services Funds Transfer Pricing - Version 8.0.7 and laterInformation in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Funds Transfer Pricing (FTP)
Symptoms
When running an FTP Process with the 'Unpriced Account' Transfer Pricing method against Management Ledger, the following ORA-00001 error occurs:
Module Logging OFS errors: (203105) Oracle drv_oci error: OCI Function: [4] - oexec(),
oexn() SQL Function: [3] -
INSERT Oracle Error: ORA- 00001: unique constraint
(<ATOMIC USER>.UI_FSI_D_MANAGEMENT_LEDGER) violated Driver Function:
drv_oci::Execute() SQL Statement:
insert into FSI_D_MANAGEMENT_LEDGER(identity_code,
FINANCIAL_ELEM_ID, as_of_date, iso_currency_cd, ORG_UNIT_ID,
GL_ACCOUNT_ID, COMMON_COA_ID, PRODUCT_ID, LEGAL_ENTITY_ID,
fiscal_month, fiscal_year, consolidation_cd, strategy_id,
balance_type_cd, entered_balance, functional_balance)
select * .........................etc.
Checking the insert into zML_unpriced_cache_xxxxxx, the Product ID defined in the TP Rule is missing and a NULL exists instead.
insert into zML_unpriced_cache_200311 (TP_PROCESS_SYS_ID, AS_OF_DATE,
ISO_CURRENCY_CD, ORG_UNIT_ID, GL_ACCOUNT_ID,
COMMON_COA_ID, PRODUCT_ID, LEGAL_ENTITY_ID, BAL, accrual_factor)
select 200311, '04/ 02/ 2020', ml1.iso_currency_cd, NULL, NULL,
NULL, NULL, NULL, sum(NVL(ml2.entered_balance, 0))/ **************
sum(NVL(ml1.entered_balance, 0)), 0.081967......
In the row with **************, the NULL value should be replaced by the Product ID having the Unpriced Account definition.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |