General Ledger: Amount Is Not Journalled In Unbilled-Earned When Product Purchased After Billing (Doc ID 798620.1)

Last updated on SEPTEMBER 02, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version: 7.3.0.0.0
This problem can occur on any platform.

Symptoms

-- Problem Statement:
Amount is not journalled in Unbilled-Earned as expected.

-- Steps To Reproduce:

Scenario 1:
2011-12-01 : Create New Account 
                      Purchase RM10 ( Credit to Account as it is a Prepaid Account)
2011-12-28 : Run pin_bill_day
2012-01-01 : Generate / Post Ledger Report with the following command

pin_ledger_report -mode run_report -start 12/01/2011 -end 01/01/2012 -type unbilled_earned -report gl_report_ub-e-d_dec -detail -verbose
pin_ledger_report -mode run_report -start 12/01/2011 -end 01/01/2012 -type billed_earned -report
gl_report_b-e-d_dec -detail -verbose

Analysis :
---------------- 
(10) went into journal for GL_ID 40001002 for billed_earned as expected for customer
100000702.

Scenario 2:
2012-01-28 : Run pin_bill_day
2012-01-29 : Purchase RM20.
2012-02-01 : Generate / Post Ledger Report with the following command

pin_ledger_report -mode run_report -start 01/01/2012 -end 02/01/2012 -type unbilled_earned -report gl_report_ub-e-d_jan -detail -verbose
pin_ledger_report -mode run_report -start 01/01/2012 -end 02/01/2012 -type billed_earned -report gl_report_b-e-d_jan -detail -verbose

Analysis :
---------------- 
(20) should be recorded in journal for GL_ID 40001002 for unbilled_earned for customer
100000702. This is because customer made a purchase on 29-Jan 2012.
The Ledger Reporting is from 1-31 Jan 2012.

Actual Result :
----------------
However, this amount is not in journal as expected.

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