SUBSTR Function In File Request Type Not Avoiding Double Quotes
(Doc ID 2676026.1)
Last updated on JUNE 04, 2020
Applies to:Oracle Financial Services Revenue Management and Billing - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
On : 126.96.36.199.0 version, IP - Installation Upgrade Proc
SUBSTR function in File Request Type is not avoiding double quotes.
Lets say the input file for File Request Type contains double quotes for every field passed.
While FRT ignores the double quotes while reading inputs, the SUBSTR() function does not ignore double quotes and considers the double quote as a character.
When SUBSTR(0,3) is used for input "ABCD", it returns the substring AB instead of ABC.
When SUBSTR(1,4) is used for input "ABCD", it returns the substring BCD instead of ABC.
The working of SUBSTR() function will have to be updated to consider double quotes.
SUBSTR function in File Request Type should avoid double quotes.
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