My Oracle Support Banner

FTP 8.0.7: Products With Names Containing Special Character "," (Comma) Do Not Remain Selected In TP Process Upon Saving (Doc ID 2873404.1)

Last updated on JUNE 07, 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 Funds Transfer Pricing (FTP)
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Enterprise Performance Management (EPM)

Symptoms

On FTP 8.0.7 version, products with "," (delimiter) character in their names are not getting saved in TP Process > Product Selection.

After selection and saving, upon reopening of the process, respective products show up as deselected.

Same was verified through back-end where no entry was there in FSI_TP_PROD_SELECTION table for those product ids, moreover user is getting an additional entry for product_id = "0" .

 

Example - from FSI_TP_PROD_SELECTION table:

TP_PROCESS_SYS_ID PRODUCT_ID PROD_HIERARCHY_ID
1023456 0 5043210
1023456 100000000001 5043210
1023456 100000000002 5043210
1023456 100000000003 5043210

Note how record for Product ID = 100000000004 is missing, however row for Product ID = 0 got there somehow.

 

STEPS TO REPRODUCE

1. Login to OFSAA -> FTP
2. Attempt to create new FTP Standard Process
3. Select few products with names containing "," in Assumption Browser screen at the bottom of "Product Selection" definition block.
4. Complete process definition and save.
5. Reopen FTP Process and check which products remained selected in "Product Selection".

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.