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: 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!