My Oracle Support Banner

Mass Additions Error: DATE_PLACED_IN_SERVICE. ORA-01830: Date Format Picture Ends Before Converting (Doc ID 2201503.1)

Last updated on NOVEMBER 29, 2016

Applies to:

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


When loading mass additions via FBDI Mass Additions Template, this error appears when running Post Mass Additions:

Record 5: Rejected - Error on table FA_MASS_ADDITIONS, column DATE_PLACED_IN_SERVICE.
ORA-01830: date format picture ends before converting entire input string

The issue can be reproduced at will with the following steps:
1. Create mass additions records with Fixed Asset Mass Additions template (FBDI). Create zip file
2. Navigate to Schedule Processes > Click Schedule New Process button
3. Search for Load Interface File for Import and click OK
4. Select file and Post Mass Additions interface
5. Click Schedule New Process button and search for Post Mass Additions and click OK
6. Select Asset Book and click OK
7. Process ends in error with the information above.


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

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

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