My Oracle Support Banner

Fusion Global HR: Update Person Search Keywords Process Runs to Success but Logs Show ORA-14054: Invalid ALTER TABLE TRUNCATE PARTITION option (Doc ID 2281015.1)

Last updated on DECEMBER 16, 2017

Applies to:

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


When running the 'Update Person Search Keywords' ESS job without parameters, the log and output file state the following;

Begin Crawler
Keyword crawler for All Persons with shadow table/setBasedSql: STARTED by 2017-06-20 12:48:07.547863000 +00:00
failed to truncate data from PER_KEYWORDS_SH ORA-14054: invalid ALTER TABLE TRUNCATE PARTITION option
End of Crawler


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

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