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 ,

                mtl_item_categories,

                mtl_categories.

 

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)

Table: - GL_SETS_OF_BOOKS, FINANCIALS_SYSTEM_PARAMETERS (View),

            MTL_DEFAULT_SETS_VIEW (View), FND_LOOKUPS (View), GL_CODE_COMBINATIONS,

            MTL_UNITS_OF_MEASURE_VL (View), PO_AGENTS, PER_ALL_PEOPLE_F, MTL_SYSTEM_ITEMS,

            MTL_CATEGORIES (View), MTL_ITEM_CATEGORIES, PO_LOOKUP_CODES (View)

******************************************************************************************************************************************************************************************

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.

Short Name: - INVIRSIQ, A02_INVIRSIQ

Parameter: -

Table: - MTL_SYSTEM_ITEMS            msi,  

   MTL_ONHAND_QUANTITIES_detail moqd,

   MTL_SECONDARY_INVENTORIES si,

   MTL_ITEM_LOCATIONS mil,

  CST_ITEM_COST_DETAILS CICD

  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.