PCM_OP_SERACH In Patchset13 Throws ORA-00933 Error (Doc ID 2117513.1)

Last updated on MAY 25, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.5.0.0.0 to 7.5.0.0.0 [Release 7.5.0]
Information in this document applies to any platform.

Symptoms

On : 7.5.0.13.0 version,

PCM_OP_SERACH in PS13 throws error.


ERROR
-----------------------
 Fri Jan 22 14:02:21 2016 dvgllptmsapp01.corp.dev.com dm:8748 dm_subr.c(165):8990 1:dvgllptmsapp01.corp.dev.com:testnap:15359:-138615088:7:1453489341:4
ORACLE error: do_sql_mr_select: PINStmtExecute: code 933, op 0
=ORA-00933: SQL command not properly ended



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
r << XXX 1
0 PIN_FLD_POID POID [0] 0.0.0.1 /search -1 0
0 PIN_FLD_FLAGS INT [0] 512
0 PIN_FLD_TEMPLATE STR [0] " select X from /profile/test where UPPER(F1) like UPPER(V1) and F2 != V2 "
0 PIN_FLD_ARGS ARRAY [1] allocated 20, used 1
1 SIR_FLD_TM_PRF_CUSTOM_INFO ARRAY [*] allocated 20, used 1
2 SIR_FLD_TM_WEB_USER_ID STR [0] "IPINTCU0000001"
0 PIN_FLD_ARGS ARRAY [2] allocated 20, used 1
1 SIR_FLD_TM_PRF_CUSTOM_INFO ARRAY [*] allocated 20, used 1
2 SIR_FLD_TM_DELETED_FROM_NOP ENUM [0] 1
0 PIN_FLD_RESULTS ARRAY [*] allocated 20, used 0
XXX
xop 7 0 1

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