Get Started with Redwood for Oracle Cloud HCM Begin Now
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.
SQL to report on draft applications?
Summary:
We have been trying to figure out for months the best way to report on incomplete applications. Through multiple CC posts, conversations with OCS, we still aren't 100% how to do this. Many people saying it can be done using SQL.
We have created the attached SQL to pull this, but the numbers do not look right - only 3% incomplete rate compared to almost 25% on our previous platform.
What we have used: The records where they have source information in the IRC_SOURCE_TRACKING table but no submission would these be draft applications?
Content (required):
Version (include the version you are using, if applicable):
Tagged:
0