Issue With Stored Procedure BILLING_UPDATES Called During Billing
(Doc ID 1173404.1)
Last updated on MARCH 22, 2019
Applies to:Oracle Communications Billing and Revenue Management - Version 220.127.116.11.0 to 18.104.22.168.0 [Release 7.3.0 to 7.5.0]
Information in this document applies to any platform.
***Checked for relevance on 16-May-2012***
During billing of customer, the stored procedure BILLING_UPDATES is called. One of the input variables (the 12th) is BILL_NO – here is the cm.pinlog call:
This procedure performs the following sql statement:
Select mod_t from BILL_T where BILL_NO = :1
This statement is unnecessary for many reasons:
• Cm has all the fields and could pass the MOD_T (as an input parameter to the stored procedure) if needed.
The extra select mod_t from bill_t where bill_no = :1 should not be called
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