Technical Terms in Oracle Apps explained through real time example

Story The below example explains a few of the important terms and concepts used in the Oracle E-Business Suite. This would be a good starting point for the beginners to better understand the concepts behind Oracle Applications. Say Harry is the owner of a wholesale fruit shop. He buys various fruits like apples, oranges, mangos(…)

Order to Cash Process

order to cash process steps can be listed as below Enter the Sales Order Book the Sales Order Launch Pick Release Ship Confirm Create Invoice Create the Receipts either manually or using Auto Lockbox ( In this article we will concentrate on Manual creation) Transfer to General Ledger Journal Import Posting Watch o2c Video: Order(…)

Procure to Pay Cycle

Diagrammatic representation of Procure to Pay cycle.   Watch the procure-pay-cycle-video Article with 11i screen shots: Procure to Pay Cycle 11i Query: Procure to Pay Cycle Query 1) Create Requisition: Requisition is nothing but a formal request to buy something (like Inventory material, office supplies etc) needed for the enterprise. Only an employee can create(…)

Respond to workflow notification from a DB procedure

The  below script can be used to auto approve notifications through database procedure. Write your business logic with in the below procedure ,register it as a concurrent program and schedule it as needed to run periodically. The same script can also be used in custom forms, custom or third party applications to respond to notifications from backend procedure.

Item import (Item conversion)

Overview: Item import program can be used to create new Inventory items or to update existing inventory items.  We can import items with all attributes information or use item templates to set attributes and import items linking with item template. Uses: Import New Inventory Items in Master Organization Assign Items to child Organization (Step1 has to be(…)


ITEM IMPORT BASED ON TEMPLATE R12 In this post, I tried to explain the steps to IMPORT an ITEM with its attributes based on ITEM TEMPLATE in R12 Oracle Apps. STEP1: Get the template id using the below query SELECT template_id       ,template_name       ,description FROM   MTL_ITEM_TEMPLATES; STEP2: Check the choosed template’s related item attribute values using the below query SELECT template_id       ,attribute_name       ,enabled_flag       ,report_user_value FROM   MTL_ITEM_TEMPL_ATTRIBUTES WHERE  template_id = 107; STEP3:  Run the below insert(…)

Update The Item Average Cost From Transaction Open Interface

Update The Item Average Cost From Transaction Open Interface INSERT INTO mtl_transactions_interface ( source_code , source_line_id , source_header_id , process_flag , transaction_mode , creation_date , last_update_date , created_by , last_updated_by , inventory_item_id , organization_id , transaction_date , transaction_quantity , transaction_uom , transaction_type_id , transaction_interface_id , material_overhead_account , material_account , resource_account , overhead_account , outside_processing_account, cost_group_id(…)

How to change xml publisher default template

Steps to change  xml publisher default template: It is possible to associate one data definition with multiple layouts . In such cases you can assign default template for a concurrent program and this template will be defaulted while submitting the concurrent program. We have an option of selecting the different layout instead of default layout. For(…)

Interview Questions

Interview Questions 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(…)


FAQ’s in SQL & PL/SQL What is PL/SQL? PL/SQL is a procedural language that has both interactive SQL and procedural programming language constructs such as iteration, conditional branching. What are the components of a PL/SQL Block? Declarative part Executable part Exception part What are the datatypes a available in PL/SQL? Some scalar data types such(…)

General Ledger Calendar FAQ [ID 134362.1]

Applies to: Oracle General Ledger – Version: 11.5<max_ver> and later   [Release: 11.5.0 and later ] Oracle General Ledger – Version: 11.5 and later    [Release: 11.5.0 and later] Purpose When investigating problems in this area the solution is often in the relevant White Paper which also provides a useful insight into the Topic. Please refer to the White Paper General Ledger Calendar(…)

Random Questions From Apps(FAQ’S)

Random Questions From Apps 1. What is overlay in payables Ans: 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 group Ans: rollup group we define and(…)

Database Structures FAQ’s

Database Structures FAQ’s 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(…)

Accounts Payable (AP) FAQ’S

Accounts Payable (AP) 1) What are the different types of Interfaces? Ans Refer Laxman Vendor import notes in scanned documents a) Vendor conversion / Import A 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 tables PO_VENDORS (Segment1-Vendor(…)


SQL*Plus 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? Eight 4 Which Clause in a query limits the(…)


REPORTS 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 statement Lexical Parameters are used to execute query dynamically. Example: An example of a lexical parameter(…)


PL/SQL 1. What’s a PL/SQL table? Its purpose and Advantages? A. A PL/SQL table is one dimensional, indexed, unbounded sparsed collection of homogeneous Data. 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(…)


INVENTORY (INV) 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(…)

Order Management (OM) FAQS

Order Management (OM) 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 : OE_ORDER_HEADERS_ALL: Order Header Information OE_ORDER_LINES_ALL: Items Information OE_PRICE_ADJUSTMENTS: Discounts Information OE_SALES_CREDITS: Sales Representative Credits. Shipping Tables :WSH_NEW_DELIVERIES, WSH_DELIVERY_DETAILS, WSH_DELIVERY_ASSIGNMENTS, WSH_DELIVERIES.2) What are(…)

Forms FAQ’S

Forms 1) Types of Triggers Overview of triggers This topic provides an overview of commonly used triggers, grouped into the following functional categories: Block-processing triggers When-Create-Record When-Clear-Block When-Database-Record When-Remove-RecordBlock processing triggers fire in response to events related to record management in a block. When-Create-Record: Perform an action whenever Form Builder attempts to create a new record(…)