Facing issue for using the SUBSTR function with negative number in eText Template

RamuV

We have requirement to print the last 4 digits from summed value in eText template. We have used the below code to print the last 4 digits but its not working. please let me know if any one of you worked on similar requirement.

SUBSTR((SUM(TO_NUMBER(Balance_Record[BASE_BALANCE_NAME=’Net Pay’]/RUN)*100)+SUM(TO_NUMBER(Balance_Record[BASE_BALANCE_NAME=’GPR POSITIVE PAY FEDERAL ELEMENTS GROUP’]/GPR_CUSTOM_BAL))

),length(SUM(TO_NUMBER(Balance_Record[BASE_BALANCE_NAME=’Net Pay’]/RUN)*100)+SUM(TO_NUMBER(Balance_Record[BASE_BALANCE_NAME=’GPR POSITIVE PAY FEDERAL ELEMENTS GROUP’]/GPR_CUSTOM_BAL))

)-3)

Mallikarjuna Kuppauru-Oracle

Hi @RamuV

You can refer below for examples -

Creating an eText Template

https://docs.oracle.com/cd/E10091_01/doc/bip.1013/b40017/T421739T481436.htm

An eText template is an RTF-based template that is used to generate text output for Electronic Funds Transfer (EFT) and Electronic Data Interchange (EDI). At runtime, BI Publisher applies this template to an input XML data file to create an output text file that can be transmitted to a bank or other customer.

Example - SUBSTR(ConctenatedInvoiceInfo, 1, 4) -If you want to use only the first four characters of the concatenated invoice info,

My suggestion is to split the functions and verify one by one.

Regards,

Arjun