Techgoeasy

How FNDFS (Oracle Report Review agent) works in EBS environment

What is FNDFS Explaining how FNDFS working (1) The user selects ‘Request Output’, ‘Request Log’, or ‘Manager Log’ (2) The file name and node name are selected from the database.Reports: SELECT outfile_name, outfile_node_name FROM fnd_concurrent_requests WHERE request_id = :id; Logfiles: SELECT logfile_name, logfile_node_name FROM fnd_concurrent_requests WHERE request_id = :id; Manager logs: SELECT logfile_name, node_name FROM fnd_concurrent_processes …

How FNDFS (Oracle Report Review agent) works in EBS environment Read More »

Oracle External tables

Oracle, Oracle Sql

External table is one of the important feature in oracle , we will exploring external table in oracle with example in this post What are EXTERNAL TABLES in Oracle? 1)External tables are read-only tables where the data is stored in flat files outside the database 2) You can use the external table feature to access external …

Oracle External tables Read More »

EBS Data Model Comparison Report

Oracle, Oracle Ebuisness Suite

Oracle provides the EBS data model comparison report to view the static database object definition changes between two EBS releases Applicable Releases Benefits of EBS Data Model Comparison Report We can view the Per product database object comparison between two releases for thefollowing object types -Regular tables, Partitioned tables, Index organized tables, Global temporary tables, Queued …

EBS Data Model Comparison Report Read More »

Downtime and Hotpatch apply mode in adop R12.2

Oracle, Oracle Ebuisness Suite

Downtime Mode adop R12.2 To run adop in downtime mode, you use the following command line options. In this example, patch 1111111 is applied in downtime mode: $ adop phase=apply patches=1111111 apply_mode=downtime It does not require the prepare phase The important point in downtime mode (1) Release 12.2 patches are not normally tested in downtime …

Downtime and Hotpatch apply mode in adop R12.2 Read More »

Oracle Database Interactive Quick Reference Guide | 11g ,12c, 19c & 23c

Oracle, Oracle Database

The Oracle Database Interactive Quick Reference is a multimedia tool for various terms and concepts used in the Oracle Database. Built as a multimedia web page, this diagram provides descriptions of database architectural components and references to relevant documentation. This is a beneficial reference and cheat sheet for writing custom data dictionary scripts, locating Oracle …

Oracle Database Interactive Quick Reference Guide | 11g ,12c, 19c & 23c Read More »

Step by Step R12.2.12 EBS installation on Virtual Box Part -2

Oracle, Oracle Ebuisness Suite

We have already installed VirtualBox and downloaded the VM appliance in the last post Now let’s continue with the installation of the 12.2.12 VM template in the Virtual box 1) Check if the Hardware Virtualization is enabled on the Desktop of the Laptop where you have installed the Virtualbox 2) Now Open the Virtual box …

Step by Step R12.2.12 EBS installation on Virtual Box Part -2 Read More »