Introduction In an Oracle E-Business Suite (EBS) R12.2 environment, the DMZ web tier acts as the first line of defense between external users and internal application services. Because this tier…
Read MoreIn SQL Server environments, routine administrative operations such as database restores, data file growth, and the addition of new data files can become increasingly time-consuming as databases grow in size…
Read MorePrerequisites PostgreSQL 17 installed and running. • Java 11 or later installed. • Apache Kafka and Kafka Connect. • Debezium PostgreSQL connector JAR placed in Kafka Connect plugin path. • A PostgreSQL…
Read MoreConnect to MongoDB usingmongosh To begin working with MongoDB, open your terminal and connect using the MongoDB shell (mongosh): mongosh Create a Database MongoDB creates databases implicitly when you first…
Read MoreStep 1: Create XML Data Template <?xml version=”1.0″ encoding=”UTF-8″ ?> <dataTemplate name=”AP_INVOICE_DETAILS” description=”AP_INVOICE_DETAILS” version=”1.0″> <properties> <property name=”xml_tag_case” value=”upper”/> <property name=”Include_Parameters” value=”True”/> </properties> <parameters> <parameter name=”P_VENDOR_ID” dataType=”NUMBER”/> <parameter name=”P_INVOICE_NUM” dataType=”CHARACTER”/> <parameter…
Read MoreDynamic 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 MoreSELECT 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 MoreError 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 MoreNew 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 MoreReplication 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