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.
Solved:How we delete Blank Status Processing Rules
Summary:
This is to share solutions with regard to cases where blank Status Processing Rules get created.
Content (required):
Sometimes while creating a new status processing rule,a blank row gets created.We can't delete this row from the element page.So, to resolve the issue,we can use HDL:
To get spr id,LDG id,element id,use below query:
select status_processing_rule_id,p1.EFFECTIVE_START_DATE,p2.element_type_id,p1.LEGISLATIVE_DATA_GROUP_ID
from pay_status_proc_rules_f p1, pay_element_types_vl p2
where p1.element_type_id = p2.element_type_id
Tagged:
7