Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now
Progress with Redwood: Redwood 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
Summary
SQL to get balance value errors out in BIContent
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:
0