Wednesday, February 25, 2026

Privacy Policy

At Know Oracle EBS (https://knoworacleebs.blogspot.com), the privacy of our visitors is extremely important to us. This Privacy Policy document outlines the types of information that are collected and recorded and how we use it.

1. Information We Collect

We may collect personal information such as your name, email address, or other details when you contact us directly or subscribe to our content.

We also collect non-personal information such as:

Browser type
IP address
Pages visited
Time and date of visits

This information is used only for analyzing trends and improving user experience.

2. Cookies and Web Beacons

Know Oracle EBS uses cookies to store information about visitors’ preferences and to optimize the website experience.

You can choose to disable cookies through your individual browser options.

3. Google AdSense & Third-Party Advertising

We use Google AdSense and other third-party advertising partners to serve ads.

Google uses DoubleClick cookies to display ads to users based on their visits to this and other websites.

Users may opt out of personalized advertising by visiting:
https://adssettings.google.com

Third-party ad servers may use technologies like cookies, JavaScript, or web beacons in their respective ads.

Know Oracle EBS has no control over these cookies.

4. How We Use Your Information

We use the collected information to:

Improve our website content
Respond to user inquiries
Provide better services
Analyze site performance

We do not sell, trade, or transfer your personal information to others.

5. Third-Party Privacy Policies

Know Oracle EBS’s Privacy Policy does not apply to other advertisers or websites.

We advise you to consult the respective Privacy Policies of these third-party ad servers for more information.

6. Children’s Information

Know Oracle EBS does not knowingly collect any personal information from children under the age of 13.

If you believe that your child provided personal information on our website, please contact us and we will remove it immediately.

7. Consent

By using our website, you hereby consent to our Privacy Policy and agree to its terms.

8. Updates to This Policy

We may update this Privacy Policy from time to time. Any changes will be posted on this page.

Last updated: February 2026

About US

About Know Oracle EBS

Welcome to Know Oracle EBS (https://knoworacleebs.blogspot.com).

Know Oracle EBS is a technical blog dedicated to sharing practical knowledge, tutorials, and solutions related to Oracle ERP, Oracle E-Business Suite (EBS), Oracle Integration Cloud (OIC), SQL, and related enterprise technologies.

Our goal is to help developers, consultants, and IT professionals understand complex Oracle concepts in a simple and easy-to-follow manner.

Our Mission

Our mission is to provide:

High-quality technical tutorials
Real-world problem-solving guides
Integration and reporting solutions
Best practices for Oracle applications

We aim to support professionals in improving their skills and growing their careers in the Oracle ecosystem.

What You Will Find Here

On this blog, you will find:
✔ Step-by-step technical guides
✔ Oracle Fusion and EBS tutorials
✔ SQL and BI report solutions
✔ OIC integration examples
✔ Tips for enterprise applications

All content is based on practical experience and continuous learning.

About the Author

This blog is managed by an Oracle technology professional with hands-on experience in ERP implementations, integrations, and reporting solutions.

With a passion for learning and sharing knowledge, the author focuses on delivering accurate, up-to-date, and useful technical content.

Our Commitment

We are committed to:

Providing original and useful content
Maintaining accuracy and quality
Respecting user privacy
Following ethical blogging practices

If you have suggestions or feedback, feel free to contact us anytime.

Thank you for visiting Know Oracle EBS and being part of our learning community.

Contact US

Contact Know Oracle EBS

Thank you for visiting Know Oracle EBS.

If you have any questions, suggestions, collaboration requests, or technical queries, feel free to contact us.

📬 Get in Touch

You can reach us through the following:

📧 Email: oraclefusiontech.oic007@gmail.com

💬 What You Can Contact Us For

You may contact us for:

Technical support
Content suggestions
Collaboration opportunities
Reporting issues
Feedback and improvements

We try our best to respond within 24–48 hours.

🌐 Website

https://knoworacleebs.blogspot.com

Thank you for connecting with us. We appreciate your interest in our content.

Saturday, February 7, 2026

Handling long-running BI Publisher (BIP) reports with huge data in Oracle Integration Cloud

Handling long-running BI Publisher (BIP) reports with huge data in Oracle Integration Cloud (OIC) is a very common real-time challenge. Here are the best-practice approaches used in production environments.

✅ 1. Use Asynchronous Report Execution (Most Important)

Never run large reports in synchronous mode.

❌ Problem

Synchronous calls timeout in OIC (typically 5–10 mins).

✅ Solution

Use asynchronous execution:

Flow:


Submit Report → Get Job ID → Poll Status → Download Output

Steps:

1️⃣ Call runReport with:


<runReport>
  <reportRequest>
    <attributeFormat>xml</attributeFormat>
    <byPassCache>true</byPassCache>
    <flattenXML>false</flattenXML>
    <sizeOfDataChunkDownload>-1</sizeOfDataChunkDownload>
  </reportRequest>
</runReport>

2️⃣ Capture jobId

3️⃣ Poll using getReportStatus

4️⃣ Download using getOutput

✅ This avoids timeout.

✅ 2. Use Pagination / Chunking (Split Data)

Never fetch millions of records at once.

Best Practice:

Split report by:

Parameter	Example
Date	From–To Date
Batch	Batch ID
Org	BU
Range	ID ranges

Example:


From Date = Today-1
To Date = Today

Then loop in OIC.

✅ Prevents memory overflow.

✅ 3. Optimize BI Publisher SQL Query

Many performance issues come from bad SQL.

Do This:

✔ Use proper indexes
✔ Avoid SELECT *
✔ Use filters
✔ Avoid correlated subqueries
✔ Use EXISTS instead of IN
✔ Use materialized views

Example:


SELECT order_id, customer_name
FROM oe_orders
WHERE last_update_date >= :p_from_date

❌ Avoid:


SELECT * FROM oe_orders

✅ 4. Enable Data Chunk Download

For very large XML/CSV files.

Set:


<sizeOfDataChunkDownload>10485760</sizeOfDataChunkDownload>

= 10 MB chunks


-1 (entire file)

Recommended: Use chunking.

✅ 5. Use File Server / Stage File Instead of Memory

Never hold huge payload in OIC memory.

Best Pattern:


BIP → OIC → Stage File → Process → FTP/S3

Use:

✔ Stage File Read/Write
✔ OIC Lookups for tracking
✔ Streaming

Example:


Stage File → Write → Process Line-by-Line

✅ 6. Use Schedule + Callback Pattern (Advanced)

For extremely heavy reports.

Pattern:

Schedule report in Fusion
Send output to UCM/FTP
OIC picks file
Process async

✅ Zero timeout risk.

✅ 7. Increase OIC Tracking & Fault Tolerance

Disable payload tracking for huge data:

In Integration Insight:


Disable Tracking = TRUE

Or use business identifiers only.

✅ Improves performance.

✅ 8. Use CSV Instead of XML (If Possible)

XML = Heavy
CSV = Lightweight

Preferred:


Output Format = CSV

Benefits:

Faster
Smaller size
Easier parsing

✅ 9. Parallel Processing (When Allowed)

If business allows:

Split by:

Region
BU
Date

Run multiple integrations.

Example:


North + South + East + West

Run in parallel.

✅ 10. Timeout & Retry Handling

Implement retry logic:


If Status = Running → Wait → Retry
If Failed → Alert

Use OIC Scheduler + Scope Fault.

📌 Recommended Architecture (Real-Time)


OIC Scheduler
     ↓
Submit BIP Report (Async)
     ↓
Poll Status
     ↓
Download in Chunks
     ↓
Write to Stage File
     ↓
Process / FTP / API

⚠️ Common Mistakes (Avoid These)

❌ Calling runReport synchronously
❌ Fetching millions of rows
❌ Holding payload in memory
❌ No filters
❌ No retries
❌ No staging

🎯 Real Project Example

Scenario:

Daily AR invoice report (5M rows)

Solution:

✔ Split by date (1 day)
✔ CSV format
✔ Async mode
✔ Stage file
✔ FTP delivery

Result:
⏱ Reduced time: 2 hrs → 15 mins
❌ Zero failures

Web extensions in Oracle Fusion

🌐 Oracle Fusion Web Extensions: Complete Guide with Use Cases, Navigation & Screenshots

📌 Introduction

Oracle Fusion Web Extensions allow organizations to extend the user interface and functionality of Fusion Cloud applications using Visual Builder Studio (VBS) and REST services.

They help businesses customize screens, add validations, integrate external systems, and enhance user experience without modifying standard Oracle code.

In this blog, you will learn:

What are Fusion Web Extensions?
Architecture Overview
Business Use Cases
Navigation Steps
Configuration Process
Screenshot Walkthrough
Best Practices

📖 What Are Fusion Web Extensions?

Fusion Web Extensions are UI-based customizations developed using Oracle Visual Builder that run on top of Fusion applications.

They allow you to:

Add custom pages
Extend standard pages
Embed external apps
Call REST APIs
Customize workflows
Improve user productivity

These extensions are upgrade-safe and fully supported by Oracle.

🏗️ Architecture of Web Extensions

User → Fusion UI → Visual Builder Extension → REST APIs → Backend Services

Key Components:

Visual Builder Studio
Business Objects
REST Services
Security Roles
Page Flows

⚙️ Types of Fusion Web Extensions

1️⃣ Page Extensions

Extend standard Fusion pages.

📌 Example:

Add custom section in Sales Order page
Add approval comments field

2️⃣ Standalone Web Apps

Independent applications integrated into Fusion.

📌 Example:

Custom Vendor Portal
Order Tracking Portal

3️⃣ Embedded Extensions

Embedded inside existing pages.

📌 Example:

Credit status widget
Stock availability panel

🏢 Real-Time Business Use Cases

✅ Use Case 1: Customer Credit Dashboard

Display real-time credit status on Order Entry page.

Benefits:

Faster decisions
Reduced risk

✅ Use Case 2: Custom Approval Interface

Create simplified approval screen.

Benefits:

Mobile friendly
Better user adoption

✅ Use Case 3: External System Integration

Embed logistics tracking portal.

Benefits:

End-to-end visibility
No manual follow-ups

✅ Use Case 4: Data Capture Enhancement

Capture additional attributes during order creation.

Benefits:

Better reporting
Compliance support

🧭 Navigation: How to Access Web Extensions

Step 1: Login to Oracle Fusion

Navigate to:

Navigator → Tools → Visual Builder Studio

📷 Screenshot 1: Fusion Navigator with Visual Builder Studio

Step 2: Open Visual Builder Instance

Select your environment and workspace.

📷 Screenshot 2: Visual Builder Studio Dashboard

Step 3: Access Application Extensions

Go to:

Projects → Fusion Applications → Web Extensions

📷 Screenshot 3: Web Extensions Project Screen

Step 4: Create New Extension

Click Create Application → Select Extension Type

📷 Screenshot 4: Create Web Extension Wizard

🛠️ Creating a Web Extension – Step by Step

Step 1: Define Application

Provide:

Application Name
Description
Base Product

Step 2: Design Pages

Use drag-and-drop UI builder.

Components:

Forms
Tables
Charts
Buttons

📷 Screenshot 5: Visual Page Designer

Step 3: Configure REST Services

Connect Fusion REST APIs.

Example:

GET /fscmRestApi/resources/latest/salesOrders

📷 Screenshot 6: REST Service Configuration

Step 4: Add Business Logic

Use JavaScript for validations.

Example:

if(orderAmount > 500000){
  alert("Approval Required");
}

Step 5: Test & Publish

Test in DEV → Publish → Deploy to PROD

📷 Screenshot 7: Publish & Deployment Screen

🔐 Security Configuration

Configure access using:

Security Console → Roles → Visual Builder Roles

Assign users appropriately.

⚠️ Best Practices

✔ Use responsive design
✔ Follow naming standards
✔ Reuse REST services
✔ Secure APIs
✔ Maintain documentation
✔ Test across devices

❌ Common Mistakes

❗ Hardcoding URLs
❗ Ignoring security roles
❗ Not handling errors
❗ Poor UI design
❗ No performance testing

📈 Performance Optimization Tips

Use pagination
Enable caching
Minimize API calls
Lazy load components

🔍 Monitoring & Troubleshooting

Use:

Tools → Application Monitoring → Visual Builder Logs

Check:

Console logs
REST errors
Performance metrics

📷 Screenshot 8: Visual Builder Monitoring Screen

📚 Interview Perspective (Bonus)

Q: What is Fusion Web Extension?

A: A Visual Builder-based UI customization for Fusion.

Q: Are web extensions upgrade-safe?

A: Yes, fully supported by Oracle.

Q: Which language is used?

A: JavaScript and JSON.

🎯 Conclusion

Fusion Web Extensions empower businesses to deliver personalized user experiences and integrate modern digital workflows into Oracle Fusion.

With proper governance and design, they can significantly enhance productivity and system adoption.

✍️ About the Author

Akhil Sayed is an Oracle Fusion & OIC Consultant specializing in SCM, Web Extensions, and Cloud Integrations.

Visit: https://knoworacleebs.blogspot.com

📢 Did you find this useful?

Like, Share & Comment below!

Happy Coding! 🚀

OM Extension in Oracle Fusion Cloud SCM

🚀 Oracle Fusion SCM – Order Management Extensions: Complete Guide with Use Cases & Screenshots

📌 Introduction

Oracle Fusion SCM Order Management (OM) provides powerful Extension Frameworks that allow businesses to customize and enhance standard order processing without modifying core code.

These extensions help organizations implement custom validations, automation, integrations, and business rules aligned with real-world processes.

In this blog, we will cover:

What are OM Extensions?
Types of Extensions
Business Use Cases
Navigation Steps
Sample Scenarios
Screenshot Walkthrough

📖 What Are Order Management Extensions?

Order Management Extensions are custom logic components that run during order processing lifecycle events.

They allow you to:

Validate orders
Enrich data
Control workflows
Trigger integrations
Enforce business rules

These are built using Groovy scripting in Oracle Fusion Cloud.

⚙️ Types of Order Management Extensions

1️⃣ Validation Extensions

Used to validate order data before submission.

📌 Example:

Prevent order submission if credit limit exceeded
Validate customer category

2️⃣ Defaulting Extensions

Used to populate default values.

📌 Example:

Default warehouse based on country
Assign price list automatically

3️⃣ Processing Extensions

Executed during order lifecycle.

📌 Example:

Auto-approve orders
Trigger shipment process

4️⃣ Integration Extensions

Used to integrate external systems.

📌 Example:

Send order to WMS
Notify finance system

🏢 Real-Time Business Use Cases

✅ Use Case 1: Credit Limit Validation

Prevent customers from placing orders beyond credit limit.

Logic:

if (orderTotal > customerCreditLimit) {
    throw new ValidationException("Credit limit exceeded")
}

✅ Use Case 2: Auto Warehouse Assignment

Assign warehouse based on shipping location.

Country	Warehouse
India	WH_IND
USA	WH_USA

✅ Use Case 3: Special Discount Approval

Route high-discount orders for approval.

Condition: Discount > 25%

Action: Send for approval

✅ Use Case 4: Integration Trigger

Send confirmed orders to 3PL system.

Trigger: Order Status = Confirmed

🧭 Navigation: How to Access OM Extensions

Step 1: Login to Fusion Application

Navigate to:

Navigator → Setup and Maintenance

📷 Screenshot 1: Fusion Home / Navigator Page (Oracle Fusion SCM Landing Screen)

Step 2: Open Order Management Setup

Go to:

Setup and Maintenance → Order Management → Order Management Extensions

📷 Screenshot 2: Setup and Maintenance – Order Management Configuration Page

Step 3: Manage Order Management Extensions

Click on:

Manage Order Management Extensions

📷 Screenshot 3: Search Results for Order Management Extensions

Step 4: Create New Extension

Click + Create

Select:

Extension Type
Event
Object

📷 Screenshot 4: Manage Order Management Extensions – Event Configuration Screen

🛠️ Creating an Extension – Step-by-Step

Step 1: Select Event

Common Events:

On Save
On Submit
On Process
On Fulfillment

Step 2: Write Groovy Script

Example:

if (Header.TotalAmount > 100000) {
    Header.ApprovalRequired = true
}

Step 3: Validate Script

Click Validate to check syntax.

📷 Screenshot 5: Groovy Script Editor with Validation Option

Step 4: Deploy Extension

Click Deploy to activate.

📷 Screenshot 6: Extension Deployment and Activation Screen

📊 Extension Lifecycle

Create → Validate → Deploy → Test → Monitor

Always test in TEST/UAT before Production.

⚠️ Best Practices

✔ Use modular scripts
✔ Avoid hardcoding values
✔ Use lookups
✔ Add error handling
✔ Maintain documentation
✔ Use version control

❌ Common Mistakes

❗ Not validating scripts
❗ Hardcoded org IDs
❗ Missing exception handling
❗ No performance testing

📈 Performance Tips

Avoid heavy loops
Minimize database calls
Cache lookup values
Use conditional logic

🔍 Monitoring & Troubleshooting

Navigate to:

Tools → Scheduled Processes → Diagnostic Logs

Check:

ESS logs
Extension logs
Error stack trace

📷 Screenshot 7: Diagnostic Logs and Troubleshooting Screen

📚 Interview Perspective (Bonus)

Q: Why use OM Extensions?

A: To implement custom business rules without modifying standard Fusion code.

Q: Which language is used?

A: Groovy scripting.

Q: Are extensions upgrade-safe?

A: Yes, Oracle supports extensions during upgrades.

🎯 Conclusion

Order Management Extensions in Oracle Fusion SCM are powerful tools to customize order processing and meet complex business requirements.

With proper design, testing, and governance, they can significantly improve operational efficiency.

✍️ About the Author

Akhil Sayed is an Oracle Fusion & OIC Consultant with hands-on experience in SCM, integrations, and cloud implementations.

For more Oracle tutorials, visit:
👉 https://knoworacleebs.blogspot.com

📢 Did you find this helpful?

Like, Share & Comment below!

Happy Learning! 🚀

Tuesday, February 3, 2026

Sample Document to Use OIC Lookup to pass the username and password from Lookup

Usecase : It is not advisable to pass the hardcoding , username and password in OIC integration.

Solution : We need to pass these values need to pass these values

From lookups.

Benefit of passing the Values from lookup is that , if some value changes we

need not make changes to OIC code , we can just update the lookup values.

And also of the OIC integration is migrated some other instance or if the password we have to change ,

We only need to update the lookup.

Sample Lookup design in OIC >

Now to use this in OIC mapping , goto mapper

Ø Components > Functions > Integratoin Cloud > Lookup Value > Drag and drop to the Mapper

Now it will open a setup page

Select the Lookup Name

Select source and Target Columns.

Click Next ,and then next Done Close.

dvm:lookupValue('FUSION_DATA_SYNC', 'NAME', srcValuePlaceHolder, 'VALUE', '')

Update srcvaluePlaceholder with the username > “BI_USERNAME”

It should look as below

dvm:lookupValue ("FUSION_DATA_SYNC", "NAME", "BI_USERNAME", "VALUE", "" )

Similar to pull password repeat the same step as above.

dvm:lookupValue('FUSION_DATA_SYNC', 'NAME', srcValuePlaceHolder, 'VALUE', '')

Update srcvaluePlaceholder with the username > “BI_PASSWORD”

dvm:lookupValue ("FUSION_DATA_SYNC", "NAME", "BI_PASSWORD", "VALUE", "" )

Now validate and Close the Mapper .

And Save the Integration.

Now when the Integration runs the username and password will be pulled from lookups.