3797614 - Error message No. FOT_US_INT_TAX_CALC078 during tax code transport in SAP S/4HANA Cloud Public Edition

In SAP S/4HANA Cloud Public Edition, during the transport of tax code for US internal tax solution, below error message is shown in the transport log:

In table T007V for &1(transport request) US &2(tax code) &3(jurisdiction code) Valid From Date precedes Valid
From Date.
Message no. FOT_US_INT_TAX_CALC078
Diagnosis
In table T007V for Transport Request &1, Country &2, Tax Code &3 and Jurisdiction
Code &4 Valid From Date is before the ValidFrom Date of the existing Tax Rate for the
same Tax Code and Jurisdiction Code in the system configuration.
System Response
This is a customizable message. The default message type is "E", "Error". You can use
the Message Control in Tax Area configuration step to change the message setting to
"W", "Warning", or "I", "Info". You can also disable the message entirely.
Please note, however, that any change you make to the message status is valid for all
users. That is, if you switch the message off, it will never show again, for any user,
unless you use the configuration step to re-enable it with one of the statuses mentioned.
If the message type is set to "Error", the system will not update the Tax Rate, unless the
ValidFrom Date of the new Rate is not later than the ValidFrom Date of the existing
Rate.
If the message type is set to "Warning" or "Info", the system will update the Tax Rate
and delete the old Tax Rate. It is the responsibility of the user to update the Tax Rate
again, in order to have the deleted Rate in the system again.
Need for updating of Tax Rates with older ValidFrom Date can occur when user
uploaded the Tax Rate files from different months in a wrong chronological order. After
changing the error message to "Warning" or "Info", the user can do the updates again,
starting with the files with relatively older ValidFrom Dates and finishing with files with
most recent ValidFrom Date.

SAP S/4HANA Cloud Public Edition

1. In configuration activity Define Tax Codes for Sales and Purchases (SSCUI 101016), maintain or transport changes to a tax code for a jurisdiction.
2. Import the transport into the target system.
3. Observe that the import is blocked with error FOT_US_INT_TAX_CALC078.

The tax code is not being updated in chronical order. 

The message is raised by application area FOT_US_INT_TAX_CALC when attempting to update a tax code where the new valid-from date is earlier than an existing customizing validity, resulting in a date conflict.

1. Open configuration activity Message Control in Tax Area (SSCUI 103887).
2. Select application area "FOT_US_INT_TAX_CALC".
3. Locate the check related to the valid-from date conflict (message FOT_US_INT_TAX_CALC078).
4. Adjust the message control as required: Set to “W” (Warning) or “I” (Info) to allow the update, or “-” (Deactivate) to bypass the blocking error. Consider the following system behaviors:

• With “W” or “I”, the system updates the tax rate and deletes old rates; re-create any needed prior rates afterward.
• If postings already exist in the target system, the update occurs only when the new valid-from date is later than existing rates.

     5.Reattempt the transport/import after the message control adjustment.

3404303 - Releasing transport with Tax Code customizing Check - SAP S/4HANA Cloud

FOT_US_INT_TAX_CALC078, message control, SSCUI 103887, SSCUI 101016, transport import error, tax code validity, valid-from date conflict, T007V, jurisdiction code, indirect tax, tax rate update, time-dependent tax, production vs qa, us tax calculation, tax configuration , KBA , FI-GL-GL-F-2CL , Value Added Tax (VAT) (Public Cloud) , Problem