Purchasing

Get Involved. Join the Conversation.

Posts

  • 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
  • Anil Nair
    Approved Supplier List (ASL)35.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 

  • Marcus Comins
    Are multiple purchasing category hierarchies possible24.0
    Topic posted March 14, 2019 by Marcus CominsBronze Trophy: 5,000+ Points, tagged Manage Procurement Catalog 
    Title:
    Are multiple purchasing category hierarchies possible
    Summary:
    In an enterprise with two ledgers and one BU per ledger is it possible to create a different set of purchasing categories, along with separate hierarchies, for each?
    Content:

    In an enterprise with two ledgers and one BU per ledger is it possible to create a different set of purchasing categories, along with separate hierarchies, for each?  As far as I can see you can just define one set of categories in the Manage Functional Area catalogs task and they cant be assigned to a particular Procurement BU.  Dos this mean it needs to be shared across the enterprise?

     

    Inventory/master items/BPAs etc are not used so all purchases are non-catalog requests/smart forms.

     

    Thanks in advance

  • 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
  • Prateek Parasar
    Cannot see Item in Purchase OrderAnswered75.0
    Topic posted August 26, 2019 by Prateek ParasarBlack Diamond: 60,000+ Points, tagged How-To, Manage Procurement Catalog, Setup 
    Title:
    Cannot see Item in Purchase Order
    Summary:
    Created Catalog, Assign catalog Functional area, Created item and assigned category but cannot see item in purchase order
    Content:

    Hi,

    I have created new item org and new inventory org. Created cataog and assigned the item to the catalog and to the Orgs. I am able to see the Item in Sales Order(Order Managerment) but cannot see the item in the Purchase Order line Item lookup. I am surely missing somethig but I cannot see any steps to enable item in implementation guide. I am not purchaing functional but a technical person.

    Version:
    R13
  • Sabarish Ganda
    Cannot Upload Descriptive Flex Field value into Oracle Using...Answered145.0
    Topic posted October 16, 2018 by Sabarish GandaGold Medal: 3,500+ Points, tagged How-To, Manage Procurement Catalog 
    Title:
    Cannot Upload Descriptive Flex Field value into Oracle Using FBDI template.
    Summary:
    When trying to import the FBDI template for items import, the DFF value is not getting populated in Oracle.
    Content:

    We enabled a DFF on the item level and we wanted to update this field while we are importing items into the system. The DFF is Attribute6, so we used the same Attribute6 in FBDI template also and tried to import it, every filed is getting imported except the DFF value.

    So can anyone please let me know what is we missing here?

    Version:
    Oracle Fusion R13
  • Sandeep Kumar
    Categories Restricted by Supplier Wise15.0
    Topic posted September 23, 2019 by Sandeep KumarSilver Medal: 2,000+ Points, tagged Agreements, Create Requisition, Manage Procurement Catalog, Orders, Requisition Processing 
    Title:
    Categories Restricted by Supplier Wise
    Content:

    Can we restrict the categories by supplier wise let's say, we have assigned some categories to supplier and when we create PR/PO, Only Those Categories appear  or when we select a category on PR, only those suppliers appear where category is assigned

  • Krishnaraj Veeraraghavan
    Change Item Code in Purchase Order25.0
    Topic posted July 29, 2019 by Krishnaraj VeeraraghavanRed Ribbon: 250+ Points, tagged Create Requisition, Manage Procurement Catalog, Orders, Requisition Processing 
    Title:
    Change Item Code in Purchase Order
    Summary:
    Change Item Code in Purchase Order
    Content:

    Hi,

    Is is possible to change Item code during Process requisition or after converting into PO in purchase order in budget control environment at Requisition level.

    Regards,

    krishnaraj

  • Siva Kumar
    Default Requestor Name in a Purchase Order45.0
    Topic posted December 26, 2018 by Siva KumarGold Trophy: 10,000+ Points, tagged Agreements, Manage Procurement Catalog, Orders 
    Title:
    Default Requestor Name in a Purchase Order
    Summary:
    Default Requestor Name in a Purchase Order line from Agreement
    Content:

    Hello


    When we add lines from an blanket agreement catalog to a PO, we want the “requesters” name should auto fill since the agreement is already approved.Please let me know if there is any way to achieve this ?

    Thank you.

    Version:
    13B 18C
  • Kelly Cooper
    ERP – Recommendations for Modeling Procurement Operations i...25.0
    Topic posted June 3, 2019 by Kelly CooperGold Trophy: 10,000+ Points, tagged Approvals, Fusion, General Ledger, How-To, Manage Procurement Catalog, Requisition Processing, Tip 
    Title:
    ERP – Recommendations for Modeling Procurement Operations in Oracle Cloud Purchasing, 20 June 2019, 9.a.m. PT - Submit Questions
    Content:

    Submit your questions for the SCM – Recommendations for Modeling Procurement Operations in Oracle Cloud Purchasing session to have them answered during the live event. Post your questions by posting a new comment to this topic.

    Please submit your questions by Wednesday, 19 June 2019.