Thursday 2 February 2012

Oracle Reports Script and Join Conditions of Tables

SELECT   ROWNUM "SL NO",
                prha.segment1 "PR NO",
                prha.creation_date "PR CREATION DATE",
               (prla.quantity*prla.unit_price) "PR VALUE",
               msib.inventory_item_id "MATERIAL CODE",
               msib.description "MATERIAL DESCRIPTION",
               prla.quantity "QTY",
               prla.unit_meas_lookup_code "UOM",
               prha.authorization_status "PR APPROVAL STATUS",
               pha.segment1 "PO NO",
               pha.creation_date "PO DATE",
               (pla.quantity*pla.unit_price) "PO VALUE"
FROM     po_requisition_headers_all prha,
              po_requisition_lines_all prla,
              mtl_system_items_b msib,
              po_headers_all pha,
              po_req_distributions_all prda,
              po_distributions_all pda,
              po_lines_all pla,
              hr_operating_units hou
WHERE prha.requisition_header_id=prla.requisition_header_id
AND       prha.org_id=msib.organization_id
AND       msib.inventory_item_id=prla.item_id
AND       prla.requisition_line_id=prda.requisition_line_id
AND       prda.distribution_id=pda.req_distribution_id
AND       pda.po_line_id=pla.po_line_id
AND       pla.po_header_id=pha.po_header_id
AND       hou.name=:Operating_Unit
AND       TRUNC(prha.creation_date)  BETWEEN NVL(:From_Creation_Date,to_date                                                   (prha.creation_date,'DD-MON-RR')) AND NVL(:To_Creation_Date,to_date
              (prha.creation_date,'DD-MON-RR'))
AND       msib.inventory_item_id BETWEEN NVL(:From_Material_Code,msib.inventory_item_id)
              AND NVL(:To_Material_Code,msib.inventory_item_id)

List of PR's Converted to PO

select  ROWNUM "SL NO",
           prha.segment1 "PR NO",
           prha.creation_date "PR CREATION DATE",
           prha.approved_date "PR APPROVAL DATE",
           msib.inventory_item_id "MATERIAL CODE",
           msib.description "MATERIAL DESCRIPTION",
           prla.quantity "QTY",
           prla.unit_meas_lookup_code "UOM",
           pha.segment1 "PO NO",
           pha.creation_date "PO_CREATION_DATE",
           pha.approved_date "PO APPROVAL DATE",
           aps.vendor_name "SUPPLIER_NAME",
           papf.full_name "BUYER NAME",
          (prla.quantity*prla.unit_price) "PR VALUE",
          (pla.quantity*pla.unit_price) "PO VALUE"     
FROM  po_requisition_headers_all prha,
            po_requisition_lines_all prla,
            po_req_distributions_all prda,
            po_distributions_all pda,
            mtl_system_items_b msib,
            po_headers_all pha,
            ap_suppliers aps,
            per_all_people_f papf,
            po_lines_all pla,
            hr_operating_units hou 
WHERE  prha.requisition_header_id=prla.requisition_header_id
AND        prla.requisition_line_id=prda.requisition_line_id
AND        prda.distribution_id=pda.req_distribution_id
AND        pda.po_header_id=pha.po_header_id
AND        prla.item_id= msib.inventory_item_id
AND        msib.organization_id=prha.org_id
AND        pha.vendor_id=aps.vendor_id
AND        pha.agent_id=papf.person_id
AND        pha.po_header_id=pla.po_header_id
AND        hou.name=:Operating_Unit
AND        TRUNC(prha.creation_date) BETWEEN NVL(:From_Creation_Date,to_date
              (prha.creation_date,'DD-MON-RR')) AND NVL(:To_Creation_Date,to_date
              (prha.creation_date,'DD-MON-RR'))
AND       msib.inventory_item_id BETWEEN NVL (:From_Material_Code,msib.inventory_item_id)
             AND NVL (:To_Material_code, msib.inventory_item_id)     
AND   aps.vendor_name=:Vendor
AND   papf.full_name=:Buyer

List of Rejected PR's

select   ROWNUM "SL NO",
           prha.segment1 "PR NO",
           prha.creation_date "PR CREATION DATE",
           prha.approved_date "PR APPROVAL DATE",
           msib.inventory_item_id "MATERIAL CODE",
           msib.description "MATERIAL DESCRIPTION",
           prla.quantity "QTY",
           prla.unit_meas_lookup_code "UOM" ,
           prla.unit_price "UNIT_VALUE",
           (prla.quantity*prla.unit_price) "TOTAL VALUE",
           plla.need_by_date,
           papf.full_name "REQUESTOR",
           pha.vendor_site_id "REQUESTOR AT SITE"     
FROM po_requisition_headers_all prha,
           po_requisition_lines_all prla,
           po_req_distributions_all prda,
           po_distributions_all pda,
           mtl_system_items_b msib,
           po_headers_all pha,
           po_line_locations_all plla,
           per_all_people_f papf,
           hr_operating_units hou
WHERE prha.requisition_header_id=prla.requisition_header_id
AND     prla.requisition_line_id=prda.requisition_line_id
AND     prda.distribution_id=pda.req_distribution_id
AND     pda.po_header_id=pha.po_header_id
AND     prla.item_id=msib.inventory_item_id
AND     msib.organization_id=prha.org_id
AND     pha.po_header_id=plla.po_header_id
AND     pha.agent_id=papf.person_id
AND     hou.name=:Operating_Unit
AND    TRUNC(prha.creation_date) BETWEEN NVL(:From_Creation_Date,to_date
           (prha.creation_date,'DD-MON-RR')) AND NVL(:To_Creation_Date,to_date
           (prha.creation_date,'DD-MON-RR'))
AND     msib.inventory_item_id BETWEEN NVL (:From_Material_Code,msib.inventory_item_id)
            AND NVL (:To_Material_code, msib.inventory_item_id)
AND   papf.full_name=:Requestor                                    
                                  

PR's Converted to RFQ

select  ROWNUM "SL NO",
           prha.segment1 "PR NO",
           prha.creation_date "PR CREATION DATE",
           prha.approved_date "PR APPROVAL DATE",
           msib.inventory_item_id "MATERIAL CODE",
           msib.description "MATERIAL DESCRIPTION",
           prla.quantity "QTY",
           prla.unit_meas_lookup_code "UOM",
           pha.segment1 "RFQ NO",
           pha.creation_date "RFQ CREATION DATE"    
FROM po_requisition_headers_all prha,
           po_requisition_lines_all prla,
           po_req_distributions_all prda,
           po_distributions_all pda,
           mtl_system_items_b msib,
           po_headers_all pha,
           hr_operating_units hou
WHERE prha.requisition_header_id=prla.requisition_header_id
AND     prla.requisition_line_id=prda.requisition_line_id
AND     prda.distribution_id=pda.req_distribution_id
AND     pda.po_header_id=pha.po_header_id
AND      prla.item_id= msib.inventory_item_id
AND      msib.organization_id=prha.org_id
AND      hou.organization_id(+)=pha.org_id
AND      hou.name=:Operating_Unit
AND      TRUNC(prha.creation_date) BETWEEN NVL(:From_Creation_Date,to_date
            (prha.creation_date,'DD-MON-RR')) AND NVL(:To_Creation_Date,to_date
            (prha.creation_date,'DD-MON-RR'))
AND      msib.inventory_item_id BETWEEN NVL (:From_Material_Code,
             msib.inventory_item_id) AND NVL (:To_Material_code, msib.inventory_item_id)
            
                                        


Oracle Apps HRMS Interview Questions

1. Important Tables in HRMS
Per_all_people_F,
per_person_types,
per_person_type_usages,
per_addresses,
per_contact_Relationships,
per_periods_of_service
Per_all_assignments_f,
per_pay_groups,
per_jobs,
per_job_Definitions,
per_grades,
per_grade_definitions,
hr_all_positions,
hr_all_position_definitions,
hr_all_locations,
pay_all_payrolls_F
pay_element_entry_values_F,
pay_element_entries_F,
pay_elements_links_F,
pay_element_types_F

2. Key Flexfields (KFFs) in HRMS
Job KFF,
Grade KFF,
People Group KFF,
Position KFF,
Cost Allocation KFF,
Comptence KFF

3.What are Date Track Tables? 
Every update in the Table, we will save the change in the form of a Record to provide the facility to find the information at any point of time.

These tables are post fixed by _F

4. What are secured Views?
The Views which do not have the _all to be said as secured views.
Per_all_people_F
per_people_f
per_all_assignemtns_f
per_assignments_f
pay_all_payrolls_F
per_payrolls_f

5. The differece between both secured views and non secured views is :
1.Secured views display information only for the current period
2.Unsecured views is used to get the information from the entire rows

6. APIs in HRMS
API are used in HR to insert the data into the Base tables. As its very secured system, the user does nothave the facility to copy the data directly into the Base tables.When we write the inbound interfaces / use WebAdI, the systems will use the APIs to store the data into system.The API are published by oracle with number of parameters.The different types of parameters are IN / INOUT / OUT.Of these parameters few are mandatory, with out which the process wont complete.Generally when we use API we give data for : Object Version Number, Effective Date, P_Validate

HR_EMOYEE_api ex: hr_employee_api.create_employee
hr_PERSON_api
hr_organization_api Ex: hr_organization_api.create_organization
hr_applicant_apI
hr_assignment_api

7. What are the reports which you have done in HR?
HR PAYROLL COSTING :
This report is used to display the information about the employees, the assignements which were given to the employees along with the payroll details including the Hours Paid, Salary, NI, Pension, Car Allowances and Other Allowances.


Imported Supply Purchase Order

SELECT         DISTINCT pva.segment1 "VENDOR CODE",
                    plla.ship_to_organization_id,
                    pha.po_header_id,
                    hla.inventory_organization_id,
                    pva.VENDOR_NAME,
                    pvsa.address_line1,
                    pvsa.address_line2,
                    pvsa.city,
                    pvsa.state,
                    pvsa.ZIP "PINCODE",
                   (PVC.first_name|| pvc.last_name) "SUPPLIER's CONTACT PERSON",
                       PVSA.phone "Mobile No./Phone No. ",
                        PVC.fax "FAX NO. ",
                   PVC.email_address "EMAIL ID ",
                  (pha.segment1||'/'||pha.revision_num) "PO/REV No",
                  (pra.release_num||'/'||pha.revision_num) "Rel/REV No.",
                  prha.segment1 "PR NO.",
                  papf.full_name "BUYER NAME ",
                  hla.address_line_1 "ADDRESS LINE 1 ",
                  hla.address_line_2 "ADDRESS LINE 2",
                  hla.LOCATION_CODE,
                  hla.town_or_city "CITY /STATE",
                  hla.telephone_number_1 "PHONE NO./FAX NO. ",
                  rownum "SL NO.",
                  msib.segment1 "ITEM_CODE",
                  pla.item_description,
                  plla.quantity "SHIPMENT QTY",
                  pla.UNIT_MEAS_LOOKUP_CODE "UOM",
                  plla.NEED_BY_DATE "NEED BY DATE ",
                  pha.currency_code "CURRENCY",
                  pla.unit_price "UNIT BASIC PRICE",
                 (pla.unit_price * plla.quantity) "TOTAL BASIC PRICE",
                 pla.po_header_id,
                 msib.organization_id,
                 plla.tax_name "SEA WORTHY PACKING",
                 pha.fob_lookup_code "DELIVERY TERMS",
                 pha.freight_terms_lookup_code "MODE OF TRANSPORT",
                 trm.name "PAYMENT TERMS",
                 papf.full_name,
                 jcvs.CST_REG_NO "CST NO.",
                 jcvs.VAT_REG_NO "VAT/ TIN NO.",
                 jcvs.EC_CODE "ECC NO.",
                 (fdt.title||fdt.description ) "ATTACHMENT",
                 hou.NAME "OPERATING UNIT"
FROM        po_headers_all pha,
                 po_releases_all pra,
                 ap_suppliers pva,
                 ap_supplier_sites_all pvsa,
                 ap_supplier_contacts pvc,
                 per_all_people_f papf,
                 po_line_locations_all plla,
                 po_distributions_all pda,
                 po_req_distributions_all prda,
                 po_requisition_lines_all prla,
                 po_requisition_headers_all prha,
                 hr_locations_all hla,
                 po_lines_all pla,
                 mtl_system_items_b msib,
                    JAI_CMN_VENDOR_SITES JCVS,
                 hr_operating_units  hou,
                ap_terms_tl trm,
                fnd_documents_tl fdt,
                fnd_attached_documents fad
WHERE  pha.po_header_id= pra.po_header_id
AND        pva.vendor_id= pvsa.vendor_id
AND       pvc.vendor_site_id= pvsa.vendor_site_id
AND       pha.org_id=pvsa.org_id(+)
AND       pha.agent_id=papf.person_id
AND       pha.po_header_id=plla.po_header_id
AND      plla.ship_to_location_id=hla.location_id
AND      plla.po_line_id=pla.po_line_id
AND       pla.item_id=msib.inventory_item_id(+)
AND      msib.organization_id=hla.inventory_organization_id

AND 
     jcvs.vendor_site_id(+)=pvsa.vendor_site_id
AND      hou.organization_id(+)=pha.org_id
AND      pda.line_location_id(+)=plla.line_location_id
AND      pra.po_release_id(+)=pda.po_release_id
AND      prda.distribution_id=pda.req_distribution_id
AND      prla.requisition_line_id=prda.requisition_line_id
AND      prha.requisition_header_id=prla.requisition_header_id
AND      trm.term_id=pha.terms_id
AND      fad.pk1_value(+) = TO_CHAR(pha.po_header_id)
AND      fdt.document_id (+)=fad.document_id
AND      pva.segment1 BETWEEN NVL(:FROM_VENDOR_CODE,pva.segment1)  
                AND NVL(:TO_VENDOR_CODE,pva.segment1)
AND     pha.currency_code<>'INR'
    


APIL payments Invoice using Vendor

SELECT   pha.segment1 "PO_NO" ,
               pha.creation_date "PO_DATE",
               pv.vendor_name,
                  SUM(pla.quantity) "PO_QTY",
               rsh.receipt_num "GRN_NO",
               rt.transaction_date "GRN_DATE",
                   SUM(plla.quantity_received) "RECEIVED_QTY",
                    SUM(plla.quantity_accepted) "ACCEPTED_QTY",
               SUM(aila.quantity_invoiced) "INVOICED_QTY",
               aia.amount_paid "PAYMENT_AMT",        
               apt.name "PAYMENT_TERMS",
               apsa.due_date "PAYMENT_DATE",
               aca.payment_method_code "PAYMENT_MODE",
                    DECODE(aca.payment_method_code,'CHECK',aca.check_number,
                    'NETTING',aca.check_number) "CHECK_NUMBER",
                  DECODE(aca.payment_method_code,'CHECK',aca.check_date,
                    'NETTING',aca.check_date) "CHECK_DATE"      
FROM     po_headers_all pha,
               po_lines_all pla,
               po_line_locations_all plla,
               po_distributions_all pda,
               po_vendors pv,
               rcv_transactions rt,
               rcv_shipment_headers rsh,
               rcv_shipment_lines rsl,
               ap_invoices_all aia,
               ap_invoice_lines_all aila,
               ap_invoice_distributions_all aida,
               ap_invoice_payments_all aipa,
               ap_payment_schedules_all apsa,
               ap_checks_all aca,
               ap_terms apt,
               mtl_system_items_b msib,
               org_organization_definitions ood
WHERE  pha.po_header_id=pla.po_header_id
AND        pla.po_line_id=plla.po_line_id
AND        plla.line_location_id=pda.line_location_id
AND        pv.vendor_id=pha.vendor_id
AND        rsh.shipment_header_id=rsl.shipment_header_id
AND        pda.po_distribution_id=rsl.po_distribution_id
AND        rsl.shipment_line_id=rt.shipment_line_id
AND        aia.invoice_id=aila.invoice_id
AND       aia.invoice_id=aida.invoice_id
AND       aipa.invoice_id(+)=aia.invoice_id
AND       aia.invoice_id=apsa.invoice_id
AND       aipa.check_id=aca.check_id(+)
AND       apt.term_id=aia.terms_id
AND       pla.item_id=msib.inventory_item_id(+)
AND       ood.organization_id(+)=msib.organization_id
AND       rt.transaction_id=aida.rcv_transaction_id
AND      TRUNC(rt.transaction_date) BETWEEN NVL(:FROM_RECEIPT_DATE,to_date
         (rt.transaction_date,'DD-MON-RR')) AND NVL(:TO_RECEIPT_DATE,to_date
         (rt.transaction_date,'DD-MON-RR'))
AND      pv.vendor_name=NVL(:VENDOR_NAME,pv.vendor_name)   
AND      aca.payment_method_code='CHECK'
GROUP BY pha.segment1,
                  pha.creation_date,
                  pv.vendor_name,
                  rsh.receipt_num,
                  rt.transaction_date,
                  aia.amount_paid,
                  apt.name,
                  apsa.due_date,
                  aca.payment_method_code,
                  aca.check_number,
                  aca.check_date



List of Open PO

SELECT     pha.segment1 "PO_NO",
               pha.creation_date "PO_CREATION_DATE",
               aps.segment1 "VENDOR_CODE",
               msib.segment1 "MATERIAL_CODE",
               msib.description "MATERIAL_DESCRIPTION",
               plla.need_by_date,
               pla.unit_meas_lookup_code "UOM",
               plla.quantity "PO_QTY",
                SUM(plla.quantity_received) "RECEIVED_QTY",
                   SUM(plla.quantity_accepted) "ACCEPTED_QTY",
                   SUM(plla.quantity_rejected) "REJECTED_QTY",
              (plla.quantity-plla.quantity_received) "BALANCE_QTY_TO_BE_RECEIVED"
FROM      po_headers_all pha,
              po_lines_all pla,
              po_line_locations_all plla,
              po_distributions_all pda,
              mtl_system_items_b msib,
              ap_suppliers aps
WHERE pha.vendor_id=aps.vendor_id
AND     pha.po_header_id=pla.po_header_id
AND     pla.po_line_id=plla.po_line_id
AND     pla.item_id=msib.inventory_item_id
AND     pha.org_id=:ORGANIZATION
AND     TRUNC (pha.creation_date) BETWEEN NVL (:FROM_RECEIPT_DATE,TO_DATE
         (pha.creation_date,'DD-MON-RR'))AND NVL (:TO_RECEIPT_DATE,TO_DATE
         (pha.creation_date,'DD-MON-RR'))                    
AND     pha.vendor_id=:VENDOR
AND     pha.segment1='7015'
GROUP BY    pha.segment1,
                  pha.creation_date,
                  aps.segment1,
                  msib.segment1,
                  msib.description,
                  plla.quantity,
                  plla.need_by_date,
                  pla.unit_meas_lookup_code,
                  plla.quantity,
                  plla.quantity_received,
                  plla.quantity_accepted,
                  plla.quantity_rejected,
                  plla.quantity,
                  plla.quantity_received

Value Sets

Value Set: Value set is nothing but list of values with validations which will be
used to to restrict the user without entering the invalid data in the Parameters

we will use value sets in two locations.
                1)Concurrent Progam parameters
                    2)Flexfields
NONE:
----
We are not providing any LOV, we can apply some format conditions as per that
conditions user should enter the data

Notes: 1)Once we create the Value set we can not Delete if we would like to delete
         we have to release the value set from the all the concurrent program
      parameters then only we can delete.
  2)Value set name is case sensitive
  3)Once we create Value set we can use for multiple Program parameters.

Navigation:
-----------
System administrator => Application=>Validation=>set=>
Enter value set name
   format type
   max size
Select validation type = "None" to create None type of Value sets.

Independent:
------------

When we would like to provide list of values to the user then we will go for selection
of Independent value set.where we will provide LOV.
User must select the Value from the list otherwise values are not accepted.

Open the Value set form create value set by selecting the validation type=Independnent
Goto Values screen enter the value set name , Select Find Buttion
enter the values whatever we would like to display as LOV.
attach the value set to the Parameter.

Note:1)Once we enter the values we can not delete instead of that we can disable by
      selecting the Enabled check box
         or Effective Dates.
Dependent value Set:
====================
This is another LOV which will be used to displays the
list of values which are depending on the previous parameter value.

Before going to create Dependent first we have to create Independent
then we have to create Dependent

First parameter will be Independent
Second parameter will be Dependent.

Note:Without Independent we can not create Dependent Value set.

Country    IND
    US
    UK
City   Banglore    Chennai     Delhi     Mumbai  Pune
       Chikago  California      Anderson
       London   Hungrant

1)We have to create Independent value set and enter the values.
2)Create Dependent value set attach independent and then enter values.


Job      Manager
      Developer
      Programmer

Position   Delivery Manager   Project manager Financce manager
       Software Developer Test Developer
       Trainee  Fresher
Navigation:
==========
1)Open the Value set form create Value set by selecting the validation type =Independent
2)Open the Values screen enter the VAlues .
3)Open the value set form enter Dependent value set by select validation type=Dependent
 Select the Button called Edit Information button enter the Independent value set
4)open the values form  enter the Dependent value set=>Find
  enter the values based on the Independent values.

Table Value set :
=================

Table value set will be used to displays the list of values from the
oracle apps base tables.
we have to give the table name and column name which will automatically
displays the values.

Note: If values are not stored in the database table then we have to
      go for Independent  value set.
      If values are there in the table then we will create table value
      set.

1.Open the value set form Select  validation type as table select the
   button called Edit Information enter table name and column name
   in the value field
2.Use where/Order By clause to implement Where/Order By clause.
3.Use Additional Columns field to displays extra columns for reference
  purpose.
4.Use the ID column to pass the ineternally other columns data
  for ex displaying username to the user and pass userID internally.
5.If multiple tables are required then enter the table names in the
  table name field with alias name and enter the Join Condition in the
  Where clause field.

6.If we know the table name we can find the Table application name from
  Application Developer responsibility
Application Developer => Application => Database => table
Query the records based on the table Name.

OAF Interview Questions


  1. What is an EO?
    a. Map to a database table or other data source
    b. Each entity object instance represents a single row
    c. Contains attributes representing database columns
    d. Fundamental BC4J object through which all inserts/updates/deletes interact with the database
    e. Central point for business logic and validation related to a table
    f. Encapsulates attribute-level and entity-level validation logic
    g. Can contain custom business methods

    2. What is a VO?
    a. Represent a query result
    b. Are used for joining, filtering, projecting, and sorting your business data
    c. Can be based on any number of entity objects
    d. Can also be constructed from a SQL statement


    3. What are the methods in controller?
    ProcessRequest and processformrequest

    4. What is a Controller?
    Controller is the java file and can be associated to a complete OAF page or to a specific region.
    There are several tasks you will do routinely in your code.
    � Handle button press and other events
    � Automatic queries
    � Dynamic WHERE clauses
    � Commits
    � JSP Forwards
    The logic for accomplishing all these tasks is written in controller

    5. When is the processRequest method called?
    PR method is called when the page is getting rendered onto the screen


    6. When is processFormRequest method called?
    PFR method is called when we perform some action on the screen like click of submit button or click on lov


    7. What is extension?
    Extension is when you take an already existing component ex an OAF page or a region and then add some more functionality to it without disturbing the original functionality.


    8. What is personalization?
    Oracle Apps Framework has an OA Personalization Framework associated with it so that you can personalize any OAF page in an Oracle E-business Suite application without changing the basic or underlying code of that OA Framework page, Oracle Application Framework makes it very easy to personalize the appearance of the page or even the personalization of data displayed on to an OA Framework page.

    9. What are levels of personalization?
    1. Function Level
    2. Localization Level
    3. Site Level
    4. Organization Level
    5. Responsibility Level
    6. Admin-Seeded User Level
    7. Portlet Level
    8. User Level
  2. 1) What is BC4J?

    Business Components for Java is JDeveloper's programming framework for building multitier database applications from reusable business components. These applications typically consist of:

    • A client-side user interface written in Java and/or HTML.
    • One or more business logic tier components that provide business logic and views of business objects.
    • Tables on the database server that store the underlying data.

    2.What are all the components of BC4J?
  3. Following are the components of BC4J:

  4. Entity Object - EO encapsulates the business logic and rules. EO’s are used for Inserting, Updating and Deleting data from the database table. E0 is also used for validating the records across the applications.

  5. View Object - View object encapsulates the database query. It is used for selecting data. It provides iteration over a query result set. VO’s are primarily based on EO’s. It can be used on multiple EO’s if the UI is for update.

  6. Application Module - Application Modules serve as containers for related BC4J components. The pages are related by participating in the same task. It also defines the logical data model and business methods needed.

    2) What is an EO?
    EO encapsulates the business logic and rules.EO’s are used for Inserting, Updating and Deleting data. This is used for validating across the applications. We can also link to other EO’s and create a Association object.

    3) What is an VO?
    View object encapsulates the database query. It is used for selecting data. It provides iteration over a query result set.VO’s are primarily based on Eo’s. It can be used on multiple EO’s if the UI is for update. It provides a single point of contact for getting and setting entity object values. It can be linked together to form View Links.

    4) What is an AO?
    An association object is created where we link EO’s. For example take the search page where we link the same EO to form a association between the manager and employee. Every employee should have a manager associated. But if it President then no there is no manager associated. This is a perfect example to understand the AO.

    5) What is an VL?
    A view link is an active link between view links. A view link can be created by providing the source and destination views and source and destination attributes. There are two modes of View link operation that can be performed. A document and Master/Detail operation.

    6). What is UIX?
    UIX is an extensible, J2EE-based framework for building web applications. It is based on the Model-View-Controller (MVC) design pattern, which provides the foundation for building scalable enterprise web applications.

    7). Where the VO is located in the MVC architecture?
    VO is located in the View Layer in MVC which is responsible for presenting the data to the user.

    9) Which package should include EO and AO.
    The EO and AO will be present in the schema.server package.

    10) What is the difference between inline lov and external lov.
    Inline lov is a lov which is used only for that particular page for which it was created and cannot be used by any other page.

  7. External lov is a common lov which can be used by any page. It is a common component for any page to use it. It can be used by giving the full path of the lov in the properties section “External LOV” of the item.

1) what is a Javabean?
JavaBeans is an object-oriented programming interface that lets you build re-useable applications or program building blocks called components that can be deployed in a network on any major operating system platform.

2) What is query Bean?
QueryBean is used to execute and return the results of a query on behalf of the QueryPortlet application.

3) what is the difference between autocustomization criteria and result based search?
Results based search generates search items automatically based on the columns on the results table.
In Autocustomization search we need to set what all fields are required to display as a search criteria.

4) what is MDS?
MDS is MetaData Service. When a web page is broken into small units like buttons,fields etc they are stored in a database. These are not stored as binary files but as data in tables. The data are present in JDR tables. MDS provides service to store & return page definitions. MDS collects those definitions in components/fields in a meaningful manner to build a page.

5) What is XML?
XML is a markup language for documents containing structured information.
Structured information contains both content (words, pictures, etc.) and some indication of what role that content plays (for example, content in a section heading has a different meaning from content in a footnote, which means something different than content in a figure caption or content in a database table, etc.).

6) What is the difference between customization and extension?
Customization is under direct user control. The user explicitly selects between certain options. Using customization a user can:
    Altering the functionality of an application
    Altering existing UI
    Altering existing business logic

Extension is about extending the functionality of an application beyond what can be done through personalization. Using extension we can:

    Add new functional flows
    Extend or override existing business logic
    Create New application/module
    Create New page
    Create New attribute
    Extend/Override defaults & validations

7) What is Personalization?
Personalization enables you to declaratively tailor the UI look-and-feel, layout or visibility of page content to suit a business need or a user preference. Using Personalization we can:

    • Tailor the order in which table columns are displayed.
    • Tailor a query result.
    • Tailor the color scheme of the UI.
    • Folder Forms
    • Do Forms Personalization
   
8)Can you extend every possible Application Module?
Answer: No..Root AM cannot be extended.

9) What is rootAM?
The application module which is associated with the top-level page region (the pageLayout region) is root application module.

10) Why can’t Root AM be extended?
 
The root AM is loaded first and after that the MDS Substitutions are parsed.
Hence ROOT AM gets loaded even before the time the substitutions definition from MDS layer get worked out. 

Obviously, the root am cant substitute itself, hence it can't be extended

Apps Technical Interview Questions asked in wipro


            1. What are different cursors available?
            2. What are cursor attributes?
            3. Can we use sql%found in Explicit cursors opened in cursor for loop?
            4. What is token?
            5. What is init pragma exception?
            6. How do you define a table type value set depending on another table value set?
            7. In this case, if the child parameter has sequence no. as 5 and the parent parameter has sequence no. as 10, what is the effect? When you will get the error and what is the error?
            8. What is the order flow including tables effected at each stage?
            9. What is the hierarchy of Multi org concept?
            10. Where do you define the ‘Set of Books’ in Multi Org Concept?
            11. In which table, you will get Organization_id and in which tables, you will get org_id?
            12. What is Run alone report?
            13. What is incompatibility in Report definition?
            14. What you have done for an interface?
            15. What is the procedures you have done?
            16. Any API used in your procedures?
            17. What are different APIs available in Oracle Apps?
            18. How the oracle Applications recognizes the print style?
            19. what is the use of Row & column columns in Report Definition above the printer style?
            20. When the workflow back end process will run in the order cycle?
            21. Can you customize a workflow?
            22. How a multi org concept effects in GL module?
            23. What is a miscellaneous receipts & issues?
            24. Do you face any performance related issues in your work?
            25. What is TCA architecture?
            26. What are the tables effected when ‘ship confirm’?
            27. In the order cycle, where it is interrelate with other oracle modules like INV, AR etc.
            28. what are the table affected when you make a customer under credit hold?

( hz_customer_profiles)
            29. What is the data available in HZ_CUST_ACCOUNTS and HZ_CUST_ACCT_SITES_ALL?
            30. Which trigger fires first in Reports?
            31. What will fire first when a parameter is defined in Report in Reports 6i and the parameters are not defined in Program definition?
            32. Can we give a parameter as mandatory(i.e. Required flag –Yes) and display is disabled?
            33. What are the possible values we can give in a value set?