Loop When Executing Pin_inv_export (Doc ID 822043.1)

Last updated on SEPTEMBER 21, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.3.1.0.0 and later
Information in this document applies to any platform.
***Checked for relevance on 10-Mar-2012***


Symptoms

Problem Statement:

When executing pin_inv_export, the application fetches the same invoice once the fetch_size of objects have been processed .

Steps To Reproduce:

1) Make the below entries in the pin.conf file in pin_inv

- pin_inv_export children 5
- pin_inv_export per_batch 5
- pin_inv_export per_step 25
- pin_inv_export fetch_size 25


2) Create 30 accounts
3) Run pin_bill_day for the cycle
4) Run pin_inv_accts for the same with the below command

pin_inv_accts -v -end <time>

5) Run pin_inv_export for the period

It can be seen that looping happens as shown in the pin_inv pinlog file:

517 Step next result:
518 # number of field entries allocated 27, used 26
519 0 PIN_FLD_POID POID [0] 0.0.0.1 /search/pin 0 0
520 0 PIN_FLD_RESULTS ARRAY [0] allocated 20, used 6
521 1 PIN_FLD_POID POID [0] 0.0.0.1 /invoice 18414505997 0
522 1 PIN_FLD_ACCOUNT_OBJ POID [0] 0.0.0.1 /account 38242572 1362
523 1 PIN_FLD_BILL_NO STR [0] "B1-345862633"
524 1 PIN_FLD_CREATED_T TSTAMP [0] (1232704777) Fri Jan 23 04:59:37 2009
525 1 PIN_FLD_INV_FLAGS INT [0] 1
526 1 PIN_FLD_BILL_OBJ POID [0] 0.0.0.1 /bill 17889247632 7
.............
.............
.............
140837 Step next result:
140838 # number of field entries allocated 27, used 26
140839 0 PIN_FLD_POID POID [0] 0.0.0.1 /search/pin 0 0
140840 0 PIN_FLD_RESULTS ARRAY [0] allocated 20, used 6
140841 1 PIN_FLD_POID POID [0] 0.0.0.1 /invoice 18414505997 0
140842 1 PIN_FLD_ACCOUNT_OBJ POID [0] 0.0.0.1 /account 38242572 1362
140843 1 PIN_FLD_BILL_NO STR [0] "B1-345862633"
140844 1 PIN_FLD_CREATED_T TSTAMP [0] (1232704777) Fri Jan 23 04:59:37 2009
140845 1 PIN_FLD_INV_FLAGS INT [0] 1
140846 1 PIN_FLD_BILL_OBJ POID [0] 0.0.0.1 /bill 17889247632 7



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