OIC ERP - How to Restore Missed or exhausted business events in OIC

Receiving Missed Business Event in OIC

Step1: Deactivate an OIC Orchestration which has subscribed to ERP Business Events for PO Receipts.

Note: If the orchestration to be deactivated contains a business event subscription, a message is displayed asking if you want to delete the event subscription while deactivating the orchestration. If you select to delete the event subscription, the integration does not receive any events after it is reactivated. Below is just an example screenshot.

If you do not want to delete the event subscription, the events in this integration are resent if the integration is activated within six hours. Beyond 6 hours those requests will be exhausted.

Step2: Create PO Receipt. PO Receipt 10944 is created in fusion at 10:46 AM, during that time integration was deactivated.

Step3: Re-activate orchestration after some time.

Integration was activated at 1PM and we see that the Integration subscribed to the business event for the specific Receipt (10944)

Conclusion: Business events are retried in SaaS and automatically captured within 6 hours of unavailability of OIC services.

Restoring Exhausted Business Events

Step1: Deactivate Integration.

Integration is deactivated for one day. This integration subscribes to “PurchaseOrder” Business event.

Step2: Run API to find exhausted Business Events:

Total number of Exhausted Business event count in last 24 hours is 68.

API URL: <fusion url>/soa-infra/PublicEvent/diagnostic/exhaustedEventsDetail?lastHours=24&pageSize=100

/soa-infra/PublicEvent/diagnostic/exhaustedEventsCount?lastHours=24&pageSize=100

Note: We can find exhausted events for a specific Business Event like “PurchaseOrder” using Subscription ID. We have 43 requests which are exhausted in the last 24 hours. We have filtered out these using SubscriptionID.

 Step3: Activate the integration and restore the Exhausted event for “PurchaseOrder” using APIs

API URI: /soa-infra/PublicEvent/exhaustedEvents/restore

Sample Payload:

{

"subscriptionId": "(*****-***-***-**********-hy.integration.ap-hyderabad-1.ocp.oraclecloud.com):aHR0cHM6Ly9zb21pYy1vaWMtZGV2LWF4bGc4Ymlta2ZuZC1oeS5pbnRlZ3JhdGlvbi5hcC1oeWRlcmFiYWQtMS5vY3Aub3JhY2xlY2xvdWQuY29tL2ljL3dzL2ludGVncmF0aW9uL3YxL2Zsb3dzL2VycC9QT19FVkVOVC8xLjAv",

//"startDate": "29-04-2025 04:03:24",

//"endDate": "29-04-2025 10:20:25",

"lastHours":24

}

After restoring, check the count of Exhausted business event for “PurchaseOrder” is now 0

All 43 records have been subscribed through integration.

Conclusion: Restoring exhaust events is feasible via provided Oracle APIs

Poc document link:

https://docs.google.com/document/d/1E4KYFsKJhDrEEvYo9wQcHjZQraunWKgQ/edit?usp=drivesdk&ouid=105651791254983245041&rtpof=true&sd=true

Reference Document: https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=13339287498551&id=2751325.1&_afrWindowMode=0&_adf.ctrl-state=ccb6zmdcu_4

OIC - Designing a Reusable Callback Integration for Multiple FBDI Uploads in Oracle Integration Cloud (OIC)

🧾 Use Case Overview

In most Oracle Fusion implementations, File-Based Data Import (FBDI) is a widely used approach to load master and transactional data into Fusion Cloud. Each business object (like Employees, Items, Customers, Daily Rates, etc.) has a unique FBDI template and requires an integration that:

1. Generates the FBDI ZIP file
2. Uploads the file to UCM
3. Submits an ESS Job (e.g., "Load Interface File for Import")
4. Monitors the ESS job status
5. Performs post-processing on success/failure

When you’re handling multiple business objects, step 4 and 5 are usually the same across integrations. Repeating this logic in every flow makes it:

• Redundant
• Hard to maintain
• Prone to errors

👉 So why not reuse this logic?

---

🎯 Goal

To create one common callback integration in OIC that can be invoked from any FBDI integration to:

• Poll the ESS Job status
• Handle success/failure
• Perform downstream processing based on the business object

---

🧱 Architecture Overview

[ FBDI Integration: Employees     ] \
[ FBDI Integration: Items         ]  \
[ FBDI Integration: Daily Rates   ]   --> [ 🔁 Common Callback Integration ]
[ FBDI Integration: Customers     ]  /

Each main FBDI flow:

• Ends by calling the Common Callback Integration
• Sends a payload with:
  • requestId (ESS Job ID)
  • businessObject (like "EMPLOYEES")
  • fileName, submittedBy, etc.

---

🧰 Prerequisites

• Oracle Integration Cloud Gen 2/3
• ERP Cloud Adapter and SOAP connection to ERPIntegrationService
• Basic understanding of:
  • FBDI process
  • ESS Jobs in Fusion
  • While/Switch activities in OIC

---

🧭 Detailed Implementation Steps

---

Step 1: FBDI Integration Flow (Example: Daily Rates)

This is your normal FBDI flow:

1. Read source data
2. Transform and generate FBDI .zip file
3. Upload to UCM using ERP Cloud Adapter
4. Submit ESS Job using submitESSJobRequest
5. Capture requestId from the response
6. Call Common Callback Integration with a payload:

{
  "requestId": "456789",
  "businessObject": "DAILY_RATES",
  "fileName": "DailyRates_20250618.zip",
  "submittedBy": "ManojKumar"
}

---

Step 2: Create the Common Callback Integration

Integration Type: App-Driven Orchestration
Trigger: REST Adapter (POST operation)

📥 Input JSON Schema:

{
  "requestId": "string",
  "businessObject": "string",
  "fileName": "string",
  "submittedBy": "string"
}

---

Step 3: Parse and Assign Variables

• Assign requestId, businessObject, and other fields to local variables.
• Initialize:

  status = ""
  loopCount = 0
  

---

🔁 Step 4: Implement Polling Logic using While Loop

Condition:

status != "SUCCEEDED" AND status != "ERROR" AND loopCount < 20

Inside the loop:

1. Call getESSJobStatus via ERPIntegrationService SOAP connection
2. Parse response:

   <JobStatus>SUCCEEDED</JobStatus>
   <Message>Completed successfully</Message>
   

3. Assign status to local variable
4. Wait for 1 minute (use Wait activity)
5. Increment loopCount += 1

---

🧠 Step 5: Decision Based on Status

After exiting the loop, check if:

• status == "SUCCEEDED": proceed with business logic
• status == "ERROR": log failure and send notification

---

🧪 Step 6: Use Switch for Business Object-Specific Logic

Switch on businessObject:
├── "DAILY_RATES"   → Call Daily Rates post-processing
├── "EMPLOYEES"     → Call Employees HDL flow
├── "ITEMS"         → Write data to DB or update flag
├── "CUSTOMERS"     → Trigger BIP report / send confirmation

Use Local Integration Calls or inline logic as needed.

---

Step7: Output we Can Fetch After getESSJobStatus

When getESSJobStatus completes, the response includes a reportFile or document ID that points to the output/log files. We can fetch:

1. .log file (execution log)
2. .out file (output message, summary of load)
3. .csv error file (for rows that failed)

Call getESSJobExecutionDetails (Optional)

We can invoke another operation (if available) to get details of the child job, if the job is a job set or composite.

Alternative Approach (Preferred):

Use ERPIntegrationService.downloadESSJobExecutionDetails or UCM file download API to download the .log and .out files using requestId.

Use UCM Web Service to Download Files

Once the ESS job runs, output files are stored in UCM. We can Call ERPIntegrationService > downloadExportOutput

Input: requestId >> You’ll get a base64 file content >> Parse it or store it in DB or FTP for audit

Or use WebCenter Content API (UCM API) to list files using requestId and download

Sample Output from .out File (Import Summary)

Total Records Read: 100  

Successfully Imported: 95  

Failed Records: 5  

Log File: import_daily_rates.log

📧 Step 8: Optional Email Notification

Send an email with:

• ESS Job Result
• File name
• Business object
• Message or error (if failed)

---

📂 Sample getESSJobStatus Request Payload (SOAP)

<typ:getESSJobStatusRequest>
   <typ:requestId>456789</typ:requestId>
</typ:getESSJobStatusRequest>

Sample Response:

<typ:getESSJobStatusResponse>
   <typ:JobStatus>SUCCEEDED</typ:JobStatus>
   <typ:Message>Completed successfully</typ:Message>
</typ:getESSJobStatusResponse>

---

🚨 Error Handling Strategy

• If ESS Job fails (ERROR), log:
  • requestId
  • businessObject
  • error message
• Store in DB or call a notification integration
• Enable retry if needed

---

💡 Best Practices

• Set a polling limit (e.g., 20 retries = ~20 mins)
• Avoid infinite loops
• Use consistent naming conventions for businessObject
• Create reusable sub-integration flows for downstream processing
• Add logging and tracking (e.g., via ATP/Logging framework)

---

🚀 Enhancements We Can Add

• Add DB persistence for incoming callback metadata
• Scheduled Integration to recheck failed jobs
• Audit dashboard for all FBDI callbacks
• Notify users in MS Teams / Slack using Webhook

---

✅ Conclusion

Building a common callback integration for all FBDI flows:

• Makes your integrations modular and maintainable
• Reduces redundancy
• Centralizes your error handling and monitoring

This pattern can be extended to HCM Extracts, BIP report monitoring, and ESS job chains as well.

---

📦 Sample Naming Suggestions

Artifact	Name
Integration	INT_COMMON_ESS_CALLBACK
SOAP Connection	ERPIntegrationServiceSOAP
Variable: requestId	varRequestId
Variable: loop counter	varLoopCount
Email Subject	FBDI ${businessObject} - Job ${status}

OIC Gen3 - New Feature - File Polling Feature using FTP trigger in OIC

Unlocking Efficient FTP Triggers: Using the New File‑Polling Feature in Oracle Integration Cloud (OIC Gen3)

Subtitle:
Learn how to automate smaller file reads from FTP servers using the built‑in file‑polling trigger in OIC Gen3 24.10+.

🛠 Use Case

Many integration scenarios require processing files placed onto an FTP server—like daily CSV or XML reports—without manual intervention. Prior to OIC Gen3 24.10, triggering on file arrival involved workarounds such as scheduled scripts or custom polling logic.

With the new File‑Polling feature, you can:

• Trigger OIC integrations based on new files matching a naming pattern.
• Auto‑load file contents as payload—ideal for lightweight file reads.
• Configure archive, delete, or reject handling.
• Avoid downloads, saving bandwidth and simplifying flow.

---

🔧 Solution Overview: Step‑by‑Step

1. Ensure Compatibility
   Verify you're running OIC Gen3 version 24.10 or higher—this is when FTP file‑polling became available.

2. Set Up FTP Connection
   In your OIC connection settings, choose or configure your FTP/SFTP source.

3. Use File‑Polling Trigger
   In the integration builder, select the “File Polling” trigger. You’ll see options for:

   • Polling frequency (e.g., every 5 minutes)
   • Source directory
   • Filename pattern (e.g., *.csv)
   • Schema type (CSV, XML), plus sample file upload support

4. File Handling Options
   Decide what happens after triggering:

   • Archive to another folder
   • Move after successful read
   • Delete automatically
   • Ignore delete‑errors to prevent retries
   • Reject invalid files

5. Design Integration Flow
   After the trigger, use the file’s contents payload to:

   • Parse with a schema
   • Route data to downstream systems
   • Handle errors via reject logic

6. Test and Validate (POC)
   Always run a proof‑of‑concept:

   • Drop a test file matching your pattern
   • Confirm the integration triggered as expected
   • Validate the post‑processing behavior (archive/move/delete)

7. Deploy and Monitor
   Once verified, deploy your integration. Monitor success/failure and adjust polling or file‑handling parameters as needed.

The below we see the demonstration how to poll a file:

OIC - Monitoring and Troubleshooting Integrations in Oracle Integration Cloud (OIC) Gen 3: A Practical Guide

📘 Use Case:

As an OIC developer or integration lead, you often need to monitor live integrations for performance, failures, and latency issues. With OIC Gen 3, enhanced tools like Observability dashboard, Projects tab, and Activity Stream help you quickly identify, trace, and resolve issues.

🛠️ Solution Steps: Monitoring & Troubleshooting in OIC Gen 3

🔍 1. Observability Dashboard (Home → Observability)

• View overall system health:
  • Success/failure trends
  • Execution volumes
  • Error frequency by integration
• Helps you monitor across all projects and integrations.

📌 Tip: Use date filters and drill into specific time windows for better root cause analysis.

---

📁 2. Projects Tab + Observe Subtab (Projects → [Your Project] → Observe)

The Observe tab under Projects gives real-time, project-specific analytics.

Key Features:

• Live status of all integrations in the project.
• Visual indicators for:
  • Failed instances
  • Slow executions
  • Backlogged or retrying flows
• You can click an integration to view:
  • Run history
  • Payload details
  • Fault/error points

📌 Use Case: Great for team-based development — each team can monitor and troubleshoot flows relevant to their assigned project.

---

🔄 3. Activity Stream (Monitor → Tracking)

• Track integration instances using filters:
  • Integration name
  • Status (failed, completed)
  • Date/time range
• Open individual runs to:
  • View complete execution trace
  • See error messages and transformation values
  • Access input/output payloads

📌 Pro Tip: Combine this with the Observe view to jump from high-level KPIs to instance-level diagnostics.

---

🧰 4. Diagnostic Logs (Observability → Diagnostic Logs)

• Search logs using:
  • Integration name
  • Flow instance ID
  • Timestamps
• Useful for back-end or infrastructure issues, not visible in instance-level logs.

---

🔔 5. Notifications & Alerts

• Use Integration Insight or configure external notification logic to send alerts when:
  • Integration fails repeatedly
  • A flow runs unusually long
  • SLA thresholds are breached

---

🧪 6. Replay and Testing

• For eligible integrations, replay failed instances after correcting data or logic.
• Also supports test executions from integration canvas for verification before redeploying.

OIC - Line-by-Line Data Parsing in OIC Using Custom XSD Schema

Use Case:

When handling files containing rowwise data, such as payment information, it’s crucial to accurately parse each row based on a delimiter—like end-of-line (EOL). In this scenario, the incoming file data is represented in an XML format, where rows (or records) are wrapped within the XML structure and separated by EOL. To enable seamless integration and processing in Oracle Integration Cloud (OIC), we define a custom XSD schema to parse each row correctly and handle these line breaks.

---

Solution Steps:

✅ 1 Create the XSD Schema for Rowwise Parsing
We’ve designed an XSD schema (payments.xsd) with the following key features:

• The root element <payments> contains multiple <MyDataSet> elements.
• Each <MyDataSet> represents a row of data and uses nxsd:cellSeparatedBy="${eol}" to handle EOL-separated entries.
• Each row contains a single <MyData> element representing the data in that line, with nxsd:style="terminated" and nxsd:terminatedBy="${eol}" to ensure accurate row termination.

<?xml version="1.0" encoding="UTF-8" ?>
<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema"
    xmlns:nxsd="http://xmlns.oracle.com/pcbpel/nxsd"
    xmlns:tns="http://xmlns.sky.com.mx/sib/FormateaEfectivoPagosAnticipados/OficinaNICRFAdptr"
    targetNamespace="http://xmlns.sky.com.mx/sib/FormateaEfectivoPagosAnticipados/OficinaNICRFAdptr"
    elementFormDefault="qualified"
    attributeFormDefault="unqualified"
    nxsd:version="NXSD"
    nxsd:stream="chars"
    nxsd:encoding="UTF-8">

    <xsd:element name="payments">
        <xsd:complexType>
            <xsd:sequence>
                <xsd:element name="MyDataSet" nxsd:cellSeparatedBy="${eol}" minOccurs="1" maxOccurs="unbounded">
                    <xsd:complexType>
                        <xsd:sequence>
                            <xsd:element name="MyData" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy="${eol}" nxsd:quotedBy="&quot;" />
                        </xsd:sequence>
                    </xsd:complexType>
                </xsd:element>
            </xsd:sequence>
        </xsd:complexType>
    </xsd:element>

</xsd:schema>

✅ 2 Upload the XSD Schema in OIC

• Navigate to OIC -> Artifacts -> XSD Schemas.
• Upload the payments.xsd file to use it for validating and parsing incoming rowwise data files.

✅ 3 Integration in OIC

• Use the File Adapter or REST Adapter to bring in the file as input.
• Use the uploaded XSD to parse the file into structured data rows automatically.

---

Benefits of this Approach:

🔹 Accurate Rowwise Parsing – The schema ensures each line is treated as a separate record using EOL delimiters.
🔹 Easy Integration – Directly parse and validate rowwise data in OIC, reducing transformation complexity.

OIC - Verifying RSA Signatures Using OCI Functions and Java – A Seamless OIC Integration

Use Case

In today’s cloud-driven world, secure communication is paramount. One critical aspect of security is verifying digital signatures using asymmetric RSA cryptography. In this scenario, you need to:

✅ Validate incoming data from a third-party system using RSA signature verification.
✅ Perform the verification logic using a Java library (with SHA256withRSA).
✅ Deploy this verification as a serverless OCI Function.
✅ Invoke this function securely from Oracle Integration Cloud (OIC) to ensure your integration flows can trust the incoming data.

---

Solution Overview

We’ll cover:

1️⃣ Writing a Java class (RSASignatureVerifier) to verify RSA signatures.
2️⃣ Deploying this logic as an OCI Function (Java runtime).
3️⃣ Calling this OCI Function from OIC (via the Function Adapter).

This ensures your verification logic is centralized, secure, and easily maintainable.

---

Step-by-Step Solution

Step 1: Java Class for RSA Signature Verification

Here’s the complete Java code (RSASignatureVerifier.java).

import java.security.*;
import java.security.spec.*;
import java.util.Base64;

public class RSASignatureVerifier {

    /**
     * Verifies an RSA signature.
     *
     * @param data The original data that was signed.
     * @param signatureBase64 The signature in Base64 encoding.
     * @param publicKeyBase64 The RSA public key in Base64 encoding (X.509 format).
     * @param hashType Hashing algorithm to use (e.g., "SHA256withRSA").
     * @return true if the signature is valid, false otherwise.
     * @throws Exception on errors during verification.
     */
    public boolean verifySignature(String data, String signatureBase64, String publicKeyBase64, String hashType) throws Exception {
        // Decode the public key
        byte[] publicKeyBytes = Base64.getDecoder().decode(publicKeyBase64);
        X509EncodedKeySpec keySpec = new X509EncodedKeySpec(publicKeyBytes);
        KeyFactory keyFactory = KeyFactory.getInstance("RSA");
        PublicKey publicKey = keyFactory.generatePublic(keySpec);

        // Decode the signature
        byte[] signatureBytes = Base64.getDecoder().decode(signatureBase64);

        // Initialize the Signature object for verification
        Signature signature = Signature.getInstance(hashType);
        signature.initVerify(publicKey);
        signature.update(data.getBytes("UTF-8"));

        // Verify the signature
        return signature.verify(signatureBytes);
    }

    // Example usage
    public static void main(String[] args) throws Exception {
        RSASignatureVerifier verifier = new RSASignatureVerifier();

        String data = "12345678910";
        String publicKeyBase64 = "MIIBIjANBgkqhkiG9w0BAQEFAAOC..."; // truncated for brevity
        String signatureBase64 = "4BDmT8Qm8c9EQDdKLor7DXN5u..."; // truncated

        boolean isValid = verifier.verifySignature(data, signatureBase64, publicKeyBase64, "SHA256withRSA");
        System.out.println("Signature valid? " + isValid);
    }
}

Screenshot:

---

Step 2: Deploy as an OCI Function

1️⃣ Create a new OCI Function using the Java runtime.
2️⃣ Package your Java code (including the RSASignatureVerifier class) as a JAR.
3️⃣ Implement the Function’s entry point (handleRequest) to accept JSON with these fields:

{
  "data": "string to verify",
  "signatureBase64": "base64-encoded signature",
  "publicKeyBase64": "base64-encoded public key",
  "hashType": "SHA256withRSA"
}

4️⃣ Parse the JSON, call verifySignature, and return the verification result as JSON.

Here’s a sample Function handler:

import com.fnproject.fn.api.*;
import java.util.Map;

public class VerifySignatureFunction {
    public boolean handleRequest(Map<String, String> input) throws Exception {
        RSASignatureVerifier verifier = new RSASignatureVerifier();

        String data = input.get("data");
        String signatureBase64 = input.get("signatureBase64");
        String publicKeyBase64 = input.get("publicKeyBase64");
        String hashType = input.get("hashType");

        return verifier.verifySignature(data, signatureBase64, publicKeyBase64, hashType);
    }
}

---

Step 3: Invoke OCI Function from OIC

✅ Use the Oracle Integration Function Adapter.
✅ Configure it to call your OCI Function endpoint.
✅ Pass the required JSON payload dynamically from your OIC integration (e.g., mapping from integration data fields).

---

Result

🎉 Your integration flows in OIC now securely validate signatures before proceeding!
🛡️ You’ve centralized this cryptographic logic in an OCI Function, making it secure and reusable across multiple flows.

---

Conclusion

🔑 By combining Java’s cryptography libraries, OCI Functions, and OIC’s Function Adapter, you’ve built a secure, scalable, and maintainable solution for RSA signature verification.

How to generate the rsa public key: use the below online tool:

https://8gwifi.org/RSAFunctionality?rsasignverifyfunctions=rsasignverifyfunctions&keysize=2048

OIC - Can you explain how you use REST and SOAP connections in OIC?

Answer:

In Oracle Integration Cloud (OIC), REST and SOAP connections are set up to enable communication with external applications or services that expose their APIs in these formats.

🔹 REST Connections:

• I create REST connections using the REST Adapter in OIC.
• The connection is configured by specifying the base URL, authentication (like OAuth 2.0, Basic Auth), and optional headers.
• I typically use REST connections to integrate with modern web services, like external APIs or Oracle SaaS REST endpoints (e.g., ERP/HCM Cloud REST APIs).

🔹 SOAP Connections:

• I create SOAP connections using the SOAP Adapter.
• This involves uploading the WSDL file or providing the WSDL URL.
• The adapter uses the WSDL to define available operations and data structures.
• I use SOAP connections for integrations with legacy systems or Oracle SaaS SOAP web services (e.g., certain HCM/ERP services that are still SOAP-based).

✅ Practical Use in OIC Integrations:

• Once the connections are created, they are used in the integration flow.
• I drag and drop the REST or SOAP connections onto the integration canvas as invoke actions to send or receive data.
• In the mapper, I map the incoming or outgoing payloads to match the API’s structure.

OIC - What is the difference between synchronous and asynchronous integrations? Can you give examples in OIC?

Difference:

• Synchronous (sync) integrations are blocking – the calling system waits for the integration to finish and provide a response. These are best suited for real-time tasks that require immediate feedback.
  🔹 Example in OIC: A REST API-based integration where a frontend application sends a request to get the current stock level of a product in ERP and waits for the response immediately.

• Asynchronous (async) integrations are non-blocking – the calling system sends the request, and OIC processes it in the background, sending the response separately. These are used for batch processing or long-running tasks where real-time response isn’t needed.
  🔹 Example in OIC: An integration that receives a file (e.g., via FTP adapter) with thousands of records and processes it in the background to load data into Oracle ERP Cloud using FBDI.

SQL - How to get the 2nd or 3rd max salary from an employee table using sql query?

How to get the 2nd or 3rd max salary from an employee table using sql query?Answer:

Using limit and offset

2nd Maximum Salary

SELECT salary

FROM employee

ORDER BY salary DESC

LIMIT 1 OFFSET 1;

3rd Maximum Salary

SELECT salary

FROM employee

ORDER BY salary DESC

LIMIT 1 OFFSET 2;

Method 1: Using Subqueries

2nd Maximum Salary

SELECT MAX(salary) AS SecondHighestSalary

FROM employee

WHERE salary < (SELECT MAX(salary) FROM employee);

3rd Maximum Salary

SELECT MAX(salary) AS ThirdHighestSalary

FROM employee

WHERE salary < (SELECT MAX(salary) 

                FROM employee 

                WHERE salary < (SELECT MAX(salary) FROM employee));

OIC - Converting Unix Timestamps to Standard Time in JavaScript

🧐 Use Case

When working with data that uses Unix timestamps (like logs, APIs, or databases), it's essential to display them in a human-readable format (YYYY-MM-DD HH:mm:ss). JavaScript provides built-in methods to handle this, but careful handling of timezones, padding for single-digit numbers, and date formatting is needed.

💡 Solution Steps

1️⃣ Parse the Unix timestamp: Convert the numeric Unix timestamp to a Date object.
2️⃣ Extract date components: Use JavaScript's Date methods to extract the year, month, day, hour, minute, and second in UTC.
3️⃣ Pad single-digit numbers: Ensure numbers like 9 become "09" for consistent formatting.
4️⃣ Assemble the formatted string: Concatenate all components into a standard format YYYY-MM-DD HH:mm:ss.

---

📜 JavaScript Code: UnixToStandardTime.js

function UnixToStandard(TS) {
    TS = Number(TS);
    var date = new Date(TS);

    // Helper to pad with leading zeros
    function pad(n) {
        return n.toString().padStart(2, '0');
    }

    var Y = date.getUTCFullYear();
    var M = pad(date.getUTCMonth() + 1); // Months are zero-based
    var D = pad(date.getUTCDate());
    var H = pad(date.getUTCHours());
    var m = pad(date.getUTCMinutes());
    var s = pad(date.getUTCSeconds());
    var result = Y + "-" + M + "-" + D + " " + H + ":" + m + ":" + s;
    return result;
}

---

🚀 Usage Example

let timestamp = 1696177311000; // Example Unix timestamp
console.log(UnixToStandard(timestamp)); // Output: e.g., "2023-10-01 17:15:11"

This approach ensures reliable and standardized UTC time conversion, making it easier to display and interpret timestamps across different systems!

Screenshots:

Test:

OIC Gen3 new feature - Simplified file handling using system events

A new type of event is now available in Oracle Integration: a system event. Prior to this release, you had to create and publish an event, and then you could subscribe to it. However, system events are always available to be subscribed to in an event integration, without having to be created or published first. You can subscribe to system events only within a project.

The first system events that are available in Oracle Integration are for File Server. Each of the following File Server activities now raises a system event:

• Creating a folder

• Deleting a folder

• Creating a file

• Deleting a file

  Note: A system event currently isn't raised when you create or delete a file using the File server action. All other methods of creating and deleting a file do raise an event.

The File Server system events offer significant opportunities for efficiency. For example, you don't need to design an integration that checks for the existence of a file in File Server anymore. Instead, create an event integration that subscribes to the File created system event. The integration then runs whenever a file is created in File Server. You can even filter the events that the integration subscribes to.

OIC Gen3 New features 25.04 version

 Please find the best new features below:

1. Announcement Banner- 
1. You can view announcements in a banner that describe ongoing, completed, and scheduled patching and required user actions for your service instance. 
2. The announcements banner is visible only to users with the ServiceAdministrator or ServiceDeveloper role.
2. Oracle-managed disaster recovery enhancements
3. New recipes
4. Additional instances are ready for upgrade
5. Oracle Integration Artificial intelligence (AI) capabilities
6. Add a process automation action to an integration
7. Add default values in the mapper - https://soalicious.blogspot.com/2025/06/oic-gen3-new-feature-add-default-values.html
8. Export and import a project with events
9. Dynamic connection support with the connectivity agent
10. Configurable invoke connection retries - https://soalicious.blogspot.com/2025/06/oic-gen3-new-feature-add-retry-logic-to.html
11. Decisions support in Oracle Integration
12. File signing and verification : https://soalicious.blogspot.com/2025/06/oic-gen3-new-feature-sign-or-verify.html
13. Simplified file handling using system events - https://soalicious.blogspot.com/2025/06/oic-gen3-new-feature-simplified-file.html
14. AI in OIC
1. Native action for OCI AI Document Understanding service
2. AI-driven SQL generation
3. Project description generation
4. Lookup description generation
5. iCal generation
15. RPA
16. B2b introduced in Project

For more features. Follow the reference link.
Reference:
https://docs.oracle.com/en/cloud/paas/application-integration/whats-new/release-25.04-april-2025.html#GUID-E9E65F5B-B469-4D5A-B8AB-08F67EFB2192

OIC Gen3 New Feature - Add Default Values in the Mapper

If your target element includes a default value, you can use the Add Default Value option to automatically add the mapping. This capability eliminates the need to manually add a default value by creating a target element and adding the value as a literal.

Note:

The Add Default Value option is only available when the target node has a default value.

1. Open the mapper.

2. Right-click an element (for this example, name) and select Node info.

Note that this element includes a default value of Peter.

The Schema info page shows the following fields with element information: DataType, Required, Repeating, XPath, DefaultValue, ContentType, Nillable, minOccurs, NodeType, Abstract, and maxOccurs. The FHIR named object, Ext Url, and Ext Datatype labels are also displayed.

3. Right-click the same element again (name) and select Add default value.

The default value of Peter is automatically mapped and displayed in the Expression Builder.

This image shows the Sources, Mapping canvas, and Target sections of the mapper. The target code element is selected. A "T" icon is shown. At the bottom, the Expression Builder shows the assigned default value for this element.

OIC - Gen3 New feature - Add Retry Logic to Invoke Connections in Projects

 We can add retry logic to invoke connections in projects that enables you to automatically retry failed invocations a specified number of times within a specified time period. Both retry settings are configured with default values, but you can update these settings, if necessary.

Capabilities:

The retry logic provides the following capabilities:

• Skip to Content
• Skip to Search
• HomeCapabilitiesRetry logic provides the following capabilities:

• The number of invoke connection retries and the time between retries are automatically configured for you. You can also change these values, if necessary.
• Is available only in integrations in projects.
• Both business and runtime faults are retried. For example, a business fault may be a duplicate customer error in Netsuite or a runtime fault may be an HTTP 500 error.
• All faults from invoke connections are currently included as part of a retry. You cannot select the type of faults to retry or ignore.
• Retry logic can be added to as many invoke connections in an integration as you feel necessary. Retry logic is not handled at the integration level.

Add Retry Logic to an Invoke Connection at Design Time

1. Open a project, and then open the integration in which to add retry logic.
2. Click the Actions  menu of an invoke connection and select Add Retry Logic.
3. Click Add when prompted to add new canvas actions and move the selected invoke connection and its associated map action.

   Your integration is updated with retry logic.

   
   
   

   The retry logic consists of the following:

   • An assign action is added immediately above the while action that controls the default number of retries (set to 3) and the time between retries (set to 5 seconds). You can update these values, as necessary.
     
     

     

     
     

     Note:

     Do not set your number of retries to a large value. This can impact performance.
   • The invoke connection and its associated map action are moved inside a scope action of the while action (for this example, the invoke connection callCustomer1 and map action callCustomer1). An assign action is also added to the scope. If your invoke connection did not include a map action, only the invoke connection is moved inside the scope action. A new map action is not created.
   • A fault handler with a switch action is added.

Run an Integration Configured with Retry Logic

This section provides a view of activity stream output when invoke connection failures occur.

1. Run an integration on which you added retry logic.
2. Expand the activity stream and note that three retries (iterations) were run (the default setting).

   
   
   

   When the invoke connection fails, it is caught by the fault handler in the scope action. A variable increments the fault. Regardless of the error code (for example, an HTTP error or an XPath expression error), a retry is performed.

3. Expand each failed iteration to view the timestamp between retries. Note the five second delay between the first and second iterations (the default setting).

   
   

Reference:

https://docs.oracle.com/en/cloud/paas/application-integration/integrations-user/retry-invoke-connections-project.html#ICSUG-GUID-016194A6-D410-419C-B6B9-20B760EB5530

OIC - Gen3 new feature - Sign or verify a file using stage action

We can perform signing using the private key to allow the receiver to verify that the file contents were not altered during transit. You can also perform signature verification using the public key on the incoming file to verify that the contents were not altered during transit.

• For files that must be signed or verified and then saved to File Server: Get File Reference, which gets a reference to a file.

  After the File server action, add a stage file action to perform file signing or verification, and then another File server action using the Write File operation. The File server action uploads the file to File Server.

• Alternatively, you can use the capabilities of the FTP Adapter to perform file signing or verification.

For decrypt file, encrypt file and read entite file operation: