Refunds Appear Twice In GL Extracts

(Doc ID 1479401.1)

Last updated on SEPTEMBER 24, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version to [Release 7.3.1]
Linux x86-64


Refund appears twice in GL extracts.

Same refund appears once in the Billed Earned report of one period and again in the Prev Billed Earned report of the subsequent period. This only happens when the refund is created during the first period and processed (for actual payment to customer) in the next period.

Steps to Reproduce :

  1. Assume the GL posting dates are 6/17/2011 and 6/18/2011 (a daily posting example)
  2. Generate a refund item on the day before the GL posting date (ie., on 6/16/2011)2. Move PVT to 6/17/2011
  3. Run pin_refund to process the refund generated.
  4. Run GL for "billied_earned" category.
  5. Move PVT to the next GL posting date (ie., to 6/18/2011) and run GL for "prev_billed_earned" category.
  6. Both outputs contain the impact from the same refund item.

This problem is also seen with pin_ledger_report's "run_report" mode.
The commands used for the run_report mode are below (for step 4 and 5 respectively) -

At step 4 -
  pin_ledger_report -mode run_report -start 6/16/2011 -end 6/17/2011 -type  billed_earned -detail -report billed_earned.out -verbose -test

At Step 5 -
  pin_ledger_report -mode run_report -start 6/17/2011 -end 6/18/2011 -type prev_billed_earned -detail -report prev_billed_earned.out -verbose -test


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