Skip to main content
Integrations

Create dynamic ERP code mappings to be used with Oracle Fusion Tax integration

Content to be added before enhancing the synchronize extract payload. You need to create the DYNAMIC ERP Code Mapping in ONESOURCE Determination to get the correct tax rate code from the system.
  1. Go to ONESOURCE Determination,
    Configurations
    ,
    Mapping
    , and then
    ERP Code Mapping
    .
  2. Select
    Add ERP Code Mapping
    .
  3. Select the company for which you want to create the mapping.
  4. The mapping group gets populated automatically as the default for the company.
  5. Select
    Dynamic
     for the
    Type
    .
  6. Enter a mapping name.
  7. A
    mapping priority
     specifies the order in which the mapping gets applied and evaluated. It populates automatically; however, you can change the order based on your requirements.
  8. Select
    Delimiter
     values as
    underscore
     (_).
  9. Create these
    conditions
    , and then
    Save
    .
    1. Condition 1 - TAXERP_TAX_CODE IS NOT NULL, and select Use Delimiter.
    2. Condition 2 - TAXTAX_RATE_CODE IS NOT NULL, and select Use Delimiter.
    3. Condition 3 - TAXTAX_DIRECTION IS NOT NULL, and select Use Delimiter.
    4. Format: <TAXERP_TAX_CODE>_<TAXTAX_RATE_CODE>_<TAXTAX_DIRECTION>

This article applies to:

  • Product: ONESOURCE Determination,ONESOURCE Indirect Tax,ONESOURCE Determination,ONESOURCE Indirect Tax
  • Subject: Integration