Upload-File-to-Application-Server-Oracle-OAF

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

Source is available here 

GitHub Source

Setup for Installation

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

Read Documentations: Documents.

Open This project in Oracle JDeveloper

OAF Current Row Values

Add Current Row Values in Event Parameters.

Parameters: Open dialog and add parameters by choosing your own Parameter name and its value from current row.

${oa.FileSetupVO1.SrlFileSetupId}

FileSetupVO1 is my view name

SrlFileSetupId is my field from view

FND_PROFILE AND FND_GLOBAL

FND_PROFILE values: 

fnd_profile.value('PROFILEOPTION');
fnd_profile.value'MFG_ORGANIZATION_ID');
fnd_profile.value('ORG_ID');
fnd_profile.value('LOGIN_ID');
fnd_profile.value('USER_ID');
fnd_profile.value('USERNAME');
fnd_profile.value('CONCURRENT_REQUEST_ID');
fnd_profile.value('GL_SET_OF_BKS_ID');
fnd_profile.value('SO_ORGANIZATION_ID');
fnd_profile.value('APPL_SHRT_NAME');
fnd_profile.value('RESP_NAME');
fnd_profile.value('RESP_ID');

FND_GLOBAL values: 

FND_GLOBAL.USER_ID;
FND_GLOBAL.APPS_INTIALIZE;
FND_GLOBAL.LOGIN_ID;
FND_GLOBAL.CONC_LOGIN_ID;
FND_GLOBAL.PROG_APPL_ID;
FND_GLOBAL.CONC_PROGRAM_ID;
FND_GLOBAL.CONC_REQUEST_ID;

How to get Current Row in OAF

We can Get current Row Using findRowByRef method of ApplicationModule.


Here Example Code.


Code of my AM
UploadFileAMImpl am = (UploadFileAMImpl)pageContext.getApplicationModule(webBean);

Code of RowImp
FileSetupVORowImpl setupRow = (FileSetupVORowImpl) am.findRowByRef(pageContext.getParameter(OAWebBeanConstants.EVENT_SOURCE_ROW_REFERENCE)) ; 



findRowByRef is standard method that will return Current Rowimplement
.
Note: Your Action Type must be FireAction. findRowByRef  will return null for firePartialAction.

Get Current Row in OAF Button Event

    private  void DeleteEntryLines(OAPageContext pageContext, OAWebBean webBean)
      {
        EslFaVerifyLinesAllGViewImpl l_linesVO = this.getEslFaVerifyLinesAllGView1();
        EslFaVerifyLinesAllGViewRowImpl l_Lines_Row = (EslFaVerifyLinesAllGViewRowImpl) this.findRowByRef(pageContext.getParameter(OAWebBeanConstants.EVENT_SOURCE_ROW_REFERENCE));
        l_Lines_Row.remove();
      }

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);
    }

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