Unexpected Tax Entries In General Ledger Reporting (Doc ID 1069712.1)

Last updated on SEPTEMBER 19, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.3.1.0.0 and later
Information in this document applies to any platform.
***Checked for relevance on 12-Oct-2012***

Symptoms

The understanding from the documentation is that the taxcode (a single one: CST) has to be provided in the GLID definition.

The expectation is that for each event, lets say purchase fee, for which the charges are applied, the corresponding tax should also be displayed in the same GLID.

Example for handset sales GLID = 102145, the expectation is that the tax corresponding with this event should be reported in the tax entry for GLID 102145.

However, this is not happening. As all the products have the same taxcode CST configured, BRM is putting the tax in GLID 100100, that is the GLID where the tax CST occurs for the first time in pin_glid.

Reproduction steps
:

1) the taxcode is defined for 13% tax (taxcode_map file):

 CST : U : 13.0 : 02/01/02 : 01/31/20 : Fed : IT : testSR : Std


Note: CM pin.conf - fm_bill taxation_switch 3

2) in the pin_glid file, the following entries are configured:

glid (
id 100100
descr Barter Adjustment
taxcode CST
gl_acct billed gross 1200 7776
gl_acct billed net 1200 7776
gl_acct billed_earned gross 1200 7776
gl_acct billed_earned net 1200 7776
)

[ ... ]

glid (
id 102145
descr HandsetsSalesMobile.onetime
taxcode CST
gl_acct billed gross 12500000052101000000000 12500000061181000000000
gl_acct unbilled gross 12500000052101000000000 12500000061181000000000
)


3) Created a new product/deal/plan, defined with:

Purchase Fee = 50$ scaled amount
taxcode (event time) = CST
GLID = 102145 (HandsetsSalesMobile.onetime)


4) Stop & start CM and created a new account with above plan. Balance is (as expected):

 56.50$ = 50.00$ + 13% tax.

5) Run GL reporting, with:

pin_ledger_report -mode run_report -start 01/01/2010 -end 05/30/2010 -segment -type unbilled -report test1.txt -detail -verbose -test


which returns the following records:

ACCT #: 0.0.0.1-514869 DATE: -- N/A -- BILL #: -- N/A --
ITEM #: -- N/A -- (Usage)
100100 (USD) DEBIT ACCOUNT DEBIT CREDIT
CREDIT ACCOUNT DEBIT CREDIT
______________________________________________________________________________
GROSS -- N/A -- 0.00 0.00 --
N/A -- 0.00 0.00
NET -- N/A -- 0.00 0.00 --
N/A -- 0.00 0.00
DISC -- N/A -- 0.00 0.00 --
N/A -- 0.00 0.00
TAX -- N/A -- 6.50 0.00 --
N/A -- 0.00 6.50

ACCT #: 0.0.0.1-514869 DATE: -- N/A -- BILL #: -- N/A --
ITEM #: -- N/A -- (Usage)
102145 (USD) DEBIT ACCOUNT DEBIT CREDIT
CREDIT ACCOUNT DEBIT CREDIT
______________________________________________________________________________
GROSS 12500000052101000000000 50.00 0.00
12500000061181000000000 0.00 50.00
NET -- N/A -- 50.00 0.00 --
N/A -- 0.00 50.00
DISC -- N/A -- 0.00 0.00 --
N/A -- 0.00 0.00
TAX -- N/A -- 0.00 0.00 --
N/A -- 0.00 0.00


As seen, the tax amount is appearing on GLID 100100, in place of the expected 102145.


Cause

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