EAP9.1: Brazil Localization - "Unknown Function or Variable in Expression" Error when Running FIN2025 SQR (Doc ID 2297722.1)

Last updated on AUGUST 17, 2017

Applies to:

PeopleSoft Enterprise FIN Payables Brazil - Version 9.1 to 9.1 [Release 9]
Information in this document applies to any platform.

Symptoms

Pay Cycle process FIN2025 is failing after applying Bundle # 21.

Steps:
------------
1) Create a Voucher.
2) Run Pay Cycle to generate the payment.
3) Run FIN2025 SQR.

Error:
-----------
Error in include file "E:\APP\PSFT\FS91ETST\sqr\finef100.sqc" on line 2739:
(SQR 4008) Unknown function or variable in expression: substring
LET $VCOD_BARRAS = SUBSTRING($VCOD_CONCESS_BRL,1,11) + SUBSTRING($VCOD_CONCESS_BRL,13,11) + SUBSTRING($VCOD_CONCESS_BRL,25,11) + SUBSTRING($VCOD_CONCESS_BRL,37,11).

Changes

 

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