Posts

Posts

  • Rashmi Rao
    JCS-SX:IS Reporting Feature (similar to BI or any...15.0
    Topic posted June 27, 2018 by Rashmi RaoBronze Trophy: 5,000+ Points, tagged ADF, Cloud, Database, PaaS, Platform Service in Application Development > Java public
    Title:
    JCS-SX:IS Reporting Feature (similar to BI or any alternative) present in JCS-SX?
    Summary:
    JCS-SX:IS Reporting Feature (similar to BI or any alternative) present in JCS-SX?
    Content:

    Hi,

    This query is in relation to the JCS-SX and its corresponding DBCS.

    Is there any reporting feature available in the JCS-SX ?

    Context:- We have certain custom tables in the DBCS and we might need to get a dump from them in a report format and send it or download it for review.

    I know that that on a stand-alone JCS , BI Reporting is possible. Is there a similar thing available for JCS-SX? If not BI , any alternative method to report? This is one of the mandatory features that our client is demanding.

    Kindly Advise.

    Regards,

    Rashmi

     

    Regards,

    Rashmi

     

  • Moon Ray Lo
    ICS: Agent not showing in DB Connection Agent Confguration...Answered45.0
    Topic posted June 25, 2018 by Moon Ray LoSilver Medal: 2,000+ Points, tagged Adapters, Agent, Connection, Database in Integration > Integration public
    Title:
    ICS: Agent not showing in DB Connection Agent Confguration after installing the On-Premise Agent
    Summary:
    The agent is not showing in the 'Configure Agents' interface when doing DB Connection setup in ICS
    Content:

    Hi,

    We are using ICS Standard Edition, Version: 18.2.3.0.1 (180419.0000.1063).

    The connectivity agent group we created is visible in 'Agents' page, which has 1 newly linked Agent (ID: PLOACS.AGENT15700) as shown in one of the screenshot (ICS_AgentsList.JPG) after being installed on our server where the DB resides. I tried to create a DB Connection and when I scroll down and access the 'Configure Agent', it is NOT showing on the list as shown in one of the screenshots (ICS_DBConnection_NoAgentsFound.JPG). I have also attached the Agent Installation Log in case it might help. (LOG-cloud-connectivity-agent-installation.txt).

     

    Any idea what could have caused this issue to arise? or anything I missed to setup?

     

    Thanks,

    Moon

    Document:
  • BHARAT RAMPALLY
    Performance on LOV's using external DB call...25.0
    Topic posted June 21, 2018 by BHARAT RAMPALLYGreen Ribbon: 100+ Points, tagged Database, REST, SaaS Integration, Web in Application Development > Visual Builder public
    Title:
    Performance on LOV's using external DB call (VBCS)
    Summary:
    Call DB to populate list of values
    Content:

    We are trying to populate list of value for the PO field from the DB, but we are having performance issue and the list is not loading due to the data volume, how do we resolve this issue, is there any other way to call the OIC DB?

     

     

  • Rajmohan Krishnamoorthy
    Connection Timeout in REST adapter25.0
    Topic posted June 12, 2018 by Rajmohan KrishnamoorthyRed Ribbon: 250+ Points, tagged Adapters, Connection, Database, Integration, REST in Integration > Integration public
    Title:
    Connection Timeout in REST adapter
    Content:

    Hi, I have a use case where I have to insert the data from BI report into the database. I have exposed the data insertion as REST service using ORDS. In some cases, the data coming from the report is high which results in the following error, 'An error occurred even before the REST endpoint could be invoked.[[java.net.SocketException: Unexpected end of file from server'. Is there any way to overcome this issue without limiting the data? Can someone please help me with this?

  • Sarv N
    Is there any direct connectivity to connect the tables in...35.0
    Topic posted May 11, 2018 by Sarv N, tagged Database in Application Development > Visual Builder public
    Title:
    Is there any direct connectivity to connect the tables in VBCS to a DB?
    Summary:
    Is there any direct connectivity to connect the tables in VBCS to a DB?
    Content:

    I'm trying to create a Web APP in Oracle Cloud Visual Builder. I could able to develop a web page with the table. I need to connect the table in the web page to a Cloud database's table to sync the records.

     

    Suggest me how to achieve this.

     

    Thanks in advance.

  • Fabian Wipfli
    ICS Database connection after patching on DB prevent...55.0
    Topic posted April 26, 2018 by Fabian WipfliBlue Ribbon: 750+ Points, tagged Database, Integration in Integration > Integration public
    Title:
    ICS Database connection after patching on DB prevent "existing state of packages has been discarded"
    Summary:
    ICS Database connection after patching on DB prevent "existing state of packages has been discarded"
    Content:

    Hi together

    How can I prevent after patching the database to get the error "existing state of packages has been discarded"?

     

    Full Error:

     

    <![CDATA[<errorCode>OSB-380001</errorCode><ICSfaultVar>

    <err:serviceInvocationError xmlns:err="http://xmlns.oracle.com/cloud/generic/service/fault">

       <err:type>Stored procedure invocation error</err:type>

       <err:title>Error while trying to prepare and execute the EFIT.EF_SL_PG_SS_WS_CREATE_ORDER.CREATE_ORDER_ENTRY API.</err:title>

       <err:detail>An error occurred while preparing and executing the EFIT.EF_SL_PG_SS_WS_CREATE_ORDER.CREATE_ORDER_ENTRY API. Cause: java.sql.SQLException: ORA-04068: existing state of packages has been discarded

    ORA-04061: existing state of package body "EFIT.EF_SL_PG_SS_WS_CREATE_ORDER" has been invalidated

    ORA-04065: not executed, altered or dropped package body "EFIT.EF_SL_PG_SS_WS_CREATE_ORDER"

    ORA-06508: PL/SQL: could not find program unit being called: "EFIT.EF_SL_PG_SS_WS_CREATE_ORDER"

    ORA-06512: at line 1

    </err:detail>

       <err:errorCode>serviceInvocationError</err:errorCode>

       <err:remedialAction>Check to ensure that the database objects exists(stored procedures,table,view..etc) in the database and the parameters match the signature of the API-like not exceeding the column range or is not NULL or is already existing value.Please examine the error message carefully to determine a resolution.</err:remedialAction>

    </err:serviceInvocationError>

    </ICSfaultVar><reason>oracle.tip.adapter.sa.api.JCABindingException: Stored procedure invocation error.

    Error while trying to prepare and execute the EFIT.EF_SL_PG_SS_WS_CREATE_ORDER.CREATE_ORDER_ENTRY API.

    An error occurred while preparing and executing the EFIT.EF_SL_PG_SS_WS_CREATE_ORDER.CREATE_ORDER_ENTRY API. Cause: java.sql.SQLException: ORA-04068: existing state of packages has been discarded

    ORA-04061: existing state of package body "EFIT.EF_SL_PG_SS_WS_CREATE_ORDER" has been invalidated

    ORA-04065: not executed, altered or dropped package body "EFIT.EF_SL_PG_SS_WS_CREATE_ORDER"

    ORA-06508: PL/SQL: could not find program unit being called: "EFIT.EF_SL_PG_SS_WS_CREATE_ORDER"

    ORA-06512: at line 1

     

     

    Check to ensure that the database objects exists(stored procedures,table,view..etc) in the database and the parameters match the signature of the API-like not exceeding the column range or is not NULL or is already existing value.Please examine the error message carefully to determine a resolution.  This exception is considered not retriable, likely due to a modelling mistake.  To classify it as retriable instead add property nonRetriableErrorCodes with value "-4068" to your deployment descriptor (i.e. weblogic-ra.xml).  To auto retry a retriable fault set these composite.xml properties for this invoke: jca.retry.interval, jca.retry.count, and jca.retry.backoff.  All properties are integers.

    ORA-04068: existing state of packages has been discarded

    ORA-04061: existing state of package body "EFIT.EF_SL:Application Error</reason><location><node>RouteNode1</node><path>response-pipeline</path></location><operation>CreateOrderEntry_REQUEST</operation>]]></ErrorDescription>

  • Tarakant Nayak
    OIC Mapping with DB35.0
    Topic posted April 25, 2018 by Tarakant Nayak, tagged Database, Integration, Mapping in Integration > Integration public
    Title:
    OIC Mapping with DB
    Summary:
    OIC Mapping with DB
    Content:

    Hello Experts,

     

    I am trying to map the source/target parmeters which are coming from a Stored procedure and one of the out params is custom data object which I am not able to do and I get the error

     

    "Drag and drop from a non-repeating parent is not recommended. Normally you want to map the individual leaf nodes. If you really want to do this, click on the target and use the mapping builder."

     

    My SP is having the following definition

     

    p_person_id  number

    p_doc_type varchars

    p_doc is customdbobject

     

    During the integration mapping with Rest API , I am able to map the request input parameters but for the response parameters I see the above error message during mapping.

    Please let us know how to resolve this issue and map properly  if the out param is custom db object.

     

    Thanks
    Tarakant

  • Thirunavukarasur
    How to migrate integrations from One OIC instance to another...54.5
    Topic posted April 25, 2018 by Thirunavukarasur Bronze Medal: 1,250+ Points, tagged Database, Integration in Integration > Integration public
    Title:
    How to migrate integrations from One OIC instance to another including database packages
    Summary:
    How to migrate integrations from One OIC instance to another including database packages
    Content:

    We have built around few custom integrations , we would like to migrate to another instance of Orace Integration Cloud. we are using database connector with stored DB packages.   Any idea how to migrate the integration along with database packages.  Thanks in advance.

     

    Thanks

    Ravi

  • Fabian Wipfli
    ICS asynchronous call95.0
    Topic posted April 12, 2018 by Fabian WipfliBlue Ribbon: 750+ Points, tagged Database, Integration in Integration > Integration public
    Title:
    ICS asynchronous call
    Summary:
    ICS asynchronous call
    Content:

    Hi, It is possible to invoke a database procedure with ICS asynchronous, without waiting of a result? Regards Fabian.

  • Fabian Wipfli
    ICS Write request XML into the database25.0
    Topic posted April 12, 2018 by Fabian WipfliBlue Ribbon: 750+ Points, tagged Database, Integration, SOACS, xml in Integration > Integration public
    Title:
    ICS Write request XML into the database
    Summary:
    ICS Write request XML into the database
    Content:

    Hi, It is possible to write the request XML from the SOAP trigger as CLOB into a 12c Oracle Database table? Regards.