Oracle Applications E-Learning Lab

No matter what the business is, there is always a common requirement to upload file data into a database table. In this article, we will learn how to upload a data file in Oracle APEX and verify how the data appears in the database table. First, create a table: CREATE TABLE xx_file_upload (     file_upload_id NUMBER         GENERATED BY DEFAULT ON NULL AS IDENTITY,     name           VARCHAR2(100),     dob            DATE,     designation    VARCHAR2(100),     location       VARCHAR2(100),     salary         NUMBER,     CONSTRAINT file_upload_id_pk PRIMARY KEY ( file_upload_id ) Next, create a data file with the sample data as shown below. Save the file with any name. I am naming it SampleFileUpload.csv . The next step is to create an application and go to the Shared Components secti...

 In Oracle APEX, Interactive Reports offer a powerful way to organize and display data. One often-overlooked enhancement is styling column groups and their corresponding columns to improve visual clarity and user experience. This blog guides you through how to color column group headers and their underlying columns using both CSS and JavaScript . Step 1: Assign a Static ID to the Interactive Report Open your APEX page in Page Designer . Select the Interactive Report region. Under the Advanced section, set the Static ID This ID helps us target the report with custom code. Step 2: Identify Column Groups You Want to Style Suppose you want to color these column groups: End Item Info Sales Info To identify them: 1.  Run the page and open the browser’s Developer Tools (Right-click > Inspect) 2. Locate the column group headers and note the attribute data-idx (e.g., data-idx="1" for End Item Info, data-idx="2" for Sales Info). To color only col...

Oracle APEX offers a wide array of powerful features, and one of the most intuitive among them is the Data Workshop. It allows users to load data directly into existing database tables—without writing a single line of code. With just a few clicks, users can upload a file, select the target table, and let APEX handle the rest seamlessly. In this article, I’ll demonstrate how to use Data Workshop to load an Excel file containing 30,000 records into an existing table. The entire process is simple and efficient, with an expected load time of under 2 minutes. Here is the navigation  Go to SQL WORKSHOP--> utilities--> Data Workshop Click on LOAD Data You can upload files into database table using different formats  CSV,XLSX,TXT,JSON,XML  Once you choose the file then next step is to either create table on the flag or choose existing table , i will choose existing table  Click on Existing Table Click on Load data , and import will begin  Once data loaded into th...

  This BLOG provides a step-by-step approach to creating a Purchase Order (PO) API in Oracle E-Business Suite (EBS). The API automates the conversion of approved purchase requisitions into purchase orders using PL/SQL procedures. /* Formatted on 3/26/2025 3:56:31 PM (QP5 v5.269.14213.34769) */ DECLARE    l_return_status         VARCHAR2 (1);    l_msg_count             NUMBER;    l_msg_data              VARCHAR2 (5000);    l_num_lines_processed   NUMBER;    l_document_number       po_headers_all.segment1%TYPE;    l_document_id           NUMBER;    l_msg                   VARCHAR2 (5000);    l_msg_index_out         NUMBER;    v_item_key   Varchar2(100); ...

  SELECT    fu.user_name, frtl.responsibility_name,  FFL.USER_FUNCTION_NAME,FF.FUNCTION_NAME,    CASE         WHEN frtl.responsibility_name LIKE '%KBNA%' THEN 'KBNA'          WHEN frtl.responsibility_name LIKE '%JATM%' THEN 'JATM'           WHEN frtl.responsibility_name LIKE '%JNA%' THEN 'JNA'           WHEN frtl.responsibility_name LIKE '%KCI%' THEN 'KCI'            WHEN frtl.responsibility_name LIKE '%JATX%' THEN 'JATX'              WHEN frtl.responsibility_name LIKE '%JASC%' THEN 'JASC'                 WHEN frtl.responsibility_name LIKE '%KBCA%' THEN 'KBCA'              WHEN frtl.responsibility_name LIKE '%JAMX%' THEN 'JAMX'                       WHEN frtl.responsi...

  Proxy Services: Proxy services are the entry point for client requests into the OSB. They receive messages, route them to the appropriate back-end service, and send responses back to the client. Business Services: Business services are the back-end services that are called by the proxy services. They may be web services, JMS queues or topics, FTP servers, email servers, or any other type of service that can be accessed through a transport protocol. Message Flow: The message flow is the path that messages follow through the OSB. It consists of stages, actions, and branches that define how messages are processed and routed. Service Bus Console: The Service Bus Console is the graphical user interface (GUI) that is used to configure, manage, and monitor OSB components. It provides a visual representation of the OSB and allows developers to create and modify proxy and business services, message flows, and other components. Operational Settings: The operational settings of OSB allow yo...