Oracle Fusion Accounting Hub Update

We have a requirement where the client would like to use an existing column in the FAH source to capture the VAT amount and use that value as the entered amount in Oracle Fusion.

The challenge is that the available columns in the existing source are of Alphanumeric data type, while the requirement also involves using a custom formula to derive the amount.

Requirement:

• New column: LOCAL_TAX_AMT (Alphanumeric)
  • This column will store the VAT amount where applicable.
  • For all other records, the value will be populated as '0.00'.
• Default Amount
  • Data Type: Numeric
  • Holds the contract dollar value (USD).