1Z0-1042-25 Practice Questions

Oracle Integration (OIC) Standard Edition provides core integration capabilities, including access to the embedded SFTP-compliant File Server for file-based integrations and Visual Builder for developing custom web and mobile applications. The Enterprise Edition includes all features of the Standard Edition, plus advanced capabilities like Process Automation and B2B. Therefore, both the File Server and Visual Builder are available in OIC Standard Edition and, by extension, also in the Enterprise Edition.

A. Process Automation: This capability for modeling, automating, and monitoring business processes is an exclusive feature of the OIC Enterprise Edition.

B. B2B Trading Partner Agreements: B2B e-commerce, which includes managing trading partner agreements, is a feature only available in the OIC Enterprise Edition.

E. Enterprise Application adapters (such as EBS, JDE, SAP, and Siebel): These specific, high-value adapters for major enterprise systems are licensed for use only with the OIC Enterprise Edition.

1. Oracle Cloud Documentation

"About Oracle Integration Editions": "Oracle Integration Standard enables you to connect your SaaS and on-premises applications... You also get Visual Builder to visually develop and host web and mobile applications." and "Oracle Integration Enterprise includes all the features of Oracle Integration Standard

plus the ability to model

monitor

and manage business processes with Process and exchange business documents with partners using B2B." This confirms Visual Builder is in Standard

while Process and B2B are Enterprise-only.

Source: Oracle Help Center

Get Started with Oracle Integration Generation 2

Section: "About Oracle Integration Editions".

2. Oracle PaaS and IaaS Universal Credits Service Descriptions: This official document details the features included in each edition.

Source: Oracle PaaS and IaaS Universal Credits Service Descriptions (E99019-121

December 2023)

Page 129

Section: "Oracle Integration". It explicitly states Standard Edition "Includes Integration... and Visual Builder" and Enterprise Edition "Includes all the features of Standard edition

plus Process Automation and B2B."

3. Oracle Cloud Documentation

"About the Embedded SFTP Server": The documentation describes the File Server as a feature of Oracle Integration

without specifying an edition

indicating its availability across the platform.

Source: Oracle Help Center

Using Integrations in Oracle Integration Generation 2

Chapter: "Manage File-Based Data"

Section: "About the Embedded SFTP Server".

In Oracle Integration B2B, the host trading partner represents your company. A primary identifier must be configured for this host partner. This primary identifier, which corresponds to the EDI Interchange ID, is implicitly and automatically used to populate the sender ID field in the interchange control header (e.g., ISA06 for X12, UNB02.1 for EDIFACT) for all outbound B2B messages. This ensures that any receiving trading partner can uniquely identify your organization as the sender of the electronic interchange.

A. EDI Interchange Internal Sub ID is a secondary identifier used for specific internal routing or departmental identification, not the primary identifier for all outbound agreements.

C. Application Partner ID is used to identify a specific backend application or system, not the overall trading entity at the B2B interchange level.

D. EDI Group ID Qualifier is a code that specifies the format or type of the Group ID; it is not the identifier itself.

1. Oracle Cloud Infrastructure Documentation

Using B2B for Oracle Integration

"Configure the Host Trading Partner": This section explicitly states

"The primary identifier you define is used in the sender ID of the outbound EDI document's interchange header." This confirms that the primary identifier

which is the EDI Interchange ID

is used for all outbound messages.

2. Oracle Cloud Infrastructure Documentation

Using B2B for Oracle Integration

"Create Trading Partners": This page details the process of adding identifiers to a trading partner. It distinguishes between the primary identifier (required for the host) and other secondary identifiers

reinforcing that the primary EDI Interchange ID is the key identifier for the host in outbound transactions.

In Oracle Integration Cloud (OIC), a connection is a fundamental resource used to communicate with a specific application instance. The creation of any connection resource begins with the selection of an adapter. The adapter provides the necessary interface and protocol-specific logic to interact with the target application (e.g., REST, SOAP, Oracle ERP Cloud, Salesforce). This association is mandatory and independent of the connection's role (Trigger or Invoke) in an integration.

A. Lookups are separate components used within an integration's mapping logic for dynamic value translation; they are not a required part of a SaaS adapter's connection configuration.

B. The OIC Connectivity Agent is only required for connections to applications residing in a private or on-premises network, not for all connections, especially those to public cloud services.

D. A single connection resource can be configured to support both Trigger and Invoke roles if the underlying adapter's capabilities permit it. The roles are not mutually exclusive.

1. Oracle Official Documentation - Oracle Integration 3

"Manage Connections": In the section "Create a Connection

" the first step listed is to "select...the adapters you can select to create connections." This confirms that every connection must be associated with an adapter.

Source: Oracle Help Center

Oracle Integration 3 Documentation

"Manage Connections

" section "Create a Connection."

2. Oracle Official Documentation - Oracle Integration 3

"Manage Connections": In the section "Edit Connection Properties

" the documentation states for the "Role" property: "Select the role (direction) in which to use this connection. A connection can be used as a trigger

an invoke

or both." This directly refutes option D.

Source: Oracle Help Center

Oracle Integration 3 Documentation

"Manage Connections

" section "Edit Connection Properties."

3. Oracle Official Documentation - Oracle Integration 3

"Manage Agent Groups and the Connectivity Agent": The documentation's overview states

"The on-premises connectivity agent enables you to create integrations that connect to your on-premises applications." This clarifies that the agent is not for all connections

refuting option B.

Source: Oracle Help Center

Oracle Integration 3 Documentation

"Manage Agent Groups and the Connectivity Agent

" section "About the Connectivity Agent."

In Oracle Integration Cloud (OIC), an Identity Certificate is required for two-way SSL (also known as mutual TLS or mTLS) communication. When OIC acts as a client calling an external service that requires client authentication, OIC must present its own certificate to prove its identity. This identity certificate, along with its corresponding private key, is packaged and uploaded as a Java KeyStore (.jks) file. This allows the external service to verify OIC's identity, completing the mutual authentication handshake.

A. Unified Communications Certificate: This is a type of SSL certificate (like a SAN certificate) used to secure multiple hostnames, not the specific functional category used in OIC for client authentication.

B. Multi Domain Certificate: Similar to a Unified Communications Certificate, this is a commercial certificate type, not the classification used within the OIC security configuration for this specific function.

D. Message Protection Certificate: This certificate type is used for message-level security, such as digitally signing or encrypting the payload of a message (e.g., WS-Security), not for transport-level SSL/TLS authentication.

---

1. Oracle Official Documentation - Using Integrations in Oracle Integration 3: In the section on managing security certificates

the documentation explicitly defines the purpose of an Identity Certificate. It states

"Select this option to upload a keystore file with an identity certificate and private key for two-way SSL communication. The keystore must be in JKS format."

Source: Oracle Help Center

Using Integrations in Oracle Integration 3

Chapter: Manage Security

Section: Manage Security Certificates

Subsection: Upload a Certificate.

2. Oracle Official Documentation - Oracle Integration Generation 2: The documentation for the previous generation of OIC also confirms this distinction. It describes the three types of certificates that can be uploaded: Trust

Identity

and Message Protection

with the Identity certificate being the one used for two-way SSL and requiring a JKS keystore.

Source: Oracle Help Center

Using Integrations in Oracle Integration Generation 2

Chapter: Manage Security

Section: Upload a Certificate.

When configuring an invoke action for the Oracle ERP Cloud Adapter in Oracle Integration and browsing by Business (REST) resources, the adapter wizard allows you to select a parent resource and its associated child resources. The official Oracle documentation does not specify a numerical upper limit on the number of child resources that can be selected. The capability is designed to accommodate the structure of the underlying ERP Cloud REST API, which can have a variable number of child resources. Therefore, you can select one or more of the available child resources, making the practical limit "unlimited" in the context of the provided options.

A. 7: This is an arbitrary number. The Oracle ERP Cloud Adapter's configuration wizard does not impose this specific limit on the selection of child resources.

B. 5: This is an arbitrary number. There is no mention of a five-child resource limit in the official Oracle documentation for the adapter.

D. 10: This is an arbitrary number. The adapter's functionality is not restricted to a maximum of ten child resources according to official sources.

1. Oracle Cloud Infrastructure Documentation. Using the Oracle ERP Cloud Adapter with Oracle Integration

"Configure the Operations Page".

Reference Details: In the section describing the configuration of an invoke (outbound) endpoint

the documentation states: "Select the checkbox for the parent resource and one or more child resources to include in the request and response." This phrasing indicates that multiple children can be selected without specifying an upper bound

supporting the "unlimited" nature of the selection.

2. Oracle Cloud Infrastructure Documentation. REST API for Oracle Fusion Cloud Financials

"Perform Actions on Resources".

Reference Details: The underlying ERP Cloud REST API documentation describes resource hierarchies (e.g.

an invoice and its lines

attachments

etc.). The number of child resources is determined by the API's design for a given parent

not by a fixed limit in the OIC adapter. The adapter's wizard is built to reflect this flexible structure.

An application-driven integration in Oracle Integration Cloud (OIC) is architecturally designed to have a single entry point. This means it can be initiated by exactly one trigger (source) connection that receives an inbound request. While the integration flow can subsequently invoke multiple target systems or applications (invoke connections), the fundamental pattern does not allow for more than one trigger. The statement that it can contain "one or more trigger" connections is therefore architecturally incorrect and invalid.

A. This statement is considered valid in the context of the design paradigm. Lookups are created and populated at design time as static resources, although they can be modified programmatically via the REST API.

B. This is a valid statement. The OIC connectivity agent is the specific component designed to establish a secure connection between OIC and applications residing in private, on-premises networks for hybrid integrations.

D. This is a valid statement. When the mapper is opened, it introspects the metadata (such as WSDL, XSD, or JSON schemas) of the source and target connections to automatically populate the data structure trees for mapping.

1. Correct Answer (C): Oracle Cloud Infrastructure Documentation

Using Integrations in Oracle Integration 3

"Create App Driven Orchestrations". The guide consistently describes and illustrates the creation process as starting with the selection of a single trigger connection. For example

in the section "Add a Trigger Connection

" it states

"The first connection you add to an empty orchestration is the trigger connection." This implies a singular starting point.

2. Incorrect Option (A): Oracle Cloud Infrastructure Documentation

Using Integrations in Oracle Integration 3

"Manage Lookups in Integrations". This section describes creating and managing lookups (DVMs) primarily through the design-time user interface. While the REST API for Oracle Integration documentation shows endpoints for updating lookups

their primary role and definition are as design-time static resources.

3. Incorrect Option (B): Oracle Cloud Infrastructure Documentation

Using the Connectivity Agent. The documentation's home page states

"The on-premises connectivity agent enables you to create hybrid integrations and exchange messages between on-premises applications and Oracle Integration."

4. Incorrect Option (D): Oracle Cloud Infrastructure Documentation

Using Integrations in Oracle Integration 3

"Map Data in Integrations". The documentation explains

"The data structures of the source and target data are automatically populated in the mapper." This confirms the behavior described in the option.

Two-way SSL (Secure Sockets Layer), also known as mutual TLS (mTLS), requires both the client and server to exchange and validate their public key certificates to establish a secure connection. In Oracle Integration (OIC), when acting as a client to an external service that requires two-way SSL, OIC must present its own identity certificate. This is accomplished by uploading an "Identity Certificate" which is packaged in a Java KeyStore (.jks) file containing the private key and the public certificate chain. The standard format for these public key certificates used in SSL/TLS communication is X.509.

A. SAML: This is an XML-based standard for exchanging authentication and authorization data for Single Sign-On (SSO), not for establishing transport-level security like two-way SSL.

B. PGP: Pretty Good Privacy (PGP) is a standard used for encrypting and decrypting data at rest or in transit (e.g., files), not for authenticating endpoints in an SSL/TLS handshake.

D. Signing key: This is a generic term for a private key used to create digital signatures. While a private key is part of the keystore, "Signing key" is not a certificate type standard like X.509.

1. Oracle Official Documentation - Using Integrations in Oracle Integration Generation 2: In the section on managing security certificates

it details the process for two-way SSL. It states

"For two-way SSL communication

you must upload an identity certificate. This certificate type requires you to upload a keystore file (.jks) that contains the private key and the certificate of the client." The certificates contained within the keystore for SSL/TLS are based on the X.509 standard.

Source: Oracle Help Center

Using Integrations in Oracle Integration Generation 2

"Manage Security Certificates"

Section: "Upload a Certificate".

2. Oracle Official Documentation - REST API for Oracle Integration Generation 2: The security overview for the REST API discusses the use of SSL for secure communication. The underlying certificate technology for all SSL/TLS communication

including the certificates managed within OIC

is X.509.

Source: Oracle Help Center

REST API for Oracle Integration Generation 2

"Security"

Section: "Transport Layer Security".

Oracle Integration (OIC) provides a built-in mechanism called the Global Fault Handler for managing unhandled errors within an integration. This handler acts as a default, top-level catch block for the entire integration flow. By adding actions (such as notifications, logging, or invoking other services) to the Global Fault Handler on the integration canvas, you can define a consistent strategy to process any unexpected faults that are not caught by more specific, lower-level fault handlers (like those within a Scope action). This is the standard approach for ensuring all unexpected errors are handled correctly.

A. Oracle Integration does not have a "Try-Catch action." The equivalent is a "Scope" action, which can contain its own fault handler for a specific block of actions, not the entire integration.

B. The Rethrow Fault action is used within a fault handler to pass the fault to a higher-level handler (e.g., the Global Fault Handler), not to invoke a separate integration.

D. The Throw New Fault action is used to explicitly generate a new, custom fault within an integration, not to handle existing ones or send them to the Error Hospital.

1. Oracle Cloud Infrastructure Documentation - Using Oracle Integration 3

"Manage Errors with Fault Handlers": "Each integration includes a single global fault handler by default. The global fault handler is responsible for processing all faults that are not caught by a scope-level fault handler in the integration." This directly supports option C as the primary mechanism for handling uncaught faults.

2. Oracle Cloud Infrastructure Documentation - Using Oracle Integration 3

"Scope Action": "A scope is an action that groups a collection of other actions into a block. A scope can have its own fault handlers to catch and manage faults raised by the actions enclosed within it." This clarifies the purpose of a Scope

showing why option A is incorrect in its terminology and scope.

3. Oracle Cloud Infrastructure Documentation - Using Oracle Integration 3

"Rethrow Fault Action": "The Rethrow Fault action enables you to rethrow a fault that has been caught by a fault handler to the next-level fault handler for further processing." This confirms that Rethrow Fault propagates errors

invalidating the claim in option B.

4. Oracle Cloud Infrastructure Documentation - Using Oracle Integration 3

"Throw New Fault Action": "The Throw New Fault action enables you to throw a new fault from within an action." This shows the action is for fault generation

not handling

making option D incorrect.

The Oracle Integration (OIC) connectivity agent is primarily used to establish a secure connection between OIC in the public cloud and resources located in a private network, such as on-premises applications or databases behind a firewall.

While an Oracle Autonomous Data Warehouse (ADW) can be deployed with a private endpoint, the connectivity agent is not the only method for OIC to connect to it. As both OIC and ADW are native Oracle Cloud Infrastructure (OCI) services, OIC can be configured to use OCI networking features (like a service gateway or by assigning the OIC instance access to a Virtual Cloud Network) to communicate with a private ADW directly. Because a viable alternative to the agent exists, it is not strictly required.

B. Transferring files to an FTP server installed on-premises or behind a firewall: An on-premises FTP server is in a private network. The connectivity agent is the standard and required mechanism for OIC to bridge the public cloud and this private resource.

C. Creating orders in Oracle E-Business Suite: Oracle E-Business Suite is typically hosted on-premises or in a private network. The connectivity agent is required for the OIC adapter to communicate with it.

D. Publishing messages to Azure Service Bus: While a public Azure Service Bus does not require an agent, if it were configured with a private endpoint, the connectivity agent would be the required method for OIC to establish a connection.

1. Oracle Cloud Infrastructure Documentation

"Connect to Private Resources in a VCN": This document explains how an Oracle Integration instance can be configured to access private resources within an OCI VCN. It states

"You can create an Oracle Integration instance with a network endpoint in a specific VCN and subnet of your choice. This enables the instance to connect to any private resource that is reachable from that subnet." This confirms an alternative to the connectivity agent for private OCI resources like ADW.

2. Oracle Cloud Infrastructure Documentation

"About the Connectivity Agent": This official guide describes the agent's purpose: "The connectivity agent enables you to create integrations that connect to your on-premises applications... The connectivity agent removes the complexity of having to poke a hole in the firewall to allow inbound traffic." This highlights its primary use for on-premises scenarios (like options B and C).

3. Oracle Help Center

"Prerequisites for Creating a Connection" (for Oracle ATP/ADW Adapter): The documentation for the Oracle Autonomous Database Adapter notes

"For an Oracle ATP/ADW database on a private endpoint

you must... associate the connection with a connectivity agent." While this shows the agent is a valid option

the existence of the native VCN connectivity method (Reference 1) means the agent is not the only option

and therefore not strictly required.

When converting a scheduled integration to an app-driven integration in Oracle Integration Cloud, any existing scheduled parameters are deleted, not automatically converted. The developer is responsible for manually re-implementing the logic to handle incoming data from the new REST trigger's request payload or parameters, effectively replacing the functionality of the old scheduled parameters. The conversion wizard does not provide an automatic mechanism for this transition.

A. You must choose an existing REST adapter trigger connection resource.

This is a valid requirement. The conversion wizard prompts the user to select a pre-configured REST connection that will act as the new trigger.

B. You cannot convert a scheduled integration to a REST adapter-triggered integration with multiple verbs.

This is a valid limitation. The conversion process only supports creating a REST trigger with a single HTTP verb and resource URI.

D. You cannot convert a scheduled integration with assignments that have the fault data type.

This is a valid, documented limitation. The conversion wizard cannot process scheduled integrations that contain an assign action using a fault data type.

1. Oracle Cloud Infrastructure Documentation

Using Integrations in Oracle Integration 3

"Convert a Scheduled Orchestration to an App Driven Orchestration": This official guide explicitly lists the limitations of the conversion process.

Regarding option C: "Any existing scheduled parameters are deleted. You must manually add them back as part of the request or response payload configuration of the REST Adapter Endpoint Configuration Wizard." This directly refutes the claim of automatic conversion.

Regarding option A: The documented steps show that in the "Configure Endpoint" section

the user must "select an existing REST Adapter trigger connection to use."

Regarding options B and D: The "Limitations" subsection clearly states

"You cannot convert a scheduled integration to a REST Adapter-triggered integration with multiple verbs" and "You cannot convert a scheduled integration with assignments that have the fault data type."