My Oracle Support Banner

ORA-01830 When Trying To Error Upload Tax Rules (Doc ID 2195157.1)

Last updated on DECEMBER 11, 2019

Applies to:

Oracle Fusion Tax Cloud Service - Version 11.1.11.1.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.1.11.1.0 version, Functional Setup Manager

Error attempting to create Tax Rules via Spreadsheet.

ERROR
-----------------------
value used for ROWS parameter changed from 64 to 4
Record 1: Rejected - Error on table ZX_DATA_UPLOAD_INTERFACE, column EFFECTIVE_FROM.
ORA-01830: date format picture ends before converting entire input string

Record 2: Rejected - Error on table ZX_DATA_UPLOAD_INTERFACE, column EFFECTIVE_FROM.
ORA-01830: date format picture ends before converting entire input string

Record 3: Rejected - Error on table ZX_DATA_UPLOAD_INTERFACE, column EFFECTIVE_FROM.
ORA-01830: date format picture ends before converting entire input string

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Populate the spreadsheet with Tax rules information.
2. Run the import.

BUSINESS IMPACT

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


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