My Oracle Support Banner

Complex Opcode Search is not Working with Limiting Fields Option (PIN_FLD_MIN_ROW & PIN_FLD_MAX_ROW) (Doc ID 2722658.1)

Last updated on OCTOBER 26, 2020

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.5.0.22.0 and later
Information in this document applies to any platform.

Symptoms

This is a requirement to fetch both event & item table records with pagination option (1-100 records first, then 101-200 records and so on) by using BRM search opcode. For pagination, we have referred Oracle doc https://docs.oracle.com/cd/E16754_01/doc.75/e16702/prg_search.htm#BRMDR1722 which has an option use PIN_FLD_MIN_ROW and PIN_FLD_MAX_ROW fields, but these fields are not working with complex opcode search, getting dm_oracle error PIN_ERR_STORAGE and failed with Oracle error (ORA-00918). 

ERROR
-----------------------
dm_oracle.pinlog:
E Mon Sep  7 03:58:46 2020  Host_IP  dm:24679  dm_subr.c(173):9119 2:Host_IP:testnap:1920:-147220736:7:1599476326:1:root.0.0.0.1:::
        ORACLE error: do_sql_mr_select: PINStmtExecute: code 918, op 0
        =ORA-00918: column ambiguously defined


Looking for an option to fetch multiple tables results (complex search) with pagination option through BRM search opcode. 

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Search opcode input flist

r << 1 1
0 PIN_FLD_POID POID [0] 0.0.0.1 /search/pin -1 0
0 PIN_FLD_FLAGS INT [0] 0
0 PIN_FLD_MAX_ROW INT [0] 3
0 PIN_FLD_MIN_ROW INT [0] 1
0 PIN_FLD_TEMPLATE STR [0] " select X from /event 1, /item 2 where 1.F1 = 2.F2 AND 2.F3 = V3 and item_t.poid_type IN ( '/item/usage', '/item/adjustment') order by event_t.created_t desc "
0 PIN_FLD_ARGS ARRAY [1] allocated 20, used 1
1 PIN_FLD_ITEM_OBJ POID [0] NULL poid pointer
0 PIN_FLD_ARGS ARRAY [2] allocated 20, used 1
1 PIN_FLD_POID POID [0] NULL poid pointer
0 PIN_FLD_ARGS ARRAY [3] allocated 20, used 1
1 PIN_FLD_BILLINFO_OBJ POID [0] 0.0.0.1 /billinfo 2358771321 0
0 PIN_FLD_RESULTS ARRAY [0] allocated 20, used 1
1 PIN_FLD_POID POID [0] NULL poid pointer
1 PIN_FLD_BAL_IMPACTS ARRAY [1] allocated 22, used 22
2 PIN_FLD_AMOUNT DECIMAL [0] 0
1 PIN_FLD_LINKED_OBJ ARRAY [2] allocated 20, used 3
2 PIN_FLD_ITEM_OBJ POID [0] NULL poid pointer
2 PIN_FLD_LINK_DIRECTION ENUM [0] -1
2 PIN_FLD_EXTRA_RESULTS ARRAY [*] allocated 20, used 1
3 PIN_FLD_ITEM_NO STR [0] NULL str ptr
1
xop PCM_OP_SEARCH 0 1



Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.