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
Offer Documentation extract failing
Summary
An error occurred during the query execution: ORA-01427: single-row subquery returns more than one rowContent
My companies Offer Documentation export has been working for over 2 years and just started failling recently.
Version
17.8Code Snippet
<quer:query productCode="TR1502" model="http://www.taleo.com/ws/tr800/2009/04" projectedClass="TransitionProcess" locale="en" alias="MainQuery" mode="T-XML" largegraph="true" preventDuplicates="false" xmlns:quer="http://www.taleo.com/ws/integration/query"> <quer:subQueries/> <quer:projections> <quer:projection alias="CandidateNumber"> <quer:field path="ProfileInformation,Candidate,Number"/> </quer:projection> <quer:projection alias="EmployeeNumber"> <quer:field path="ProfileInformation,Candidate,EmployeeNumber"/> </quer:projection> <quer:projection alias="EmailAddress"> <quer:field path="ProfileInformation,Candidate,EmailAddress"/> </quer:projection> <quer:projection alias="FirstName"> <quer:field path="ProfileInformation,Candidate,FirstName"/> </quer:projection> <quer:projection alias="MiddleInitial"> <quer:field path="ProfileInformation,Candidate,MiddleInitial"/> </quer:projection> <quer:projection alias="LastName">
Tagged:
0