Tax Derivation Issue For US - SPECIAL_PURPOSE_DISTRICTUSOUTPUT from Vertex is 32 Characters Which Causes the Tax Calculation to Fail and the Order is Not Able to Book (Doc ID 1985438.1)

Last updated on MARCH 12, 2015

Applies to:

Oracle E-Business Tax - Version 12.1.3 and later
Information in this document applies to any platform.


On : 12.1.3 version, Partner Integration

VAT Tax Logic takes the Tax returned from the O Series XML response + 2 digit country code + OUTPUT. Typical example is COUNTRYCAOUTPUT.

For jurisdiction level SPECIAL_PURPOSE_DISTRICT, it is getting derived as SPECIAL_PURPOSE_DISTRICTUSOUTPUT - Which is 32 character.
The Tax package is defined as 30 character, which causes the tax calculation to fail and the order is not able to book.

Vertex information shows SPECIAL_PURPOSE_DISTRICT is valid value.

Need to increase size of zx_tax_partner_pkg.tax_lines_tbl_type from 30 characters to 150


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