Pin_bill_day Completes Before "/bill" Object End_t Is Updated (Doc ID 819703.1)

Last updated on SEPTEMBER 26, 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 18-Oct-2011***
**Checked for relevance on 6th May 2013***



Symptoms

Scenario :


Errors Logged in dm_oracle.pinlog:

E Thu Apr 23 00:05:13 2009 xxxxx dm:5690 dm_ops.c(167):9816
1:xxxxx:pin_bill_accts:27239:5:110:1240445113:1
ERROR RFLDS: map_poid_to_table_info poid=("/payinfo/internal", 190257) table=payinfo_t
failed, err=4(PIN_ERR_BAD_ARG)
E Thu Apr 23 00:05:13 2009 xxxxx dm:5690 dm_ops.c(167):3337
1:xxxxx:pin_bill_accts:27239:5:110:1240445113:1
ERROR RFLDS: op_rflds_prep_top_level_flds(190257) failed, err=4(PIN_ERR_BAD_ARG)
E Thu Apr 23 00:05:13 2009 xxxxx dm:5681 dm_ops.c(167):9816
1:xxxxx:pin_bill_accts:27239:2:110:1240445113:1
ERROR RFLDS: map_poid_to_table_info poid=("/payinfo/internal", 195530) table=payinfo_t
failed, err=4(PIN_ERR_BAD_ARG)
E Thu Apr 23 00:05:13 2009 xxxxx dm:5681 dm_ops.c(167):3337
1:xxxxx:pin_bill_accts:27239:2:110:1240445113:1
ERROR RFLDS: op_rflds_prep_top_level_flds(195530) failed, err=4(PIN_ERR_BAD_ARG)
E Thu Apr 23 00:05:13 2009 xxxxx dm:5683 dm_ops.c(167):9816
1:xxxxx:pin_bill_accts:27239:4:110:1240445113:1
ERROR RFLDS: map_poid_to_table_info poid=("/payinfo/internal", 191620) table=payinfo_t
failed, err=4(PIN_ERR_BAD_ARG)
E Thu Apr 23 00:05:13 2009 xxxxx dm:5683 dm_ops.c(167):3337
1:xxxxx:pin_bill_accts:27239:4:110:1240445113:1
ERROR RFLDS: op_rflds_prep_top_level_flds(191620) failed, err=4(PIN_ERR_BAD_ARG)
E Thu Apr 23 00:05:13 2009 xxxxx dm:5690 dm_subr.c(116):1583
1:xxxxx:pin_bill_accts:27239:5:110:1240445113:1
ORACLE error: do_sql_select: PINStmtExecute: code 904, op 0
=ORA-00904: "CUST_SEG_LIST": invalid identifier
E Thu Apr 23 00:05:13 2009 xxxxx dm:5690 dm_ops.c(167):3390
1:xxxxx:pin_bill_accts:27239:5:110:1240445113:1
ERROR RFLDS: do_sql_select "select poid_DB, poid_ID0, poid_TYPE, poid_REV, mod_t,
account_no, brand_obj_DB, brand_obj_ID0,
brand_obj_TYPE, brand_obj_REV, timezone_id, status, status_flags, currency, currency_secondary,
group_obj_DB, group_obj_ID0,
group_obj_TYPE, group_obj_REV, bal_grp_obj_DB, bal_grp_obj_ID0, bal_grp_obj_TYPE, bal_grp_obj_REV,
close_when_t, item_poid_list,
next_item_poid_list, actg_type, last_status_t, gl_segment, cust_seg_list from payinfo_t where
payinfo_t.poid_id0 = :1", x=1, pp->id 190257


Steps To Reproduce:

  1. 5 minutes after the billing cycle ends, execute pin_bill_day.
  2. After pin_bill_day completes, query for bills with END_T = <cycle end date>
  3. Observe that several of the expected bills are not included in the query results.



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