Sunday, April 24, 2016

Oracle Report customizations

 ***   Report customization  ***
============================================================================
                         ** Account Receivable Application **
-------------------------------------------------------------------------------------------------
1)Incomplete Invoice Report:(Short Name->RAXIIR)

  Table        :-a)RA_CUSTOMER_TRX        b)RA_CUSTOMER
                 c)RA_CUST_TRX            d)RA_CUST_TRX_LINE_GL_DIST
  
  Parameter    :-Total have 8 parameter within only one is required that is P_Order_by 
                 because the order having two important type INVOICE  and CUSTOMER

  Customization:-Create Two New Parameter
                 1)Complete_Flag->In original Report in query it hard coded default 'N'
                 bacause Invoice shows Incomplete but i take as a parameter then we select
                 'N'/'Y' that is report view is change and it is use both the purpose Incomplete
                 or complete Invoice.
                 2)Customer_number->It is newly created 2 bind variables because if yoy select
                 complete_flag is 'Y' then show all records of complete invoice it is houg data
                 that why you enter particular number,I make user friendly using a between                  
                 function in query.
-------------------------------------------------------------------------------------------------
2)Customer Balance Revaluation Report:(Short Name->ARXVDREV)
  
  Table        :-a)PO_AGENTS               b)HR_LOCATIONS
                 c)HR_EMPLOYEE             d)MTL_CATEGORIES
                 e)GL_SET_OF_BOOKS         f)FINANCIAL_SYSTEM_PARAMETERS
                 g)MTL_DEFAULT_SET_VIEW    h)FND_LOOKUPS
  
  Parameter    :-Total have 3 required parameter 1)P_REVALUITION_PERIOD 2)P_CUST_BALANCE
                 3)P_RECEIPTS_AT_RISK these are required parmater.
  
  Customization:-1)Record Pre Page->Select repeating frame of amain group from navigator
                 window goto property record Per Page-1 done
                 2)Customer_name->Create a bind variable but this type i create a value set
                 A_CUST_NAME it's table value set on table-RA_CUSTOMER in sysadmin define 
                 paramter keep value-A_CUST_NAME,Default Type-SQL Statement & Default Value-
                 'Select distinct customer_name from RA_CUSTOMER
                 3)Remove the Union from query in Report keep first query as it's because it's
                 show all the data and i test it's no need to keep a Union as the record 
                 retrived requirement  
-------------------------------------------------------------------------------------------------
                           *** Order Management Application  ***  
-------------------------------------------------------------------------------------------------
3) Order Discount Detail Report:(Short Name->OEXPRPRD)
  
  Table        :-a)OE_ORDER_LINES_ALL       b)OE_ORDER_TYPES_V
                 c)OE_LINE_TYPES_V          d)MTL_SYSTEM_ITEMS_VL
                 e)OE_ORDER_HEADERS_ALL     f)RA_SALESREDS
                 g)RA_ADDRESSES             h)OE_ITEMS_V
                 i)MTL_CUSTOMER_ITEMS       j)OE_SOLD_TO_ORG
                 k)RA_SALESREP             

   Parameter   :-Total have 6 required parmater1)P_SOB_ID 2)P_ORGANIZATION_ID 3)P_ITEM_FLEX_CODE
                 4)P_ORDER_BY 5)P_ITEM_FLEX_DESC 6)P_MIN_PRICISION


  Customization:-Subtotal of two field LIST_PRICE_DISPLAY & SELL_PRICE_DISPLAY these fields in table
                 OE_ORDER_LINES_ALL These report is order by Order number
-------------------------------------------------------------------------------------------------   
4)Order By Item Report:(Short Name->OEXOEITR)
  
  Table        :-a)OE_ORDER_LINES_ALL       b)OE_ORDER_TYPES_V
                 c)OE_LINE_TYPES_V          d)MTL_SYSTEM_ITEMS_VL
                 e)OE_ORDER_HEADERS_ALL     f)RA_SALESREDS
                 g)OE_SOLD_TO_ORGS_V        h)OE_ITEMS_V
                 i)MTL_CUSTOMER_ITEMS       j)OE_ITEM_V

   Parameter   :-Total have 5 required parmater1)P_SOB_ID 2)P_ORGANIZATION_ID 3)P_ITEM_FLEX_CODE
                       4)P_ORDER_BY 5)P_PRINT_FLEX_OR_DESC

  Customization : All frames are expand and through the Data window enter a repiting frame add a fielde 
                         ITEM_TYPE_CODE   in table OE_ORDER_LINES_ALL then report was order by Item Name 
                         and Item_Type and then Customer_name -wise Report see.
---------------------------------------------------------------------------------------------------   
                   

                               

No comments:

Post a Comment

Types of animations

Animation is a diverse and creative field with a variety of styles that artists and filmmakers use to bring their visions to life. Here are ...