Purchasing

Get Involved. Join the Conversation.

Topic

    Puneet Goyal
    Requisitions are not appearing in Process Requisitions Page
    Topic posted August 16, 2019 by Puneet GoyalRed Ribbon: 250+ Points, tagged Create Requisition, Fusion, Orders, Requisition Processing 
    77 Views, 14 Comments
    Title:
    Requisitions are not appearing in Process Requisitions Page
    Summary:
    Requisitions are not appearing in Process Requisitions Page without running Generate Orders
    Content:

    Hi All,

    I really need some feedback on this topic. Below is the scenario I am working on:

    1. I am creating an Expense Requisition Manually.

    2. I have Buyer Assignment Rule for this Category.

    3. When I approve the requisition, I can see buyer is also getting assigned in the requisition based upon Buyer assignment rule.

    4. But I am not able to see requisition on Process Requisition page.

    5. If I run Generate Orders Program, then I can see requisition on Process Requisition Page.

    I have done multiple Cloud Procurement Implementations and have never used Generate Orders program for requisitions to appear on Process Requisition page.

    In my current Project also, we never used Generate Orders process for Manual Requisitions to appear on Process Requisition page earlier.

    But after recent upgrade to 19B, we have to run Generate Orders program for manual requisitions to appear on Process Requisition page. 

    Oracle Support engineer says this was always supposed to be working like this, which I don't agree with.

    Version:
    19B

    Comment

     

    • Karthikeyan Sukumar

      Puneet- That requisition is in Approved status rite ? and still not seeing that ?

       

      Thanks!

      Karthik

      • Puneet Goyal

        Yes Karthik,

        Requisition is Approved.

        Regards,

        Puneet

        • Karthikeyan Sukumar

          Can you see all are set correctly as below.Mainly see the POOL_FLAG for that requisition if it is N then it wont show up.

          Requisition is status Approved
          PRC BU populated
          Buyer field completed
          Negotiated flag checked
          Not previously converted to PO
          REQS_IN_POOL_FLAG = Y

          Thanks!

          Karthik

          • Puneet Goyal

            1. Requisition is Approved

            2. Cannot see Procurement BU from front end.

            3. Buyer field is populated. 

            4. Cannot see Negotiated Flag from front end.

            5. No PO Created.

            6. Cannot see REQS_IN_POOL_FLAG from front end.

          • Puneet Goyal

            Karthik,

            Below is the data from POR_REQUISITION_LINES_ALL, PRC_BU_ID is populated but REQS_IN_POOL_FLAG is N.

            REQUISITION_HEADER_ID (300000100743298)
            REQ_BU_ID (300000001296310)
            PRC_BU_ID (300000001296310)
            DEFAULT_TAXATION_COUNTRY (AU)
            LINE_GROUP (LINES_AWAITING_PROCESSING)
            CREATED_BY (Puneet.Goyal)
            CREATION_DATE (2019-08-17T02:15:03.064+00:00)
            LAST_UPDATED_BY (Puneet.Goyal)
            LAST_UPDATE_DATE (2019-08-17T02:15:27.166+00:00)
            LAST_UPDATE_LOGIN (8E98132946CD60F0E05390717C0A3A29)
            OBJECT_VERSION_NUMBER (5)
            REQUISITION_LINE_ID (300000100743299)
            LINE_NUMBER (1)
            LINE_TYPE_ID (1)
            CATEGORY_ID (300000084012776)
            ITEM_DESCRIPTION (Laptop4)
            UOM_CODE (EA)
            UNIT_PRICE (1)
            PRICE_VARIANCE_EXCEEDED_FLAG (N)
            QUANTITY (1)
            ASSIGNED_BUYER_ID (300000069408820)
            NEED_BY_DATE (2019-08-24T00:00:00.000+00:00)
            CURRENCY_CODE (AUD)
            CURRENCY_UNIT_PRICE (1)
            URGENT_FLAG (N)
            DESTINATION_TYPE_CODE (EXPENSE)
            DESTINATION_ORGANIZATION_ID (300000049690586)
            DELIVER_TO_LOCATION_ID (300000049690263)
            ONE_TIME_LOCATION_FLAG (N)
            REQUESTER_ID (300000006911406)
            ITEM_SOURCE (QUICK_ENTRY)
            PCARD_FLAG (N)
            INFO_TEMPLATE_TOUCHED_FLAG (N)
            REQS_IN_POOL_FLAG (N)
            ORDER_TYPE_LOOKUP_CODE (QUANTITY)
            PURCHASE_BASIS (GOODS)
            MATCHING_BASIS (QUANTITY)
            TRX_BUSINESS_CATEGORY (PURCHASE_TRANSACTION)
            PRODUCT_TYPE (GOODS)
            ASSESSABLE_VALUE (1)
            BUYER_PROCESSING_FLAG (N)
            LINE_STATUS (APPROVED)
            LAST_SUBMITTED_DATE (2019-08-17T02:15:09.640+00:00)
            LAST_APPROVAL_DATE (2019-08-17T02:15:27.151+00:00)
            CONFIGURED_ITEM_FLAG (N)
            SOURCE_TYPE_CODE (EXTERNAL)
    • Puneet Goyal

      I found below note: 

      The Generate Orders Job Is Not Triggered Automatically ( Doc ID 1374948.1 ) 

      Solution on this note says: 

      If the requisition lines does not have Procurement BU derived from Source Agreement/Buyer at the time of Requisition creation, then the Generate Orders program will not be submitted automatically. Hence the users have to launch the Generated Orders ESS program separately to process these requisitions. 
      The Requisition Approval process will automatically trigger the 'Generate Orders' process if procurement BU is assigned at the time of requisition creation. 
      Use the Fusion Purchasing task link "Generate Orders" to process requisitions without Procurement BU sourced information.

    • Puneet Goyal

      I have found the solution:

      there is below New Feature enabled in 19A release which is causing this issue. 

      Consolidate Online Requisitions into Fewer Purchase Orders

      After disabling this option, it is working now.

      Now, when I create requisition, after it is approved it is appearing on Process Requisition page automatically.

    • Puneet Goyal

       

      Approved Requisitions Do Not Show in Process Requisitions (Doc ID 2522391.1)