General Ledger: Amount Is Not Journalled In Unbilled-Earned When Product Purchased After Billing
Last updated on SEPTEMBER 02, 2016
Applies to:Oracle Communications Billing and Revenue Management - Version: 126.96.36.199.0
This problem can occur on any platform.
-- Problem Statement:
Amount is not journalled in Unbilled-Earned as expected.
-- Steps To Reproduce:
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
(10) went into journal for GL_ID 40001002 for billed_earned as expected for customer
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
(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.
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