Incorrect Bill Period For Monthly General Ledger Report (Doc ID 2786972.1)

Last updated on AUGUST 27, 2023

Applies to:

Symptoms

The issue can be reproduced at will with the following steps:

1) Go to $PIN_HOME/sys/data/config/
load the file as load_pin_config_export_gl -v pin_config_export_gl.xml

2) In sys/data/pricing/example , update the entry in 'pin_glid' file.

  gl_segment .east no_rollup

In sys/cm/pin.conf,

Add the entry ==> "- fm_cust_pol gl_segment .east"
Comment the entry ==> #- fm_cust_pol gl_segment .

Restart the cm/pin

3) Create a product with Cycle Forward Event with 100 USD and GLID "Monthly Charges"
Create a Plan using that Product

pvt to Nov 1
Create an Account using that plan
move the pvt from Nov 1 to Dec 1
run pin_bill_accts
move the pvt from Dec 1 to Jan 1
run pin_bill_accts

4) From sys/data/pricing/example
pin_ledger_report -mode run_report -segment .east -start 12/01/2020 -end 01/01/2021 -type billed_earned -detail -all_resource -verbose

  CM input flist: opcode PCM_OP_BILL_LEDGER_REPORT, opflags=0x0
# number of field entries allocated 20, used 8
0 PIN_FLD_POID POID [0] 0.0.0.1 /ledger_report -1 0
0 PIN_FLD_NAME STR [0] "pin_ledger_report"
0 PIN_FLD_GL_REPORT_TYPE INT [0] 1
0 PIN_FLD_CURRENCY_ONLY INT [0] 2
0 PIN_FLD_TYPE ENUM [0] 8
0 PIN_FLD_START_T TSTAMP [0] (1606809600) Tue Dec 1 00:00:00 2020
0 PIN_FLD_END_T TSTAMP [0] (1609488000) Fri Jan 1 00:00:00 2021
0 PIN_FLD_GL_SEGMENT STR [0] ".east"

  op_gl_ledger_report return flist
# number of field entries allocated 20, used 1
0 PIN_FLD_POID POID [0] 0.0.0.1 /ledger_report 516173 0

ACTUAL BEHAVIOR

+++++++++++++++

 Revenue reported belongs to 01-Nov-2020 to 30-Nov-2020 mid-night.

EXPECTED BEHAVIOR
+++++++++++++++
Revenue report should be from 01-Dec-2020 to 31-Dec-2020 mid-night.

Cause

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