Tag Archives: OIC

DB Timeout Issue In ICS



Call PLSQL from ICS DB adapter, if ICS to DB calls take more than 240 seconds it will timeout at ICS.

Can we increase this value to some value higher?


Timeout can not be changed. It is set to 240sec.
If you are still getting timeout, then we need to find out what is the root cause of Agent timeout. Agent logs should contain information on communication status between ICS and agent, and trace of DB requests processing.


Thank you !!



ICS Connection Count



ICS Connection Count (Doc ID 2385409.1)

How many connections will be considered from an ICS licensing Point of view?


A ‘Connection’ identifies a connection from an instance of ICS to a unique end system/application.
If, for example, a customer has number of WSDLs, but they all point to the same base URI, this would constitute 1 ICS connection. The following are the other rules when it comes to considering if two endpoints are considered the same connection or not.

– 2 different adapter types used to connect to the same instance of the application would be considered 2 different chargeable connections (e.g. using EBS Adapter and the Database Adapter to talk to the same EBS Instance is considered two connections)

– Different pillars/modules within an App (e.g. ERP) would still be different chargeable connections. e.g. ERP Financials would be one, ERP SCM would be second, ERP Projects and so on…, even if they are a single GSI instance.

– ICS-to-ICS is free (Daisy chaining integration). This includes invocation of ICS Flows on other ICS Instances.

– In Pub/Sub flows, Publishing or subscribing actions are not considered additional connections.

– Inbound (local) SOAP or REST connections counted as separate connections as well

– Connections are always chargeable – used actively in integration or not.



ICS Integration Not Working



ICS Integration Not Working (Doc ID 2340114.1)

Integration between Oracle Sales Cloud and Oracle service cloud – After adding the CSF Key, no instance is created in ICS.

User from ICS connection was not defined in ICS

After creating the user in ICS, the flow worked

To implement the solution, please execute the following steps:
1. Go into MyServices console
2. Navigate to Users
3. Create new user with the username defined in the ICS Connection
4. Change the password to the one used in the ICS Connection and csf-key

5. Retest


ICS: Which Bugs Are Fixed In 18.3.3



Useful Oracle Document:

ICS: Which Bugs Are Fixed In 18.3.3? (Doc ID 2425178.1)

ICS 18.3.3 Bug Fixes

1. Bug 27903791 – Consider User specified/Default Timezone in Preferences while running Scheduled Orchestrations

2. Bug 27362036 – Design-time Performance Improvements while working with very large Integrations

3. Bug 28316295 – Two Way SSL Support in REST Adapter

4. Bug 28308929 –  Gzip Support in FTP Adapter

5. Bug 28274350 – Enable User to specify Schedule Parameter with or without quotes

6. Bug 28266402 – Retain state of the schedule when importing a schedule driven integration flow into OIC from ICS

7. Bug 28266395 – Payload Trace/Logging setting not being honored when activating an integration flow with a new minor version

8. Bug 28246985 – Changing the Security type after Importing an Integration with REST/Oauth Client credentials based Connection does not work

9. Bug 28168603 – On execution of a outbound SAP Adapter flow using IDOC interface,TID is not being returned in response.

10. Bug 28164267 – Unintended line breaks introduced at runtime in payloads when using literal result element based mappings in the Mapper

11. Bug 28127472 – ERP Adapter design-time throws “The application has encountered an unexpected error”

12. Bug 28032110 – Audit trail of Global fault displays ‘Resource messageID ‘UF_NAME_EH’ not found in resource bundle EhStop’ when Database down

13. Bug 28025831 – Misleading Alert Notifications strongly advising the user to initiate manual purge of the data

14. Bug 28017414 – Handle Exclamation characters in JSON Keys in JSON samples

15. Bug 28011838 – Issue Consuming ICS Integration with complex request payload from PCS

16. Bug 28325374 – Do not mask the underlying errors when returned to caller in Lookups

17. Bug 27932827 – Updated values in Lookups not reflected at runtime due to Cache issues

18. Bug 28082314 – Unable to find the Lookup due to MDS Issues

19. Bug 28181446 – REST API call to Fusion Applications fails with SSLException


Thank you !! Unexpected end of file from server – An error occurred while invoking the target REST endpoint – ICS


ICS runtime execution error</summary></part><part name=”detail”><detail><detail><errorCode>OSB-380001</errorCode><ICSfaultVar/><reason><genericRestFault><errorCode>REST_CLIENT_RES_ERR</errorCode><errorPath><![CDATA[An error occurred while processing the client response from the target REST endpoint.]]></errorPath><instance><![CDATA[Target REST endpoint’s response processing failed.[[ Premature EOF]]]]></instance></genericRestFault>


Calling One integration from Another integration through REST API fails with error
“Generic Rest Fault, unexpected end of file from server”

An error occurred while invoking the target REST endpoint

Issue is due to the child integration takes long time to finish and parent integration is timing out. To address issue, invoke child integration either one-way  or Asynchronously which will help address the issue.

In case still issue exists, please contact Oracle Support.


Thank you !!





Cause: java.sql.SQLException: ORA-04068: existing state of packages has been discarded ORA-04061: existing state of package body has been invalidated – ICS Integration Failed



ORA-04068: existing state of packages has been discarded

Cause: java.sql.SQLException: ORA-04068: existing state of packages has been discarded ORA-04061: existing state of package “XXX” has been invalidated

ORA-04065: not executed, altered or dropped package “XXXXX”

ORA-06508: PL/SQL: could not find program unit being called: “XXX” ORA-06512: at line 1


Recompilation is resulting in invalidation of packages by database for existing database sessions related to ICS.

Avoid recompilation of packages during the working hours and plan such all migrations at once during the weekend.

Hope next execution of ICS integration run should be fine, if not, restarting Agent is the solution at the moment or contact Oracle Support.


Thank you !!




Unlock an Integration – ICS OIC


When an ICS integration is in edit mode and the browser get suddenly crashes, the integration becomes locked, which prevents it from being edited. There are several ways to unlock the ICS integration.

To unlock the ICS integration:

  1. Log in as a user with the Administrators role.
  2. In the navigation pane, click Integrations.
  3. For the integration that is locked, click the hamburger menu (hamburger) menu at the far right, then select Unlock.

Thank You !!