After Billing The Pending_Recv In Billinfo Is Not Equal To Due In Bill. Is It A Problem?

(Doc ID 736732.1)

Last updated on SEPTEMBER 26, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.2.1.0.0 to 7.2.1.0.0 [Release 7.2.1]
Information in this document applies to any platform.
***Checked for relevance on 12-Jun-2014***

Goal

The Pending_recv amount in billinfo is not equal to due in bill. Is this a problem?

Some analysis that was done to confirm this.

Get the accounts that should appear for this bill run where pending_recv > 0.04:

select distinct i.account_obj_id0
 from billinfo_t bi, item_t i
 where bi.poid_id0 = i.billinfo_obj_id0 and bi.pay_type = 10003 and       bi.account_obj_id0 =
i.account_obj_id0 and last_bill_obj_id0 > 0 and infranet_to_date(bi.collection_date)
>='04-Sep-2008' and infranet_to_date(bi.collection_date) < '05-Sep-2008' and i.status = 2
having sum(i.due) > = 0.04 group by i.account_obj_id0


This returned account poid: 645612102.

SQL Statement to produce "due" data:

select account_obj_id0, due
from item_t
where account_obj_id0=645612102
and status = 2

 

"ACCOUNT_OBJ_ID0"|"DUE"
645612102|4.31
645612102|0.9
645612102|35



Query to find out records to collect that pin_collect application runs:

select *
from billinfo_t b, account_t a, payinfo_t p
where b.poid_id0 > 1
and
infranet_to_date(b.collection_date) >= '04-Sep-2008' and infranet_to_date(b.collection_date)
< '05-Sep-2008'
and b.status = 10100 and b.pay_type = 10003 and b.payinfo_obj_id0 = p.poid_id0 and p.ach=0 and
b.account_obj_id0 = a.poid_id0
and a.poid_id0= 645612102 and b.pending_recv > 0.04 order by b.poid_id0 asc


The above query didn’t return any rows.

Verified the item poid and its details:

select poid_id0, poid_type, infranet_to_date(created_t) account_obj_id0, due, status
 from item_t
where account_obj_id0=645612102 and status = 2

 

"POID_ID0"|"POID_TYPE"|"ACCOUNT_OBJ_ID0"|"DUE"|"STATUS"
645766418|/item/cycle_tax|6/27/2008 7:57:57 PM|4.31|2
645765906|/item/misc|6/27/2008 7:57:57 PM|0.9|2
707742083|/item/cycle_forward|7/14/2008 7:46:39 PM|35|2


Verified the due in bill_t:

select poid_id0, infranet_to_date(created_t), due , invoice_obj_id0
from bill_t where account_obj_id0=645612102

 

"POID_ID0"|"INFRANET_TO_DATE(CREATED_T)"|"DUE"|"INVOICE_OBJ_ID0"
645613894|6/27/2008 7:55:23 PM|0|143333
645612870|6/27/2008 7:55:23 PM|40.21|220212
707293900|7/14/2008 9:47:50 AM|0|0
816179361|8/14/2008 6:38:39 PM|0|0



Pending-recv from billinfo_t is -21.55:

select poid_id0, pay_type, pending_recv from billinfo_t where account_obj_id0=645612102

 

"POID_ID0"|"PAY_TYPE"|"PENDING_RECV"
645611846|10003|-21.55



Due in Item_t – Due is 40.21:

select poid_id0, poid_type, infranet_to_date(created_t), account_obj_id0, due, status from item_t
where account_obj_id0=645612102 and status = 2

 

"POID_ID0"|"POID_TYPE"|"INFRANET_TO_DATE(CREATED_T)"|"ACCOUNT_OBJ_ID0"|"DUE"|"STATUS"
645766418|/item/cycle_tax|6/27/2008 7:57:57 PM|645612102|4.31|2
645765906|/item/misc|6/27/2008 7:57:57 PM|645612102|0.9|2
707742083|/item/cycle_forward|7/14/2008 7:46:39 PM|645612102|35|2



Due in Bill_T – Due is 40.21:

select poid_id0, infranet_to_date(created_t),infranet_to_date(end_t), due , invoice_obj_id0
from bill_t where account_obj_id0=645612102
order by created_t desc

 

"POID_ID0"|"INFRANET_TO_DATE(CREATED_T)"|"INFRANET_TO_DATE(END_T)"|"DUE"|"INVOICE_OBJ_ID0"
816179361|8/14/2008 6:38:39 PM|12/31/1969 7:00:00 PM|0|0
707293900|7/14/2008 9:47:50 AM|12/31/1969 7:00:00 PM|0|0
645613894|6/27/2008 7:55:23 PM|7/14/2008|0|143333
645612870|6/27/2008 7:55:23 PM|8/14/2008|40.21|220212



Solution

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