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.
FUSION.PAY_CORE_UTILS
Summary
FUSION.PAY_CORE_UTILSContent
Hi,
Can someone share the package body of the FUSION.PAY_CORE_UTILS.
Iam facing an issue while retriving Balance values for all the employees using the pay_balance_view_pkg.get_balance_dimensions package. The error says"
The payroll relationship action ID is invalid. Details: Contact your help desk.
ORA-06512: at "FUSION.PAY_CORE_UTILS", line 1986
ORA-06512: at "FUSION.APP_EXCEPTION", line 60
Regards,
Riyaz
Code Snippet
SELECT DISTINCT papf.person_number,
uspn.display_name person_name,
paaf.assignment_status_type,
p.effective_date,
flv.meaning employee_category,
pd.name department,
pldv.location_name,
p.payroll_action_id,
SUM (CASE WHEN b.balance_name = 'Personal Loan' THEN NVL (bal.balance_value, 0) ELSE .00 END) "Personal Loan Paid",
0