Posts

Posts

  • Gopinath Kartheesan
    Question on Centralized Procurement (with BUs across...13
    Topic posted June 16, 2017 by Gopinath KartheesanBronze Trophy: 5,000+ Points, tagged How-To, Orders, Setup in Procurement > Purchasing public
    Title:
    Question on Centralized Procurement (with BUs across ledgers) and Invoicing+Payments in a common ledger
    Summary:
    We are planning to use Multiple ledgers in US to separate the Joint ventures vs the main entities by managing them in separate ledgers. But we would like to create a shared procurement services
    Content:

    I have a question on Shared services procurement with the below scenario that we are trying to accomplish. Could you please let us know if this is possible or if there's an alternative on what we are trying to accomplish?

    Here is the Scenario

    Problem Summary
    ---------------------------------------------------
    Trying to setup shared service procurement and not able to select proper Bill-To on the Supplier Master

    Problem Description
    ---------------------------------------------------
    We have three BUs
    1. OC Centralized Procurement BU
       a. Acting as centralized procurement BU
       b. No Ledger/LE attached to this BU
    2. OC Enterprises BU (in US and assigned to Ledger 1)
       a. Responsible for AP invoicing and payments
       b. Ledger: Controlled Entities USD
       c. LE: OC Enterprises, Inc. (Delaware)
    3. OC at Legacy Health (JV) BU (in US to manage their Joint Venture companies and assigned to Ledger 2)
       a. Requisitioning and receiving BU
       b. Ledger: Non-Controlled Entities USD
       c. LE: OC at Legacy Health, LLC

    Problem: trying to create supplier with following attributes
    . OC Centralized Procurement BU as Procurement BU on Supplier
    . OC Enterprises BU as Bill-To-BU
    . OC at Legacy Health (JV) BU as Client BU (not getting an option).

    How can we associated the Client BU as Joint venture BU so that we can create the Requisitions in OC at Legacy Health JV BU, Purchase orders in Centralized Procurement BU and then Invoicing + Payments in OC Enterprises BU

    Any help would be appreciated

    Thanks

    Gopi

  • Judy Hamner
    Purchase Order Attachments Not Sent To Supplier via email125.0
    Topic posted September 11, 2018 by Judy HamnerSilver Trophy: 7,500+ Points, tagged Orders, Supplier Communication in Procurement > Purchasing public
    Title:
    Purchase Order Attachments Not Sent To Supplier via email
    Summary:
    In testing the new functionality in R13: Send purchasing document attachments as separate files, we have not been successful in getting the attachments to send when the communication method is email.
    Content:

    Based on all the documentation I can find in Oracle Support, the configuration and opt-in/enabling of the new feature is set up correctly in our environment.  However, the attachments to the Supplier are not being communicated via email with the purchase order document.

    I am attaching screen shots of the configuration that is set up.  Have we missed something in our configuration?

     

    Judy

    Version:
    R13 18B
    Document:
    Opt In.JPG (44KB)
    Document:
  • Nagaraj VinayakaRao
    PO CLOSE SCHEDULE has a limitation of 5000 schedules (or...11
    Topic posted October 31, 2019 by Nagaraj VinayakaRaoGreen Ribbon: 100+ Points, tagged Orders in Procurement > Purchasing public
    Title:
    PO CLOSE SCHEDULE has a limitation of 5000 schedules (or lines) in the spreadsheet.
    Summary:
    PO CLOSE SCHEDULE has a limitation of only 5000 schedules (or lines) in the spreadsheet. Clients in Retail industry have more than 5000 PO schedules to action on. Why this restriction?
    Content:

    Ability to close/Final close POs  through a spreadsheet is available in Fusion R13. CLOSE SCHEDULE SPREADSHEET has a limitation of 5000 schedules (or lines)  to action on in the spreadsheet. Clients in Retail industry have more than 5000 PO schedules to download and action on them.  Want to know WHY oracle has limited it to only 5000 lines? Why this restriction?

    As per Oracle help, there are options to create smaller batches of less than 5000 lines by selecting different criteria. However, downloading POs at one go and then action on them in the same spreadsheet would be easier to manage than to create multiple batches.

  • Niamath Jeddy
    BPA backed PO Creation (FBDI) : Line Price Logic11
    Topic posted July 17, 2019 by Niamath JeddyGold Trophy: 10,000+ Points, tagged Agreements, Orders in Procurement > Purchasing public
    Title:
    BPA backed PO Creation (FBDI) : Line Price Logic
    Summary:
    BPA backed PO Creation (FBDI) : Line Price Logic
    Content:

    Hi,

    • I am using the FBDI method to create a PO
    • PO is backed by a BPA (source agreement columns are populated at PO line level)
    • When the PO is created, it is observed that the
      • PO Line price specified in PO line FBDI template is not used
      • The PO Line price is also not taken as per the quantity price breaks
      • The PO line price is taken from BPA line.

    Shouldn't the price be taken as per the slab instead of BPA line price?

    Also, in case the 'Allow price override' flag of BPA is 'Y', then shouldn't the price specified in PO line FBDI template be used ?

    If anyone has loaded legacy POs (referencing BPA with price breaks), can you share your experience?

    Also requesting some points from product management on this feature.

    Please refer below snapshot.

    Regards,

    Niamath

     

     

    Image:
  • Amy Chan
    Define value set with bind variableAnswered115.0
    Topic posted March 14, 2019 by Amy ChanSilver Medal: 2,000+ Points, tagged FAQ, Financials, Fusion, How-To, Orders, Setup in Procurement > Purchasing public
    Title:
    Define value set with bind variable
    Summary:
    Define value set with bind variable
    Content:

    I have a requirement to define a value set in PO Distribution level and such value always the same as the PO charge account segment3.

    SELECT cc.segment3 DEPT,

     FROM po_distributions_all po_dis,

                 gl_code_combinations cc

     WHERE po_dis.CODE_COMBINATION_ID = cc.CODE_COMBINATION_ID

     and        po_dis.po_distribution_id = ?????? (screen UI)

  • Judy Hamner
    Modify DFF Display TypeAnswered10
    Topic posted October 28, 2019 by Judy HamnerSilver Trophy: 7,500+ Points, tagged Create Requisition, Fusion, How-To, Orders, Setup in Procurement > Purchasing public
    Title:
    Modify DFF Display Type
    Summary:
    Is is possible to change the Display Type of a Descriptive Flexfield from a List of Values to a Text Box?
    Content:

    We have an existing Purchase Order Distributions DFF that was configured with a Display Property of  List of Values with a Validation Value Set.  Due to a change in business process, the business owners would like to change this DFF to be a Text Box without a List of Values associated with it.  Is it possible to modify the DFF Segment Value Set and Display Properties to be a Text Box?

    Current Configuration screen shots are included for reference.

     

     

    Image:
    Document:
  • Nishanth B Jain
    Order Creation Options in Blanket Purchase AgreementAnswered105.0
    Topic posted August 9, 2018 by Nishanth B JainSilver Crown: 22,500+ Points, tagged Agreements, Fusion, Orders in Procurement > Purchasing public
    Title:
    Order Creation Options in Blanket Purchase Agreement
    Summary:
    Automatically generate orders should be uncheked by default
    Content:

    Hi,

    We are trying to uncheck the Automatically generate orders option by default in BPA.

    Currently its checked for all BPA's as shown in attached screen. We want it to be unchecked by default.

    Any suggestions on this?

    Thanks,

    Nishanth

    Image:
  • Boyuan Zhu
    How to Exchange Messages through Oracle Supplier Network...95.0
    Topic posted July 29, 2019 by Boyuan ZhuBronze Trophy: 5,000+ Points, tagged How-To, Orders, Supplier Communication, Web Services in Procurement > Purchasing public
    Title:
    How to Exchange Messages through Oracle Supplier Network Using a Web Service
    Content:

    You can now set up Collaborative Messaging Framework to exchange messages with your suppliers through Oracle Supplier Network (OSN) using a web service. Routing messages using a web service simplifies message exchange between Fusion Applications and OSN. Messages will no longer be routed through Oracle B2B and you will not need to do any setup in Oracle B2B. This guide covers the configuration you need to perform in Fusion Applications and OSN to support message exchange using a web service. 

    Fusion Applications setup (needed for outbound messages)

    1. In the Manage Collaboration Service Provider task, select the OracleSN or OracleSNTest service provider. 
    2. If you are updating your test pod: 
      1. Select the ORA_B2BMessageTestService delivery method.
      2. Set the endpoint to https://osn.oracle.com/HTTPService/ProcessSOAPCollaborationMessage
      3. User Name: The buyer account user name that was used for the HTTP connection
      4. Password: The buyer account password that was used for the HTTP connection
    3. If you are updating your production pod, follow the same steps in 2, but set the endpoint to https://osn-prod.oracle.com/HTTPService/ProcessSOAPCollaborationMessage
    4. In the Outbound Collaboration Messages tab, change the status of all messages to “Inactive”, then update the Delivery Method from ORA_OracleSNOneWayHTTP to ORA_B2BMessageTestService. Note that this step is not applicable for new customers. 
    5. Change the status of all outbound messages to Active (applicable for all customers).


    Oracle Supplier Network setup (needed for inbound messages)

    1. Login as the buyer to OSN and select Messaging Setup. 
    2. Under Communication Parameters, add a new SOAP Service delivery method 
    3. Specify the endpoint URL for the service that Oracle Supplier Network will invoke to send messages to the Collaboration Messaging Framework. The URL is https://<host>/soa-infra/services/default/CmkCollaborationMessagingInboundServiceComposite/CollaborationMessageServiceV2. Replace <host> with the appropriate values from your test and production pod.
    4. Specify a user name and password for your test and production pods. Note that the user specified here must be a valid Fusion user and must have the Invoke Collaboration Message Inbound Service privilege (CMK_INVOKE_INBOUND_COLLAB_DOC_SERVICE_PRIV) in the respective pod.
    5. Once you have specified the appropriate values, select Submit. The dialog is closed and the Communication Parameters table now shows the newly added delivery method.
    6. In the Transaction Management table, edit the Transactions with “Receive” action – these are the ones that OSN is going to send to Fusion Applications. If you are a new customer setting up OSN for the first time, this table will not have any records. Update the delivery method to the new method you created. 

     

    Document:
    Document:
    Document:
    EditOSN.png (127KB)
  • Sabarish Ganda
    How to change the Supplier after the PO is in Open statusAnswered9
    Topic posted June 17, 2019 by Sabarish GandaGold Medal: 3,500+ Points, tagged Approvals, Approvals/Notification, Fusion, How-To, Orders, Setup in Procurement > Purchasing public
    Title:
    How to change the Supplier after the PO is in Open status
    Content:

    Is there a way to change the supplier after the PO is fully approved and in Open status.

    Business requirement:

    We have 2 suppliers with almost same name with minor difference in their names, so buyer selected the wrong Supplier and created a PO and now it has been fully approved. Now, we found that the PO should have been created with the other supplier. So, is there a way or custom role that allows buyer to change supplier during change order process.

     

    Version:
    Oracle Fusion 13, 19B
  • Shyam Singh Patel
    Grouping PO lines based on a Requisition DFF valueAnswered95.0
    Topic posted May 20, 2019 by Shyam Singh PatelGold Trophy: 10,000+ Points, tagged Create Requisition, Orders, Setup in Procurement > Purchasing public
    Title:
    Grouping PO lines based on a Requisition DFF value
    Summary:
    Grouping PO lines based on a Requisition DFF value
    Content:

    Is there a way to group PO based on Requisition DFF. We have a requirement to create different POs based on an attribute in requisition line

    SR 3-20100069221 : Grouping PO lines based on a Requisition DFF value
    Version:
    19B