Purchasing

Get Involved. Join the Conversation.

Posts

  • Ivan Pena
    Desupport Notice for Oracle B2B Gateway in Procure-to-Pay...25.0
    Topic posted August 9, 2019 by Ivan PenaBronze Crown: 15,000+ Points, tagged Agreements, Orders, Payables, Supplier Communication 
    Title:
    Desupport Notice for Oracle B2B Gateway in Procure-to-Pay B2B Communications in Update 20A
    Summary:
    B2B Gateway desupported as communication method for Procure to Pay Flow in Update 20A
    Content:

    Present Behavior:

    When setting up a supplier site in Oracle Procurement Cloud, you have three options for the B2B communication method you want to use to exchange B2B messages with the supplier:

    • None
    • Oracle B2B Gateway - Deprecated
    • Collaboration Messaging Framework

    The Oracle B2B Gateway - Deprecated and Collaboration Messaging Framework achieve the same end result, but have different setup and management capabilities. Oracle Collaboration Messaging Framework Cloud provides better capabilities to set up and manage B2B messaging with trading partners, including features such as message configuration and the ability to reprocess messages.

    Future Behavior:

    Starting in Update 20A, the Oracle B2B Gateway – Deprecated option will be desupported, and it will be removed as an option in a later release. 

    Effect on Customers:

    New Oracle Procurement Cloud implementations must not use the Oracle B2B Gateway - Deprecated option. If you are an existing customers using this B2B communication method, you must migrate your setup to use Collaboration Messaging Framework for all supplier sites enabled for B2B messaging. Refer to the Oracle Supply Chain Collaboration and Visibility Cloud What’s New for Release 19B and the Migrate Oracle B2B Trading Partner Setup to Collaboration Messaging Framework white paper (Doc ID 2564389.1) for details about the migration process.

  • Boyuan Zhu
    How to Include Back-to-back Sales Order Customer Information...2
    Topic posted September 9, 2019 by Boyuan ZhuGold Medal: 3,500+ Points, tagged Orders, Supplier Communication 
    Title:
    How to Include Back-to-back Sales Order Customer Information in the Purchase Order PDF
    Content:

    If you have a specialized back-to-back order process, you may need to communicate sales order customer information to your supplier. For example, you have asked your supplier to label packages with customer shipping information. You can configure the purchase order PDF data model and template to include customer information from the sales order. In the steps below, you will add the the customer name, address, and the scheduled arrival date to the purchase order data model.

    1. Create a copy of the Purchasing Order Data Model. Make the following edits to the draft and archive distribution data sets.  
    2. Add this statement to the SELECT clause:

      SalesOrder.PARTY_NAME CustomerName,

      SalesOrder.ADDRESS1 CustomerAddress1,

      SalesOrder.CITY CustomerCity,

      SalesOrder.STATE CustomerState,

      SalesOrder.SCHEDULE_ARRIVAL_DATE AS ScheduledArrivalDate

    3. Add this statement to the FROM clause:

      (SELECT ReqDist.DISTRIBUTION_ID, Customer.PARTY_NAME, CustomerLoc.ADDRESS1, CustomerLoc.CITY, CustomerLoc.STATE, FulfillLine.SCHEDULE_ARRIVAL_DATE FROM POR_REQ_DISTRIBUTIONS_ALL ReqDist, DOS_SUPPLY_TRACKING_LINE_DOCS TrackingDoc, DOS_SUPPLY_TRACKING_LINES TrackingLine, DOO_HEADERS_ALL SalesOrderHeader, HZ_PARTIES Customer, HZ_RELATIONSHIPS CustRel, DOO_FULFILL_LINES_ALL FulfillLine, HZ_PARTY_SITES CustomerSite, HZ_LOCATIONS CustomerLoc WHERE TrackingDoc.DOCUMENT_TYPE='ORA_PR' AND TrackingDoc.DOCUMENT_LINE_ID = ReqDist.REQUISITION_LINE_ID  AND TrackingLine.TRACKING_LINE_ID = TrackingDoc.TRACKING_LINE_ID AND TrackingDoc.ACTIVE_FLAG = 1 AND TrackingLine.SUPPLY_ORDER_REFERENCE_LINE_ID = FulfillLine.FULFILL_LINE_ID AND FulfillLine.HEADER_ID = SalesOrderHeader.HEADER_ID AND FulfillLine.SHIP_TO_PARTY_SITE_ID = CustomerSite.PARTY_SITE_ID AND CustomerSite.LOCATION_ID=CustomerLoc.LOCATION_ID AND SalesOrderHeader.SOLD_TO_PARTY_CONTACT_ID = CustRel.RELATIONSHIP_ID AND CustRel.SUBJECT_TYPE = 'PERSON' AND Customer.PARTY_ID = CustRel.SUBJECT_ID) SalesOrder

    4. Add this statement to the WHERE clause: 

      AND Distribution.REQ_DISTRIBUTION_ID = SalesOrder.DISTRIBUTION_ID(+)

    5. Make corresponding changes to add the attributes to the PDF template. If you are using Collaborative Messaging, you can also add the attributes to the CMK message transform.
  • Swati Gupta
    How to include item attachments on purchasing documents...5.0
    Topic posted August 30, 2019 by Swati GuptaRed Ribbon: 250+ Points, tagged How-To, Orders, Supplier Communication 
    Title:
    How to include item attachments on purchasing documents communicated to suppliers
    Content:

    The buyer creates a Purchase Order with an item. The item has a few attachments in the master item page. Once the purchase order is approved, the purchasing documents will get communicated to the supplier via e-mail or electronically. You can automatically include item attachments on the supplier e-mail communication.

    1. Login as a buyer. Once logged in, go to Setup and Maintenance -> Manage Attachment Categories task. Search the Category name TO_SUPPLIER. Add ITEM_ENTITY to the attachment.

    2. Alternatively, you can go to Setup and Maintenance -> Manage Attachment Entities task. Search for the entity name ITEM_ENTITY. Add TO_SUPPLIER to the attachment categories.

    3. Navigate to Setup and Maintenance -> Manage Item Classes task. Edit the Root Item Class.

    4. Scroll to the bottom of the basic tab and add 'To Supplier' to this list of Attachment Categories. Save and Close.

    5. The list of attachment categories on the Edit Item page should now include 'To Supplier'.

    Item attachments of category 'To Supplier' will be now added to purchasing documents communicated to suppliers via e-mail or electronically (B2B).

    Document:
    Document:
    Document:
    Video:
    item_1.png (54KB)
  • Dev Thota
    Is it possible to add multiple suppliers an option in...15.0
    Topic posted August 8, 2019 by Dev ThotaGold Trophy: 10,000+ Points, tagged Agreements, Approvals, Approvals/Notification, Approved Supplier List, BI Publisher Reports, Business Intelligence, Create Requisition, FAQ, Financials, Fusion, General Ledger, How-To, Manage Procurement Catalog, Notifications, Orders, OTBI, Payables, Public Sector, Requisition Processing, Security, Setup, Supplier Communication, Supply & Distribution Planning Cloud, Tip, Web Services, White Paper 
    Title:
    Is it possible to add multiple suppliers an option in purchase agreements?
    Summary:
    Is it possible to add multiple suppliers an option in purchase agreements?
    Content:

    Hi all,

    We have a requirement like Is it possible to add multiple suppliers an option in purchase agreements?

     

    Thanks,

    Dev Thota.

    Version:
    19B
    Image:
  • Eliane Vianna
    Supplier Portal - Supplier User need add a Attachment in...2
    Topic posted August 6, 2019 by Eliane ViannaGreen Ribbon: 100+ Points, tagged Financials, Orders, Setup, Supplier Communication 
    Title:
    Supplier Portal - Supplier User need add a Attachment in the Purchase Order
    Summary:
    Supplier Portal - Supplier User need add a Attachment in the Purchase Order
    Content:

    With Standard Roles, the Provider does not have access to add a Attachment in the P.O.
    The supplier user needs to attach a doc (PDF / XML / XLS / others) either in the PO header or in the same PO line, thus sending, for example, the Invoice PDF issued by the supplier, so that the user of the system can associate the Invoice with the PO and later with Invoice.

    The call at Oracle states that this need is a request for future improvement. (very future).

    If anyone knows which ROLE, or Duty Role, or Privileges giving this permission please let me know.

    Has anyone here faced this same problem and acted on it?
    Please, if you can help me, thank you very much.

    Version:
    R13- last version
  • Eliane Vianna
    Supplier Portal - Supplier User need add a Attachment in...45.0
    Topic posted August 6, 2019 by Eliane ViannaGreen Ribbon: 100+ Points, tagged Financials, Orders, Setup, Supplier Communication 
    Title:
    Supplier Portal - Supplier User need add a Attachment in the Purchase Order
    Summary:
    Supplier Portal - Supplier User need add a Attachment in the Purchase Order
    Content:

    How to the Supplier User (user of the Portal) add a Attachment in the Purchase Order in the Supplier Portal?

    With Standard Roles, the Provider does not have access to add ATTACHMENTS in the Purchase Order.
    The supplier user needs to attach a doc (PDF / XML / XLS / others) either in the PO header or in the same PO line, thus sending, for example, the Invoice ODF issued by the supplier, so that the user of the system can associate the Invoice with the PO and later with Invoice.

    A SR at Oracle states that this need is a request for future improvement. (very future).

    Has anyone here faced this same problem and acted on it?
    Please, if you can help me, thank you very much.

     

    Thanks.    MARCOS SOARES

    Version:
    R13- last version
    Image:
  • Shlomo Elnekave
    Purchase order workflow customization8
    Topic posted August 4, 2019 by Shlomo ElnekaveRed Ribbon: 250+ Points, tagged Approvals/Notification, Orders, Supplier Communication 
    Title:
    Purchase order workflow customization
    Summary:
    Purchase order workflow customization
    Content:

    Hi,

    I want to customize the purchase order workflow so the mail message to the supplier will include additional attachments as follows:

    1) Buyer create Purchase order with Item # A.  Item # A have few attachments in the master item page ( see attached file )

    2) Buyer submit the Purchase order for approval

    3) Upon Purchase order approval, the customization will automatically attach the files from step # 1 to the supplier mail message.

    Any ideas how to acheive that ?

    Thanks Shlomo

    Image:
  • Dev Thota
    How to write approval rules for “Outside Processing P...25.0
    Topic posted July 30, 2019 by Dev ThotaGold Trophy: 10,000+ Points, tagged Agreements, Approvals, Approvals/Notification, Approved Supplier List, BI Publisher Reports, Business Intelligence, Create Requisition, FAQ, Financials, Fusion, General Ledger, How-To, Manage Procurement Catalog, Notifications, Orders, OTBI, Payables, Public Sector, Requisition Processing, Security, Setup, Supplier Communication, Supply & Distribution Planning Cloud, Web Services, White Paper 
    Title:
    How to write approval rules for “Outside Processing Purchase Order” through BPM?
    Summary:
    How to write approval rules for “Outside Processing Purchase Order” through BPM?
    Content:

    Hi all,

    When we are releasing the work order our requisitions are auto approving and POs are getting created automatically. As per the Oracle, we can't control the approvals of PR so we want to enable the approval flow for the purchase orders(OSP orders). If anyone has any idea on how to create a BPM rule for these kinds of POs please let me know.

    Version:
    19B
  • Boyuan Zhu
    How to Exchange User-Defined cXML Messages via Oracle...5.0
    Topic posted July 29, 2019 by Boyuan ZhuGold Medal: 3,500+ Points, tagged How-To, Orders, Supplier Communication 
    Title:
    How to Exchange User-Defined cXML Messages via Oracle Supplier Network
    Content:

    As of release 19B, you can exchange user-defined cXML messages with your trading partners via Oracle Supplier Network. You can use this capability to customize your messages to meet your partners' requirements. To send a user-defined cXML message, you need to define a cXML message with custom mapping, create a custom service provider pointing to OSN, and use this service provider and message when setting up trading partners on your supplier sites.

    1. First, define a new message by going to Manage Collaboration Message Definitions in the Collaboration Messaging Workarea. For the message you want to customize, download the existing transformation file by taking the Export Transformation Package action. You can then customize the transform file as you wish. 
    2. Duplicate the existing cXML message and upload your customized transform file. This is now the message you will be using in the future steps. 
    3. Create a service provider in the Manage Collaboration Service Providers task. If you have different customizations for different trading partners, you will need to create a separate message and service provider for each case.
    4. For the service provider, add a Delivery Method, using the delivery method type as “Web Service”. In the Service Name field, select the Service Name as CollaborationMessageV2.Process. Specify the following: 
      • Endpoint: https://osn.oracle.com/HTTPService/ProcessSOAPCollaborationMessage or https://osn-prod.oracle.com/HTTPService/ProcessSOAPCollaborationMessage.
      • User Name: The Oracle Supplier Network buyer account user name
      • Password: The Oracle Supplier Network buyer account password 
      ​​
    5. Add the message from earlier and use the delivery method you created. Set the status as Active and save. 
    6. Make sure that the correct documents are set up on OSN and that your supplier site is using the new service provider and message. The Collaboration Messaging Framework will transform your message into cXML using your defined mapping before invoking OSN.
    Document:
    Document:
    Document:
    Document:
  • Boyuan Zhu
    How to Exchange Messages through Oracle Supplier Network...35.0
    Topic posted July 29, 2019 by Boyuan ZhuGold Medal: 3,500+ Points, tagged How-To, Orders, Supplier Communication, Web Services 
    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)