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

HCM Integration Real Time

Received Response
edited Sep 1, 2021 3:56PM in Reporting and Analytics for HCM 4 comments


HCM Integration Real Time


Hi Experts,

I am trying to build an OTBI report based on "HCM Integration Real Time" subject area to fetch HCM Extract definition details. I am successful until I add the column "Rule" from Extract Attribute section. Any idea why this column "Rule" is causing issue ?

As soon as I put the rule in selection , I get "State: HY000. Code: 17001. [nQSError: 17001] Oracle Error code: 1427, message: ORA-01427: single-row subquery returns more than one row at OCI call OCIStmtFetch. (HY000)"

Could someone suggest or share the catalog file if similar report is available handy ?


Harish C

Howdy, Stranger!

Log In

To view full details, sign in.


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