Oracle Fusion - SQL Query to check error message while Change Purchase Order Failed while send for and approval

--SQL to Check PO Detail--

SELECT *

FROM FUSION.PO_HEADERS_ALL

WHERE SEGMENT1 = '900001114637' --ENTER PO NUMBER

--SQL to Check PO Version Details--

SELECT  CO_NUM,

      VERSION_ID

FROM    FUSION.PO_VERSIONS

WHERE   PO_HEADER_ID IN

      (SELECT PO_HEADER_ID FROM FUSION.PO_HEADERS_ALL WHERE SEGMENT1 = '900001114637' --ENTER PO NUMBER

  )

ORDER BY CREATION_DATE DESC

--SQL to Check PO Approval Error--

SELECT  TEXT_LINE

FROM    FUSION.PO_ONLINE_REPORT_TEXT

WHERE   VERSION_ID = 300000225949043 --ENTER THE 1ST VERSION ID RECEIVED FROM ABOVE QUERY

ORDER BY CREATION_DATE DESC

Oracle Fusion: How to create Approval Delegation Rules / Vacation Rule / Approval Delegation Rule

 

Step1: Click on Bell Icon

 

Click on Show all

Click on Worklist

 

Step2: Lets Create Delegation rule.

  Right Hand Side - Top Corner > Select Preference

-           Click on Other Rule

Se    Search the username for whom we need to created delegation rule.

-           Click on “+”

-           Enter Name

-           Select Checkbox – Execute rule between these dates.

-           Select Start and End Date

-           Select Task : Task Matching this conditions

-           Click on “+”

-           Search Approver and Select the Approver name which you want to delegate

-           Select the Radio Button Delegate To – Select the person whom we need to send approver during that period.

 

 

Person1- xyz@gmail.com  (who is on leave or vaction)

to

Person2 - abc@gmail.com (who will approve in absence of Person1)

 

Now going forward all the approval redirect to person2 till the end date which we selected.