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

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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