OTBI filter show no data — Cloud Customer Connect
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

OTBI filter show no data

edited Dec 4, 2024 9:35AM in Reporting and Analytics for HCM 3 comments

Summary:

Hello experts,

we have a report for recruiting requisitions, but when trying to search in the values we get no data..

the list of values:

SELECT DISTINCT
IRB.REQUISITION_NUMBER || ' - ' || IRT.TITLE AS "REQUISITION_ID_Filter"
FROM IRC_REQUISITIONS_B IRB
JOIN IRC_REQUISITIONS_VL IRT ON IRB.REQUISITION_ID = IRT.REQUISITION_ID
WHERE 1=1
AND IRB.ATTRIBUTE_CHAR8 = 'N'
AND IRB.REQUISITION_NUMBER IS NOT NULL
AND IRT.TITLE IS NOT NULL
ORDER BY 1 DESC.



no matter what put on search, no data can be found.

best regards-

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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