Error On Trial Billing : Pin_err_stream_eof, Fm_ar_get_action_items_find_item_details Search Error (Doc ID 1331765.1)

Last updated on JUNE 27, 2016

Applies to:

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

Symptoms


Scenario:

Created an account bill and  perform an A/R  operations and execute PCM_OP_AR_GET_ACTION_ITEMS

Sample flist (flist001):
 0 PIN_FLD_POID POID [0] 0.0.0.1 /account 963886 0
 0 PIN_FLD_AMOUNT_INDICATOR INT [0] 0
 0 PIN_FLD_AR_ACCOUNT_OBJ POID [0] 0.0.0.1 /account 963886 0
 0 PIN_FLD_AR_BILLINFO_OBJ POID [0] 0.0.0.1 /billinfo 340363 40
 0 PIN_FLD_BILLINFO_OBJ POID [0] 0.0.0.1 /billinfo 340363 40
 0 PIN_FLD_INCLUDE_CHILDREN INT [0] 0
 0 PIN_FLD_POID_TYPE STR [0] "/item/payment"
 0 PIN_FLD_STATUS ENUM [0] 2
 
 run from testnap:
 [brm@brm-test-vm-pb test]$ testnap
 ===> database 0.0.0.1 from pin.conf "userid"
 nap(6606)> r flist001 1
 nap(6606)> xop PCM_OP_AR_GET_ACTION_ITEMS 1
 xop: opcode 1317, flags 1
 buffer: 1
 XOP "1317" failed: err 50:PIN_ERR_STREAM_EOF, field 0/0:0,
 loc 2:PIN_ERRLOC_PCP, errclass 3:PIN_ERRCLASS_SYSTEM_RETRYABLE, rec_id  0, resvd 0




Which result in the error:

E Wed Apr 6 16:15:30 2011 test cm:18990 fm_ar_utils.cpp:2446 1:dev:<no_name>:18989:-134830400:1123:1302110107:2
fm_ar_get_real_time_tax_on_item error
<location=PIN_ERRLOC_DM:4 class=UNKNOWN:0 errno=PIN_ERR_STORAGE:43>
<field num=0:0,0 recid=0 reserved=3 reserved2=0 time(sec:usec)=0:0>
<facility=0 msg_id=0 version=0>


dm.pinlog snippet


E Wed Apr 6 16:15:30 2011test dm:2391 dm_subr.c(139):1739 1:dev:<no_name>:18989:-134830400:1123:1302110107:2
ORACLE error: do_sql_select: PINStmtExecute: code 936, op 0
=ORA-00936: missing expression
on

E Wed Apr 6 16:15:30 2011 test dm:2391 dm_search.c(100):2264 1:dev:<no_name>:18989:-134830400:1123:1302110107:2
ERROR: dm_search_calc: do_sql_select = 1: " select sum ( event_bal_impacts_t.amount ) from event_t ,event_bal_impacts_t where event_t.poid_id0 in ) and ( event_bal_impacts_t.impact_type = :1 or event_bal_impacts_t.impact_type = :2 ) and event_t.poid_TYPE NOT LIKE :3 and event_t.poid_TYPE NOT LIKE :4 and event_t.poid_TYPE NOT LIKE :5 and event_t.poid_TYPE NOT LIKE :6 and event_t.poid_id0 = event_bal_impacts_t.obj_id0"
E Wed Apr 6 16:15:30 2011 test dm:2391 dm_back.c(31):1440 1:dev:<no_name>:18989:-134830400:1123:1302110107:2
DMbe #3: process_op: op 7(PCM_OP_SEARCH), err 43(PIN_ERR_STORAGE)





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