Posts

Posts

  • Visvanath prasanth
    Details and Implementation Doc on...Answered1
    Topic posted December 11, 2019 by Visvanath prasanth, tagged Adapters, Cloud, Integration, PaaS in Integration > Integration public
    Title:
    Details and Implementation Doc on "oic.ics.stagefile.pgp.key.support" feature flag
    Summary:
    Details and Implementation Doc on "oic.ics.stagefile.pgp.key.support" feature flag
    Content:

    Hi,

    I need document or URL, explaining on "oic.ics.stagefile.pgp.key.support" feature flag which
    Support encryption/decryption in stage file read/write operation. Could you please help us with details of how it works once enabled and how to encrypt and decrypt using stage file.

    Thanks,

    Prasanth
     

  • Avinash Jayaprakash
    OIC Callback OnjobCompletion vs Event based1
    Topic posted December 11, 2019 by Avinash Jayaprakash, tagged Adapters, Cloud, Connection, ERP Cloud, Integration, PaaS, SOAP, Web Services in Integration > Integration public
    Title:
    OIC Callback OnjobCompletion vs Event based
    Summary:
    OIC ERP adaptor has a new update
    Content:

    I have found the onJobComplettion operation for callback is no more generic for all the objects(Payables,Receivables,Import Journals). Oracle has made it callback as object specific. We cannot make a callback as generic for all the objects. Is it true? and is it a good approach to go with event based callback, so that callback service could be generic for all the importBulkData operation. Please let me know your input on this.

  • Marcelo Cavalcante
    OTM 19C integration callback issueAnswered3
    Topic posted December 10, 2019 by Marcelo CavalcanteGreen Ribbon: 100+ Points, tagged Adapters, Cloud, Connection, Integration, Orchestration, PaaS in Integration > Integration public
    Title:
    OTM 19C integration callback issue
    Summary:
    TransmissionResponse is null and no order release has been created
    Content:

    Hello, community.

    I'm trying to create order releases into OTM through OIC.

    In Logistics adapter, I informed our Logistics integration WSDL: https://<our instance domain>/GC3Services/TransmissionService/call?wsdl.

    In the first attempts, I got database constraint errors. For that, I know I'm hitting OTM service.

    But, after correcting them, no order release has been created and the response has been as follows:

    <executeResponse xmlns="http://xmlns.oracle.com/apps/otm/TransmissionService">null</executeResponse>

    I found out the following article that states the same issue, but it is related to OTM 6.4.x versions and we are using OTM 19C.

    An issue was encountered after activation of OM-OTM pre-built integration. This pre-built integration integrates between Order Management- OM (from Oracle SCM Cloud) and OTM using Integration Cloud.

    Pre-built flow information

    Application Type Application Connector
    Source Application OM SCM Adapter
    Target Application OTM Logistics Adapter

     

    We wont go into the details of the integration itself. Refer to this Support note for details on the OM-OTM pre-built integration Sample Integration with OTM/GTM using ICS (Doc ID 2209248.1)

    Issue

    During testing of the flow it was seen that OIC monitoring shows successful transmission from OM to OTM and also a successful callback but a transaction was not created on OTM. However, the callback response from OTM shows "Null TransmissionBody" in the message as shown below

     Null TransmissionBody
    

    Resolution

    For OTM 6.4x, Transmission Service does not work when the OTM WSDL url is used in the logistics adapter connection. An offline TransmissionService wsdl has been made available which addresses this issue for 6.4x. It can be accessed from the below support note Transmission Service WSDL with Inline Schemas (Doc ID 2294108.1)

    Use the wsdl file provided in the support note when configuring the logistics adapter connection instead of the online wsdl url.

    Source: https://www.ateam-oracle.com/oic-integration-with-logistics-cloud/comment-submitted?cid=53e9f45e-36bd-479e-beb9-ecf851c6e887

    Does anyone knows if that is also the case for OTM 19C? WSDL URL for OTM 19C is also broken? If so, is that a place where I can download a working version? I could not find it.

    Version:
    OIC 19.4.2.0.0 (191120.0200.32560), OTM 19C
  • Dasaradha Kasukurthi
    Insert CDATA into XML in a mapping1
    Topic posted December 10, 2019 by Dasaradha KasukurthiGreen Ribbon: 100+ Points, tagged Cloud, Integration, SOACS, xml in Integration > Integration public
    Title:
    Insert CDATA into XML in a mapping
    Summary:
    Insert CDATA into XML in a mapping
    Content:

    I am using OIC to call quickBase API. Trying to insert CDATA in xml ,output should look like below.

    <qdbapi>
     
       <records_csv>
          <![CDATA sid,sflag

                      1234,1

                       4321,1

                       4567,1


             ]]>
       </records_csv>
      
    </qdbapi>

    Trying with below in xslt:

    <nsmpr9:records_csv xml:id="id_92">
    <xsl:value-of disable-output-escaping="no" select='concat("&lt;![CDATA["," ")'/>
     
    <xsl:text> sid,sync</xsl:text>
    <xsl:text disable-output-escaping="yes">&#13;</xsl:text>
    <xsl:for-each select="$v1/nsmpr1:testResponse/nsmpr5:testbapi/nsmpr5:record">
     
    <xsl:value-of select="concat(@sid, ',', '1')"/>
    <xsl:choose>
    <xsl:when test="position()!=last()">
    <xsl:text disable-output-escaping="yes">&#13;</xsl:text>
     
    </xsl:when>
     
    </xsl:choose> 
     
    </xsl:for-each>
    <xsl:value-of disable-output-escaping="yes" select='concat(" ","]]>")'/>
    </nsmpr9:records_csv>
     
    Error:
     
    Issue1: records are not coming in new line
     
    Issue 2: 
    oracle.cloud.connector.api.CloudInvocationException: oracle.xml.parser.v2.XMLParseException; lineNumber: 7; columnNumber: 86; ']]&gt;' is not allowed in text.
     
     

     

     

  • Hiten Shah
    AR invoice negative amount issue via REST API
    Topic posted December 5, 2019 by Hiten ShahRed Ribbon: 250+ Points, tagged Cloud in Integration > Data Integration public
    Title:
    AR invoice negative amount issue via REST API
    Content:

    Hello Everyone,

    While creating an AR invoice with negative amount in any of the lines, the AR invoice is not getting created via REST API but when we do it manually using Application, it allows to create.  It also works when using FBDI template, but fails with API.  Not sure if we are missing a parameter.

    I have attached the sample request payload for working as well as not working AR invoice CREATE payload.

     

     

    Image:
    Document:
  • Avinash Jayaprakash
    ImportBulkData operation of ERPIntegration service without...15.0
    Topic posted December 5, 2019 by Avinash Jayaprakash, tagged Cloud, ERP Cloud, Integration, Mapping, SOAP, Web Services, xml in Integration > Integration public
    Title:
    ImportBulkData operation of ERPIntegration service without properties file
    Content:

    How to load FBDI file to ERP using importBulkData operation using ERPIntegration service using parameterList parameter instead of properties file. I have tried loading zipped FBDI file, but its thowing fault as it is expecting properties file. Please find below for the sample request payload.

     

    <importBulkData xmlns:ns0=\"http://www.oracle.com/XSL/Transform/java/com.bea.wli.sb.resources.icsxpathfunctions.ICSInstanceTrackingFunctions\" xmlns:sdoXML=\"commonj.sdo/xml\" xmlns:plnk=\"http://schemas.xmlsoap.org/ws/2003/05/partner-link/\" xmlns:nsmpr6=\"http://xmlns.oracle.com/cloud/ics/fa/v1/ucm/\" xmlns:sdoJava=\"commonj.sdo/java\" xmlns:nsmpr7=\"http://www.oracle.com/XSL/Transform/java/com.bea.wli.sb.functions.dvm.DVMFunctions\" xmlns:nsmpr8=\"http://xmlns.oracle.com/cloud/adapter/ftp/Invoke_DownloadFBDIZipFile_REQUEST/types\" xmlns:wsdl=\"http://schemas.xmlsoap.org/wsdl/\" xmlns:nsmpr9=\"http://xmlns.oracle.com/types/InvokeImportBulkData/OutboundSOAPRequestDocument\" xmlns:nsmpr2=\"http://xmlns.oracle.com/cloud/adapter/ftp/Invoke_DownloadFBDIZipFiles_REQUEST/types\" xmlns:ns35=\"http://xmlns.oracle.com/cloud/adapter/ftp/Invoke_DownloadFBDIZipFile_REQUEST\" xmlns:nsmpr3=\"http://xmlns.oracle.com/cloud/adapter/ftp/Invoke_ListFBDIFiles_REQUEST/types\" xmlns:ns34=\"http://xmlns.oracle.com/cloud/adapter/ftp/Invoke_ListFBDIFiles_REQUEST\" xmlns:xml=\"http://www.w3.org/XML/1998/namespace\" xmlns:ns33=\"http://xmlns.oracle.com/ics/tracking/ics_tracking_context.xsd\" xmlns:ns32=\"http://xmlns.oracle.com/procmon\" xmlns:nsmpr0=\"http://xmlns.oracle.com/cloud/adapter/erp/Invoke_ImportBulkdata_REQUEST\" xmlns:ns37=\"http://xmlns.oracle.com/adf/svc/types/\" xmlns:dvm=\"http://www.oracle.com/XSL/Transform/java/oracle.tip.dvm.LookupValue\" xmlns:nsmpr1=\"http://xmlns.oracle.com/cloud/list/pull\" xmlns:types=\"http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/types/\" xmlns:nxsd=\"http://xmlns.oracle.com/pcbpel/nxsd\" xmlns:orajs1=\"http://www.oracle.com/XSL/Transform/java/oracle.tip.pc.services.functions.JsExecutor_ENCRYPTDECRYPTSAMPLE_01_00_0000_encryptDecryptSample_encryptDecryptSample_param1\" xmlns:orajs2=\"http://www.oracle.com/XSL/Transform/java/oracle.tip.pc.services.functions.JsExecutor_GETSTARTTIME_01_00_0000_startTime_getStartDate_param1\" xmlns:orajs0=\"http://www.oracle.com/XSL/Transform/java/oracle.tip.pc.services.functions.JsExecutor_STRINGREPLACE_01_00_0000_StringReplaceJS_StringReplaceJS_inputKey_ReplaceWith\" xmlns:tns=\"http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/\" xmlns:nstrgmpr=\"http://xmlns.oracle.com/cloud/adapter/erp/Invoke_ImportBulkdata_REQUEST/types\" xmlns:orafault=\"http://xmlns.oracle.com/oracleas/schema/oracle-fault-11_0\" xmlns:errors=\"http://xmlns.oracle.com/adf/svc/errors/\" xmlns:soap=\"http://schemas.xmlsoap.org/wsdl/soap/\" xmlns:sdo=\"commonj.sdo\" xmlns=\"http://xmlns.oracle.com/cloud/adapter/erp/Invoke_ImportBulkdata_REQUEST/types\">
        <nstrgmpr:document>
            <tns:DocumentId>1909238</tns:DocumentId>
        </nstrgmpr:document>
        <nstrgmpr:jobDetails>
            <tns:JobName>/oracle/apps/ess/financials/generalLedger/programs/common/,JournalImportLauncher</tns:JobName>
            <tns:ParameterList>300000279764762,Payables,300000009274397,ALL,N,N,N</tns:ParameterList>
        </nstrgmpr:jobDetails>
        <nstrgmpr:notificationCode>30</nstrgmpr:notificationCode>
    </importBulkData>

     

    Please let me know if anyone has input on this.

     

    Thanks,

    Avinash

     

  • Jaeyshree Kumaran
    skip record in for-each present in mapper2
    Topic posted December 4, 2019 by Jaeyshree KumaranRed Ribbon: 250+ Points, tagged Adapters, API, Cloud, Connection, Integration, Mapping, Orchestration, SOAP, Web Services, xml in Integration > Integration public
    Title:
    skip record in for-each present in mapper
    Content:

    I have write adapter in which I have for-each loop for two levels(1. for-each of assignments, 1.a. for each of Global_Card_Components_State). The Global_Card_Components_State tag will be optional. Some assignments may contain it. I have included a choose condition (as in image). This is successful when Global_Card_Components_State tag is present but fails when input doesnt have that particular tag.

    Is there any option to skip and process next record. <otherwise> doesnt help as i dont have sny option to map as its child.

    I am getting below error when for-each encounters assignments tag without Global_Card_Components_State tag

     

    com.oracle.bpel.client.BPELFault: faultName: {{http://schemas.oracle.com/bpel/extension}remoteFault} messageType: {{http://schemas.oracle.com/bpel/extension}RuntimeFaultMessage} parts: {{ CODE=<code>{http://schemas.oracle.com/bpel/extension}remoteFault</code> ,SUMMARY=<summary>ICS runtime execution error</summary> ,DETAIL=<DETAIL><detail><ICSfaultVar/><reason>Translation Error. Translation Error. Error while translating message to native format. Please make sure that the payload for the outbound interaction conforms to the schema and payload size does not exceed threshold. Error occured as {1} :Application Error</reason><operation>WriteFile</operation></detail></DETAIL>} cause: {null} Stage Read Failed

     

    Image:
  • Nazeer Anantha
    Wants to download or read file from File Storage in OIC2
    Topic posted December 3, 2019 by Nazeer AnanthaBlue Ribbon: 750+ Points, tagged Adapters, Agent, API, Cloud, Connection, ERP Cloud, Integration, PaaS, REST, Web Services in Integration > Integration public
    Title:
    Wants to download or read file from File Storage in OIC
    Summary:
    Wants to download or read file from File Storage in OIC
    Content:

    Hi All,

    I am trying to download or read a file from File Storage in OIC.

    is there any way to achieve this without using File Adapter?

    Thanks,

    Nazeer.

  • Nick Cox
    Where are the OIC Pre-Built Integrations for CDM Merge...3
    Topic posted December 2, 2019 by Nick Cox, tagged Cloud, Integration, Sales Cloud in Integration > Integration public
    Title:
    Where are the OIC Pre-Built Integrations for CDM Merge please?
    Summary:
    Customer is asking for prebuilt integrations for CDM Merge to OSvC
    Content:

    The documentation for CDM refers to "predefined integrations" which support of merging / de-duplication activities.

    Please can someone point to where these are held?

    I already looked on the Oracle Market place and only see an Oracle Sales Cloud to Oracle Service Cloud - which  only syncs basic contact and account information 

    This requirement is specifically regarding merge / data dedupe functionality.

    Documentation Reference:

    https://docs.oracle.com/en/cloud/saas/sales-and-b2b-service/19d/oacdm/customer-data-management-integration-with-other-cloud-services.html#OACDM2857402

    Customer Data Management Integration Using the Integration Cloud Service

    You can use the Integration Cloud Service to leverage predefined integrations between Customer Data Management, other cloud services, and on premise applications. For example, you can integrate Oracle Service Cloud with Customer Data Management to provide the duplicate resolution capability. Using this capability, you can merge an Oracle Engagement Cloud account (organization) or contact (person) with an Oracle Service Cloud account (organization) or contact (person).

    Version:
    OIC 19.4.2.191110.1400-32380
    Code Snippet:
  • Nagesh Manda
    Identify Deprecated Services used in OIC Integration2
    Topic posted November 30, 2019 by Nagesh MandaGold Medal: 3,500+ Points, tagged Adapters, API, Cloud, ERP Cloud, Integration, PaaS, REST in Integration > Integration public
    Title:
    Identify Deprecated Services used in OIC Integration
    Content:

    Hi All,

    I would like to know if there is anyway to identify the list of the OIC Integrations which are potentially impacted by the use deprecated REST API's from the ERP Cloud. I know that even when oracle marks them as deprecated on the documentation they will still be available for a limited period of time (Not exactly sure about the time limit). If these services are used across on a large scale across different integrations is there anyway to identify the services without manually going and looking for the deprecated service in each integration?

    Thanks,

    Nagesh.