Posts

Posts

  • Harshith Eshwar Shaila
    Issues with Requisition ImportAnswered7
    Topic posted October 31, 2019 by Harshith Eshwar ShailaBronze Medal: 1,250+ Points, tagged Requisition Import in Procurement > Self Service Procurement public
    Title:
    Issues with Requisition Import
    Content:

    Hi all,

    Every mass Requisition Import through FBDI, we face a lot of issues. So is there a pre-requisite we need to follow for the data related to specific attributes before uploading the zip files.

    Next, we find the same issues even when the value provided in zip files are right, below are few errors for reference

    CURRENCY_AMOUNT 210 Amount is not applicable for goods lines. 
    ITEM_REVISION 1 The value of the attribute Item Revision is not valid. 
    ITEM_NUMBER S0210506 The value of the attribute Item is not valid. 
    SUGGESTED_VENDOR_SITE DETROIT LAKES The value of the attribute Supplier Site is not valid. 

    Note: Item provided was with right format, supplier site was available, and errors are not related to same requisitions.

    Is there a way we can tackle these issues, because need to know the exact background process how these errors are generated/triggered from technical point of view.

     

    Thank you,

    Harshith   E S

    Version:
    19C
  • Avner Chen
    PurchaseRequest SOAP API functionality65.0
    Topic posted July 3, 2017 by Avner ChenRed Ribbon: 250+ Points, tagged Approvals/Notification, Create Requisition, Requisition Import in Procurement > Self Service Procurement public
    Title:
    PurchaseRequest SOAP API functionality
    Summary:
    No updateRequisition API
    Content:

    All,

    My customer, WIX.com would like to build an external requisition creation page (from various reasons), import the requisition to Fusion SS Procurement, initiate an approval process and have the ability to withdraw the requisition from Approval, update and re-submit.
    Currently the SOAP WS supports 

    1. Create Requisition as ExternallyManaged='Yes' in APPROVED status (no way to initiate the approval process), with ability to CANCEL the requisition line
    2. Create Requisition as ExternallyManaged='No' in INCOMPLETE status and initiate the approval cycle, but without ability to update the Requisition. 

    Does anyone know of a way to update a requisition through SOAP or any other way?

    Does anyone know of a way to initiate approval for a requisition through SOAP or any other way?

    SOAP doc is here -(http://docs.oracle.com/cloud/latest/procurementcs_gs/OESWP/Purchase_Request_Service_Version_1_PurchaseRequestService_svc_4.htm#oracle.apps.prc.po.editDocument.purchaseRequestService.PurchaseRequestService) 


     

  • Nick Hirsch
    FX Rates on Requisitions / PO2
    Topic posted October 4, 2019 by Nick HirschRed Ribbon: 250+ Points, tagged Create Requisition, How-To, Requisition Import, Requisition Processing in Procurement > Self Service Procurement public
    Title:
    FX Rates on Requisitions / PO
    Summary:
    System defaults to today's FX Rates
    Content:

    Hello,

    When we convert a currency requisition into a PO, it defaults to today's conversion rate - is there any way to make Oracle use the previous days rate?

    Reason why is because we don't receive today's FX rates from our in-house risk system until late at night, and therefore during the day, we don't have the current days FX rates loaded into the system.

    Thanks

    Nick

    Version:
    Fusion 19B
  • Lokeswara Raju Chamarti
    FBDI import for Requisitions - Preparer and Requester Email25.0
    Topic posted August 6, 2019 by Lokeswara Raju ChamartiBlue Ribbon: 750+ Points, tagged Create Requisition, Requisition Import in Procurement > Self Service Procurement public
    Title:
    FBDI import for Requisitions - Preparer and Requester Email
    Summary:
    Case sensitivity of email address for Preparer / Requester / Buyer in Requisition Import FBDI
    Content:

    The FBDI import for requisition import expect the email address to exactly match with the email address of employee with case. Expectation is that this should not be validated and matching has to happen case insensitive. Email address are not case sensitive and if the email address is sent with upper case / lower case, both will work in any email server. So the email address field should not be considered with case. 

    We have multiple systems and the user accounts don't have the exact same email address in all the systems. Our Cloud ERP has user address as First.Last@Company.com. The external system that send the Requisition information to Oracle Cloud has email address as first.last@company.com. This is causing the FBDI import of requisition to fail as the email address in the Preparer / Requester is not matching with ERP value.

    The email address match should not be case sensitive for any comparisions.

  • MANISH KUMAR
    Need to create requisition from 3rd party1
    Topic posted August 12, 2019 by MANISH KUMARBronze Medal: 1,250+ Points, tagged Requisition Import, Requisition Web Services in Procurement > Self Service Procurement public
    Title:
    Need to create requisition from 3rd party
    Summary:
    Need to create requisition from 3rd party
    Content:

    Need to create requisition from 3rd party. The question is third party can send all details of requisition ( header, line and distribution) in one go and try to create requisition. Can we able to do this or 3rd party needs to call requisition api multiple times first to create header then line and then distribution. So, is this one call or 2-3 calls.

    Regards,

    Manish

  • Dev Thota
    How to restrict items (Inventory) in requisition /...45.0
    Topic posted August 3, 2019 by Dev ThotaGold Trophy: 10,000+ Points, tagged Agreement Loader, Approvals, Approvals/Notification, Budget/Encumbrance, Business Intelligence - BI, Create Requisition, FAQ, How-To, Internal Material Transfer, Inventory Cloud, Manage Procurement Catalog, OTBI, Public Sector, Requisition Import, Requisition Mobile, Requisition Processing, Requisition Web Services, Setup, Tip, Update Preparer and Requester, White Paper in Procurement > Self Service Procurement public
    Title:
    How to restrict items (Inventory) in requisition / PO Lines?
    Summary:
    How to restrict items (Inventory) in requisition / PO Lines?
    Content:

    Hi all,

    In Requisition / PO line-entry all inventory items are coming, We need to restrict some items for some people.

    Please suggest.

    Thanks,

    Dev Thota.

     

    Version:
    19B
    Image:
  • Dev Thota
    Unable to create a receipt in my receipts?75.0
    Topic posted July 8, 2019 by Dev ThotaGold Trophy: 10,000+ Points, tagged Agreement Loader, Approvals, Approvals/Notification, Internal Material Transfer, Inventory Cloud, OTBI, Public Sector, Requisition Import, Requisition Mobile, Requisition Processing, Tip in Inventory and Logistics > Inventory public
    Title:
    Unable to create a receipt in my receipts?
    Summary:
    Unable to create a receipt in my receipts?
    Content:

    Hi all,

    Unable to create a receipt in my receipts?

    PO created through work order(WO).

    Thanks,

    Dev Thota.

    Version:
    19B
    Image:
  • Dev Thota
    Work Order(WO): Requisition is approved without...85.0
    Topic posted July 22, 2019 by Dev ThotaGold Trophy: 10,000+ Points, tagged Agreement Loader, Approvals, Approvals/Notification, Budget/Encumbrance, Business Intelligence - BI, Internal Material Transfer, Inventory Cloud, Manage Procurement Catalog, OTBI, Public Sector, Requisition Import, Requisition Mobile, Requisition Processing, Requisition Web Services, White Paper in Procurement > Self Service Procurement public
    Title:
    Work Order(WO): Requisition is approved without approval.
    Summary:
    Work Order(WO): Requisition is approved without approval.
    Content:

    Hi all,

    Work Order(WO): Requisition is approved without approval.

     

    Thanks,

    Dev Thota.

    Version:
    19B
  • Ashok
    Update 19B: How to override agreement price on a Requisition75.0
    Topic last edited July 12, 2019 by AshokBlack Diamond: 60,000+ Points, tagged Create Requisition, How-To, Requisition Import, Requisition Web Services in Procurement > Self Service Procurement public
    Title:
    Update 19B: How to override agreement price on a Requisition
    Summary:
    How do you override the price from an agreement on a Purchase Requisition
    Content:

    Customers / Support

    I thought this article would serve two purposes:

    a) Quick primer on functionality that exists in this regard prior to Update 19B

    b) Feature as introduced in Update 19B.

    Business Problem:

    Customers have provided us business use cases where a standard agreement captures the price for a product or service at the outset of a negotiation but later,  these prices may be re-negotiated by specific requesters. You could look at this problem in two dimensions:

    a) Quantity based products or services

    b) Amount based products or services

    Solution:

    As I assume many of you are aware, Fusion Self Service Procurement already allows requesters the ability to update the price in cases of an amount based requisition. In Update 19B, this functionality has been extended to include quantity based requisitions as well.

    Here is a solution summary:

    A. What is supported:

    Requesters can modify the price on a requisition for both quantity and amount based lines.

    B. Pre-requisites:

    To avail of the feature introduced in Update 19B, we have introduced an Opt-in entitled: Override Agreement Price on Requisitions.  

    C. Who can update price:

    Any requester with the job role: Procurement Requester can edit the price on a requisition provided the agreement allows it.

    D. What flows are supported for these features:

    You can update the price through the following flows:

    1. Shopping flows through the UI

    2. Enter Requisition Line flow through the UI

    3. Using the FBDI template to import requisitions

    4. Using the Purchase Request Web Service to create a requisition

    5. Approver editing a requisition during the approval process

    NOTE: The Purchase Requisition REST service does not support this feature at this time.

    E. How does this feature work?

    Once opted in, you can create an agreement (a blanket purchase agreement using Fusion Purchasing). You must ensure that the attribute Allow price override must be enabled for the agreement line that you create. Additionally, you can set a value for the attribute Price Limit. The value you set here is the maximum value up to which the requester may edit the price on the requisition line.

    Once this configuration is complete, the next time a requester shops for the item or service, the system will enable the Price attribute for edit (See Screenshot 1 below). This screenshot describes how price is edited in a regular UI flow. 

    If you wish to enable this feature when using an FBDI template or the Purchase Request Web Service payload, you must provide a valid BPA reference in the template or the payload. If you don't and the system auto-sources an agreement, then the agreement price will prevail. This is important to remember.

    F. Additional considerations:

    1. The system will display an error message if you enter a price that is over the Price Limit value set in the agreement

    2. You cannot enter Null or Blank as the price on the requisition line but you can enter 0

    3. If the agreement is in a different currency than the functional currency, remember the price is updateable in that currency. So if the agreement is in EUR and the functional currency is USD, the requester changes the EUR price. This is current behavior but worth remembering.

    4. The Opt-in for this feature expires in Update 19D. This means that the feature is automatically turned on and available to all requesters after the expiration.

    Let us know if this article is helpful and if you have any questions or clarifications.

    Image:
  • Ashok
    User Preferences not a source of Charge Account defaulting...25.0
    Topic posted December 8, 2018 by AshokBlack Diamond: 60,000+ Points, tagged FAQ, Requisition Import, Requisition Web Services, Tip in Procurement > Self Service Procurement public
    Title:
    User Preferences not a source of Charge Account defaulting during Requisition Import
    Summary:
    User Preferences not a source of Charge Account defaulting during Requisition Import
    Content:

    Customers and Support

    This has come up twice recently on forum posts. It might merit a reminder. As you know Charge Account derivation uses various sources. User Preferences is one of them. Note that if you are importing requisitions (either using FBDI Templates or the Web Service), the charge account defined on User Preferences will not be considered for defaulting purposes.

    We get asked this question as to why the charge account derivation either fails or ignores the charge account on user preferences.

    User preferences by definition and design is applicable for UI based charge account defaulting, not for backend services such as Web Service or Import Requisitions.