Home » Page 90

How to check if Port pool is free in Oracle applications R12

Oracle, Oracle Ebuisness Suite

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 »

Concurrent Request Phase and Status

Oracle, Oracle Ebuisness Suite

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 …

Concurrent Request Phase and Status Read More »

NVL2 function in Oracle

Oracle, Oracle Sql

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 …

NVL2 function in Oracle Read More »

Oracle dba interview questions and answers

Interviews questions, Oracle, Oracle Database

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 »

How to change Priority for Concurrent Program

Oracle, Oracle Ebuisness Suite

Many times in Oracle Apps env,user  complain there request get stuck or takes time to start processing. Majority of time Support team can’t do anything, unless waiting or asking Oracle DBA to check the server performance. There is couple of option you can try , if you know a demanding user and there request name( …

How to change Priority for Concurrent Program Read More »

Scroll to Top