Posts

Posts

  • Mahesh Kumar
    Integration of Cloud SCP and Oracle EBS using Web Service -...
    Topic posted 2:23 PM by Mahesh Kumar, tagged API, Cloud, Connection, E-Business Suite, ERP Cloud, Integration, REST, SOAP in Integration > Integration public
    Title:
    Integration of Cloud SCP and Oracle EBS using Web Service - Challenge
    Summary:
    How to download files from UCM directory using Java or PLSQL
    Content:

    I am trying to integrate the Oracle SCP with Oracle EBS 12.2.5 using ErpInteration WebSerive fscmService/ErpIntegrationService.

    I am calling the SOAP action getDocumentsForFilePrefix to download the zip files from UCM account. I getting the response as but it is a multipart HTTP response - 1st part is XML document which has the document details like document name, document id, document account, etc and 2nd part is zip file binary format.

    I want to know how to handle this multipart response from Web Service? How to separate the multipart response.

    Any help on this is highly appreciated.

    Let me know if anyone has the code to do this either Java or PLSQL.

    Please refer the attachments for more details.

    Document:
  • Frank Brink
    Failed instances with heading "Primary Identifier:...8
    Topic posted 9:07 AM by Frank BrinkGreen Ribbon: 100+ Points, tagged Integration, REST in Integration > Integration public
    Title:
    Failed instances with heading "Primary Identifier: undefined" in the monitoring/tracking area
    Summary:
    Failed instances with heading "Primary Identifier: undefined" in the monitoring/tracking area next to a succesful instance for the same integration of type basic routing
    Content:

    The launch of an integration of type basic routing result next to a succesful instance also in a failed insatnce with the following heading:
    Primary Identifier: undefined | 3200186 (latter is the instance id)
    Note that there is also a succesful instance with heading:
    name: Paco Instance ID: 4000090
    Hello World Map Data Invoke | 1.1.0 Completed
    Where does this failed instance for the Hello World Map Data Invoke integration coming from - why are there two instances - one succesful and one failed?
    This can be easy reproduced with the deafult sample (Hello World Map Data Invoke integration) you receive when you create an instance: 
    I can also reproduce it with my custom integrations of type basic routing: there are always two instances: one failed and one succesful
    How to explain this during a demonstration of the prroduct?

    Version:
    OIC Version 19.3.3.0.0 (190924.1600.31521)
    Image:
  • Karthick R
    How to convert/transform a simple csv file into FBDI...1
    Topic posted 6:19 AM by Karthick RRed Ribbon: 250+ Points, tagged Adapters, Cloud, ERP Cloud, Integration, Mapping, Orchestration, PaaS, REST, SOAP, xml in Integration > Integration public
    Title:
    How to convert/transform a simple csv file into FBDI template with master-detail data?
    Summary:
    How to convert/transform a simple csv file into FBDI template with master-detail data?
    Content:

    Hi Everyone,

    I'm using FBDI template for Account Receivables - AutoInvoiceImport.

    My client will shares data in a simple CSV file

    How to convert/transform a data in simple csv file into FBDI template with master-detail data?

    Can you point out any blog reference/KM materials?

    Regards,

    Karthick.R

  • Abhinav Kumar
    Multiple Condition in mapping in AICAnswered3
    Topic posted 6:00 AM by Abhinav KumarRed Ribbon: 250+ Points, tagged Integration, Mapping, Orchestration in Integration > Integration public
    Title:
    Multiple Condition in mapping in AIC
    Content:

    I want to add multiple condition in a mapping. Is this possible in AIC. If yes, then how?

    this is the sample condition I have to include in the mapping

    If A!=B or C!=' '

    then C=X

  • Aff Team
    How to update Source in OIC4
    Topic posted 12:40 AM by Aff Team, tagged Integration in Integration > Integration public
    Title:
    How to update Source in OIC
    Summary:
    How to update Source in OIC
    Content:

    Hi Experts,

    We have created an integration between Engagement Cloud and EBS.

    When any customer created in Engagement Cloud got created in EBS as well. I am populating Engagement cloud party number and party id in EBS. Now i want to update back Engagement Cloud that party as well with the generated CUST_ACCOUNT_ID column in EBS. So that customer in both system have ids to remain in synch.

    Engagement cloud have EBS column reference and EBS have engagement cloud reference.

    For Example:

    Before Integration:

    Engagement Cloud: 

    Party Number: 123

    Party Name: ABC

    Reference Column: null

    EBS

    Party Number: null

    Party Name: null

    Reference Column:null

    After Integration

    EBS:

    Party Number: 789 (Auto Generated)

    Party Name: ABC

    Reference Column:123

    Engagement Cloud: 

    Party Number: 123

    Party Name: ABC

    Reference Column: 789 (Party Number from EBS)

     

    How can we achieve the same?

    Regards,

    Zahid Rahim

  • Sridhar Yerram
    How the Connection Details are preserved during...2
    Topic posted Yesterday by Sridhar YerramRed Ribbon: 250+ Points, tagged Integration in Integration > Integration public
    Title:
    How the Connection Details are preserved during download/upload of iar file
    Summary:
    How the Connection Details are preserved during download/upload of iar file
    Content:

    Hello ,

    When i'm trying to upload the iar file, i don't see the connection string and credentials of it.

    Why it happens so , don't we get the connection string and credentials ?

    In projects, how does it happen, how does the migration process happens from DEV to UAT to PROD ?

    Any Inputs ?

    -Sridhar

  • Sridhar Yerram
    Error While Configuring Oracle DBaaS Connection1
    Topic posted Yesterday by Sridhar YerramRed Ribbon: 250+ Points, tagged Connection, Database, Integration in Integration > Integration public
    Title:
    Error While Configuring Oracle DBaaS Connection
    Summary:
    Error While Configuring Oracle DBaaS Connection
    Content:

    Hello,

    Iam getting the below issue, while configuring the Oracle DBaaS connection.

    Unable to test connection "ORACLEDBAASCONN". [Cause: CLOUD-0005]

    • CLOUD-0005 : Unable to establish connection. Please check connection parameters
    • Network Adapter could not establish the connection. Please check the wallet credentials and ensure database is reachable.

    Pl

     

    Please let me know what is the reason and how to rectify this issue.

    -Sridhar 

    Image:
    Document:
    DBaaS2.PNG (27KB)
  • Ritu
    Convert comma-delimited String to XML Node2
    Topic posted Yesterday by RituSilver Medal: 2,000+ Points, tagged Integration, Mapping in Integration > Integration public
    Title:
    Convert comma-delimited String to XML Node
    Content:

    Hi,

    I am trying to convert an input variable which contains comma-delimited string values into an XML nodeset using oraext:create-nodeset-from-delimited-string and Stage File action. I have gone through other posts on the forum but i am not able to convert the delimited value in nodeset. Please let me know if there is an alternative approach or any help on below approach will be helpful.

    $Vars_CountryStringFilter = A,B,C

    XSLT for Stage Write action : StageWriteXSLT.xsl

    XSD for Stage Write action : StageWriteSchema.xsd

    Request log for Stage Write action : StageWriteRequest.log

    With above approach .attached is the snapshot of the payload(StageWriteRequest.log) sent to Stage Write action . However, an empty file is getting generated when i write the stage file reference to FTP.

    Thanks,

    Ritu

    Document:
    Document:
    Document:
  • Aff Team
    Custom Web Service for multiple records4
    Topic posted Yesterday by Aff Team, tagged APIs, Gateways, Integration in Integration > API Management public
    Title:
    Custom Web Service for multiple records
    Summary:
    Custom Web Service for multiple records
    Content:

    Hi Experts,

    I am able to develop and deploy a web service which when we pass inventory item id give me one record details of that inventory item id in EBS R12.1.3.

    Now My requirement is when i pass LAST_UPDATE_DATE it should give me all the items later than that last update date. I will use this web service in OIC to get EBS Items and POST in Engagement Cloud adapter.

    Regards,

    Zahid Rahim

     

     

    Version:
    EBS R12.1.3
    Code Snippet:
  • Noam Tamarkin
    The OIC Invoke endpoint convert body json field integer to...4
    Topic posted November 11, 2019 by Noam Tamarkin, tagged Integration in Integration > Integration public
    Title:
    The OIC Invoke endpoint convert body json field integer to string
    Content:

    I have a POST service on OIC with JSON body that have integer fields.

    When I check the call to the service provider log, I see that the double are becoming strings For example:

    Original request body:[
    {
    "itemNumber" : "551",
    "section" : null,
    "statusId" : 11
    },
    {
    "itemNumber" : "99-30",
    "section" : 3,
    "statusId" : 2
    }
    ]
     
    The request body that the service provider gets:
    [
    {
    "itemNumber" : "551",
    "section" : "",
    "statusId" : "11"
    },
    {
    "itemNumber" : "99-30",
    "section" : "3",
    "statusId" : "2"
    }
    ]

    That is rejected by the service provider.

    I made sure that the WSDL's of OIC show data type of double  on Trigger and Invoke requests.

    Any ideas?

     

    Thansk,

    Noam

    Version:
    19.3.3.190924.1600-31522