My Oracle Support Banner

No Result Output for Large Product Value Assigned to TP Method "Unpriced Account" (Doc ID 2874027.1)

Last updated on JUNE 22, 2022

Applies to:

Oracle Financial Services Funds Transfer Pricing - Version 8.0.7 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Funds Transfer Pricing (FTP)

Symptoms

When attempting to run an FTP Process against Management Ledger records, the Transfer Pricing (TP) method "Unpriced Account" does not output any result for certain Products with large Product ID values.

When checking the TP Engine log, the Product values are listed in scientific notation format in the following insert code:

Module Logging OFS Access module data: insert
insert into zML_unpriced_cache_xxxxxx (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 xxxxxx, '02/ 24/ 2020', ml1.iso_currency_cd, NULL, NULL,
       NULL, NULL, NULL, sum(NVL(ml2.entered_balance, 0))/
       sum(NVL(ml1.entered_balance, 0)), 0.079235
from fsi_d_management_ledger ml1, fsi_d_management_ledger ml2
where ml1.financial_elem_id = 100
and ml2.financial_elem_id = 170
and ml1.ORG_UNIT_ID = ml2.ORG_UNIT_ID
and ml1.GL_ACCOUNT_ID = ml2.GL_ACCOUNT_ID
and ml1.COMMON_COA_ID = ml2.COMMON_COA_ID
and ml1.PRODUCT_ID = ml2.PRODUCT_ID
and ml1.LEGAL_ENTITY_ID = ml2.LEGAL_ENTITY_ID
and ml1.iso_currency_cd = ml2.iso_currency_cd
and ml1.as_of_date = '02/ 24/ 2020'
and ml2.as_of_date = '02/ 24/ 2020'
and ml1.PRODUCT_ID in (select source_prod_cd
from FSI_M_TP_UNPRICED_ACCT_DTL ua
where ua.transfer_price_sys_id = xxxxxx
and ua.product_id = 1.10101e+ 07
and ua.ccy_cd = 'USD' )
group by 1.10101e+ 07, ml1.iso_currency_cd

The scientific notation format seems to prevent a value from getting inserted into zML_unpriced_cache_xxxxxx.

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


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