OCI 2023

Which is NOT an advantage of using Oracle Integration Cloud (OIC) for creating application Integrations?. Prebuilt integrations. Auto-association of Oracle SaaS applications. User Choice of IDE for development. Public/Private Cloud portability. Data mapping recommendations.

Oracle Integration Cloud (OIC) Service is available in two editions, Standard and Enterprise.Which two OIC Enterprise Edition capabilities are ALSO available in OIC Standard Edition?. File Server. Visual Builder. Integration Insight. B2B Trading Partner Agreements. Enterprise Application adapters (such as EBS, JDE, SAP and Siebel). Process Applications.

You are tasked with creating an Oracle Integration Cloud (OIC) integration flow that supports a B2B document exchange. When configuring the B2B action there are several capabilities as well as limitations. Which statement is NOT valid concerning OIC B2B capabilities?. It is mandatory to perform validations on EDI documents for Inbound translations;however, for outbound translations it is optional. A previously created Trading Partner Agreement is optional when configuring the inbound or outbound translation. You can customize standard Electronic Data Interchange (EDI) documents by adding new schema constructs or by editing existing constructs.

As an integration developer, you are creating an integration in Oracle Integration Cloud (OIC) to transform a payload with multiple orders. You need to configure for-each action to loop through each order and process them individually. How do you correctly configure for the for-each action to loop through each order and process them individually?. Select the Parallel Processing option and set the number of threads to the number of orders. Select the Group By option and group the orders by the order number. Select the Repeating Element field and map the source element that contains the orders. Select the Sequential Processing option and set the batch size to the number of orders.

Once they have been configured, which actions are allowed to be repositioned to another location within the design canvas of an orchestration style integration flow? Select THREE. Stage File Action using a Read File in Segments operation. Stage File Action using a Write File operation. Switch Action. JavaScript Call Action. For Each Loop Action. Stage File Action using a Read File operation.

Your design of an Asynchronous Oracle Integration Cloud (OIC) integration flow includes the requirement for additional processing logic that is conditionally based on the results returned to the integration instance from earlier external service invocations. You decide to leverage the switch action to facilitate this implementation. Which is a valid consideration concerning the configuration and capabilities of the switch action?. Nested Switch actions are not supported and, therefore, you may need to create more complex conditional expressions, if necessary. Data objects returned from actions within a branch of a switch action are not visible in the main flow of the integration after the switch action. The switch action must include an otherwise branch.

You are creating Integrations in Oracle Integration Cloud (OIC) using B2B trading partner agreements. Which identifier is implicitly used for all outbound agreements?. EDI Interchange Internal Sub ID. EDI Interchange ID. Application Partner ID. EDI Group ID Qualifier.

You are an Oracle Integration Cloud (OIC) specialist working on a project to integrate two systems using OIC. During testing, you notice that the integration instance fails to execute and returns an error message. Which step would you take first to troubleshoot the issue?. Check the instance logs for specific error messages and details. Increase the number of instances to handle the error. Immediately restart the integration instance. Contact Oracle Support and wait for a response.

Which action cannot be performed from the Oracle Integration Cloud (OIC) monitoring Dashboard?. Download OIC Lookups. Download Design-time Audit Records. View Design-time Metrics. View Current Email Count. View Connectivity Agent Group Status.

You are an Oracle Integration Cloud (OIC) specialist responsible for integrating two enterprise applications. Recently, you noticed that your integration instance is processing messages much slower than expected, causing a significant delay in data synchronization between the applications. What is the best course of action?. Delete and re-create the integration to start with a clean slate. Analyze the performance metrics of the instance, identify bottlenecks, and optimize the integration accordingly. Reactivate the integration to clear any temporary issues that might be causing the slowdown. Immediately increase the number of instances to handle the increased load.

Oracle Integration Cloud (OIC) integrations can be exported so that later they can be imported into another OIC instance environment. Which statement is NOT true about the import and export of OIC Integrations?. Imported integrations cannot be immediately activated if their dependent connection resources are not already present in the target OIC environment. Exported integrations include all their dependent connection resource information except URLs and credentials. Integrations must be exported as a package if you want to import them into another OIC environment. Imported integrations can be reconfigured to use different connection resources by using the OIC REST API.

A Company has been using Oracle Integration Cloud (OIC) to integrate its business applications,such as Oracle HCM Cloud, Oracle ERP Cloud, and Salesforce. However, they are planning to migrate some of their integration workloads from their current OIC instance to a new instance in a different region to comply with data sovereignty regulations. Which statement is true regarding the exporting and importing of integrations?. To change an integration identifier or version, you can manually edit the exported integration (IAR) file before importing it into another instance. You cannot import an integration if it already exists with the same identifier and version. You can export an integration either as a separate file (IAR) or bundled in a package (PAR) and it will still contain the connection resources. You can import a package containing activated integrations.

Which statement is valid regarding Oracle Integration Cloud (OIC) Lookups?. You cannot clone an existing lookup if it is being currently referenced in one or more active OIC Integrations. Lookup values are retrieved from a back-end database at runtime. Lookup values must include two or more domains associated with the corresponding SaaS Applications. A custom OIC XPath function is used to retrieve data from Lookups in the data mapper.

Which Oracle Integration Cloud (OIC) XPath function can be used to retrieve data from an OIC lookup within the Data Mapper tool?. Get-value-from-lookup. lookupValue. get-content-as-string. getLookup.

Your organization has a number of active integrations in Oracle Integration Cloud (OIC). Your advice is sought on the consequences of deactivating integration instances. Which statement concerning integration deactivation is NOT valid?. You can choose to retain the event subscription, where events are resent if the integration is reactivated again within six hours. Processing if any new messages will be immediately stopped. You will not be able to observe any failed instances occurring after the deactivation request. All existing history, monitoring, and runtime data will be lost.

Your team is responsible for an OIC package that contains five integrations. Currently, three of these integrations are active while the other two are inactive. Which statement is valid if you were to replace a connection used in this package?. You cannot replace connections unless all integrations in the package are in an inactive state. You can only replace the connections used by the three active integrations. You can only replace the connections used by the two inactive integrations. You cannot replace connections unless all integrations in package are in active state.

Which statement about Oracle Integration Cloud (OIC) is NOT Valid?. OIC lookups are based on a static definition, meaning you create and populate them during design time, and cannot be changed by runtime activities. Using the connectivity agent, you can create hybrid integrations and exchange messages between applications in private or on-premises networks and OIC. An application-driven integration can contain one or more trigger (source) Connections for requests sent to OIC and one or more invoke (target) connections for requests sent from OIC. When you open the mapper for a request or response message in an integration, the data structures are automatically populated with the information pulled from the source and target connections.

You have an Oracle Integration Cloud (OIC) synchronous integration flow that updates external systems with several invocations. However, several of your OIC Integration clients are reporting that they are experiencing timeouts waiting for the response confirmation from this processing.Which is legitimate strategy to mitigate this issue?. Increase the blocking timeout within the OIC integration settings to allow for extended time. Change the implementation logic to invoke multiple fine-grained external API calls within a single loop. Change the design implementation strategy to an asynchronous flow that provides a separate notification to clients when the processing is complete.

Which are types of certificates in Oracle Integration Cloud (OIC) that can be imported from the Certificates page under settings? Select THREE. Identity certificate. Message protection certificate. Multi Domain SSL Certificate. Unified Communications Certificate. Trust Certificate.

As an Oracle Integration Cloud (OIC) specialist, you are tasked with implementing a scheduled integration between two enterprise applications. The client requires that the integration be run every weekday at 3:00 PM to synchronize data between the systems. Which advanced scheduling configuration expression will you use?. “FREQ=DAILY;BYDAY!=SA,SU;BYHOUR=15”. “FREQ=WEEKLY;BYDAY=MO-FR;BYHOUR=15”. “FREQ=DAILY;BYDAY=MO-FR;BYHOUR=15”. “FREQ=WEEKLY;BYDAY=MO,TU,WE,TH,FR;BYHOUR=15”.

When defining the frequency for scheduled orchestration style integration runs, you can choose either Basic or the Advanced option. Which expression format is used for defining advanced scheduled runs?. iCal. cron. YAML. Groovy.

You are tasked with testing an integration that uses a REST trigger in Oracle Integration Cloud (OIC). You have successfully configured the REST adapter, and now you want to verify that the integration functions correctly. What should you do to test the integration?. Manually trigger the integration by sending an email to a specified email address with the required REST parameters. Export the integration as a .jar file and run it in a local development environment. Use the “Test” button in the integration designer to create a request, validate the response, and review the execution logs. Perform a SQL query on the associated database to ensure that the expected data is present.

In Oracle Integration Cloud (OIC), you are working on an integration that uses a REST trigger,which will require authentication. You need to ensure that only authorized clients can access the integration. Which configuration should you apply?. Enable Cross-Origin Resource sharing (CORS) and set an API key in the REST adapter configuration. Configure the REST adapter with a Basic Authentication or OAuth 2.0 security policy and provide the required credentials. Set up an IP whitelist in the OIC Instance, allowing only specific IP addresses to access the integration. Encrypt the payload using a Custom encryption algorithm and provide the decryption key to authorized clients.

Which statements are TRUE with regard to SOAP and the advantages it provides? Select THREE. SOAP clients can easily hold stateful references to remote server-side SOAP objects. SOAP is platform independent and programming language independent. SOAP typically leverages XML-based payloads to communicate between two client machines across any modern network. SOAP commonly serves as a cleaning agent that removes excess data from the transmission protocol. SOAP provides flexibility for message formatting allowing for loose coupling between a client and a server. SOAP over HTTP is typically not blocked by firewalls and proxy servers.

Which statements are TRUE about WSDL? Select TWO. It uses XML to define the service layer document which consist of origin of the webservice, headers, port types, request, and response data. It stands for “Web Service Description Language” and is a document written in XML. It stands for “Web Service Description Language” and is a document written in Object Notation. It is a wrapper for a SOAP message. It uses XML or JSON to define the service layer document which consists of origin of the web service, headers, port types, request and response data.

GlobalTech Corporation uses Oracle Integration Cloud (OIC) to synchronize data between their CRM and ERP systems. They currently have a scheduled integration that runs nightly at 3 AM. With the implementation of a new CRM system that supports real-time data synchronization,GlobalTech wants to update their ERP system immediately after any data changes in the CRM. To achieve this, they need to convert their scheduled integration to an app-driven integration,allowing the CRM system to trigger the integration upon data changes. When implementing this conversion, which of these considerations is NOT valid?. You must choose an existing REST adapter trigger connection resource. You cannot convert a scheduled integration to a REST adapter-triggered integration with multiple verbs. Any existing scheduled parameters will be automatically converted to integration properties. You cannot convert a scheduled integration with assignments that have the fault data type.

You need to create a scheduled orchestration integration that is based on an existing app-driven orchestration using the same display name. Which statement is valid for this use case?. You can create the new integration as a different major version of the existing one. You can clone the existing integration and specify it to use the scheduled orchestration pattern. You cannot create another integration that uses the same name. You can create the new integration by using the same display name but with a different identifier.

When creating a new Oracle Integration Cloud (OIC) Connection resource, there are several steps that must be done before it is fully configured and can be used in an integration flow. Which task is NOT required in order to transition a new Connection resource from the draft to the configured state?. Specify an adapter type. Specify the connection role. Configure the Security properties. Specify the corresponding lookup. Configure the connection properties. Execute a successful test of the connection.

Which statement is valid regarding connection resources in Oracle Integration Cloud (OIC)?. Each connection associated with a SaaS adapter type also requires a lookup component configuration. All connection configurations require the association of an active OIC Connectivity agent group. All connection resources must be associated with an adapter type regardless of role configuration. Connection resources can be configured with either a Trigger role or an invoke role, but not both.

Which type of certificate requires the uploading of a keystore (.jks) file in Oracle Integration Cloud to facilitate two-way SSL communication with external services?. Unified communications certificate. Multi Domain Certificate. Identity Certificate. Message Protection Certificate.

You are working on an integration within Oracle Integration Cloud (OIC) that includes several connections to external systems. As part of your development work, you need help to implement Global Fault handling to ensure that any unexpected errors are caught and handled correctly. Which approach should you use to add global fault handling within your integration?. Use the Raise Fault action within your integration flow to generate custom faults and handle them accordingly. Create a separate integration solely for the purpose of handling faults and configure your main integration to call it when necessary. Open the Global Fault handler page on the integration canvas and add actions as needed to handle unexpected faults. Add a Try-Catch action to your integration flow and configure it to catch and handle any faults.

You have a use case requiring the design of a synchronous Oracle Integration Cloud (OIC) integration flow that returns a custom business fault message to the client if processing fails due to an external runtime fault encountered during the integration instance execution. Which implementation strategy best satisfies this requirement?. Implement a scope fault handler to catch the runtime fault, and then use the Fault Return action providing mapped data for the custom fault. Implement a scope fault handler to catch the runtime fault, then allow the global fault handler to automatically send the runtime fault to the error hospital. Create a custom scope fault handler to catch the runtime fault, and then use the Re Throw Fault action to send the fault to the Error Hospital. Implement the Global Fault handler to catch the runtime fault, and then use the Re throw Fault action to send the custom fault to the client.

Which two statements are true regarding messaging adapters in Oracle Integration Cloud (OIC)?. Both the Apache Kafka and OCI Streaming adapters support XML, JSON, and AVRO message formats. The OCI streaming adapter does not support consuming messages from a specified consumer group. The Apache Kafka Adapter can be configured to support Transactions in case of Producer. It is not mandatory to install a connectivity agent to use the OCI Streaming Adapter for Inbound pooling.

You are designing a new integration in OIC that needs to expose a RESTful interface trigger for client applications. Which is a valid consideration while choosing request and response options using the REST Adapter Endpoint Configuration wizard?. Both Standard and custom HTTP headers can be defined for both the request and the response. File attachments can be accepted as a request option for the trigger interface, but you cannot include attachments as a response to the client. If you select a PUT or POST action (HTTP method), you must define a JSON response payload format. Although you can define both query and template parameters, only template parameters are available for mapping in the mapper because query parameters are considered optional.

Which Oracle Integration Cloud (OIC) service role does NOT have permission to run an OIC Integration?. ServiceDeveloper. ServiceAdministrator. ServiceInvoker. ServiceUser.

You can group one or more Oracle Integration Cloud (OIC) integrations into a single structure called a package. Which statement is not true about OIC packages?. All packages must include at least one integration. You can import packages directly from the Oracle Marketplace. Packages cannot be locked to deny other users access to your integrations. New packages can be created by clicking the Create button on the packages page in the OIC console. Integrations do not need to be part of a package. Packages enable you to easily import and export a group of integrations to and from OIC.

You can recover unsaved changes in an Oracle Integration Cloud (OIC) integration that crashes during design time because of a browser crash, loss of network connectivity, or a server going down. Which statement is NOT true about the unsaved changes feature in OIC?. A user with the ServiceAdministrator role can recover the unsaved changes. A user with the ServiceAdministrator role can unlock an integration that has unsaved changes. Changes made while editing a Connections page cannot be recovered. Change made while working inside a data mapper cannot be recovered. A backup copy is created after each complete task, therefore there is no time limit to logging back in and recovering the changes.

The Oracle Integration Cloud (OIC) integration designer editor provides a data mapper UI tool that is available for Map actions. Which statements are TRUE regarding the use of the Mapper tool? Select TWO. You cannot drag and drop an XSLT flow control statements directly to a target node element. You can drag and drop a source data element to multiple target node elements. You cannot drag and drop a source data element to a target node element that is already mapped. You cannot drag and drop an XPath function activity directly to a target node element.

There are use cases in which you need to perform an advanced XSLT task that you cannot perform in the Oracle Integration Cloud (OIC) data mapper. To perform the advanced mapping tasks, you decide to use an external XSLT mapper and then import the .xsl file back to your integration. What is NOT a valid consideration when handling this use case?. The exported archive file can include a map file that is largely complete in content or a map file that is empty of content. The exported archive must be imported into an Oracle Service Bus project in JDeveloper. You must export the entire integration that contains one or more .xsl files. Once the advanced mapping is complete, you must import the entire integration that contains the updated .xsl files.

CSV-formatted data has been extracted from ERP cloud by invoking a web service using the SOAP Adapter, and the data extracted has been returned as an MTOM attachment. You now need to send this CSV file to an external REST API that supports accepting this content as a Base64 encoded string. Which XPath mapper function should be used to map the SOAP MTOM attachment to the Base64 element present in the target REST API payloads?. decodeBase64. encodeBase64. encodeReferenceToBase64. decodeBase64ToReference.

When creating Integrations in Oracle Integration Cloud (OIC), a visual mapper enables you to map element nodes between applications by dragging source element nodes onto target element nodes. Which statement is NOT true about the OIC Data Mapper functionality?. All transformation mappings use eXtensible Stylesheet Language (XSL). In the designer view, the Sources section contains data structure or all available data objects, which includes integration metadata, tracking variables, global variables, and integration property values. The data structure for the target service is always displayed on the right side in the designer view. All source and target data objects are represented internally as JSON structures. When you navigate to the mapper and select a target element, Expression builder launches in a user-friendly mode by default.

You are designing an OIC Integration that processes files in a shared file system located within your on-premises data center.You have decided to leverage various stage file action operations within the integration flow in conjunction with an on-premises OIC Connectivity Agent.Which statement is not valid concerning file operation capabilities with regard to restrictions on using Stage File Action operations with the file and attachment features of the connectivity agent?. Files uploaded through the Connectivity Agent can only be read with a file reference,with regard to both the Read Entire File and Read File in Segments operations. Files uploaded through connectivity agent cannot be unzipped using a file reference. Files uploaded through connectivity agent are not available with the zip file operation. Files uploaded through connectivity agent are not available with the list file operation.

Which are valid considerations when leveraging the Oracle Integration Cloud (OIC) connectivity agent for high availability on-premises environments? Select TWO. Each host on which the agent is installed must be configured on separate subnets and assigned to the same OIC agent group. You should install the connectivity agents on the same host as the target application, and then specify different agent group identifiers for each agent during its installation. You cannot have more than two agent instances per agent group. Attempting to include a third agent instance in the same group during installation results in an error. File adapter is not supported in high availability environments. When using file adapterand if some groups have multiple instances, use a dedicated agent group (with one agent only). You need to have the OIC ServiceDeployer role permissions to download and install the OIC on-premises connectivity agent.

You created a scheduled integration in Oracle Integration Cloud (OIC) that uses scheduled parameters named startDate and endDate to determine the data range for a data synchronization process. The default values for these parameters are set to the previous day for startDate and the current day for endDate. However, you now want to schedule a run of the instance with a different start date. What should you do?. Modify the parameter value in the instance’s integration properties and restart the instance. Create a new version of the integration by modifying the parameter value, and then deploy the new scheduled integration version. Override the parameter value when scheduling the integration instance. Modify the parameter value in the integration code and redeploy the integration.

Which statement is NOT true about schedule parameters in Oracle Integration Cloud (OIC)integration flow?. Updates to schedule parameters value can be made manually before submitting an ad hoc request. Updates to schedule parameters value made dynamically in an Assign action will not persist on to the next instance run of the integration. Schedule parameters are always visible as an additional data source in the Sourcessection of the mappers and expression editors within the integration. Updates to Schedule Parameter values can be made manually when starting a schedule.

You have built an integration that includes an ERP Cloud Adapter connection. After the development has been completed, there is now a requirement to include newly added custom objects and custom attributes as part of the mappings. Which is the most efficient way to handle this requirement?. Check the Refresh Metadata option for the ERP Cloud Connection, navigate back to your integration, then delete and recreate the map action to include the new custom objects and attributes. Check the Refresh Metadata option for the ERP Cloud Connection, navigate back to your integration, then edit the map action to include the new custom objects and attributes. Delete the invoke action to the ERP Cloud, re-create it, then edit the map action to include the new custom objects and attributes. Delete the integration and recreate it to include the new custom objects and attributes in the map action.

Which is NOT an available option while configuring an ERP Cloud Adapter to use in an Oracle Integration Cloud (OIC) integration?. Invoke CRUD operation on ERP Cloud REST API. Upload files to UCM. Extract Bulk Data from ERP Cloud. Enable Callback.

You are configuring an ERP Cloud Adapter connection invoke action within an Oracle Integration Cloud (OIC) integration. How many child resources can you select?. Unlimited. 10. 5. 7.

In an Oracle Integration Cloud (OIC) project, you are asked to leverage a custom JavaScript library function to be used within an application-driven orchestration integration flow. Which set of steps should you follow to correctly use the JavaScript library within your OIC integration?. Copy and paste the entire JavaScript function code into a new JavaScript stage within the integration flow, and then map the inbound and outbound data elements in the corresponding map action. Use the function call action within the integration flow to reference an external URL that is hosting the JavaScript library function. Import the JavaScript library file into your OIC instance’s database schema, and then use a Local Invoke action to call the library function. Import the JavaScript library file to the OIC Console, and then use the JavaScript action within the integration flow to reference the library function.

Your team is using a JavaScript library function within an Oracle Integration Cloud (OIC) Integration flow. Because of business requirements, one of the functions need to be updated with additional code to incorporate new logic. Which consideration regarding JavaScript library functions is NOT valid?. JavaScript functions are not allowed to make outbound calls to external services. The JavaScript action has a timeout threshold of 60 seconds. Active integrations using a function that has been updated must be reactivated. Network, disk, or thread access is not supported from within a JavaScript function.

Which operation is NOT supported by an Oracle Integration Cloud (OIC) connection resource configured with FTP Adapter in the Invoke role?. Write File. Read File. Read File in Segments. Delete File. Download File. List File.

You have a use case that requires a large data extract, which is more than 10 MB, to be processed within an Oracle Integration Cloud (OIC) Integration. Which are three valid options?. Send the file as a multipart attachment to an OIC integration using a REST trigger, and make it available for processing using a Stage File action. Retrieve the file by invoking a SOAP API, which sends base64 encoded data within the SOAP body, and then decode the data and make it available for processing using a Stage File action. Retrieve the file by invoking a SOAP API, which sends the document as an MTOM attachment, and make it available for processing using a Stage File Action. Retrieve the file from an external endpoint using APIs that support application/blob as content type, and make it available for processing using a Stage File Action. Upload the file to the OIC file server, and then use an FTP adapter Download File operation, which makes it available for processing using a Stage File action.

Oracle Integration Cloud (OIC) provides the file server feature which is an embedded SFTP server that enables organizations to focus on building integrations without the need to host and maintain a separate SFTP server. Which statement is NOT valid concerning the OIC File Server feature?. Any external SFTP client can access file server if an OIC administrator has configured specific folder access permissions for that client. To write files to the OIC File Server from an internal OIC integration flow, a REST adapter connection resource must be used. Access to the OIC File Server management REST APIs is limited to users with the ServicAdministrator role. The OIC File Server is a feature that is disabled by default in a newly provisioned OIC Instance.

Which set of operations are supported by the Oracle Integration Cloud (OIC) File Adapter?. Read, write, list, download. Read, write, list, download, move. Read, write, list. Read, write, list, download, move, delete. Read, write.

You need to create an Oracle Integration Cloud (OIC) Integration that processes many records individually that are contained within a large file. You have been advised to use an implementation approach that uses the Download File operation of an FTP adapter in conjunction with the Stage File Action Read File in Segments operation to mitigate issues with memory consumption. When using this approach, which is a valid consideration regarding the use of the Read File in Segments operation?. Segment sized default to 50 records but can be configured to any other segment size. The Read File in Segments operation allows you to process the segments sequentially or in parallel. You need to explicitly configure a Scope action for this operation if you want to add additional actions during the processing of each segment. You must provide the actual filename because file references cannot be processed by the Read File in Segments operation.