Update file to server OAF java

    public void uploadFileToServer(OAPageContext pageContext,String fileName,BlobDomain pBlobDomain)
    {
 
    try
    {
     File file = new File("/opt/apps/apps_st/comn/temp", fileName);
     FileOutputStream output =  new FileOutputStream(file);
    for (int bytes = 0; bytes < pBlobDomain.getLength(); bytes++)
    {
    output.write(pBlobDomain.getInputStream().read());
    }
    System.out.println(" file writing");
        output.close();
    }
    catch (Exception e)
    {
    e.printStackTrace();
    throw new OAException(e.getMessage(),OAException.ERROR);
    }
 
        throw new OAException(("file size:"+pBlobDomain.getLength()),OAException.ERROR);
    }

Difference between account alias receipt and miscellaneous receipt

Miscellaneous receipt:- This is one of the Transaction type of the Inventory.
When we want to increase the Stock of the Item in the Oracle inventory but we have no purchase order against that then we can directly receive the Inventory items in some Subinvnetory using Inventory Open Miscellaneous Transactions form with using Transaction type of ‘Miscellaneous receipts’ .Transaction Type is very Important In this. We also need to enter the GL Account Combination to which this Item Material Should be charged.

 Less User-friendly as compered to  Account alias receipt

Account alias receipt: This is also one of the Transaction type of the Inventory. Account alias receipt is almost similar like the Miscellaneous receipt in oracle. They also uses to Increate the Stock of the Item in Subinvnetory without having Requirment of Open Purchase order. But the Only Difference between   Miscellaneous receipt and Account alias receipt is that , In Miscellaneous receipt , We need to remember the complete GL Account Combination to which this Item Material Should be charged but in the Account alias receipt we can use the GL Account Combination aliases which we have already created in the GL so that we don’t need to remember the complete account. Account alias is the user friendly name of the GL account combination that helps non finance user to easily remember the names instead of entire gl account combination to which material should be charged.

 

More User-friendly as compered to  Miscellaneous receipt.

How to access APEX application from other Computer

If you want to access/operate Apex application from other computer then Case 1 applicable Otherwise if you want locally then Case 2 applicable.

Case 1. URL : http://ComputerName:Port/apex
or http://IPaddress:Port/apex

Case 2. URL : http://localhost:/apex

For Case 1 if you are not able to access the application then have to enable network access true.
To do so, you have to log on as SYS with SYSDBA privilege and execute the following command.

execute dbms_xdb.setListenerLocalAccess(l_access => FALSE);

Just copy the above command and paste into your SQL Editor and execute. After scuccessfull execution of the above command, if the remote computer name is ABC and apex access port 8080 then your url will be as bellow-

http://abc:8080/apex

If the remote computer IP is 119.18.144.201 and apex access port 8080 then your url will be as bellow-

http://119.18.144.201:8080/apex

load Files to Database Oracle

Upload-Files-to-Database-Oracle

This library is the first step of our journey to build java based utilities, Use this and report if found Bug.

Setup for Installation

Install OAF and configure its envirnoment as per your Oracle E-Buisness Suite.

Open This project in Oracle JDeveloper

Generate java Classes and configure to EBS Application. After this you will be able to upload files.

Source Link: Upload-Files-to-Database-Oracle

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