Posts

Query to find list of custom forms, custom reports and custom form personalization

-
1. Query to get List of Custom Concurrent Programs SELECT   DISTINCT fcp.user_concurrent_program_name "Concurrent Program Name", fa.application_name, fcp.concurrent_program_name conc_short_name, decode( fef.execution_method_code, 'H','Host', 'I', 'PLSQL Stored Procedure', 'P', 'Report', 'L', 'SQL Loader', 'Q','SQL*Plus', 'A','Spawned', 'K','Java Concurrent Program', 'B','Request Set Stage Function', 'S','Immediate', 'J','Java Stored Procedure', 'M','Multi-Language Function', fef.execution_method_code) "execution method", fef.executable_name, fcp.description "Concurrent Program Description", fef.executable_name"Executable Name", fef.description "Executable Description", fef.execution_file_name , fcp.enabled_flag ,FCP.CREATION_DATE     FROM ...
3 comments
Read more

Finding Nth Highest Salary of an Employee

-
-- Find nth highest salary of an employee 1)  Using Corelated Subquery select * from Emp e1 where 1= (select count(distinct(e2.sal)) from Emp e2 where e2.sal>e1.sal); 2)  Using Rownum select * from (select e.*, row_number() over(order by sal desc) rownumb from Emp e where sal is not null) where rownumb=3; 3) Using Rank select * from (select e.*, rank() over(order by sal desc) ranking from Emp e where sal is not null) where ranking =2;
28 comments
Read more

Oracle ADF Beginner Links

-
Simple Tutorials On Oracle ADF Beginners Peoples(Oracle ADF beginners) who are all passing this street,  here is one way to start with simple start tutorials.  Oracle JDeveloper and Oracle ADF 11g Tutorials Build Rich Client Forms with ADF Swing and ADF Business Components Oracle   JDeveloper   11g   Release   2(11.1.2) Tutorials Oracle   ADF   11g    DeskTop   Integration  
39 comments
Read more

Oracle Purchasing Module Step by Step in R12

-
Image
PURCHASING  All the Purchasing related activity information will be declared in Purchasing              Procure 2 Pay Cycle : Requisition à RFQ à Quotation à Quotation Analysis à Purchasing à Receiving à Invoice  à  Payment à Reconciliation PO-Integration :  PO  is integrated by GL, AP, I Supplier, Procurement, and Project Accounting  PO  Responsibility             Step1: Define  PO  Responsibility                         Nav: System administrator à Security à Responsibility à Define             Step2: Assign  PO  options to the PO Responsibility                 ...
122 comments
Read more