Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Extract Getting Into Error due the DBI 'Time in Current Job'
Content
Hello Everyone,
Hope everyone is doing great!
My requirement is to pull out the Job and Department Change Date Using HCM Extract.
I have an extract based on the UE "PER_EXT_SEC_ASSIGNMENT_UE' and there I am trying to fetch the data from the DBIs "Time in Current Job" and "Time in Current Department". Due to which extract is trowing an error which says:
--------------------
RA-20001: Formula EXT_RECORD1_300000010290800, line 56, no data returned. Details: Item HWP_EMP_TIME_CURR_ORG returned no data. This error most commonly occurs when a database item query returns no data, but the database item is configured not to allow no return data. It can also occur within a formula function call.
Tagged:
0