Purchasing

Get Involved. Join the Conversation.

Posts

  • Rich Lines
    'Withdrawn: Approve Purchase Order' email...2
    Topic posted September 10, 2018 by Rich LinesBlue Ribbon: 750+ Points, tagged Approvals, Approvals/Notification, Fusion, How-To, Notifications, Setup 
    Title:
    'Withdrawn: Approve Purchase Order' email notifications
    Summary:
    I am seeking guidance on how to disable these notifications coming through to approval group members.
    Content:

    We have recently upgraded to Oracle Fusion R13 (18B). Members of the approval group for purchase orders are now receiving an FYI type email notification when another member of the group approves a PO. The email only comes through 3 x days AFTER the PO was originally approved. These notifications are clogging up our email accounts and we would like to disable.

    Can anybody confirm the steps I need to undertake to stop this notification from being actioned? I do not wish to affect any other notifications that are set up (we do not have notifications set up to inform of PO approval however).

    I believe the task might be 'DocumentApproval'. Within the 'Notifications' tab, I can see that 'Enable Reminder' is checked and the frequency is set as every 3 x days. This would correspond to when we receive these notifications compared to when the PO was approved. Would simply un-ticking this box have the desired effect?

    Many thanks

     

    Version:
    Oracle Fusion R13 (version 18B)
  • Piyush Bihany
    Access to Procurement/Purchasing Subject Area & Purchasing...45.0
    Topic posted July 30, 2019 by Piyush BihanyGold Medal: 3,500+ Points, tagged BI Publisher Reports, Fusion, How-To, Orders, OTBI 
    Title:
    Access to Procurement/Purchasing Subject Area & Purchasing Related Reports
    Summary:
    User without Buyer role are unable to Access Procurement Subject Area and Procurement Related Reports, Also they are unable to Create New Analysis
    Content:

    Client is live with Oracle Purchasing cloud and users have been creating PO on the Prod Instance.

    However there are few users who doesn't have the Buyer License (Buyer Role is not assigned) and don't have access to create and manage Purchase Order but still wants to review (view only access) for the Purchase order Data via Reports. 
     

    Client has additionally procured license for B84576 - Oracle Fusion Transactional Business Intelligence Cloud Service - Hosted Name, with an understanding that this will grant access to the users for BI Reports. 

    We have created a custom BI Role, and have added the following Privileges to the same: 
    BI Consumer Role 
    And have assigned the custom role to above listed users. 

    These users are unable to create a New Analysis (OTBI report) under the BI Page.

     
    Also for any existing OTBI Report, when the open the same, they are getting error as: 
    No Results 
    The specified criteria didn't result in any data. 

    However the same report is fetch data for other users, who are having Buyer role assigned. 

    Please advice, if in addition to creation of Custom Role for Oracle Fusion Transactional Business Intelligence Cloud Service, any other steps needs to be performed. 

    --

    PB

    Image:
  • Sridhar Tumati
    ADFService11G - JBO-25096: Accessor ItemEFFBIFlattenedVO Was...15.0
    Topic posted November 19, 2018 by Sridhar TumatiBronze Medal: 1,250+ Points, tagged BI Publisher Reports, Business Intelligence, Create Requisition, FAQ, Financials, Fusion, Manage Procurement Catalog, Orders, Requisition Processing, Setup, Tip, White Paper 
    Title:
    ADFService11G - JBO-25096: Accessor ItemEFFBIFlattenedVO Was Not Correctly Resolved;
    Summary:
    Procurement Custom Reports: ADFService11G - JBO-25096: Accessor ItemEFFBIFlattenedVO Was Not Correctly Resolved;
    Content:

     Hi All,

    After Upgrading to Release 13 18C, All the custom Reports developed using Procurement Purchasing Real time subject area having item Description. field results error as below:

    State: HY000. Code: 77031. [nQSError: 77031] Error occurs while calling remote service ADFService11G. Details: Runtime error for service -- ADFService11G - JBO-25096: Accessor ItemEFFBIFlattenedVO was not correctly resolved in view def InventoryItemRefPVO. Locate the resolution error and address the issue. (HY000)

    We raised  SR and Oracle Support Provided the solution as per below docment:

    FA OTBI - After 18C Patch Errors on OTBI SCM, Produrement Subject areas erroring out ItemEFFBIFlattenedVO; FulfillLineDetailBIEffEFFBIFlattened (Doc ID 2470931.1) 

    Bug 28895661 : FA OTBI ANALYSIS FAILING AFTER 18C UPDATE - ACCESSOR ITEMEFFBIFLATTENEDVO WAS NOT CORRECTLY RESOLVED

    EGO_ITEM_EFF:
    To deploy Item extensible flexfields, do the following:

    1. In the Setup and Maintenance work area, open the task panel and click Search.
    2. Search for and select the Manage Extensible Flexfields task.
    3. On the Manage Extensible Flexfields page, search for the Item Extended Attributes flexfield (flexfield code EGO_ITEM_EFF).
    4. Select the Item Extended Attributes row. From the Actions menu, select ‘Refresh & Deploy Offline’

    This action starts the Item extensible flexfield deployment process.
    5. Monitor the Offline Status column, which shows the status of the deployment process.
    DOO EFF
    Doc 26739757 - BI EFF DOCUMENTATION[This section is not visible to customers.]
    Steps:
    1. Please run the ESS program: Publish Extensible Flexfield Attributes.
    2. In the Manage Extensible Flexfield UI, force deploy the doo header, fulfill line, fulfill line details EFF regardless of whether the customer uses these EFFs or not by invoke Actions->Refresh & Deploy Offline
    3. After deployment, in the same EFF UI, invoke Actions->Download Flexfield
    Archive to download the artifacts, and make sure the directory structure is like: oracle.apps.publicFlex.scm.doo.fulfillLineCategories.analytics
    4. Bounce SCM’s UI and Service Server (Open SR for the bounce)

    Regards,

    Sridhar Tumati

     

    Version:
    Release 13 18C
  • Neha Aggarwal
    Allocate invoice Freight/Surcharge cost to purchased items...15.0
    Topic posted January 24, 2019 by Neha AggarwalGreen Ribbon: 100+ Points, tagged Fusion, How-To, Payables, Setup 
    Title:
    Allocate invoice Freight/Surcharge cost to purchased items on pro-rata basis
    Summary:
    We don't have Landed Cost Management implemented, but we have a requirement to allocate invoice Freight/Surcharge cost to purchased items on pro-rata basis such that it updates item average cost.
    Content:

    LCM may be a standard solution for the above requirement, but I wanted to see if anyone in this community has ever come across this kind of a requirement  without LCM and has found an alternative way to address this. Any help or suggestions will be appreciated.

  • Murali Gangidi
    Approval Aging Report including all approvers and timestamp...35.0
    Topic posted November 19, 2018 by Murali GangidiSilver Medal: 2,000+ Points, tagged Approvals, BI Publisher Reports, Business Intelligence, Fusion 
    Title:
    Approval Aging Report including all approvers and timestamp (PO, Contract, Invoice).
    Summary:
    Approval Aging Report including all approvers and timestamp (PO, Contract, Invoice)
    Content:

    Hello Gurus,

     

    Is there seeded report or any OTBI Subject Area's to join or BIP Query which will get the Approval details of  all approvers and timestamp  for Purchase Order , Contracts and Invoices. Need custom report  to pull all Open and Pending Approval PO's, Contract's and Invoices in one report. Trying to explore the options and if any one can help on this.

  • Anil Nair
    Approved Supplier List (ASL)45.0
    Topic posted December 13, 2018 by Anil NairBronze Medal: 1,250+ Points, tagged Agreements, Approvals, Approvals/Notification, Approved Supplier List, Create Requisition, FAQ, Fusion, How-To, Manage Procurement Catalog, Orders, Requisition Processing, Setup, Supplier Communication, Supply & Distribution Planning Cloud, Tip, White Paper 
    Title:
    Approved Supplier List (ASL)
    Summary:
    Approved Supplier List (ASL)
    Content:

    Hi,

    We have a requirement to restrict any purchasing (Req/Orders) for specific suppliers (Blacklisted).

    The approved supplier list functionality doesn't allow any restriction on Order creation when category and supplier from ASL is used.

    There are no Inventory items for now only categories.

    Also, i'm unable to find the source document - Blanket Purchase Agreements, there is only Contract Purchase Agreement in the drop down list under ASL source documents.The Generate Approved supplier list also doesn't show any agreement numbers.

    Please share if you have come across customers with similar requirement.

    Many thanks.

    Anil 

  • Rich Lines
    Auto receipt PO below a set value15.0
    Topic posted May 2, 2019 by Rich LinesBlue Ribbon: 750+ Points, tagged Fusion, How-To, Orders, Setup, Tip 
    Title:
    Auto receipt PO below a set value
    Summary:
    Is it possible to create a rule for this
    Content:

    Is it possible to create a rule/s in Oracle Fusion that would automatically receipt ALL lines on a purchase order IF the overall value is below a certain amount?

    We have 3 way matching set up BUT our organisation struggles with PO's not being receipted by the requester (this delaying payment to the supplier etc.)

    We would like to know if there is a way to for example auto receipt ALL the lines on a PO where the total value of that PO is £100.00 or less.

    Thanks.

    Version:
    Oracle Fusion release 19B
  • Ekansh Jain
    Auto-population of need-by/promise date on PR/PO based on...15.0
    Topic posted June 6, 2019 by Ekansh JainBronze Medal: 1,250+ Points, tagged Agreements, Create Requisition, Fusion, How-To, Manage Procurement Catalog, Notifications, Orders, Requisition Processing, Setup, Supply & Distribution Planning Cloud, White Paper 
    Title:
    Auto-population of need-by/promise date on PR/PO based on Lead time setup for an item corresponding to ship-to location
    Summary:
    Auto-population of need-by/promise date on PR/PO based on Lead time setup for an item corresponding to ship-to location
    Content:

    Hi,

    Please let me know if there is any workaround or custom solution to achieve the below requirements in Oracle Purchasing Cloud.

    Scenario: Auto-population of need-by/promise date on PR/PO based on Lead time setup for an item corresponding to ship-to location

    Use Cases

    1. Manual Purchase requisition: Requestor selects the ship-to location and Catalogue item, the system automatically populates the need-by date as <SysDate+Lead Time>. This data flows to the PO as Promise Date
    2. Min-Max Planning based Purchase Requisitions: Min-Max planning is run at Org/Sub Inventory level which automatically populates the need-by date as <SysDate+Lead Time>. This data flows to the PO as Promise Date

    As-Is Business Process: Client maintains BPA for each catalogue item with the supplier but doesn’t use ship-to location on the BPA. Lead time is separately managed in custom form for each Item-Ship-to combination. When the user enters PR or min-max planning triggers a PR, customization calculated the need-by date as <SysDate+Lead Time> (as maintained in the mentioned custom form), and populates on PR. This need-by date flows to the PO as the promised date. Buyer can override this date if there are concerns with the promise date from the supplier side.

     

    Why is it critical:

    1. To make sure the right expectations are set up with the requestor about the availability of purchases
    2. To make sure inventory specialists sees correct Supply/Demand picture as promise date is used as supply cut-off date. This helps in avoiding the inventory stock-out situations
    3. To enforce the SLA agreements with vendors, and vendor’s performance can be measured
    4. Extra work to override the populated promise date which will be sysdate if this solution is not in place. Separate communication needs to happen to change this as per SLA agreement which is extra work

    Requirements:

    1. Show end user what is the lead time for that ship-to location for the item?
    2. Auto-populate <SysDate + Lead time> as the promise date on PR/PO. This should be applicable to both manual as well as planning (Min-max) based PR
    3. Supply and Demand report should be able to use the Lead time while calculating the demand/supply based on the cut-off date
    4. Ability to see/review updates on PO promise data by supplier
  • Palash Kundu
    Automated Testing tool for Oracle Cloud Procurement and SSP1
    Topic posted March 12, 2018 by Palash KunduSilver Medal: 2,000+ Points, tagged Fusion, Tip 
    Title:
    Automated Testing tool for Oracle Cloud Procurement and SSP
    Summary:
    Any suggestion on Automated Testing tool for Oracle Cloud Procurement and SSP
    Content:

    Hello

    Please wanted to check with other customers for Any suggestion on Automated Testing tool for Oracle Cloud Procurement and Oracle Cloud Self Service Procurement

     

    Thanks

    Palash

  • Mohammad Arif Zaffar
    Automatically updating FINAL CLOSE status for a POAnswered8
    Topic posted September 11, 2019 by Mohammad Arif ZaffarBronze Medal: 1,250+ Points, tagged Fusion, Setup 
    Title:
    Automatically updating FINAL CLOSE status for a PO
    Summary:
    Automatically updating FINAL CLOSE status for a PO
    Content:

    Hello, 

    Although the PO status gets updated automatically to CLOSE once full PO is received and invoiced however our requirement is the the PO should be automatically changed to final close status either immediately along with the close status or lets say after certain duration which we should define. 

    Is it possible? is there any work around?