My Oracle Support Banner

Inconsistent Output For PCM_OP_RATE_TAX_CALC After Upgrade (Doc ID 2908406.1)

Last updated on JULY 06, 2023

Applies to:

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

Symptoms

On : 12.0.0.5.0 version, Rating

ACTUAL BEHAVIOR
---------------
Inconsistent output for PCM_OP_RATE_TAX_CALC after upgrade

PCM_OP_RATE_TAX_CALC cannot pass PIN_FLD_TAXCODE_MAP for specific tax entries in taxcodes_map file.

e.g:

Taxcode "Space - Setup" is correctly parsed but "Space - Set-up" is not parse from the taxcodes_map file.

op_rate_tax_calc calls op_rate_pol_pre_tax and the input flist of op_rate_pol_pre_tax is popluated with PIN_FLD_TAXCODE_MAP. This is not happening for certain taxcodes.
 

EXPECTED BEHAVIOR
-----------------------
There should be consistent output when opcode is executed.

Steps:

r << xxx 1
0 PIN_FLD_POID POID [0] 0.0.0.1 /account 311489086 12
0 PIN_FLD_START_T TSTAMP [0] (1661472000) Thu Aug 25 19:00:00 2022
0 PIN_FLD_END_T TSTAMP [0] (1661472000) Thu Aug 25 19:00:00 2022
0 PIN_FLD_ACCOUNT_NO STR [0] "500015"
0 PIN_FLD_CURRENCY INT [0] 840
0 PIN_FLD_CURRENCY_NAME STR [0] "USD"
0 PIN_FLD_TAXES ARRAY [0] allocated 20, used 9
1 PIN_FLD_TAX_CODE STR [0] "Space - Setup"
1 PIN_FLD_AMOUNT_TAXED DECIMAL [0] 290.00
1 PIN_FLD_BAL_GRP_OBJ POID [0] 0.0.0.1 /balance_group 311491902 6
1 PIN_FLD_GL_ID INT [0] 0
.

.

.
1 PIN_FLD_LOCATION_MODE ENUM [0] 0
0 PIN_FLD_INCORPORATED_FLAG ENUM [0] 0
0 PIN_FLD_RESIDENCE_FLAG ENUM [0] 0
0 PIN_FLD_VAT_CERT STR [0] ""
0 PIN_FLD_TAX_SUPPLIER INT [0] 8707
0 PIN_FLD_VATINFO ARRAY [0] allocated 20, used 2
1 PIN_FLD_CANON_COUNTRY STR [0] "US"
1 PIN_FLD_VAT_CERT STR [0] "vat_cert_US"
0 PIN_FLD_NAME STR [0] "Exod"
0 PIN_FLD_REGULATED_FLAG ENUM [0] 0
0 PIN_FLD_EVENT_TYPE STR [0] "/event/billing/product/fee/purchase"
xxx
xop PCM_OP_RATE_TAX_CALC 0 1
nap(17156)> xop: opcode 502, flags 0
# number of field entries allocated 20, used 2
0 PIN_FLD_POID POID [0] 0.0.0.1 /account 311489086 12
0 PIN_FLD_TAXES ARRAY [0] allocated 20, used 3
1 PIN_FLD_TAX DECIMAL [0] 21.39
1 PIN_FLD_SUBTOTAL ARRAY [0] allocated 20, used 9
2 PIN_FLD_TYPE ENUM [0] 1
2 PIN_FLD_AMOUNT_TAXED DECIMAL [0] 290.00
2 PIN_FLD_NAME STR [0] "US; MN; ; Shakopee; 55379; [241390940]; 1 - General Sales and Use Tax; 0.00; 0"
2 PIN_FLD_PERCENT DECIMAL [0] 0.06875
2 PIN_FLD_TAX DECIMAL [0] 19.94
2 PIN_FLD_DESCR STR [0] "General Sales and Use Tax"
2 PIN_FLD_SUBTYPE ENUM [0] 0
2 PIN_FLD_AMOUNT_GROSS DECIMAL [0] 290.00
2 PIN_FLD_AMOUNT_EXEMPT DECIMAL [0] .00
1 PIN_FLD_SUBTOTAL ARRAY [1] allocated 20, used 9
2 PIN_FLD_TYPE ENUM [0] 8
2 PIN_FLD_AMOUNT_TAXED DECIMAL [0] 290.00
2 PIN_FLD_NAME STR [0] "US; MN; ; Shakopee; 55379; [241390940]; 1 - Local Sales and Use Tax; 0.00; 0"
2 PIN_FLD_PERCENT DECIMAL [0] 0.005
2 PIN_FLD_TAX DECIMAL [0] 1.45
2 PIN_FLD_DESCR STR [0] "Local Sales and Use Tax"
2 PIN_FLD_SUBTYPE ENUM [0] 0
2 PIN_FLD_AMOUNT_GROSS DECIMAL [0] 290.00
2 PIN_FLD_AMOUNT_EXEMPT DECIMAL [0] .00


Failure scenario:

nap(17156)> r << xxx 1
0 PIN_FLD_POID POID [0] 0.0.0.1 /account 1 12
0 PIN_FLD_START_T TSTAMP [0] (1661472000) Thu Aug 25 19:00:00 2022
0 PIN_FLD_END_T TSTAMP [0] (1661472000) Thu Aug 25 19:00:00 2022
0 PIN_FLD_ACCOUNT_NO STR [0] "320211"
0 PIN_FLD_CURRENCY INT [0] 840
0 PIN_FLD_CURRENCY_NAME STR [0] "USD"
0 PIN_FLD_TAXES ARRAY [0] allocated 20, used 9
1 PIN_FLD_TAX_CODE STR [0] "Space - Set-up"
1 PIN_FLD_AMOUNT_TAXED DECIMAL [0] 290.00
1 PIN_FLD_BAL_GRP_OBJ POID [0] 0.0.0.1 /balance_group 1 6
1 PIN_FLD_GL_ID INT [0] 0
.

.
1 PIN_FLD_LOCATION_MODE ENUM [0] 0
1 PIN_FLD_TAXPKG_TYPE ENUM [0] 0
1 PIN_FLD_TAXPKG_TAX_CODE STR [0] ""
1 PIN_FLD_ELAPSED_TIME TSTAMP [0] (0)
0 PIN_FLD_INCORPORATED_FLAG ENUM [0] 0
0 PIN_FLD_RESIDENCE_FLAG ENUM [0] 0
0 PIN_FLD_VAT_CERT STR [0] ""
0 PIN_FLD_TAX_SUPPLIER INT [0] 8707
0 PIN_FLD_VATINFO ARRAY [0] allocated 20, used 2
1 PIN_FLD_CANON_COUNTRY STR [0] "US"
1 PIN_FLD_VAT_CERT STR [0] "vat_cert_US"
0 PIN_FLD_NAME STR [0] "Exod"
0 PIN_FLD_REGULATED_FLAG ENUM [0] 0
0 PIN_FLD_EVENT_TYPE STR [0] "/event/billing/product/fee/purchase"
0 PIN_FLD_ROUNDING INT [0] 2
0 PIN_FLD_ROUNDING_MODE ENUM [0] 5
xxx
xop PCM_OP_RATE_TAX_CALC 0 1
nap(17156)> xop: opcode 502, flags 0
XOP "502" failed: err 13:PIN_ERR_MISSING_ARG, field 0/1519:PIN_FLD_TAXCODE_MAP,
  loc 5:PIN_ERRLOC_FM, errclass 1:PIN_ERRCLASS_SYSTEM_DETERMINATE, rec_id 0, resvd 0
# number of field entries allocated 20, used 2
0 PIN_FLD_POID POID [0] 0.0.0.1 /error_poid 1 0
0 PIN_FLD_ERR_BUF ERR [0]
  <location=PIN_ERRLOC_FM:5 class=PIN_ERRCLASS_SYSTEM_DETERMINATE:1 errno=PIN_ERR_MISSING_ARG:13>
  
  <facility=0 msg_id=0 version=0>
nap(17156)>

Please resolve this issue.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


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