Learn about the new Oracle Fusion AI Agent Studio on April 15, 2025 at 8:00 am PT - Register Now
Get Started with Redwood for Oracle Cloud HCM Begin Now
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.
EFF ID using Defaulting SQL does not work
We are currently utilizing Extensible Flexfields for Additional Assignment Information
Currently we are using an SQL as EFF entry ID to prevent same values being entered vs exisiting records for employee assignment.
However, despite utilizing Date and Time stamp within our SQL as Default ID Value it is still throwing an error as below:
here is the SQL we are using :
SELECT 'VM' || regexp_replace(TO_CHAR(SYSTIMESTAMP,'yy.MM.DD'), '[^0-9]', '') || '-' || regexp_replace(TO_CHAR(SYSTIMESTAMP,'HH24:MI:SS'), '[^0-9]', '') FROM dual
Any recommendations as to the approach how to not encounter error above?
Tagged:
0