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 11.1.11.1.0 and later
Information in this document applies to any platform.

Goal

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

Solution

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.