Yearly Archives: 2023

How to preview multiple Blob contents while uploading using file browser in Oracle APEX

Overview This document explains about how to preview multiple blob contents while uploading using file browser element in Oracle Apex. Technologies and Tools Used The following technology has been used…

Read More

Download APEX Chart as IMAGE format using Java script

1. Overview This document will teach the details about how to Download APEX Chart as IMAGE format using java script in Oracle Apex. Question may rise why do we need to…

Read More

Query to get the tax type and tax accounts details.

SELECT hou.name Entity_name, tax_type_id, tax_type_code, tax_type_name, (SELECT concatenated_segments FROMapps.gl_code_combinations_kfv WHEREcode_combination_id=interim_recovery_ccid) interim_recovery_ccid, (SELECT concatenated_segments FROMapps.gl_code_combinations_kfv WHEREcode_combination_id=recovery_ccid) recovery_ccid, (SELECT concatenated_segments FROMapps.gl_code_combinations_kfv WHEREcode_combination_id=interim_liability_ccid) interim_liability_ccid, (SELECT concatenated_segments FROMapps.gl_code_combinations_kfv WHEREcode_combination_id=liability_ccid) liability_ccid FROM apps.jai_tax_types_v tv, apps.jai_tax_accounts…

Read More

Query to get ship to and Dist location mismatch invoices details.

select distinct hou.name,         a.org_id, a.invoice_id, a.invoice_num, a.invoice_date, a.attribute11 ship_to d.segment4 dist_loc, aps.vendor_name, apsa.vendor_site_code from apps.ap_invoices_all a, apps.ap_invoice_lines_all b, apps.ap_invoice_distributions_all c, apps.gl_code_combinations d, apps.hr_operating_units hou, apps.ap_suppliers aps,…

Read More

Appending Image to The Email using Email Template Feature in Oracle APEX

Overview This document talks about how to Customize your html tags to show your images inline in Email body using Email Template feature in Oracle Apex. Technologies and Tools Used…

Read More

AutoNumber Generation for Serial Column without Sequence in Interactive grid using JavaScript

Overview This document talks about how to Customize Interactive Grid with Auto Populate Column value without Database sequence using JavaScript.  Technologies and Tools Used The following technologies has been used…

Read More

Vendor Transaction Report

1.Overview This document talks about getting the vendor transaction detailed report in oracle apps r12 2.Technologies and Tools Used The following technologies have been used to achieve the expected output.…

Read More

Sales Margin by Item

1. Overview This document talks about getting the sales details of the item in oracle apps r12 2.Technologies and Tools Used The following technologies have been used to achieve the…

Read More

CUSTOM NAVIGATION FROM PAGE ITEM TO INTRECTIVE GRID COLUMN ON TAB PRESS

1. Overview This document will teach the details about how to Custom navigation from page item to Interactive grid specific column in Oracle Apex. Question may rise why do we…

Read More

How to Use Server-Side Conditions for Interactive Grid Buttons in Oracle Apex

Overview Server-Side condition is the condition will execute at the time of page initialization. We can set the server-side condition to the page, region, item, button…etc. Based on the server…

Read More