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 

  • Dhinesh Rajagopalan
    Attachment Upload to Requisition in R13 ERP Cloud15.0
    Topic posted January 31, 2019 by Dhinesh RajagopalanGreen Ribbon: 100+ Points, tagged Create Requisition, Requisition Processing 
    Title:
    Attachment Upload to Requisition in R13 ERP Cloud
    Summary:
    Facing issue while adding attachments to Requisitions in R13 ERP Cloud
    Content:

    We have a requirement to upload attachments to a Requisition. Based on the Oracle note (Doc ID 2261597.1), we attempted uploading attachments to Requisition using the ERP Object Attachment Service.

    We used UploadAttachment operation of the ErpObjectAttachmentSoap web service to add attachments to the requisitions. PFA request and response payloads in this context. We are running into errors and the attachment upload is not successful. Any pointers to help resolve the issue will be much appreciated.

     

    Version:
    11.13.18.10.0
  • 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
  • NIRANJAN KRISHNA VARADHARAJAN
    BU AND ledger creation for procurement15.0
    Topic posted July 23, 2019 by NIRANJAN KRISHNA VARADHARAJANBlue Ribbon: 750+ Points, tagged Create Requisition, Financials, Fusion, General Ledger, Payables, Requisition Processing 
    Title:
    BU AND ledger creation for procurement
    Summary:
    doubt regarding enterprise structure
    Content:

    My client has 4 LE registered in 4 different countries and also does operations in various other countries now when an pr is raised from the countries they are not registered they do sourcing and after that they want to create po from any one of the L.E that they are registered can any body provide me with solution regarding enterprise structure that we can follow and req proc setups.

  • Max Basandrai
    Budgets1
    Topic posted March 4, 2019 by Max BasandraiBlue Ribbon: 750+ Points, tagged Create Requisition, FAQ, Fusion, How-To, Orders, Requisition Processing, Setup, Tip 
    Title:
    Budgets
    Summary:
    Set Up Budgets in Requisitions
    Content:

    Is there a way to set up Budgets to show in Purchase Requisitions in R13

    Version:
    R13 19A
  • Ed van Kessel
    Cannot find my PO in My Receipts25.0
    Topic posted March 10, 2019 by Ed van KesselRed Ribbon: 250+ Points, tagged Agreements, Create Requisition, Requisition Processing 
    Title:
    Cannot find my PO in My Receipts
    Summary:
    BPA with line items referring to inventory items, Create requisition through Self-Service and automatically processes. I cannot query the receipt.
    Content:

    I have created a BPA of line items, referencing item numbers from our item master.  I have no problem purchasing the item through Self-service procurement.  The purchase order has the requestor, is direct delivery, is an expense type, user has Receiving Agent with the data access to the home organization, the deliver to location is tied back to the home organization.

    I still cannot query the receipt in My Receipts.

    My one concern is that the requisition line Deliver-to Location type is "Internal"

    I have a CRP tomorrow and need an answer on this as soon as possible.  I have a SR open with Support, but I am not getting my answer.

    Any help would be appreciated.

    Version:
    19A
  • Sabarish Ganda
    Cannot see Requisition Lines in PROCESS REQUISITIONS screenAnswered135.0
    Topic posted October 16, 2018 by Sabarish GandaGold Medal: 3,500+ Points, tagged Create Requisition, Requisition Processing 
    Title:
    Cannot see Requisition Lines in PROCESS REQUISITIONS screen
    Summary:
    After the Requisition is in approved status, it is not available in Process Requisitions Screen to create a Purchase Order
    Content:

    We planned to import Requisitions from Service Now to Oracle using Rest API. We are able to get them into oracle once they are in approved status in Service Now, we can see them on Requisitions screen but when I tried to find them on Process Requisitions Screen/Add to Document builder then I can't see them. So, I am wondering is there any setup we are missing or please let me know how we can make this work?

    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