Unable to create an entity object OAF

if Database objects are disable for selection in EO Window.
perform following setups

1)Re-Create Workspace with Oracle application settings and then try to create EO.

2) Go to tools/SQL Work sheet and then login to database, After this again try EO creation setups.
3) Set JDEV_USER_HOME environment variable as :\jdevhome\jdev,

Now you should be able to create the Entity Object.

JDeveloper Screen display problems while scrolling

JDeveloper on Windows using a laptop had serious problems with the display when the IDE tried to scroll as it was leaving visible marks.

 It ended up that the remedy was adding 

AddVMOption -Dsun.java2d.noddraw=true at the $JDEV_HOME/jdev/bin/jdev.conf file.

Oracle Work In process Costing Report with Hierarchical view of all component

SELECT H1.ORGANIZATION_ID,

       H1.ROOT_INVENTORY_ITEM_ID,

       H1.PRIMARY_ITEM_ID,

       H1.INVENTORY_ITEM_ID,

       H1.QUANTITY_PER_ASSEMBLY,

       H1.LEVEL_PATH,

       H1.WIP_ENTITY_ID,

       H1.JOB_QUANTITY,

       H1.JOB_QUANTITY_COMPLETED,

       H1.REQUIRED_QUANTITY,

       H1.H_LEVEL,

       H1.H_PATH,

       MSI.SEGMENT1||'-'||MSI.SEGMENT2||'-'||MSI.SEGMENT3 Item_code,

       MSI.DESCRIPTION,

       MSI.PRIMARY_UOM_CODE,QUANTITY_ISSUED,cit.item_cost , ROUND(QUANTITY_ISSUED*cit.item_cost)iTEMCost

             FROM

                ------END INLINE HIRARCHY

                (SELECT    ORGANIZATION_ID, CONNECT_BY_ROOT PRIMARY_ITEM_ID ROOT_INVENTORY_ITEM_ID ,

                           PRIMARY_ITEM_ID,

                           INVENTORY_ITEM_ID,

                           QUANTITY_PER_ASSEMBLY,

                           SYS_CONNECT_BY_PATH(LEVEL, '.')LEVEL_PATH,

                           WIP_ENTITY_ID,

                           START_QUANTITY JOB_QUANTITY,

                           QUANTITY_COMPLETED JOB_QUANTITY_COMPLETED ,

                           REQUIRED_QUANTITY, QUANTITY_ISSUED,LEVEL H_LEVEL

                           ,SYS_CONNECT_BY_PATH(PRIMARY_ITEM_ID, '/') H_PATH

                      FROM (SELECT WDJ.WIP_ENTITY_ID, WDJ.ORGANIZATION_ID,

                                   WDJ.PRIMARY_ITEM_ID, WRO.INVENTORY_ITEM_ID,

                                   WRO.REQUIRED_QUANTITY, WRO.QUANTITY_ISSUED,

                                   WRO.QUANTITY_PER_ASSEMBLY , WDJ.QUANTITY_COMPLETED , WDJ.START_QUANTITY

                              FROM WIP_DISCRETE_JOBS WDJ, WIP_REQUIREMENT_OPERATIONS WRO

                             WHERE 1 = 1

                               AND WRO.WIP_ENTITY_ID = WDJ.WIP_ENTITY_ID

                               AND WRO.ORGANIZATION_ID = WDJ.ORGANIZATION_ID)

                START WITH PRIMARY_ITEM_ID in (&PrimaryItemId)

                CONNECT BY NOCYCLE PRIOR INVENTORY_ITEM_ID = PRIMARY_ITEM_ID 

                            AND ORGANIZATION_ID = &pOrg)H1 ,

                ---END INLINE HIRARCHY

                APPS.CST_ITEM_COST_TYPE_V CIT,

                Mtl_system_items msi

            WHERE H1.INVENTORY_ITEM_ID = CIT.INVENTORY_ITEM_ID

            AND H1.ORGANIZATION_ID = CIT.ORGANIZATION_ID

            AND MSI.ORGANIZATION_ID = CIT.ORGANIZATION_ID

            AND MSI.INVENTORY_ITEM_ID = H1.INVENTORY_ITEM_ID

Sql query to get po details in oracle apps

SELECT ph.segment1 po_num, ph.creation_date, hou.NAME "Operating Unit",

        ppx.full_name "Buyer Name", ph.type_lookup_code "PO Type",

        plc.displayed_field "PO Status", ph.comments, pl.line_num,

        plt.order_type_lookup_code "Line Type", msi.segment1 "Item Code",

        pl.item_description, pl.unit_meas_lookup_code "UOM",

        pl.base_unit_price, pl.unit_price, pl.quantity,

        ood.organization_code "Shipment Org Code",

        ood.organization_name "Shipment Org Name", pv.vendor_name supplier,

        pvs.vendor_site_code, (pl.unit_price * pl.quantity) "Line Amount",

        prh.segment1 req_num, prh.type_lookup_code req_method,

        ppx1.full_name "Requisition requestor"

   FROM po_headers_all ph,

        po_lines_all pl,

        po_distributions_all pda,

        po_vendors pv,

        po_vendor_sites_all pvs,

        po_distributions_all pd,

        po_req_distributions_all prd,

        po_requisition_lines_all prl,

        po_requisition_headers_all prh,

        hr_operating_units hou,

        per_people_x ppx,

        mtl_system_items_b msi,

        po_line_types_b plt,

        org_organization_definitions ood,

        per_people_x ppx1,

        po_lookup_codes plc

  WHERE 1 = 1

    AND ph. vendor_id = pv.vendor_id

    AND PH.ORG_ID=:P_ORG_ID

    AND ph.po_header_id = pl.po_header_id

    AND ph.vendor_site_id = pvs.vendor_site_id

    AND ph.po_header_id = pd.po_header_id

    AND pl.po_line_id = pd.po_line_id

    AND pd.req_distribution_id = prd.distribution_id(+)

    AND prd.requisition_line_id = prl.requisition_line_id(+)

    AND prl.requisition_header_id = prh.requisition_header_id(+)

    AND hou.organization_id = ph.org_id

    AND ph.agent_id = ppx.person_id

    AND pda.po_header_id = ph.po_header_id

    AND pda.po_line_id = pl.po_line_id

    AND pl.line_type_id = plt.line_type_id

    AND ood.organization_id = pda.destination_organization_id

    AND ppx1.person_id(+) = prh.preparer_id

    AND pda.destination_organization_id = msi.organization_id(+)

    AND msi.inventory_item_id = NVL (pl.item_id, msi.inventory_item_id)

    AND plc.lookup_type = 'DOCUMENT STATE'

    AND plc.lookup_code = ph.closed_code