BSP Product Instrument Mapping Error: The Product id xxxx does not have a Instrument Table Mapped to It for Node ID (Doc ID 2089353.1)

Last updated on DECEMBER 15, 2015

Applies to:

Oracle Financial Services Balance Sheet Planning - Version 8.0.1 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms


When attempting to run product instrument mapping the following error occurs in FSI_PROCESS_ERRORS for leaf and node that do not have data in the instrument table. Expect no error or warning for Node ID that does not have any entries in the instrument table.

Error:
TABLE_NAME:               FSI_ALM_PROC_TABLES
ERROR_DESCRIPTION: The product id xxxx does not have a instrument table mapped to it.


Steps:
1. Run Product Instrument Mapping.
2. Check FSI_PROCESS_ERRORS and see a lot of errors referring to Product ID.
3. Check DIM_PRODUCTS_TL and found LEAF_ONLY_FLAG is Y for PRODUCT_ID that represents a node.


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