ECM- ABENDED AT STEP FS_MAP_PR.MAIN.MAPPER (PEOPLECODE) (Doc ID 2296621.1)

Last updated on AUGUST 13, 2017

Applies to:

PeopleSoft Enterprise FIN Cash Management - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

Condition Type 'like' in the criteria.

Process FS_MAP_PR abends with the following:

SQL error. Function: SQLExec Error Position: 59 Return: 920 - ORA-00920:
invalid relational operator Statement: select count(*) from
ps_bnk_stmt_prse_v where descrlonglikE'%12345%' Original Statement: select
count(*) from ps_BNK_STMT_PRSE_V where DESCRLONGlike'%12345%'

SQL error in Exec. (2,280) FS_MAPPER_ENGINE.DBNode.OnExecute Name:Load
PCPC:11055 Statement:259 Called from:FS_MAPPER_ENGINE.DBNode.OnExecute
Name:LoadNextValue Statement:124 Called
from:FS_MAPPER_ENGINE.MapperEngine.OnExecute Name:MapTtoT Statement:558
Called from:FS_MAPPER_ENGINE.MapperEngine.OnExecute Name:ProcessMapper
Statement:70 Called from:FS_MAPPER_ENGINE.MapperEngine.OnExecute
Name:ProcessMapper2 Statement:909 Called
from:FS_MAP_PR.MAIN.GBL.default.1900-01-01.Mapper.OnExecute Stat

Process 119528 ABENDED at Step FS_MAP_PR.MAIN.Mapper (PeopleCode) -- RC = 8

REPLICATION STEPS
=================
1. Create MAP ID that uses 'like' as a Condition Type
Set Up Financials / Supply Chain > Common Definitions > Data Export Import Utility > Map Definition

2. Run Data Export Import Request
Set Up Financials / Supply Chain > Common Definitions > Data Export Import Utility > Data Export Import Request



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