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 08, 2017

Applies to:

Oracle Time and Labor - Version 12.0.2 and later
Information in this document applies to any platform.
***Checked for relevance on 02-Feb-2011***


Symptoms

-- 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.

Cause

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