Purchase Requisition in Oracle Fusion

 Purchase Requisition in Oracle Fusion

To check the roles for creating the Purchase Requisition

Click on the User and Add Roles

We need the role called

Advanced Procurement Requester or Procurement Requester 

And also check for Data Access Role

Under 

Setup and Maintenance-->Choose Financials-->Manage Data Access for Users.

Click on Done

Run the scheduled process called LDAP

Now, go to Procurement-->Choose Purchase Requisition(Redwood pages) Purchase Requisition(ADF) classic method

Click on Edit Update requisition preferences

We can choose specific BU in which user want to do Purchase Requisition.

Choose Deliver to Location

Click on More Tasks

Enter Requisition Line

Destination Type would be Inventory

Subinventory leave blank

Click on Add to Cart

Enter another item details and click on Add to Cart

And then click on Add to Cart and click on Review

Click on Manage Approvals

It will show  Purchase Requisition Approval Flow

If you want to add more items in the cart then we need to use Shop option

Create the requisition

Enter into requisition line

proceed with filling the data and add to cart

And then click on Submit and view the PDF

=======================

Back-End Tables

SELECT PRH.requisition_number AS "PR_Number",
       PRH.document_status    AS "Status",
       PRH.description        AS "Header_Description",
       PNF.full_name          AS "Requester_Name",
       PRL.line_number        AS "Line_Num",
       PRL.item_description   AS "Item_Description",
       PRL.quantity           AS "Quantity",
       PRL.unit_price         AS "Price",
       PRL.currency_code      AS "Currency",
       -- Accounting Data from GL_CODE_COMBINATIONS
       GCC.segment1
       || '-'
       || GCC.segment2
       || '-'
       || GCC.segment3        AS "Account_Combination",
       -- Linked PO Number
       PHA.segment1           AS "Linked_PO_Number",
       PRH.creation_date      AS "Created_On"
FROM   por_requisition_headers_all PRH,
       por_requisition_lines_all PRL,
       por_req_distributions_all PRD,
       per_person_names_f PNF,
       po_distributions_all PDA,
       po_headers_all PHA,
       gl_code_combinations GCC
WHERE
  -- Header to Line
  PRH.requisition_header_id = PRL.requisition_header_id
  -- Line to PR Distribution
  AND PRL.requisition_line_id = PRD.requisition_line_id (+)
  -- PR Distribution to GL Code Combinations
  AND PRD.code_combination_id = GCC.code_combination_id (+)
  -- Header to Requester
  AND PRH.preparer_id = PNF.person_id (+)
  AND PNF.name_type (+) = 'GLOBAL'
  AND PNF.effective_end_date (+) > SYSDATE
  -- PR Distribution to PO Distribution
  AND PRD.distribution_id = PDA.req_distribution_id (+)
  -- PO Distribution to PO Header
  AND PDA.po_header_id = PHA.po_header_id (+)
-- Optional: Limit to last 30 days for performance
-- AND PRH.CREATION_DATE >= TRUNC(SYSDATE) - 30
ORDER  BY PRH.creation_date DESC,
          PRH.requisition_number DESC