Ledger Summary And Detail Reports Not Tallying (Doc ID 948743.1)

Last updated on OCTOBER 29, 2009

Applies to:

Oracle Communications Billing and Revenue Management - Version: 7.3.0.0.0
Information in this document applies to any platform.

Goal

Run a summary report for the month of September, like below :

pin_ledger_report -mode run_report -start 09/01/09 -end 10/01/09 -type billed_earned -report gl_report_b-e-s  -summary -posted

Could not run the detailed report for the entire month of September owing to memory issues, we had to split it into 4 weeks each like below :

pin_ledger_report -mode run_report -start 09/01/09 -end 09/07/09 -type billed_earned -report 09012009_gl_report_b-e-d -detail -posted

pin_ledger_report -mode run_report -start 09/07/09 -end 09/14/09 -type billed_earned -report 09072009_gl_report_b-e-d -detail -posted

pin_ledger_report -mode run_report -start 09/14/09 -end 09/21/09 -type billed_earned -report 09142009_gl_report_b-e-d -detail -posted

pin_ledger_report -mode run_report -start 09/21/09 -end 10/01/09 -type billed_earned -report 09212009_gl_report_b-e-d -detail -posted

After we ran these reports, the total amount between summary report and details report are not tallying.We found some amount in Billed Earned is decreased in the detail report, when compared to the summary report generated for the whole month.

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