DM_VERTEX Not Calculating As Per The Tax Configuration

(Doc ID 1565747.1)

Last updated on OCTOBER 06, 2017

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.4.0.0.0 to 7.4.0.1.0 [Release 7.4.0]
Linux x86-64
***Checked for Relevance on 10/06/2017***

Symptoms

Vertex is used to calculate the taxes.

If dm_vertex is down, and suppose any operation like product purchase using (PCM_OP_SUBSCRIPTION_PURCHASE_DEAL) or tax calculation (PCM_OP_RATE_TAX_CALC) is executed, no error is being returned, instead the operation is success.
Thus revenue loss is occuring.

Tax when: Event time

Steps to reproduce:

Used testnap with the following input flist to execute some unit tests.

1) Change tax_supplier_interweb.xml address as


<TaxSupplierConfiguration
xmlns="http://www.portal.com/PortalXMLSchema"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.portal.com/PortalXMLSchema
/export/pinxxxx/opt/portal/7.4/xsd/pin_tax_supplier.xsd">
<TaxSupplierElement>
<Name>INTERWEB</Name>
<Description>INTERWEB-ADDRESS</Description>
<Address>Denver;CO;80202;US</Address>
<NexusInfo>CA;OH;NY;CO</NexusInfo>
<RegulatedFlag>0</RegulatedFlag>
<DefaultFlag>1</DefaultFlag>
<VATInfo>
<CanonCountry>US</CanonCountry>
<VATCertificate>US4567890</VATCertificate>
</VATInfo>
</TaxSupplierElement>
</TaxSupplierConfiguration>

load the file and restart cm and dm_vertex.

2) In sys/cm/taxcodes_map file:
uncomment ct_direct

3) In sys/data/config
load_tax_supplier -dv pin_tax_supplier.xml

4) Commit the plan.
5) Restart all services
6) stop_dm_vertex; source setup_vertex; start_dm_vertex
7) Create an account with add Denver;CO;80202;US through cc. 
8) Run the below opcode through testnap when dm_vertex is up.

#PCM_OP_RATE_TAX_CALC
# number of field entries allocated 20, used 9
0 PIN_FLD_POID POID [0] 0.0.0.1 /account 2134877 1
0 PIN_FLD_END_T TSTAMP [0] (1300135038) Mon Mar 14 13:37:18 2011
0 PIN_FLD_CURRENCY INT [0] 124
0 PIN_FLD_CURRENCY_NAME STR [0] "CAD"
0 PIN_FLD_TAXES ARRAY [0] allocated 20, used 8
1 PIN_FLD_TAX_CODE STR [0] "ct_direct"
1 PIN_FLD_AMOUNT_TAXED DECIMAL [0] 20
1 PIN_FLD_GL_ID INT [0] 0
1 PIN_FLD_SHIP_FROM STR [0] ";;;;[700190820,2,1]"
1 PIN_FLD_SHIP_TO STR [0] ";;;;[700190820,2,1]"
1 PIN_FLD_INTERNATIONAL_IND INT [0] 1
1 PIN_FLD_LOCATION_MODE ENUM [0] 1
1 PIN_FLD_ELAPSED_TIME TSTAMP [0] (249) Wed Dec 31 16:04:09 1969
0 PIN_FLD_VAT_CERT STR [0] ""
0 PIN_FLD_INCORPORATED_FLAG ENUM [0] 0
0 PIN_FLD_RESIDENCE_FLAG ENUM [0] 0
0 PIN_FLD_REGULATED_FLAG ENUM [0] 0

Prepatch Behavior:
Transactions succeeds but appropriate taxes are not applied



Changes

 

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