Integration

Get Involved. Join the Conversation.

Posts

  • Nagesh Manda
    Account Updates - Business Event in OIC124.0
    Topic posted March 17, 2019 by Nagesh MandaSilver Medal: 2,000+ Points, tagged ERP Cloud, Events, Integration 
    Title:
    Account Updates - Business Event in OIC
    Summary:
    Business Events
    Content:

    Hi All,

    I am using publish integration pattern in OIC to get the details when an account is updated or created in ERP Cloud.  When i update an account in ERP Cloud i am able to see the message coming through to OIC But the payload content doesn't show any details. I am attaching the payload for your reference.

    <ns01:onEvent xmlns:ns01="http://xmlns.oracle.com/cloud/adapter/erp/AccountUpdates_REQUEST/types"><ns0:getAccountResponse xmlns:wsu="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd" xmlns:wsa="http://www.w3.org/2005/08/addressing" xmlns:ns0="http://xmlns.oracle.com/cloud/adapter/erp/AccountUpdates_REQUEST/types" xmlns:env="http://schemas.xmlsoap.org/soap/envelope/"/></ns01:onEvent>

    Appreciate if you could provide some inputs around how to resolve this issue.

    Thanks,

    Nagesh.

    Version:
    19.1.5.0.0
  • Karthick R
    Are business event available to capture customer account...15.0
    Topic posted October 10, 2019 by Karthick RRed Ribbon: 250+ Points, tagged Adapters, API, Cloud, ERP Cloud, Events, Mapping, Orchestration, PaaS, REST, Sales Cloud, SOAP, Web Services, xml 
    Title:
    Are business event available to capture customer account creation/update?
    Summary:
    Are business event available to capture customer account creation/update?
    Content:

    Hi Everyone,

    I'm looking for a business event that triggers when a (Trading Community) customer account is either created/updated in Oracle Fusion.

    I referred the below supported business events documentation available for Oracle Sales cloud but it doesn't point out customer account events.

    https://docs.oracle.com/en/cloud/paas/integration-cloud-service/icssc/oracle-sales-cloud-capabilities.html#GUID-BF281C4F-D708-4AAA-B983-33DAA8E6AB7E

    Please advise.

    Regards,

    Karthick.R

    Version:
    Oracle Fusion application 19b (11.13.19.04.0)
  • Karthick R
    Are web services available to create Credit Invoice, Cash...45.0
    Topic posted October 6, 2019 by Karthick RRed Ribbon: 250+ Points, tagged Adapters, API, Cloud, Events, Integration, Orchestration, REST, SOAP, Web Services 
    Title:
    Are web services available to create Credit Invoice, Cash Invoice, Cash Receipt , Credit note?
    Summary:
    Are web services available to create Credit Invoice, Cash Invoice, Cash Receipt , Credit note?
    Content:

    Hi everyone,

    We are using Oracle Fusion application 19b (11.13.19.04.0) and Oracle Financial Receivables.

    Inbound to Oracle: Are web services available to create Credit Invoice, Cash Invoice, Cash Receipt , Credit note?

    Outbound from Oracle: Are business events available to send out Customer Data whenever Create/Update happens?

    Regards,
    Karthick.R

    Version:
    Oracle Fusion application 19b (11.13.19.04.0)
  • Cesar Tepetla Corte
    Break the contents of an OIC variable in lines to insert it...1
    Topic posted April 5, 2019 by Cesar Tepetla CorteBronze Medal: 1,250+ Points, tagged Adapters, Cloud, Connection, Database, Events, Integration, Mapping, Orchestration, Process 
    Title:
    Break the contents of an OIC variable in lines to insert it into a database
    Summary:
    Break the contents of an OIC variable in lines to insert it into a database
    Content:

    Hi everyone,

     

    I have created a variable in OIC where it stored the contents of a file, for example:
    varoic = "METADATA | Location | SetId | SetCode | ActiveStatus | LocationCode | LocationName | AddressLine1 | Country | PostalCode | EffectiveStartDate
    MERGE | Location | 0 || Active | LocationTest_22032019 | RESTAURANTE_Location22032019 | Jaime Balmes AvenueI Secc, 11550 Miguel Hidalgo, CDMX | MX | 11550 | 1951/01/01

    MERGE | Location | 0 || Active | TLocationTest_23032019 | RESTAURANTE_Location22032019 | Jaime Balmes AvenueI Secc, 11550 Miguel Hidalgo, CDMX | MX | 11550 | 1951/01/01
    "

    when I insert into the database what I'm looking for is to take only the files that start with MERGE, so in theory I should create only two records in the table.

    Which I want comment or help is appreciated.

    Regards

  • Karthick R
    Business Events - HCM Cloud3
    Topic posted September 30, 2019 by Karthick RRed Ribbon: 250+ Points, tagged Adapters, Cloud, Events, Integration, Orchestration, PaaS, REST, SOAP, Web Services 
    Title:
    Business Events - HCM Cloud
    Summary:
    Are Business Events available for Oracle HCM Cloud?
    Content:

    Hi Everyone,

    We have a requirement to integrate Oracle HCM cloud with a Third Party application. In HCM cloud, whenever a New Hire/Existing Hire updates are made the integration has to automatically pass those information along with Hire data to Third Party application. The Third Party application had exposed SOAP services to import data coming from HCM cloud.

    The below oracle document states Business events are not available for Fusion HCM cloud:
    https://docs.oracle.com/cloud-machine/latest/intcs_gs/ICSKI/GUID-B8AC4537-C86D-4649-9D64-34C199051396.htm#ICSKI-GUID-B8AC4537-C86D-4649-9D64-34C199051396

    If Business events are not available for HCM cloud, then what is the alternative to capture New Hire/Existing Hire updates?

    Regards,

    Karthick.R

    Version:
    Oracle Cloud Application 19C (11.13.19.07.0)
  • Nagesh Manda
    Business Events Filter ConditionAnswered4
    Topic posted August 16, 2019 by Nagesh MandaSilver Medal: 2,000+ Points, tagged Events, Integration 
    Title:
    Business Events Filter Condition
    Content:

    Hi All,

    I am unable to add the below filter condition for the business events received from ERP Cloud. Could you let me know if it is possible to add multiple conditions within the filter section.

    <xpathExpr xmlns:ns_0="http://xmlns.oracle.com/adf/svc/types/"
    xmlns:ns_1="http://xmlns.oracle.com/apps/scm/receiving/receipts/receivingTransaction/"
    xmlns:ns_2="http://xmlns.oracle.com/apps/scm/receiving/receipts/receivingTransaction/types/">$eventPayload/ns_2:result/ns_0:value/ns_1:TransactionType="RETURN TO VENDOR" AND $eventPayload/ns_2:result/ns_0:value/ns_1:OrganizationCode="PPG" </xpathExpr>

     

    Thanks,

    Nagesh.

    Image:
  • Cesar Tepetla Corte
    Compare if a Select query returns data.Answered3
    Topic posted June 5, 2019 by Cesar Tepetla CorteBronze Medal: 1,250+ Points, tagged API, Connection, Database, Events, Integration, Mapping, xml 
    Title:
    Compare if a Select query returns data.
    Summary:
    Compare if a Select query returns data.
    Content:

    Hi everyoe,

    I am working on an integration where I must evaluate a condition, first I need to do an operation 'select * from ...'
    if the query does not return records then I must send a notification that says no records were found but otherwise the table returns data I must send another notification that says there is data to process.

    I tried to make the comparison taking the collection created after making the query as shown in the attached image but it does not work.

    Any comment is grateful.

    Image:
  • Cesar Tepetla Corte
    consult database table and repeat a determined process for...Answered1
    Topic posted March 28, 2019 by Cesar Tepetla CorteBronze Medal: 1,250+ Points, tagged Adapters, API, Case Management, Cloud, Connection, Database, Events, Integration, Mapping, Orchestration, Process 
    Title:
    consult database table and repeat a determined process for each value obtained from a specific field of the table.
    Summary:
    consult database table and repeat a determined process for each value obtained from a specific field of the table.
    Content:

    Hi everyone,

    I am working on a requirement in which I must obtain a record of a table and for each record to generate a file, I am currently working only with the name field I try to recover all the names of the table and for each one to generate a .txt file where print that name but I get an error:

    "XPath query string returns multiple nodes. The assign activity part and query $messagecontext_30.parameters/../nsmpr2:HomeDirectoryCollection/nsmpr2:HomeDirectory/nsmpr2:fname are returning multiple nodes. The assign activity part and query named in the error message returned multiple nodes. It should return single node. According to BPEL4WS specification 1.1 section 14.3, the assign activity part and query named in the error message should not return multiple nodes. Verify the part and xpath query named in the error message at line number 932 in the BPEL source."

  • logu Prasanth
    Date to number JS function not working as expected125.0
    Topic posted May 11, 2019 by logu PrasanthSilver Medal: 2,000+ Points, tagged Adapters, Connection, E-Business Suite, Events, Integration, Mapping, PaaS, REST, SOAP, Web Services, xml 
    Title:
    Date to number JS function not working as expected
    Summary:
    I am using below JS function for convert date to number
    Content:

    I am using below  JS function for convert date to number  

    In Browser it working and give a result as 11572923446000

    But OIC provides NaN as a result.

     

    Is any parser problem in Code?

    Any default function is there convert date to number!

     

    function dateToNumber(datetoNum){

      var NumberDate = Date.parse(datetoNum);

       return NumberDate; 
    }

    var dateVar = dateToNumber('11-05-2019 03:10:46 UTC')

  • M Sridhar
    Different Processors, Same Target Namespace9
    Topic posted January 12, 2019 by M SridharSilver Medal: 2,000+ Points, tagged Cloud, Connection, ERP Cloud, Events, Integration, Mapping, Orchestration, PaaS, REST, Web Services, xml 
    Title:
    Different Processors, Same Target Namespace
    Summary:
    OIC Orchestration: Different Processors, Same Target Namespace
    Content:

    I have integrations referring to multiple instances of same connection (ItemUpdateInvoke) in an Orchestration. 

    But most of integrations are getting activated successfully, some integrations are failing with ORABPEL-05215 

    XML parsing failed because "IllegalStateException

     

    -->  For failed orchestration, If we remove 2nd instance of ItemUpdate Connection, integration is getting activated successfully. So definitely issue is using same connection multiple times.

     

    Please let me know what could be the issue with some integrations failing...how can we fix