General Ledger (GL) Report Missing Some Numbers When Account Billing Is Stopped and Resumed (Doc ID 1518951.1)

Last updated on SEPTEMBER 26, 2016

Applies to:

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

Symptoms

When an account is in stop billing (by changing /billinfo's PIN_FLD_BILLING_STATUS to 1) for a couple of months (for example, three sequential months, i.e July, August, September) and then in the next month (October) this account goes to billing again.  After billing, the previous months (July to September) are successfully billed.

The issue in here is when preparing reports for General Ledger (GL). Even though those invoices show the date of October (month in which those missing bills were generated), the GL report run in October for period Sept 1st - Sept 30th only shows the September bill. The July and August bills do not show in this GL report. And at the beginning of each month, GL report is run for previous month for posting. Since the account was in billing suspension in July to September, there wasn't any bill for July and August and the GL report was posted for those months. So July and August bills will be missing from GL report.

Expect the GL report for billed after the account is out of billing suspension shows all the previous missing bills. In this example, when pin_ledger_report is run in October for Sept 1st to Sept 30th, expect the report picks up July, August and September bills.

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