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.
Need Payroll costing query to fetch the Element eligibility costing information
Summary
Payroll costingContent
I need to update the costing segment values at Element eligibility level. I tried to load the new costing segment values usinf CostAllocationAccount.dat HDL file with an effective date of 01/04/2020 but it did a correction instead of update. Then I tried to create the ConstingInfo.dat abd CostingAllocation.dat file with an Effective start date of 01/04/2020 to update the costing segment value but here I stuck finding the element eligibility records of all costable types.
Could anyone share a query so that it should fetch the below mentioned column values from pay_cost_info_f, pay_cost_allocation_f and pay_cost_allocation_accounts tables.
Tagged:
1