Purchasing

Get Involved. Join the Conversation.

Comments

  • Bas van Gameren

    Hi Jim, 

    Unfortunately, I haven't setup XML communication from PRC cloud to OSuN myself, but I do have experience with EBS to OSuN.
    If I remember well, the identifiers (sender/receiver) can be be set in te profile section on OSuN (you may select DUNS or MISC as identifier).

    You may find some supporting documents on OSuN here: https://osn.oracle.com/snw/faces/Resources.jsf
     

    Identifiers 

    OSN Test Hub

    Oracle Transport Adapter URL: https://osn.oracle.com:443/servlets/oracle.apps.ecx.oxta.TransportAgentServer 
    HTTPS URL: https://osn.oracle.com:443/HTTPService/Receive
     

    Hope this helps,

    Cheers,
    Bas 

     
  • Shubham Chandra

    Hi Ivan,

    I am unable to attach word doc in my earlier reply. I am attaching here with image format with same content. PFA.

    Regards,

    Shubham.

  • Shubham Chandra

    Hi Ivan,

    I am unable to form the criteria and unable to get the result. Please find attached PO and BPA report.doc (Word Doc) for criteria and other details described in it.

    Regards,

    Shubham

  • Jim Van Tongerloo

    Hi Ivan,

    I think right point for this would be B2B/SOA team to answer on how to setup the different channels(File/Email) for the communication.

    Well, if this team could make some documentation on how to set this up, that would be great.

    On top of that, we're on release 9 on premise, so not the latest versions.

  • Ivan Pena

    Hi Jim, Bas

    I think right point for this would be B2B/SOA team to answer on how to setup the different channels(File/Email) for the communication.

    Also, if this is for new customer we can suggest them to use CMK for communicating to a Webservice?

    Documentation References
    Release 11

    Release 12

    Thanks,

    Ivan

  • Ivan Pena

     

    Hi Shubham,,

    Currently BI does not support cross functional report at document level. (PO number, Line attributes are not shared across different subject areas. ) So customer can't expect they pull Agreement Number from Agreement SA to associate with the PO records from PO subject area. Those are totally separate entities.  Cross functional reports only work for the shared common dimensions such as Item, BU, Supplier. For example: if user create cross functional reports like Supplier, PO amount, Agreement Amount, this will work. However, if the report is drilling down to document level, such as Supplier, PO number, PO amount, Agreement Amount, (PO Number, Agreement Number are document level attributes), the report will not work as expected since PO number from PO subject area does not join to agreement Subject area to get the associated agreement amount.

    For the below report, we can only suggest customer to build a report like:

    Supplier, Item, Category, PO Amount, Agreement Amount, Release Amount.

    Then from PO amount, create another report to drill down for the individual PO record, and from Agreement Amount drill down to another report for the individual agreement record. It's not ideal solution. However, current BI model can do very limited cross functional report. We don't recommend users to create cross functional reports except at common dimension level

     

    Thanks

    Ivan

  • Jim Van Tongerloo

    Hi Bas,

    Thanks for your answer. It's a good call, and I've tried it. But unfortunately I have no idea how to set up certain parameters for the OSN channel.

    The 'SENDER ID' and 'RECEIVER ID' I assume are the User ID's I can find on the User's profile in OSN?

    SENDER and RECEIVER_ID_TYPE is what? DUNS?

    Also, have no idea what the correct URL is and which port it would use.

    Alas, have not been able to set it up, there seems to be only some general high level documentation on this.

    Any help with that is appreciated.

    Thanks.

    [EDIT: I've also logged an SR for this, since I'm not progressing]

    ~Jim

  • Ivan Pena

    Hi Stephen,

    Your understanding is correct. For unmatched invoices, you need to ensure you pick the correct balancing segment values for the charge and liability accounts, so that IC entries are created if needed. 

    Ivan

     

  • Stephen Manning

    Also, when an unmatched invoice comes into the shared services center how do you get it to hit the right BU? It seems like we would still need the payables service provider relationship to be setup?

  • Stephen Manning

    Thanks Ivan,

    So staying away from supply chain orchestration; since we can't have a cross-ledger service provider relationship at the beginning of the payables process our enterprise structure would need a dedicated Shared Service BU that will handle the entire PO to Payment flow after requisition and then intercompany gets the financials entries back to the requisitioning BU after payment?

    Referencing: Oracle Fusion Applications Setting Up a Minimal Enterprise Structure to Support Procurement Shared Services - Page 5

  • Bas van Gameren

    Hi Jim, 

    Not sure whether you found a solution yet, but did you consider sending the XML to OSN and pick it up from there to review the XML message?

    In case you managed to send it by email, would love to learn how you did it!

    Thanks,
    Bas

  • Ivan Pena

    Hi Stephen,

    It's not on the product roadmap. You could implement supply chain financial orchestration to achieve this, but I'd not recommend going down that route unless you need to support financial orchestration flows to meet other requirements.

    https://docs.oracle.com/cloud/latest/scmcs_gs/FAIMS/FAIMS1925804.htm

    Ivan

  • Stephen Manning

    Hi Ivan,

    Is this functionality supported in a future release or on the product roadmap?

    Thanks,

    Stephen

  • Jim Van Tongerloo

    Hi Ramesh, Ivan,

    Ultimately, we want to send out XML's for approved PO's through an (S)FTP or any other shared location. Hence my setup for B2B Communication. I was first trying to setup to send the XML through e-mail to get an idea of what the XML looked like, but there's no guide on how to configure this.

    So if anyone knows what to do to set this up, all information is welcome. It's quite urgent.

    ~Jim

  • Ivan Pena

    Hi Jim,

    Do you want to communicate the PO in XML format via email? 

    Ivan