Skip to main content

The Cool Fox

Oracle Cloud Technologies Blog

Home
Site Map
Oracle OCI
Oracle OIC
Oracle VBCS
Oracle Fusion
Oracle VBS
Oracle ADF
Oracle SOA
Oracle Apps
Oracle OAF
Oracle SQL

Showing posts with the label Oracle SQL

Posts

[SQL] SQL Common Table Expressions (CTEs) for Beginners: Think in Steps, Not in Circles

on April 13, 2026

CTE Oracle Oracle SQL SQL

+

Get link
Facebook
X
Pinterest
Email
Other Apps

[SQL] Mastering COUNT(*) OVER() in Oracle SQL

on May 03, 2025

Data Aggregation Oracle SQL SQL SQL Functions SQL Queries SQL Query SQL Tips

+

Get link
Facebook
X
Pinterest
Email
Other Apps

[SQL] Encrypting and Decrypting Data Using Oracle's DBMS_CRYPTO Package

on April 28, 2025

Decryption Encryption Oracle SQL SQL SQL Functions SQL Queries

+

Get link
Facebook
X
Pinterest
Email
Other Apps

[EBS] Retrieve All Customer Site Use Codes in Oracle E-Business Suite (EBS)

on April 20, 2025

oracle ebs Oracle ERP Oracle SQL SQL SQL Queries SQL Query SQL Tips

+

Get link
Facebook
X
Pinterest
Email
Other Apps

All Categories

Account Hierarchy1 Accounting Flexfields1 AP Invoices1 API2 ASCII1 Autonomous Database1 BIP7 BIP Refresh Time1 BIP Report1 Business Unit1

Call Fusion BIP Report2 Change Password1 Code Combinations2 Compute Instance2 CTE1 Customer1 Data Aggregation2 Database5 Date Conversion1 DB Adapter2 Decryption1 Development1 EBS4 Encryption1 ESS Jobs3 Examine1 FBDI3 Fusion APIs1 Fusion BIP4 GIT2 GL3 GL Journals1 GL_DAILY_CONVERSION_TYPES1 GL_DAILY_RATES1 ICS1 Identity Domain1 Integrations1 Java1 Journal Import1 Keys1 Legal Entity1 LookupTypeLOV1 LOV1 LOVs1 MultiPartAPIs1 Networking1 NVL2 NVL in OIC2 OCI10 OCI Compute5 OCI Events Service1 OCI Free Tier2 OCI Notifification Service1 OCI Security2 OIC4 OIC Mapper2 Oracle22 Oracle ADF17 Oracle APEX1 Oracle Apps59 Oracle Apps R126 Oracle ATP1 Oracle BIP7 Oracle Cloud10 Oracle Cloud Free Tier1 Oracle cloud Infrastructure8 Oracle Cloud Security2 Oracle Cloud VM1 Oracle DB4 oracle ebs5 Oracle ERP3 Oracle ERP Adapter2 Oracle ERP Cloud7 Oracle financials2 Oracle Forms1 Oracle Fusion55 Oracle Fusion BIP3 Oracle Fusion ERP15 Oracle Fusion Financials16 Oracle Integration Cloud3 Oracle OAF17 Oracle OCI13 Oracle OIC22 Oracle SOA 12c10 Oracle SQL17 Oracle VBCS1 Oracle VBS2 Oracle Visual Builder Cloud Service1 Oracle Visual Builder Studio2 Oracle Workflow Notifications1 Others10 Payables Import1 Properties1 R121 Register BIP as ESS Job1 Reset Password1 Responsibility1 REST4 Security List1 Site Map1 SOAP2 SOAP API2 SOAP UI3 SQL16 SQL Functions3 SQL Queries14 SQL Query8 SQL Tips3 SSH1 TCA1 Value Sets1 VBCS1 Virtual Machine2 Virtual Machines1 XML1 XSLT1

Show more Show less

Gurpreet Singh - Oracle ACE.

Total Pageviews

Search This Blog

Popular Posts

[Fusion] How to Import Payables Invoices in Oracle Fusion Cloud?

Importing Payables invoices is a common requirement in every Oracle Fusion implementation — especially during data migration or when integrating with external systems like OIC, third-party ERPs, or legacy platforms. In this post, I’ll walk you through the complete process of importing Payables invoices , including key interface tables , required jobs , and troubleshooting tips . 🧩 Step 1: Load Data into Interface Tables Before importing, your invoice data must be inserted into the Payables Open Interface Tables : Table Name Purpose AP_INVOICES_INTERFACE Holds invoice header information such as Supplier, Invoice Number, Invoice Date, Amount, etc. AP_INVOICE_LINES_INTERFACE Holds invoice line-level details such as Item, Description, Amount, Distribution Account, Tax, etc. These ta...

Understanding .properties file for ERP Bulk Import Jobs in Oracle Integration Cloud (OIC)

In this post, we will understand how to import FBDI files using OIC and how to create .properties file for the process. To import FBDI file using OIC we need two files: FBDI zip file .properties file While working with ERP Adapter in OIC, we select the below option to Import FBDI in Oracle Fusion Cloud. Then we select the Bulk Import Process name Here we selected Import Journals process. Make a note of Import Job Name and...

[OIC] Purge Oracle Fusion Interface Data using OIC

This post will show how to Purge Oracle Fusion Interface Data using OIC. Scenario - Consider a scenario that you have created OIC Interface to Import Journals into Oracle Fusion ERP. Now, you want that once import is completed, interface tables should purge automatically. So, follow the below steps to implement this: Callback integration of type Application Driven will be created which will be accepting the callback once " Import Journals " job will be completed. We will be using Oracle ERP Cloud Adapter Connection as trigger point of the integration with below configuration. Add another Oracle ERP Cloud Adapter Connection, just to get interface ID of import job Also, get details for Purge job from Fusion by going to Setup and Maintenance -> Search -> Manage Enterprise Scheduler Job Definitions and Job Sets for Financial, Supply Chain Management, and Related Applications InterfaceLoaderPurge Purge Interface Tables /oracle/apps/ess/financials/commonMo...

[OIC] Trigger OIC REST Integration from Oracle Fusion BIP Report

In this post we will see how to trigger the OIC REST Integration from Oracle Fusion BIP Report. Prerequisites: Access to OIC Console to create integration. Make sure you have ServiceDeveloper or ServiceAdministrator access. OIC REST Integration which can be invoked by using Basic Authentication. Make sure you have one generic OIC user which can be used to setup OIC Connection in Oracle Fusion BIP. For this generic user we need to have username and password available and it should not be SSO user, i.e. it should be of type non-federated account. Access to Oracle Fusion BIP with Admin access to add new data sources, i.e. user must have BI Administrator Role Steps: Create an OIC REST Based Integration with Parameters and which returns XML type response. Create a Data Source for OIC Integration instance in which you need to put hostname of OIC Intance and generic user credentials Create an Oracle Fusion BIP Report with XML Feed type data set to trigger the integrat...

[EBS] SOLVED - Customer Not Visible in Oracle Apps R12

When working with Oracle E-Business Suite R12, especially in Receivables (AR) or Trading Community Architecture (TCA) , you might encounter a situation where you create a new customer , but it doesn't show up in the Customer Search screen . Several things could be causing this. Here's a checklist to help you troubleshoot: ✅ 1. Customer Status Ensure the customer account is active . ✅ 2. Customer Site and Site Use Ensure at least one customer site exists for the customer. Also ensure site use is defined – e.g., "Bill To", "Ship To". Without proper site and site use, the customer might not appear in downstream flows or searches. ✅ 3. Party vs Account Confusion Oracle uses Trading Community Architecture (TCA) , where a party (in HZ_PARTIES) may exist without a customer account (in HZ_CUST_ACCOUNTS). Verify that the customer has a customer account created (not just a party). Check HZ_CUST_ACCOUNTS table for the party ID. ✅ 4. Search...

Powered by Blogger

All rights reserved