Monday, June 30, 2014

Useful links







=============> Change displayed data in LOV using Forms Personalization  <========

General personalization

Creating Descriptive Flex field


Report Registration

XML Publisher
Value Set Creation:-


=======> P2P accounting <==========

===========> P2P CYCLE FLOW <===============

===========>Order to Cash cycle<===============



=========>ITEM INTERFACE <=================

====> po interface <==========

ORACLE APPS Technical Online Training



open interface interview link

OAF Framework
==============='tBeAMuggle.htm OA Framework with Forms 6i

Oracle Forms Web
Upload, edit and download files from/to the database with the
Webutil library

Check Java Version

Linux Commands

Register Shell Scripts As Concurrent Program
=================================== /


Oracle Applications
=============== /
(All In one Blog) Useful Blog for all Topics

(AR Customer Interface Info.)
( Customer Interface Error Code Meaning )


R12 Vision Instance Login


Oracle Apps Data Structure 

Oracle Apps Scripts

Metalink Notes

Orcale DB Concepts


TroubleShooting Concurrent Managers

NLS Language Parameters

Trace Concurrent Request and Generate TKPROF

How to find Processes running in Sunsolaris Operating System

Character Set 

ASCII Characters

Oracle SMS Getway Guide

Hindustan Times Corporate News

MS Word Mail Merge Tutorial

How to start perticular Concurrent Manager

Company Profile & Overview

Letter Generation using WEB-ADI

Oracle HRMS Fast Farmula Tutorial

Oracle Workflow


Make Packages Valid

DB Upgrade Context File Creation


Oracle Apps DBA
============================ l

Insert BOB Object (Image) in Database and Display In Report 6i
=============================================== l

Tuning Oracle Reports

FSG Reports
======================= /

XML / BI Publisher

GRC : /

Standards for Report Developments in Oracle Apps

Standards for Report Developments in Oracle Apps

Oracle Applications Standards for New Report Developments...
For developing a Report in Oracle Applications we should follow three standards.
1. Creation of Bind Variable - P_CONC_REQUEST_ID: We must create a Bind Variable called “P_CONC_REQUEST_ID” (We can’t change this name. It is standard name.). If we run Conc. Prgm. from SRS window, it will give a Request ID. It will get store in ‘P_CONC_REQUEST_ID” automatically. This Bind Variable is useful, when we call another Conc. Prgm. with in a Conc. Prgm.

2. FND SRWINIT in Before Report Trigger:
We call the USER_EXIT (‘FND SRWINIT’) form Before Report Trigger. Syntax is
This USER_EXIT is initializing the user profiles in the report trigger i.e., before getting the date from the Database.
While executing the Conc. Prgm. the system allocate memory for the program which contains all details of user. In above syntax,
SRW.USER_EXIT refers to D2K and purpose of this is, when we want to transfer the control from execution of report to other 3rd generation language and again transfer the control to report execution.
FND SRWINIT refers to Oracle Applications. Purpose of this is to get the “User Profile”.
3. FND SRWEXIT in After Report Trigger:
We call the USER_EXIT (‘FND SRWEXIT’) form After Report Trigger. Syntax is
This USER_EXIT is frees the memory which is occupied by user profiles.

Some Standard Oracle Apps Report Customization's

Some Standard Oracle Apps Report Customization's

1. Report Name :- Inactive Item Report         (Inventory)

Customization :-   Add one field Transaction Qty to report

Short Name :-  INVIRSLO

Parameter :- Organization,Subinv Break Option,Category Set Name,Inactive From Date

Table :-  mtl_system_items ,
               mtl_material_transactions ,
Solution  :-    See the parameter listing which is required for the report with the help of report name and short name .
                           Then  FPT the report from apps/viappl/inv/11.5.0/reports/US to your directory.
                        Go to the data module and click on the Query In the select statement add transaction Qty from MTL_MATERIAL_TRANSACTION
                 Go the report builder navigator window ->click on the icon Layout editor.
                Go to the header section separate all the frames of header section. 
place the boilerplate text for the status.Add One  field and give the source to the field as status
                 save the report -ftp the rdf file
                 create concurrent program with required parameter as per original report  attach that program to the Oracle Payble or your responsibility group

 This Customize Inactive Items Report Shows Added Customer Status.

2. Report Name: - A02 Item Summary Listing Report (PO)

Customization: - Displays the summarized item listing with necessary information of buyer.
                          Added a group for category wise summation of list price.

Short Name: - POXSUMIT,     A02_POXSUMIT

Parameter: - Title, Active/inactive (Active, Inactive, Both)


3.Report Name: - Subinventory Quantity report:  (INV)

Customization: - Customized this report to displays  price of every item and their sub inventories with total of price.
Parameter: -
Table: - MTL_SYSTEM_ITEMS            msi,  
  org_organization_definitions  ood


4. Internal Requisition  Status Report. (PO)

Customization :-   Add total for Quantity Ordered

Short Name :-POXRQSIN

Parameter :-

Table :-  po_requisition_lines ,  po_requisition_headers  ,  mtl_system_items , hr_employees  
Solution          :-      See the parameter listing which is required for the report with the help of report name and short name . Then  FPT the report from apps/viappl/inv/11.5.0/reports/US to your directory.
 Create one summary Column for the Quantity order for Sum  Go the report builder navigator window ->click on the icon layout add the total field  give the source of the summary column to that field  save the report -ftp the rdf file create concurrent program with required parameter as per original report attach that program to the Oracle Inventory or your responsibility group. This customize Internal Requisition status report shows total for quantity order.

Lexical Parameters Interview Questions

Oracle Apps - Lexical Parameters Interview Questions

1. Defining Runtime Queries with Lexical Parameters

            You can modify the report query at runtime using lexical parameters. A lexical parameter is a placeholder column containing the actual text to be used in a query. To illustrate this concept, open the matrix report built earlier. For this report, create a parameter for the report year and a parameter for the user to enter one of the following values, depending on the data preference:

2. Function  Data Value 

SUM  Monthly total orders shipped 
AVG  Average shipping delay by month 
MAX  Maximum shipping delay by month 

Also, create the appropriate validation triggers for the individual parameters.

            Next, create a placeholder column at the report level called SELECTION_DATA. Set this field as a character field with a width of 100 characters and assign a default value of h.hist_ord_shipped. Next, create a before report trigger as follows:

function Before_Report_Trigger return boolean is
            if :P_REPORT_TYPE = `SUM' then
                        :SELECTION_CRITERIA := `h.hist_ord_shipped';
            elsif :P_REPORT_TYPE = `AVG' then
                        :SELECTION_CRITERIA := `h.hist_ship_days / h.hist_ord_shipped';
                        :SELECTION_CRITERIA := `h.hist_max_days';
            end if;

Finally, modify the query:

select w.wh_name WAREHOUSE, h.hist_month_no    MONTHNO, to_char (to_date (to_char (h.hist_month_no), `MM'),'MON') RPT_MONTH, &SELECTION_CRITERIA from warehouses w, warehouse_history h where w.wh_code = h.hist_wh_code and h.hist_year = :P_year
            h.hist_month_no    MONTHNO, to_char (to_date (to_char (h.hist_month_no), `MM'),'MON') RPT_MONTH, &SELECTION_CRITERIA from warehouses w, warehouse_history h where w.wh_code = h.hist_wh_code and h.hist_year = :P_year

            You reference the lexical parameter in the query using an ampersand (&) before the parameter name. Lexical parameters within a query substitute the text stored in the parameter directly into the query. For this reason, when using a lexical parameter, you must enter a default value for NULL values to assist with compilation in the designer.

3. Ten Tips for Oracle Reports

            Oracle Reports is a powerful tool that you can use to generate useful reports against Oracle databases. Although there are no hard and fast rules regarding how you should use the tool, experience has borne a number of tips that make use of this tool much easier:
             Attempt to lay out the report on paper. This assists with the development of the data model as well as the final layout. Understand where subtotals should be provided to create the data breaks up front. When the default layout is used, define the page size to be excessively wide. You can then resize and reposition the data columns to fit within the printable page. If possible, formulate the data retrieval in a single query. Experience has shown that a single, somewhat inefficient query can perform better than several, dependent, well-tuned queries.

            Complete the data model before attempting to finalize the layout. The addition of a single column in a query might necessitate a redesign of the layout and thus a misuse of time.
When adding an additional break level to an existing report, 90 percent of the time it is faster to redo the default layout. Adding another intermediate level frame is one of the most difficult tasks to be done. It can be done but is often not worth the effort.

            Rather than try to resize or reposition objects in the Layout Editor, use the Size Objects and Align Objects tools. You can select several columns at once, quickly make them all the same custom size, and then align and space them with minimal effort. To lock the relative position of multiple objects, select them and create a group to join them together. Use the Magnify tool to zoom in to view the relative positions of the objects or to zoom out to view the total report structure. When you make a mistake in the editor, use Edit | Undo to reverse the action rather than try to correct it with the mouse.
Before running any report, save it in a file to make sure that it can be recovered. Also, save different versions to facilitate recovery.

How to improve blog performance

Improving the performance of a blog can involve a variety of strategies, including optimizing the website's technical infrastructure, im...