Python is a general purpose programming language. It is also a high level programming language, which allows a wide range of applications. Python is good for desktop GUI applications, websites, and other online applications. Python is very easy to learn. After a few lessons, beginners can write functional code. In fact, many experts recommend learning …
Python Tutor Help: Get Excellent Quality of Any Technical Task Read More »
What is Port Pool in Oracle Apps? Oracle Applications 11i/R12.0/R12.1/R12.2 uses the concept of a port pool. A port pool is a preconfigured set of unique port assignments for every E-Business Suite technology stack component that requires network connectivity. So multiple Release 12 environments can coexists on the same machine,provided you have configured each of …
How to check if Port pool is free in Oracle applications R12 Read More »
FND_CONCURRENT_REQUESTS table contains the Concurrent Request Phase and Status of each concurrent request. Here are the information about Concurrent Request Phase and Status Values and Meaning for Status code SELECT LOOKUP_CODE STATUS_CODE, MEANING FROM FND_LOOKUP_VALUES WHERE LOOKUP_TYPE = ‘CP_STATUS_CODE’ AND ENABLED_FLAG = ‘Y’ AND VIEW_APPLICATION_ID = 0 ORDER BY LOOKUP_CODE STATUS_CODE MEANING A Waiting B …
I have worked on Oracle Apps Version 11i, R12.0 , R12.1 and R12.2. Each of these has fixed location for log files.Apps DBA is supposed to know those location so that troubleshooting and monitoring can be done. I am giving here the logfile location for all these version which can be lot of help to …
This SQL tutorial provides explanations, examples for NVL2 function in Oracle NVL2 function is a nesting function .It examines the first impression, if the the first impression is not null ,then NVL2 function returns the second expression. if the first impression is null, then it return the third expression. expr1: it is the source values …
This article contains the most commonly asked top 80 oracle dba interview questions and answers oracle database administrator interview questions Question 1. What is oracle database ? Answer: Oracle Database is a relational database management system (RDBMS) which is used to store and retrieve the large amounts of data. Oracle Database had physical and logical structures. …
Oracle dba interview questions and answers Read More »
