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
Best way to query Job Application History - Event Details for time between specific event dates
Summary:
I have been wrestling with the same issue. For so many of our requirements, we need to be able to search though an application's history, find if/when certain things happened, and also determine the duration between when certain things happened.
Content (required):
I believe this requires sub queries and is outside the scope of the OTBI presentation layer. But I am having a very difficult time determining the join path between IRC_SUBMISSIONS and IRC_LC_HISTORY to be able to write a query. There is no model or documentation that provides this info. The documentation that exists falls short in this area. Can anyone help?
Tagged:
0