0 Replies Latest reply on Aug 10, 2016 5:39 AM by 2834979

    Fill Employee Hierarchy (POCFH) concurrent log contains error statement "Po.plsql.POFEH.080ORA-01436: CONNECT BY loop in user data"


      Hi all

      Please Help me its urgent

      We are user Oracle EBS 12.2.3


      In Purchase requisition  we are using Position Hierarchy for approving requisition. now we  change some position in Position Hierarchy, as par process of Oracle , we run Fill Employee Hierarchy process,

      Fill Employee Hierarchy process showing completed succesfully but in log message show below error,


          po.plsql.POFEH. : 080 : Error While Processing the Active Version Id : 24064ORA-01436: CONNECT BY loop in user data : -1436

          Error occured in : po.plsql.POFEH.080ORA-01436: CONNECT BY loop in user data : -1436


      as a result Position Hierarchy don't load new position of  employee , and all requisition struck.


      Thanks a Lot in Advance