Sunil Dutt's Oracle Apps Technical World

Oracle Apps WIP KEY Tables

2009-03-02T08:39:00.000-08:00

Oracle Apps WIP KEY Tables WIP_LINES WIP_LINES stores production line information. Each row includes a line name, maximum and minimum rate information, throughput for rate based lines (lead time), and the start and stop time information that determines the amount of time per day that the line is available. Oracle Work in Process uses this information when you associate a line with a repetitive

Database Security And Admin FAQ's

2009-02-22T04:56:00.000-08:00

97. What is user Account in Oracle database?A user account is not a physical structure in database but it is having important relationship to the objects in the database and will be having certain privileges.98. How will you enforce security using stored procedures?Don't grant user access directly to tables within the application.Instead grant the ability to access the procedures that access the

DBA,Memory Mgmt,DB Logical & Physical Architecture

2009-02-22T04:48:00.000-08:00

Data Base Administration51. What is a database instance? Explain. A database instance (Server) is a set of memory structure and background processes that access a set of database files. The processes can be shared by all of the users.The memory structure that is used to store the most queried data from database. This helps up to improve database performance by decreasing the amount of I/O

Database Structures FAQ's

2009-02-22T04:42:00.000-08:00

1. What are the components of physical database structure of Oracle database?Oracle database is comprised of three types of files. One or more datafiles, two are more redo log files, and one or more control files.2. What are the components of logical database structure of Oracle database?There are tablespaces and database's schema objects.3. What is a tablespace?A database is divided into Logical

Project Accounting

2009-01-03T11:00:00.001-08:00

Project AccountingCostingItems not costedThe output of the labor cost distribution cost distribution shows the error as Missing Cost Rate. This happens for Sub-Contractors when they do not have a Cost Rate setup. For employees the costing is based on the Job Grade but for Sub-contractors the costing is based on the Cost Rate setup. All Sub-contractors should have a Cost Rate set up.Labor Cost

ITime

2009-01-03T10:56:00.000-08:00

ITimeTimecard Issues Timecard Status shows SUBMITTED and not APPROVEDThis issue happens in two cases –An Oracle Bug in iTime Workflow that makes the Timecards to be stuck in the Approval process. A TAR has been raised with Oracle and resolution expected from them.The Timecard is Submitted by the Secretary / Personal Assistant on behalf of the Sub-Contractor. In this case the Approval process gets

FIXED ASSETS

2009-01-03T10:44:00.000-08:00

FIXED ASSETS1. What is unplanned depreciation? Answer: Unplanned depreciation is a feature used primarily to comply with special depreciation accounting rules in Germany and the Netherlands. However, you also can use this feature to handle unusual accounting situations in which you need to adjust the net book value and accumulated depreciation amounts for an asset without affecting

Random Questions From Apps

2009-01-03T10:33:00.000-08:00

1. What is overlay in payablesAns: Over lay is used in payable open interface where we would like to pass and overwrite certain value which is set to appear by default when data is inserted into the production tables. 2. What is rollup groupAns: rollup group we define and attached with the parent segment in the accounting flexfield for summary total for which summary template is defined. This

Happy New Year 2009 to One and All

2009-01-03T10:23:00.001-08:00

Dear All, Wishing you a Very Very Happy New Year 2009 and may all your wishes come true in this year,lets kick the sad moments of 2008 as well as memorise the beautiful moments of 2008 and welcome to 2009 year.RegardsSunil Dutt.BSorry for the belated wishes

Template Form in Oracle Apps 11i

2009-01-03T10:05:00.000-08:00

Template Form in Oracle Apps 11iThis is an overview of the template form.This form derives its importance from the fact that this form is the starting point of all development involving forms. The document highlights the importance of Template.fmb in forms development and also provides a detailed explanation of the various components of the Template form. Overview of the Template FormThe

Entire Developer 2000

2009-01-03T09:53:00.000-08:00

1. Types of Triggers in FormsBlock-processing triggers: - Block processing triggers fire in response to events related to record management in a block. E.g. When-Create-Record, When-Clear-Block, When-Database-Record, When-Remove-RecordInterface event triggers: - Interface event triggers fire in response to events that occur in the form interface. Some of these triggers, such as

XML Publisher report

2009-01-03T09:45:00.000-08:00

XML Publisher report1)Develop the Report(.rdf) Only DataModel2)Save the report and Compoile and Generate the data in .xml Format File=>Generate to File => XML3)Open the Ms-WOrd document Design the Layout include the follwing Tool Bar options called Form and Templete builder4)Define the Table and Specify the Titles and Labels whatever we would like to print5)Include 'Text Form Field' Double CLick

Oracle Manufacturing Inventory

2009-01-03T09:16:00.000-08:00

Oracle Manufacturing InventoryContents MANUFACTURING CONCEPTS Flow of any manufacturing companManufacturing StrategiesMake-to-stockMake-to-orderAssemble-to-order Engineer-to-orderMaterials Management ActivitiesModulesRelation with major modulesInventory Functions of inventoryInventory Flexfields Account AliasesItem catalogsItem categoriesSales orderStock locators System items (item flexfieldITEM

AUTOLOCKBOX FAQ's

2009-01-02T10:27:00.000-08:00

AUTOLOCKBOX FAQ's1. How do you bring in the Receipt Information Descriptive Flexfield through AutoLockbox?As long as you modify the control file to populate the ATTRIBUTE_CATEGORYcolumn of the AR_PAYMENTS_INTERFACE_ALL table the Lockbox process willpopulate the AR_INTERIM_CASH_RECEIPTS_ALL table and Post Quick Cash willpopulate the AR_CASH_RECEIPTS_ALL table with the

HRMS reports

2009-01-02T10:14:00.000-08:00

HRMS reports

FORMS GENERATION

2009-01-02T10:04:00.000-08:00

FORMS GENERATIONgoal: How to Regenerate a Form, Library or Menufact: Oracle Formsfact: Oracle Application Object Libraryfix:Oracle Forms executable used to generate forms depends of platform andOracle Applications versions :Unix Windows 95 Windows NT10.7SC N/A f45gen.exe f45gen32.exe10.7NCA f45gen N/A f45gen32.exe11.0.x f45gen N/A f45gen32.exe 11.5.x f60gen N/A f60gen.exeCommande line is :module=

Business Group and Organization

2009-01-02T09:59:00.001-08:00

Business Group and Organization

ORACLE HRMS FAQ's

2009-01-02T09:52:00.000-08:00

ORACLE HRMS FAQ'sWhat are the minimum classifications to create a Business Group?(i) Business Group(ii) GRE/Legal Entity(iii) HR OrganizationWhat are the Pre-Requisites for creating a Business Group?(i) Value Sets(ii) Key Flexfields(iii) LocationWhat is the use of HR Organization?If we want to assign the employee

Useful Oracle Queries

2008-12-27T09:56:00.000-08:00

1) Display the name of employees along with their annual salary (sal*12) the name of the employee earning highest annual salary should appear first?Select ename, sal, sal*12 "Annual Salary" from EMP order by "Annual Salary" desc;2) Display name, salary, Hra, pf, da, TotalSalary for each employee. The out put should be in the order of total salary, hra 15% of salary, DA 10% of salary .pf 5% salary

RECORD BUILTINS

2008-11-18T05:42:00.000-08:00

CLEAR_RECORDDescriptionCreates a new record in the current block after the current record. Form Builder then navigates to the new record.Example clear_record;CREATE RECORDDescriptionCreates a new record in the current block after the current record. Form Builder then navigates to the new record.Example create_record;DELETE RECORDDescriptionWhen used outside an On-Delete trigger, removes the

OM Cycles

2008-11-18T05:39:00.000-08:00

OM Cycles

SQL Interview Questions

2008-09-14T01:29:00.000-07:00

1. The most important DDL statements in SQL are:CREATE TABLE - creates a new database tableALTER TABLE - alters (changes) a database tableDROP TABLE - deletes a database tableTRUNCATE - cleans all dataRENAME- renames a table name2. Operators used in SELECT statements.= Equal<> or != Not equal> Greater than<>= Greater than or equal<= Less than or equal BETWEEN Between an inclusive range LIKE

Customer Interface Diagram

2008-09-11T03:24:00.000-07:00

Customer Interface Diagram

Master Detail Forms

2008-09-11T03:13:00.000-07:00

1) Create Two Tables (With Parent / Child relationships)a) Create table orders(order_no number(10),custoner varchar2(20),order_date date)/ b) Create table lines( line_no number(10), order_no number(10), item varchar2(20), qty number(10), price number(10), amount number(10)) /2) Alter the table structures and primary and foreign keys Alter table orders

CUSTOM FORM DEVELOPMENT

2008-09-11T03:03:00.000-07:00

On the CLIENT machine create a FOLDER as say: c:\custom_sunilIn custom_sunil folder creates 2 folders forms, resourceCopy TEMPLATE.fmb, APPSTAND.fmb, .pll files to CLIENT• Copy TEMPLATE.fmb , APPSTAND.fmb from AU_TOP/forms/US to c:\custom_sunil\ forms directory copy all .pll files from /Applvis/visappl/au/11.5.0/resource to c:\custom_sunil\resource using ftp• On windows go to command prompt• Cd c

TRIGGERS

2008-09-10T09:35:00.001-07:00

TRIGGERSIT IS A PL/SQL BLOCK OR PL/SQL PROCEDURE ASOCITED WITH A TABLE,VIEW,SCHEMA OR DATABASE EXECUTED AUTOMATICALLY RATHER IN TECHNICAL TERMS IMPLICITLY FIRED AUTOMATICALLY WHENEVER A SPECIFIC EVENT OCCURS UPON THE OBJECT ASSOCIAYED WITH.TYPES OF TRIGGERSTHERE ARE TWO TYPES OF TRIGGERS.APPLICATION TRIGGER:-FIRED WHENEVER AN EVENT //CAN BE CONSIDERED AS A DML OPERATION// OCCURS UPON A PARTICULAR

All modules Interface Tables

2008-09-10T08:55:00.000-07:00

GL INTERFACE TABLESTNAME TABTYPE ------------------------------ ------- ----------------------GL_BUDGET_INTERFACE TABLEGL_DAILY_RATES_INTERFACE TABLEGL_IEA_INTERFACE TABLEGL_INTERFACE TABLEGL_INTERFACE_CONTROL TABLEGL_INTERFACE_HISTORY TABLEAP

GL interface Diagram

2008-09-09T05:59:00.001-07:00

Trigger Solutions

2008-09-09T01:45:00.000-07:00

Problems (For DML Triggers): Q.1 Keep the backup of department data for DELETE and UPDATE.Ans: CREATE OR REPLACE TRIGGER dept_backup_trg AFTER DELETE OR UPDATE ON dept FOR EACH ROW BEGIN INSERT INTO dept_backup (deptno, dname, loc) VALUES (:OLD.deptno, :OLD.dname, :OLD.loc); END; Q.2 Secure emp table from SCOTT user for DELETE or UPDATE of manager and salesman records.Ans: CREATE OR REPLACE

Entire - Oracle

2008-09-09T01:44:00.000-07:00

Good zip file of Entire Oracle worth reading this have a look friendshttp://www.esnips.com/doc/d327c757-49b3-47f7-bf7d-36d6a854c497/Entire-Oracle

Oracle Apps Technical Interview

2008-09-09T01:20:00.000-07:00

1. Using PL/SQL, which exception is raised when a division by zero is attempted?Ans ) zero divide error occurs2. Which constraint type ensures that each row in a table contains an entry that uniquely identifies that row from any other. Ans ) primary key3. Views can be defined with up to (?) columns. Ans ) 2544. During database creation, which of the

SQL*Loader Examples

2008-09-08T05:43:00.000-07:00

What is SQL*Loader and what is it used for?SQL*Loader is a bulk loader utility used for moving data from external files into the Oracle database. Its syntax is similar to that of the DB2 Load utility, but comes with more options. SQL*Loader supports various load formats, selective loading, and multi-table loads. How does one use the SQL*Loader utility?One can load data into an Oracle database by

NEW APPLICATION DEVELOPMENT PROCESS

2008-09-08T05:28:00.000-07:00

NEW APPLICATION DEVELOPMENT PROCESS Designing the new payroll module, which is not a part of Oracle Applications.Process of new application development:1) Register the new module or new application – One record will be inserted in to the table FND_APPLICATION table. Owner of this table is Applsys.DATABASE DESIGN2) Create Oracle Data base user account and grant privileges Connect and Resource.3)

List of Useful Unix Commands

2008-09-08T05:26:00.001-07:00

List of useful unix commands

Oracle Applications Introduction

2008-09-08T05:16:00.000-07:00

To connect the Oracle applications address is:http://computername.dnssuffix name:portnumber/dev60cgi/ifcgi60http://computername:oa_html/us/texindex.htmlUser name is: OPERATIONSPassword is: WELCOMEResponsibility is: System Administration ResponsibilityWhen you click internet explorer and gives the above address then the system will be doing the following activities before getting the log on form:1

Oracle Forms document

2008-09-08T05:12:00.000-07:00

Oracle Forms dochttp://www.esnips.com/doc/4d7e7e3e-8270-42bf-bdba-5ab5aacb1a5c/Sunil-Forms-61

Oracle Financials and HRMS

2008-09-08T05:00:00.000-07:00

These docs consists of setups likecurrency,calendar,chart of accounts and journals like simple journal,tax journal,recurring journals,foreign currency journal,mass allocation journal etc.......and also the HRMS doc consists of setups of Core HR,Pay roll and SSHRhttp://www.esnips.com/doc/64ba8c32-4d1a-473d-993a-661109df6187/Sunildatt---HRMS.docx http://www.esnips.com/doc/2d89d4a5-f8d0-4d7c-bcb7-

Overview of Work in Process

2008-09-07T22:57:00.000-07:00

Overview of Work in ProcessOracle Work in Process is a complete production management system. Work in Process is part of Oracle Applications, an integrated suite of business solutions. Work in Process supports discrete, project, repetitive, assemble-to-order, work order-less, lot based jobs, or a combination of manufacturing methods. Inquiries and reports give you a complete picture of

VARRAY and NESTED TABLES

2008-09-07T22:34:00.000-07:00

Nested TableSo, what is the difference between an Associative Table and Nested Table? A nested table looks a lot like an associative table. The main difference in the declaration is the missing INDEX BY keywords.If we go back to our first example in part 1, we can modify it easily to use a nested table instead:DECLARE TYPE a_char_data IS TABLE OF VARCHAR2(10); v_char_data a_char_data :=

Oracle Forms Code Searcher

2008-09-07T22:29:00.000-07:00

Fmbgrep - Oracle Forms Code SearcherDescription: Fmbgrep is a GUI searching tool, that allows to search for Oracle Forms Developer files on your computer or local network.The main features are:· Supports 6i and 9i fmb file versions.· Supports perl5-style regular expressions.· Stores most recent used paths and patterns.· Allows a recursive directory search.·

FND TABLES

2008-09-06T06:17:00.000-07:00

FND_CONCURRENT_QUEUES FND_CONCURRENT_PROGRAMS FND_CONCURRENT_REQUESTS FND_CONCURRENT_PROCESSES FND_CONCURRENT_QUEUE_SIZEFND_APPL_TOPS FND_LOGINS FND_USER FND_USER_RESP_GROUPSFND_EXECUTABLESFND_LOOKUPSFND_DM_NODES FND_TNS_ALIASES FND_NODES FND_RESPONSIBILITY FND_DATABASES FND_UNSUCCESSFUL_LOGINS FND_LANGUAGES FND_APPLICATIONFND_PROFILE_OPTION_VALUES

Oracle AIM Document Templates

2008-09-02T10:44:00.001-07:00

1. Business Process Architecture (BP)BP.010 Define Business and Process StrategyBP.020 Catalog and Analyze Potential ChangesBP.030 Determine Data Gathering RequirementsBP.040 Develop Current Process ModelBP.050 Review Leading PracticesBP.060 Develop High-Level Process VisionBP.070 Develop High-Level Process DesignBP.080 Develop Future Process ModelBP.090 Document Business Procedure2. Business

KFFs in Oracle Apps

2008-09-02T09:26:00.001-07:00

Types of Purchase Orders ( PO types )

2008-09-02T09:06:00.000-07:00

Standard Purchase Order:A standard purchase order is a type of purchase agreement with the supplier committing to buy its items or services if all the details like terms and conditions,items,price,delivery dates are, the first priority of choosing a purchase ordr is given to standard purchase orderPlanned Purchase Order: A planned purchase order is a long-term agreement committing to buy it items

Procure To Pay base tables

2008-09-02T06:25:00.000-07:00

Requisitionpo_requisition_headers_allpo_requisition_lines_all ( segment1 ========== requisition number)po_req_distributions_allNote: requisition_header_id is the link between po_requisition_headers_all and po_requisition_lines_allrequisition_line_id is the link between po_requisition_lines_all and po_req_distributions_allPurchase

Procure To Pay Life Cycle

2008-09-02T06:01:00.000-07:00

Here are the detailed steps of what happens in Procure To Pay Life Cycle1) Create purchase requisition for the purchased items enter each item one by oneorganization,location,subinventory,supplier,supplier siteclick on distributions button ( show charge account) -----in the requisitions formclose form go to main form and click on approve2) Go to requisition summary form and enter requisition

Oracle XML Publisher

2008-09-01T21:05:00.000-07:00

why we are going for xml publisher insted we are having oracle reports beacause of these advantages1) reduce complexity2) reduced cost3) development productivity4) rich formatted reportsnormally we go for layout in reports 6i but now we go for xml publisher and remaining is the same proceduresteps to develop a xml publisher report and register it as a concurrent program1) develop the report as .

Oracle Interview Questions and Answers

2008-08-28T22:27:00.000-07:00

Oracle Interview Questions and Answers1. To see current user nameSql> show user;2. Change SQL prompt nameSQL> set sqlprompt “Manimara > “Manimara >Manimara >3. Switch to DOS promptSQL> host4. How do I eliminate the duplicate rows ?SQL> delete from table_name where rowid not in (select max(rowid) from table group byduplicate_values_field_name);orSQL> delete duplicate_values_field_name dv from

SQL*Loader

2008-08-27T22:01:00.000-07:00

SQL*Loader is a tool that is used to load data into a database, it is very powerful and has the followingcapabilities · use it to transform data before it's loaded into the database· load data from multiple sources i.e. disk, tape and named pipes· load data across a network· selectively load from the input file based on conditions· load part or all of a table·

AP Invoice Interface

2008-08-27T21:14:00.000-07:00

Excel Sheet -> Data file -> SQL Loader (Control file) -> Staging Tables -> Run Validation program -> Interface Tables -> Run the Payables Open Invoice Import Program -> Base TablesStaging tables: Create a custom staging table XX_AP_INVOICES_INTERFACE, XX_AP_INVOICE_LINES_INTERFACE which should be same as seeded interface table AP_INVOICES_INTERFACE and AP_INVOICE_LINES_INTERFACE.Interface Tables:

How to submit a concurrent program from command / shell prompt

2008-08-27T20:49:00.000-07:00

We can submit concurrent programs from OS command / shell prompt using CONCSUB utility. Heres the full length syntax: We can submit concurrent programs from OS command / shell prompt using CONCSUB utility. Heres the full length syntax: Examples:Active UsersCONCSUB apps/[apps_pwd] SYSADMIN “System Administrator” SYSADMIN WAIT=N CONCURRENT FND FNDSCURSPrints Environment VariablesCONCSUB apps/[

Oracle Apps E-books

2008-08-12T07:40:00.000-07:00

Easy to Learn Oracle Apps Tutorials ==================================== http://www.exforsys.com/content/category/17/260/342/ Oracle Apps Student Guides ========================== http://www.megaupload.com/?d=YTD92KVF http://files.filefront.com/11i+Student+Guidesrar/;5289744;;/fileinfo.html Oracle Student Guides ============================ http://www.megaupload.com/?d=WPXTBMMVOracle Financials

Data Load Tutorial Introduction

2008-08-09T07:21:00.000-07:00

Data Load Tutorial Introduction:Dataload is an utlity where you can load data into different Form Based systems especially Oracle APPS. This simple utility works by recording keystrokes, that are necessary for loading data from frontend. Software be downloaded free fromhttp://www.dataload.net/downloads/download.php Advantages: 1. Easy to learn and use 2. Can save time for repetitive processes 3.

DB Procedure to check if file exists

2008-08-09T07:18:00.001-07:00

DB Procedure to check if file existsThis script is required when you want to check a file if it physically exists on the server or not. Use to two out parameters when you register this procedure a concurrent program otherwise comment them out. This procedure uses concept of exception handling to return the value when you try to open the file.When you register it as a concurrent program pass two

FNDLOAD

2008-08-09T07:15:00.000-07:00

FNDLOADThe Generic Loader (FNDLOAD) is a concurrent program that can transfer Oracle Application entity data between database and text file. The loader reads a configuration file to determine which entity to access. In simple words FNDLOAD is used to transfer entity data from one instance/database to other. for example if you want to move a concurrent program/menu/valuesets developed in

Develop and Register new form

2008-08-09T07:14:00.000-07:00

1. Take the template(template.fmb) form serverGenerally, Template will be available in AU_TOP Ex:/m100/app/applmgr/110/kup8989/au/11.0.28/forms/US/ template.fmb 2. Open with form 4.5 or 6i3. Remove the window, which is having name as "block_name"; Create a new window with the name what u wants like "window_what_u_want" We may

ORACLE 9I COMMANDS

2008-08-07T07:36:00.000-07:00

ORACLE 9I COMMANDS To create tableCreate table (value1 datatype,……);To insert to tableInsert into values(data1,……);To view the all the data tableSelect * from ;To view some columnSelect from ;To update data in the tableUpdate set =data to update where =data to find;To delete from tableDelete from where =data to find;To drop the table;Drop table ;To set primary keyWhen you create the

Detailed Reports Information of some reports

2008-08-06T09:15:00.000-07:00

UNBOOKED ORDERS REPORT The unbooked Orders Report reviews orders you have entered but not booked.Thes report shows you the order number order date ordered item and line amount for each unbooked order line you choose as well as the user who entered the order.Submission:in the Order Management Reports window select Unbooked Orders Report is theName field.Parameters:When you

Multi Org Implementation Setups

2008-08-02T11:08:00.000-07:00

1.Login as sysadmin responsibility2.Ddefine required responsibilities Navigation:security->responsibility->define3.Define user and assign responsibilities to the user. N:Security->user->define.4.Login as GL Responsibility5.Define accounting flexfield N:setup->financials->flexfield->key->segments6.Give values for your segments N:setup->financials->flexfield->key->values.7.Define Currency N:setup->

Multiorg Concept

2008-08-02T11:02:00.000-07:00

Multi-Org is a server-side (applications and database) enhancement that enables multiple business units in an enterprise to use a single installation of Oracle Applications products while keeping transaction data separate and secure. The Multi-Org enhancement uses native database views to build a security layer on top of a single installation of Oracle Applications. In Oracle Applications Release

WHEN TRIGGERS

2008-08-01T04:10:00.000-07:00

WHEN TRIGGERSWhen-Button-PressedDescriptionFires when an operator selects a button, by clicking with a mouse, or using the keyboard.Definition Level form, block, or itemWhen-List-ChangedDescriptionFires when an end user selects a different element in a list item or de-selects the currently selected element. In addition, if aWhen-List-Changed trigger is attached to a combo box style list item, it

Concurrent Program Submission Through Backend

2008-08-01T04:02:00.000-07:00

declarel_request_id number(9) ;beginl_request_id := Fnd_Request.submit_request( 'PO', -Concurrent Prog Application Name 'SQL-USERS', -Conccurrent Prog Short Name'Users Data', -Concurrent Prog description '',-start time '',-sub request 1000,-first parameter value 2000,-second parameter value 'CREATION_DATE');-third parameter valueCommit;if l_request_id = 0 then fnd_file.put_line(fnd_file.log,'

KFF List

2008-08-01T03:59:00.000-07:00

Multiorg Tables

2008-08-01T03:57:00.001-07:00

Oracle Apps Tables

2008-08-01T03:51:00.000-07:00

All about Forms 6i

2008-08-01T03:44:00.000-07:00

System Variables SYSTEM.DATE_THRESHOLD : Represents the database date requery threshold.Default : 01:00 (Synchronization occurs after one minute of elapsed time.) This does not mean that Form Builder polls the RDBMS once every minute. It means that whenever Form Builder needs to generate the value for the system variables $$DBDATE$$, $$DBDATETIME$$, $$DBTIME$$, or SYSTEM.EFFECTIVE_DATE, it

All about Reports 6i

2008-08-01T03:38:00.000-07:00

About User ExitsA user exit is a program that you write and then link into the Report Builder executable or user exit DLL files. You build user exits when you want to pass control from Report Builder to a program you have written, which performs some function, and then returns control to Report Builder.You can write the following types of user exits: ORACLE Pre-compiler user exitsOCI (ORACLE

Oracle Apps 11i Interview Questionnaire

2008-08-01T03:32:00.000-07:00

1. Why do we call FND SRWINIT from Before Report TriggerA. FND SRWINIT fetches concurrent request information and sets up the profile options. It must be included if one is using any ORACLE APPLICATION OBJECT LIBRARY features in his report (such as concurrent processing)2. Why do we call FND SRWEXIT from After Report TriggerA. FND SRWEXIT frees all the memory allocations done in

Oracle Apps Question / Answer

2008-08-01T03:23:00.000-07:00

1.Q. Different Type of Value Sets. What is exactly Translatable independent and Translatable Dependent Value Sets (Introduced in latest version of 11i).Ans:- There are 8 types of Values Sets.a. None (Non Validate at all) (Validation is Minimal)b. Independent (Input must exist on previous defined list of values)c. Dependent (Input is checked against a subset of values based on

Oracle Discoverer

2008-08-01T03:16:00.000-07:00

Oracle Discoverer introductionhttp://www.uploadbigfiles.net/download.php?file=170008 Oracle Discoverer 3-1 Introduction.dochttp://www.uploadbigfiles.net/download.php?file=316009 Oracle Discoverer Plus - Introduction.doc

HZ Architecture

2008-07-30T10:28:00.001-07:00

AIM Methodology

2008-07-30T10:20:00.000-07:00

Enhance your project documentation process with Oracle Applications Implementation Methodology (AIM)IntroductionHaving supported many software implementations including those of ERP systems I have found that project documentation is one area which requires significant improvement. Often just finding the project documentation is difficult enough and once this frustrating process is completed you

GL_INTERFACE_ERRORS

2008-07-30T10:12:00.001-07:00

Period Error CodesEP01 This date is not in any open or future enterable period.EP02 This set of books does not have any open or future enterable periods.EP03 This date is not within any period in an open encumbrance year.EP04 This date is not a business day.EP05 There are no business days in this period. Unbalanced Journal Error CodesWU01 Warning: This journal entry is

Base Tables of O2C Process:

2008-07-30T07:45:00.000-07:00

Base Tables of O2C Process:When you entered the Order and Booked the Order following table will store the Information:SELECT * FROM OE_ORDER_HEADERS_ALLWHERE ORDER_NUMBER = 55950AND HEADER_ID = 82465SELECT * FROM OE_ORDER_LINES_ALLWHERE HEADER_ID = 82465AND LINE_ID IN (161391, 161393)SELECT * FROM WSH_DELIVERY_DETAILSWHERE SOURCE_HEADER_ID = 82465AND SOURCE_LINE_ID in (161391, 161393) Ø

API's

2008-07-20T11:21:00.000-07:00

API'sFND_PROGRAM.EXECUTABLE ( )FND_PROGRAM.DELETE_EXECUTABLE( )FND_PROGRAM.REGISTER( )FND_PROGRAM.DELETE_PROGRAM( )FND_PROGRAM.PARAMETER( )FND_PROGRAM.DELETE_PARAMETER( )FND_PROGRAM.INCOMPATIBILITY( )FND_PROGRAM.DELETE_INCOMPATIBILITY( )FND_PROGRAM.REQUEST_GROUP( )FND_PROGRAM.DELETE_GROUP( )FND_PROGRAM.ADD_TO_GROUP( )FND_PROGRAM.REMOVE_FROM_GROUP( )FND_REQUEST.SUBMIT_REQUEST( )

Order to cash life cycle

2008-07-20T11:09:00.000-07:00

Order cycle1.customer sends details of order or sales dept brings order from customer.2.Enter the order in Sales order (SO)3.Book an SO4.Check for ATP (Available to promise)5. Check for CTP (Capable to Promise) and CTD (capable to deliver)6.Schedule SOship date7.Send SO Acknowledgement8.Resolve SO Holds9.Release Credit Holds (Go to SO actions tab and release hold or increase the credit amount in

Oracle Apps Stuff in Net

2008-07-20T11:02:00.001-07:00

http://wordpress.com/tag/oracle-order-management/http://georgenet.net/oracle/http://oracleebusinesssuite.wordpress.com/http://www.sap-img.com/oracle-database/oracle-application-hints-and-tips.htmhttp://garethroberts.blogspot.com/2007/09/standard-report-to-csv-file-via-bi.htmlhttp://oracle-hrms-11i.blogspot.com/http://www.w3schools.comhttp://www.ebusinesslab.cnhttp://www.trutek.com/index.php?id=

Oracle Apps Training Videos

2008-07-20T10:58:00.000-07:00

Easy to Learn Oracle Apps Tutorialshttp://www.exforsys.com/content/category/17/260/342/Oracle Apps Student Guideshttp://www.megaupload.com/?d=YTD92KVFOracle Studenthttp://www.megaupload.com/?d=WPXTBMMVOracle Financials Open Interface Manualhttp://www.megaupload.com/?d=K0QVC3IDVideo Tutorials on Oracle General Ledgerhttp://www.megaupload.com/?d=JOET6PQSOracle ADI and 11i Tip Sheetshttp://

Query to retieve KFF's in Oracle E-Business Suite

2008-07-20T10:53:00.000-07:00

SELECT COUNT(*), FAT.APPLICATION_NAMEFROM FND_ID_FLEXS FIF, FND_APPLICATION_TL FATWHERE FAT.APPLICATION_ID = FIF.APPLICATION_IDAND FAT.LANGUAGE = 'US'GROUP BY FAT.APPLICATION_NAMEORDER BY FAT.APPLICATION_NAME SELECT FA.APPLICATION_SHORT_NAME, FAT.APPLICATION_NAME, FIF.ID_FLEX_CODE, FIF.ID_FLEX_NAMEFROM FND_ID_FLEXS FIF, FND_APPLICATION

Apps Tables

2008-07-20T10:47:00.000-07:00

General AOL

2008-06-25T12:03:00.000-07:00

General AOLWhere do concurrent request logfiles and output files go? The concurrent manager first looks for the environment variable $APPLCSF If this is set, it creates a path using two other environment variables: $APPLLOG and $APPLOUT It places log files in $APPLCSF/$APPLLOG Output files go in $APPLCSF/$APPLOUT So for example, if you have this

PO Interfaces

2008-06-25T08:57:00.000-07:00

PO_HEADERS_INTERFACEis the interface table that imports header information from e– Commerce Gateway for blanket purchase orders and catalog quotations.INTERFACE_HEADER_IDBATCH_IDINTERFACE_SOURCE_CODEPO_LINES_INTERFACEis the interface table that imports lines information from e– commerce Gateway for blanket purchase orders and catalog quotations.INTERFACE_LINE_IDINTERFACE_HEADER_IDACTION NULL

Inventory and PO Interface Tables

2008-06-25T08:54:00.000-07:00

Inventory InterfacesOpen Item InterfaceInterface Table:MTL_SYSTEM_ITEM_INTERFACEMTL_ITEM_REVISIONS_INTERFACEMTL_ITEM_CATEGORY_INTERFACEMTL_INTERFACE_ERRORSBase Table:MTL_SYSTEM_ITEMS_BMTL_ITEM_REVISIONSMTL_ITEM_CATEGORIESOpen Transaction InterfaceMTL_TRANSACTIONS_INTERFACEMTL_TRANSACTION_LOTS_INTERFACEMTL_SERIAL_NUMBERS_INTERFACEMTL_INTERFACE_ERRORSBase

Forms Customization

2008-06-25T08:49:00.000-07:00

What is custom development?Custom development is new development, In order to provide new functionality , which is not available in Oracle Application, we are going for custom development.What is customization?Customization is not a new development. The existing form will be modified as per our requirement. This may be cosmetic change or navigation change or functionality change.Compare Custom

HRMS Windows and their Navigation Paths

2008-06-25T08:45:00.000-07:00

Windows and their Navigation PathsThe following list shows the default navigation paths for all the windows in Oracle HRMS, as they are supplied. You can use task flow windows directly from the menu, or from the People and Assignment windows.The responsibility that you use determines which of these windows you can use and how you access them. Your system

HRMS Assignment

2008-06-25T08:36:00.000-07:00

1. How do you change the Secondary Assignment to become the Primary Assignment?To make a secondary assignment the primary assignment, follow the stepslisted below: Responsibility = Must be a HRMS ResponsibilityNavigation = People ->Enter and Maintain -> AssignmentForm Name = PERWSEMA or PERWSHRG (Assignment)1. Sign into Oracle Applications and navigate to theAssignment form by clicking on People

ORACLE HUMAN RESOURCES

2008-06-25T08:33:00.000-07:00

1. What are the seeded Person Types? Person types are used to describe people entered into the Oracle Human Resources product. The person types names may be modified if needed, or new person types can be added. In 10.7 and 11.0.3 there are eight person types delivered by the system, and identified by a system name. For each, there is a predefined user name. You can change the predefined name

SQL*Plus

2008-06-25T08:07:00.000-07:00

1 Which command in SQL*Plus is used to save the query output to a file?SPOOL2 How would you extract a SQL statement in the SQL buffer of SQL*Plus?Enter a SLASH (/)3 What is the default display length of the DATE Datatype column?Eight4 Which Clause in a query limits the rows selected?WHERE5 Which SQL*Plus command always overwrites a file?SPOOL6 Which single-row function could you use to return a

SQLTRACE-PLAN

2008-06-25T08:00:00.000-07:00

TUNING SQL Statements: Using TK_PROF, EXPLAIN PLAN.If you have a system that is performing badly, a good way to identify problem SQL statements is to trace a typical user session and then use TkProf to format the output using the sort functions on the tkprof command line.Explain plan is a representation of the access path that is taken when a query is executed within Oracle.1. SET TIME ON;2.

Report Questions

2008-06-25T07:36:00.000-07:00

1. What is SRW Package? Ans: The Report builder Built in package know as SRW Package (Sql Report Writer) This package extends reports, Control report execution, output message at runtime, Initialize layout fields, Perform DDL statements used to create or Drop temporary table, Call User Exit, to format width of the columns, to page break the column, to set the colorsEx: SRW.DO_SQL, It

Some Of Frequently Asked Questions in Interviews

2008-06-25T07:32:00.000-07:00

1. What Is the Forms Registration Process.2. What is the forms registration process using back end.3. What are the default packages added to a TEMPLATE.fmb----custom.pll,appdaypk,apcore2,fndsqf4. Where do you save the FMB / FMX files. AU_TOP-----resources5. What is the Report Registration process.6. What is the Report Registration Process through back end.7. How do you link the parameters of your

GL Tables

2008-06-25T07:30:00.000-07:00

GL_ACCOUNT_HIERARCHIES stores lists of the detail accounts associated with each summary account. When you create a summary account, the list of its detail accounts is stored in this table, one detail account per row. This table stores one such list for each summary account.GL_ALLOC_BATCHES stores information about MassAllocation and MassBudget batches. Each row includes a batch’s unique ID, name

GL Flow

2008-06-25T07:29:00.000-07:00

GENERAL LEDGER1. Creating Journal ( Batch, Header and Lines).2. Creating Code Combination,3. Creating Journal Source4. Creating Journal Category5. Understanding Accounting Period,6. Understanding Key Flexfileds,7. Understanding Descriptive Flexfields 8. Understanding SetUp of General Ledger9. Understanding Account Inquiry form10. Understanding GL Interface

Interview Questions

2008-06-25T07:16:00.000-07:00

1.We have 2 different databases,and each system has 2 tables. Know there is a link provided between them. The client want a report to be developed based on the 4 tables that r there in the 2 different databases.The solution must be efficient. Assume that the two databases be DB1 and DB2. At one time I could connect to only one database say DB1. Now I should able to access the tables in DB2 from

REPORTS

2008-06-25T07:07:00.000-07:00

1. What is a Lexical Parameter?Lexical parameters are used to substitute multiple values at runtime and are identified by a preceding ‘&’. Lexicals can consist of as little a one line where clause to an entire select statementLexical Parameters are used to execute query dynamically.Example: An example of a lexical parameter usage in a select statement is as followsSelect * from emp, deptno&

PL/SQL

2008-06-25T06:58:00.000-07:00

1. What’s a PL/SQL table? Its purpose and Advantages?A. A PL/SQL table is one dimensional, indexed, unbounded sparsed collection of homogeneousData.PLSQL tables are used to move data into and out of the database and between client side applications and stored sub-programs. They have attributes such as exits, prior, first, last, delete ,next . These attributes make PLSQL tables easier to use and

INVENTORY (INV)

2008-06-25T06:56:00.000-07:00

1. What is item import? How is it done?A) The process of converting inventory items from another inventory system, migrating assembly and component items from a legacy manufacturing system, converting purchase items from a custom purchasing system and importing new items from a product data management package into Oracle Inventory. This import mechanism is achieved through a concurrent

Order Management (OM)

2008-06-25T06:53:00.000-07:00

1) What are the Base Tables and Interface Tables for Order Management? Interface Tables : OE_HEADERS_IFACE_ALL, OE_LINES_IFACE_ALL OE_PRICE_ADJS_IFACE_ALL, OE_ACTIONS_IFACE_ALL OE_CREDITS_IFACE_ALL (Order holds like credit check holds etc) Base Tables :

Accounts Payable (AP)

2008-06-25T06:51:00.000-07:00

1) What are the different types of Interfaces?Ans Refer Laxman Vendor import notes in scanned documentsa) Vendor conversion / ImportA vendor is any company or person that we buy goods or services from.Interface table --- we need to create our own custom interface table.Base tablesPO_VENDORS (Segment1-Vendor number is unique)PO_VENDOR_CONTACTSPO_VENDOR_SITES_ALLb) Legacy InvoiceInterface

Accounts Receivable (AR)

2008-06-25T06:49:00.000-07:00

1. What is TCA? Tables?A) Trading Community Architecture. It is a centralized repository of business entities such as Partners, Customers, and Organizations etc. It is a new framework developed in Oracle 11i.HZ_PARTIES: The HZ_PARTIES table stores basic information about parties that can be shared with any relationship that the party might establish with another party. Although a record in the