HXC_ABS_RETRIEVAL_PKG Invalid PLS-00302: component 'COMMENT_TEXT' must be declared

(Doc ID 2299487.1)

Last updated on AUGUST 22, 2017

Applies to:

Oracle Time and Labor - Version 12.2 and later
Information in this document applies to any platform.

Goal

After CPU patches are applied or after grants and synonyms are recreated, package HXC_ABS_RETRIEVAL_PKG became invalid.

Why this is happening and how can be fixed?
 

Solution

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 hundreds of Community platforms