How To Fetch Complete Entry/line From Taxcodes_map File for a Vertex/thirdparty Tax Code ? (Doc ID 2096576.1)

Last updated on MARCH 27, 2023

Applies to:

Goal

The user has customized PCM_OP_RATE_POL_PRE_TAX for the input which is being sent to Vertex during item level adjustment with tax. As part of this, the user needs to overwrite PIN_FLD_TAX_CODE and PIN_FLD_TAXCODE_MAP fields with new values.

The user was able to get PIN_FLD_TAX_CODE from event_bal_impacts_t but could not get the value that has to be passed to PIN_FLD_TAXCODE_MAP which is supposed to be the whole line corresponding to the tax code from taxcodes_map file.

The following ways have been tried to get the taxcodes_map entry:

1. Called PCM_OP_RATE_POL_GET_TAXCODE to fetch taxcodes
    But, its returning only user defined tax codes.

2. Used extern variable Tax_Table that caches the tax data during cm startup
    But, it also contains only user defined tax codes data.

3. Used fm_utils_tax_get_taxcode() and fm_utils_tax_get_taxcodes() functions
    But all these functions returned only user defined tax codes.

Basically, it is required to fetch all the vertex tax codes and its corresponding values like categoryCode and serviceCode values from taxcodes_map file.
Is there any way to achieve this other than parsing the file to get vertex tax codes?
 

Solution

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