Oracle Applications Reports (Reports 6i) – Technical – Interview – Question Answers

Posted by Jiltin     Tags: , , 4 April, 2009    3,941 views    (0) Comment

Question: How many types of columns are there and what are they? Formula columns: For doing mathematical calculations and returning one value Summary Columns: For doing summary calculations such as summations etc. Place holder Columns: These columns are useful for storing the value in a variable Question: Can u have more than one layout in report? Answer: It is possible to have more than one layout in a report by using the additional layout option in the layout editor. Yes it is possible to Read Full Article (Click here)...

Categories : Oracle AOL Tags : , ,

What is in Oracle Financials? – Enterprise Resource Planning – Simple Guide

Posted by Jiltin     Tags: , , , 4 April, 2009    3,380 views    (4) Comment

The financial applications of the Oracle ERP suite of applications are the General Ledger and the sub-ledgers. The financial applications discussed in this book include the following (the common shorthand abbreviation is shown in parentheses): General Ledger (GL) Accounts Payable (AP) Accounts Receivable (AR) Fixed Assets (FA) Projects (PA) In addition, the Inventory (INV), and Purchasing (PO) applications can make journal entries into the General Ledger, but Read Full Article (Click here)...

Categories : Oracle Applications Tags : , , ,

Setting the Applications Context FND_GLOBAL.APPS_INITIALIZE in oracle applications.

Posted by Jiltin     Tags: , , 17 February, 2009    4,830 views    (1) Comment

Use the API FND_GLOBAL.APPS_INITIALIZE to set the applications context in standalone sessions that were not initialized through normal means. Typically, you would use this API in external custom programs that are establishing their own connections. procedure APPS_INITIALIZE(user_id IN number,resp_id IN number,resp_appl_id IN number security_group_id IN number); USER_ID – The User ID number. RESP_ID – The ID number of the responsibility. RESP_APPL_ID – The ID number Read Full Article (Click here)...

Categories : Oracle Applications Tags : , ,

Oracle applications – List all the concurrent Jobs ran by user.

Posted by Jiltin     Tags: , , 9 January, 2009    938 views    (0) Comment

Here is the simple sql that gives you the all the concurrent Jobs ran by user. This is working code, verified in oracle 11i financial applications /***************** Author: Jay Substitute &user or pass as parameter ******************/ SELECT        fcr.REQUEST_ID,        FU.USER_NAME,        fcr.PHASE_CODE,        fcr.STATUS_CODE,        (fcr.ACTUAL_COMPLETION_DATE –   Read Full Article (Click here)...

Categories : 11i Scripts, Oracle Applications Tags : , ,

Pending normal jobs running (oracle 11i) in oracle applications

Posted by Jiltin     Tags: , , , , 10 November, 2008    1,039 views    (1) Comment

/* Description: This script will all the pending normal jobs running (oracle 11i) in oracle applications Backend query is always faster than front end query Author:      Jay Gopal / Jiltin Input:       none */ Download the Code SELECT fcr.REQUEST_ID, fu.user_name, fcr.PHASE_CODE, fcr.STATUS_CODE, (fcr.ACTUAL_COMPLETION_DATE –   fcr.ACTUAL_START_DATE) * 24 * 60 Read Full Article (Click here)...

Categories : 11i Scripts Tags : , , , ,