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
Skip to content
  • Register
    • Get Started: AI Resources for Oracle Cloud HCM – Go Here

    Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

    SQL to get balance value errors out in BI

    edited Oct 8, 2020 8:32PM in Payroll and Global Payroll Interface (GPI) 3 comments

    Summary

    SQL to get balance value errors out in BI

    Content

    I am trying to fetch some balance value by calling the package in BI sql pay_balance_pkg.get_value_dbi and i get the following error 

    oracle.xdo.servlet.data.DataException: oracle.xdo.servlet.data.DataException: oracle.xdo.servlet.data.DataException: oracle.xdo.XDOException: java.sql.SQLException: ORA-20001: 

    The payroll relationship action ID is invalid. 

    Details: Contact your help desk. 

    ORA-06512: at "FUSION.PAY_CORE_UTILS", line 1938 ORA-06512: at "FUSION.PAY_BALANCE_PKG", line 5238 ORA-06512: at "FUSION.PAY_BALANCE_PKG", line 5352 ORA-06512: at "FUSION.PAY_BALANCE_PKG", line 5562 ORA-06512: at "FUSION.PAY_BALANCE_PKG", line 5625 ORA-06512: at "FUSION.PAY_BALANCE_PKG", line 5741

    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

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