Uncategorized

Dynamic Printable PDF Document in Oracle APEX

Dynamic Printable PDF Document in Oracle APEX Introduction In this document, we demonstrate how to create a dynamic printable document in Oracle APEX using a Dynamic Content Region.The content is…

Read More

Query to get vendor master with missing GST Numbers report in fusion.

SELECT Qry_rslt.”Supplier Name”       ,Qry_rslt.”Supplier Number”   ,Qry_rslt.”Supplier Site Name”   ,Qry_rslt.”Supplier Status”   ,Qry_rslt.”Inactive Date”   ,Qry_rslt.”Procurement Business Unit”   ,Qry_rslt.”Currency”   ,Qry_rslt.”Total Amount”   ,Qry_rslt.”No Data…

Read More

Resolving PRCR-1079 / CRS-5076 Due to DB_UNIQUE_NAME Mismatch in Oracle RAC 

Error  While starting an Oracle RAC database using srvctl, the startup failed with:  PRCR-1079: Failed to start resource ora.RACDB.db  CRS-5076: Startup of database resource ‘ora.RACDB.db’ is failing because  DB_UNIQUE_NAME ‘RAC_DB’ is not expected  Description …

Read More

New Development Report Using XML Data Template

New Development Report Using XML Data Template  Introduction XML Publisher (BI Publisher) provides multiple ways to generate reports in Oracle E-Business Suite. One important and commonly used approach is creating…

Read More

Replication snapshot agent permission issue and Troubleshooting

Replication snapshot agent permission issue and Troubleshooting   1. What is the replication for the SQL server?  SQL Server replication is one of the HADR technologies that copy and distribute the data…

Read More

SQL servers’ registration in SSMS

SQL servers’ registration in SSMS   What is server registration in SSMS?  It is one of the features in SQL Server Management Studio (SSMS) which is very  useful to have a list of registered servers…

Read More

AJAX-Dynamic Tooltips & Cascading LOVs in Oracle APEX

AJAX-Dynamic Tooltips & Cascading LOVs in Oracle APEX Introduction:  In Oracle APEX applications, cascading List of Values (LOVs) are commonly used to filter data based on user selections. However, users…

Read More

Build and Consume Secure REST APIs in Oracle APEX using ORDS and OAuth2

Introduction:  In the current enterprise technology landscape, applications are increasingly required to integrate and exchange information across diverse systems in a secure and reliable manner. Oracle APEX, in conjunction with…

Read More

Complete WIP Job via External Application (APEX Integration)

Introduction/ Issue:  Completing a WIP job in EBS usually involves multiple manual steps. Integrating with external systems like APEX requires an automated and reliable method to complete jobs programmatically. A…

Read More

Enhancing Oracle APEX Pie Charts with Custom Colors and 3D Effects

INTRODUCTION: In Oracle APEX 19.2, Pie charts are widely used to visualize proportional data. However, the default 2D Pie chart sometimes lacks visual depth, especially when displaying many categories. Business…

Read More