My Oracle Support Banner

FATAXUP: Upload Tax Book Interface Program Error 'You Have Made No Changes You Need To Commit' (Doc ID 2960554.1)

Last updated on JULY 16, 2023

Applies to:

Oracle Assets - Version 12.1 and later
Information in this document applies to any platform.
FATAXUP

Symptoms

Uploading data to the Tax interface and running the FATAXUP: Upload Tax Book Interface program.
The program is showing the following for some assets in the log file:

Asset number Example 12345.
You have made no changes that you need to commit.
Tax Upload failed for this asset. Please view the log file for details.
Asset number Example 12346.
You have made no changes that you need to commit.
Tax Upload failed for this asset. Please view the log file for details.

Ending with the following:
Number of successes: XXX.
Number of failures: YYY.
Module Tax Upload Interface ended with error.


STEPS TO REPRODUCE THE ISSUE
--------------------------------------

1) Using an Oracle Assets responsibility, in the Corporate book create new asset(s).
2) Run the Mass Copy program to copy these assets into an existing tax book.
3) Using the API Procedure Name: IMPORT_TAX_BOOK, upload data to the FA_TAX_INTERFACE table.
4) Navigate to Other -> Requests -> Run
5) Select program Upload Tax Book Interface
6) Select the tax book to upload and submit.
7) This concurrent requests ends in error with the following seen in the log file.

Asset number Example 12345.
You have made no changes that you need to commit.
Tax Upload failed for this asset. Please view the log file for details.
Asset number Example 12346.
You have made no changes that you need to commit.
Tax Upload failed for this asset. Please view the log file for details.

Ending with the following:
Number of successes: XXX.
Number of failures: YYY.
Module Tax Upload Interface ended with error.

When comparing the data provided to the interface table with the Tax book asset data, it appears that the data was uploaded with success despite the message provided.
The corporate and tax books have differences in the following fields for the erroring assets: 

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


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