Billed And Billed Earned Revenue Types Not Created If Billing Is Executed After Gl Extraction Date (Doc ID 1349357.1)

Last updated on MAY 08, 2024

Applies to:

Symptoms

If the pin_ledger_report -mode export is executed without running pin_bill_day, even if pin_bill_day is subsequently executed, the GL data for the missed days are not accounted for.

### Steps to Reproduce ###

1. Configure GL extraction with:
   Frequency=Daily
   ReportLevel=Detailed
2. Create account with a cycle fee product
3. Run billing and GL extraction (billing first the GL extract next) normally until the next BDOM to see the normal GL behavior, i.e., there will be a 'Billed' revenue type reported on BDOM+1
4. Move date to the following BDOM, this time, run only pin_ledger_report -mode export
5. Move date a few more days and run only pin_ledger_report -mode export
6. Move 1 day forward and run pin_bill_day followed by pin_ledger_report -mode export
7. Query the GL data and you will notice that you are missing the GL data from BDOM until the day you run billing.

Example:
Suppose the BDOM of an account is 15 and it should have been billed last May 15.
Meanwhile GL is executed and posted daily without fail until May 20.
If billing is run on May 20, it will generate the cycle fees from May 15 for this account.
When GL is executed and posted the next day (May 21) and onwards, we do not see the GL data from May 15 to May 19.

Expected result :
On the May 21 GL extract,

1. There should be a 'Billed' revenue reported for May 15
2. There should also be a catch-up revenue for the missed days that should be reported under 'Billed Earned' revenue type

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.