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.
How to generate numbers sequentially and automatically for each employment record entered by a user
Summary
How to generate numbers sequentially and automatically for each employment record entered by a userContent
Hi experts,
I am trying to find out the solution for a customer requirement: to generate numbers sequentially and automatically for each employment record entered by a user (hire, transfer, promotion, termination, etc.). Numbers must be gapless.
I have created a table validated values set with a query like:
(select distinct max(****_ATTRIBUTE_NUMBER1) + 1 as ORD_NUM from PER_ALL_ASSIGNMENTS_M) VVF_ORDERS
And assigned this value set to a segment in PER_ASG_DFF.
I am able to get a new number from the list and it gets saved into the table.
Tagged:
3