Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Getting an Error in BIP Report: ORA-01427: single-row subquery returns more than one row
Summary:
Currently, we are using the attached data model to generate a BIP report for Employee leave Details which is working perfectly. We got a requirement to get the Completed Date column from transactions table, for this I have using the below subquery, after running the report with date
from and to parameter, we are getting an error: ORA-01427: single-row subquery returns more than one row
(Select TO_CHAR(TXND.COMPLETED_DATE,'DD-Mon-YYYY')
from FUSION.HRC_TXN_HEADER TXNH,
FUSION.HRC_TXN_DATA TXND,
FA_FUSION_SOAINFRA.WFTASK WFT
where TXNH.MODULE_IDENTIFIER = 'Global Absence Recording'
and TXNH.TRANSACTION_ID = TXND.TRANSACTION_ID
Tagged:
0