You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
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.

FUSION.PAY_CORE_UTILS

edited Feb 11, 2021 12:35PM in Payroll and Global Payroll Interface (GPI) 1 comment

Summary

FUSION.PAY_CORE_UTILS

Content

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",
      

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!