Offer Documentation extract failing

Summary

An error occurred during the query execution: ORA-01427: single-row subquery returns more than one row

Content

My companies Offer Documentation export has been working for over 2 years and just started failling recently.    

Version

17.8

Code 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">