Posts

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 in Procurement > Purchasing public
    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 in Procurement > Purchasing public
    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.
  • MerriH
    Supplier Site Report3
    Topic posted September 2, 2019 by MerriHGreen Ribbon: 100+ Points, tagged Audit, Financials, Fusion, How-To, Supplier Communication in Procurement > Supplier Management public
    Title:
    Supplier Site Report
    Summary:
    Is there a report/query available for Supplier Sites
    Content:

    Customer has a number of suppliers sites with the communication method set to None.  They would like to report on supplier sites with communication method set to NONE so that they can update the method to email.  

    Is this available?

    Version:
    19B (11.13.19.04.0
  • 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 in Procurement > Purchasing public
    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)
  • Eliane Vianna
    How to Customize the Oracle Fusion Applications-Welcome...1
    Topic posted August 29, 2019 by Eliane ViannaGreen Ribbon: 100+ Points, tagged Supplier Communication, Supplier User Account in Procurement > Supplier Management public
    Title:
    How to Customize the Oracle Fusion Applications-Welcome E-Mail
    Summary:
    How to Customize the "Oracle Fusion Applications-Welcome E-Mail" for the Supplier Portal User Contact?
    Content:

    When a Supplier Responsible Account is activated as USER ACCOUNT for use of the Supplier Portal, Oracle Fusion sends an Email to the "Contact" defined as their Supplier Contact.
    This Email Subject is: "Oracle Fusion Applications-Welcome E-Mail"

    example:

    --------------------------------------------------------------------------------------------------------------------------------

    Dear USER,

         Congratulations! Your Oracle Fusion Applications account has been successfully created.

         Please follow the link below to reset your password.

          https: //efxrtest.xxxxxxxx.***..x.x.x.x.x.x.xx.xx.x (URL)

         For any issues, contact your system administrator.

    Thank you,
    Oracle Fusion Applications

    -------------------------------------------------- ------------------------------------------------------------------------------

    I need help and guidance on how to customize this "Report" Email to change text.

    If you can help me, thank you.

    MARCOS

    Version:
    R13- last version
  • Aishwarya Pawar
    Desupport for Oracle B2B Gateway coming in Update 20A, B2B...5.0
    Topic posted August 28, 2019 by Aishwarya PawarGold Medal: 3,500+ Points, tagged Supplier Communication, Supplier Profile Management, Tip in Procurement > Supplier Management public
    Title:
    Desupport for Oracle B2B Gateway coming in Update 20A, B2B Supplier Site code retained and moved to a new location!
    Summary:
    Oracle B2B Gateway will be desupported in Update 20A. B2B Supplier Site Code will continue to be available.
    Content:

    Oracle B2B Gateway will no longer be supported as a B2B Communication method starting Update 20A. We do realize that the B2B Site Code attribute will continue to remain significant for some customers, so we have retained it as a supplier profile attribute, and have moved to it to a new location.

    Starting Update 19C, the B2B Site Code field no longer appears only when the B2B Communication Method is selected as Oracle B2B Gateway - Deprecated and in the B2B Communication Method section. Instead it appears in the section above, which is the Identification section and independent of the B2B Communication Method selected.

    Screenshot below provides additional reference.

    We want to encourage you to update the  B2B Communication Method to a value other than Oracle B2B Gateway - Deprecated and migrate your setup to use Collaboration Messaging Framework for all supplier sites enabled for B2B messaging (if you select Collaboration Messaging Framework as your choice).

    Refer to the Customer Connect post: Desupport Notice for Oracle B2B Gateway in Procure-to-Pay B2B Communications in Update 20A for additional details.

    Image:
  • Eliane Vianna
    Supplier Portal User - How to Customize the Welcome E-mail...1
    Topic posted August 8, 2019 by Eliane ViannaGreen Ribbon: 100+ Points, tagged Security, Supplier Communication, Supplier Profile Management, Supplier User Account in Procurement > Supplier Management public
    Title:
    Supplier Portal User - How to Customize the Welcome E-mail Notification
    Summary:
    How do I customize the body of the Welcome email that the system sends to the Supplier User to access the Supplier Portal?
    Content:

    How do I customize the body of the Welcome email that the system sends to the Supplier User to access the Supplier Portal?

     

    Version:
    R13- last version
  • 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 in Procurement > Purchasing public
    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:
  • Jihane
    Web Service to Update Supplier Primary Payment Method25.0
    Topic posted August 7, 2019 by JihaneBronze Medal: 1,250+ Points, tagged Financials, Fusion, Supplier Communication, Supplier Creation, Supplier Merge, Supplier Profile Management, Supplier Registration, Supplier User Account, Web Services in Procurement > Supplier Management public
    Title:
    Web Service to Update Supplier Primary Payment Method
    Content:

    Is there any Web Service to Update Supplier Primary Payment Method.

    Case Scenario:

    System A - Change the Payment method/details

    We want to update Oracle Cloud - Supplier Primary Payment Method, Accordingly.

    Can you direct me to the Web Service and payload example?

    Thanks

    Version:
    19B
  • 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 in Procurement > Purchasing public
    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