Some Standrad Oracle Apps Report Customizations
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.
Leave a Reply
Want to join the discussion?Feel free to contribute!