PRC: Transaction Import shows no record to import and errors with ORA-20001 HXC_0012_GNRET_NO_TIMECARDS

(Doc ID 464865.1)

Last updated on MARCH 29, 2018

Applies to:

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


-- Problem Statement:
In OTL, successfully submitted and approved a project timecard. In PA, run PRC: Transaction Import concurrent request, it normally completed. But the request output shows that no timecard record to import, log shows Pa_Otc_Api query returns no results.
After turn on PA debug and FND diagnostic options, found that package hxc_generic_retrieval_pkg raised exception: ORA-20001 HXC_0012_GNRET_NO_TIMECARDS. In table hxc_latest_details, all records of timecard, column application_set_id was null.


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