Compute and Set Interactive Grid Column Value Oracle Apex

Set / Get Interactive Grid Column Value Master Detail Form Oracle Apex 1) Assign Static Id to Column (that will be update by command) and use it's id in following commands. in my example P4_ITEM_VALUE is Static Id of Item Value Column.


2) Write Dynamic action and call this JavaScript apex.item( "P4_ITEM_VALUE").setValue(apex.item('P4_RATE').getValue()*apex.item('P4_QUANTITY').getValue());

Set / Get Interactive Grid Column Value Master Detail Form Oracle Apex

1) Assign Static Id to Column (that will be update by command) and use it's id  in following commands.

in my example P4_ITEM_VALUE is Static Id of Item Value Column. 

2) Write Dynamic action and call this JavaScript

var salary = apex.item( "P4_ITEM_VALUE"); 

salary.setValue(100);

or 

apex.item( "P4_ITEM_VALUE").setValue(10);

Oracle DDL with EXECUTE IMMEDIATE -- Drop Multiple Object at once

If You want to Drop Multiple Object at once use this script. Please using

This script check cursor query and take update of your database

/* Formatted on 3/31/2020 1:40:01 am (QP5 v5.139.911.3011) */

DECLARE

   CURSOR OBJECTLIST

   IS

      SELECT    'Drop '

             || OBJECT_TYPE

             || '  '

             || OWNER

             || '.'

             || OBJECT_NAME

             || ''

                DROPCOMMAND

        FROM ALL_OBJECTS

       WHERE OWNER = 'APPS' AND OBJECT_NAME LIKE 'EBA%';

BEGIN

   FOR LDX IN OBJECTLIST

   LOOP

      DBMS_OUTPUT.PUT_LINE (TO_CHAR (LDX.DROPCOMMAND));

      BEGIN

         EXECUTE IMMEDIATE LDX.DROPCOMMAND;

         DBMS_OUTPUT.PUT_LINE ('Object has been dropped.');

      EXCEPTION

         WHEN OTHERS

         THEN

            DBMS_OUTPUT.

            PUT_LINE (

                  SQLERRM

               || ' While performing this Command,'

               || TO_CHAR (LDX.DROPCOMMAND));

      END;

   END LOOP;

END;

select 'Drop '||OBJECT_TYPE||'  '||OWNER||'.'||OBJECT_NAME||';'

from all_objects

where owner='APPS'

AND OBJECT_NAME LIKE 'EBA%'

Import DMP file from one schema to another

imp FILE=D:\dmpFile.dmp FULL=N fromuser=fromUser touser=ToUser LOG=D:\LOG.TXT



imp FILE=D:\25mar2020.dmp FULL=N fromuser=apps touser=pos LOG=D:\LOG.TXT

change tablespace of table Oracle

Runtime this Query and Move one table space to other.

SELECT 'ALTER TABLE <SCHEMA>.' || TABLE_NAME ||' MOVE TABLESPACE '||' <TABLESPACE_NAME> ' FROM dba_tables WHERE OWNER = '<SCHEMA>' AND TABLESPACE_NAME <> '<TABLESPACE_NAME>'


SELECT 'ALTER TABLE POS.' || TABLE_NAME ||' MOVE TABLESPACE '||' POS ' FROM dba_tables WHERE OWNER = 'POS'

Command :

ALTER TABLE POS.APPS_CATALOG_HEADER MOVE TABLESPACE  POS 

Java File.deleteOnExit() method

1. import java.io.File;  
2. import java.io.IOException;  
3. public class DeleteOnExitExample  
4. {  
5. public static void main(String[] args)  
6. {  
7. File temp;  
8. try  
9. {  
10. temp = File.createTempFile("abc", ".temp");     //creating a .temp file  
11. System.out.println("Temp file created at location: " + temp.getAbsolutePath());      
12. temp.deleteOnExit();                     //delete file on runtime exit  
13. System.out.println("Temp file exists : " + temp.exists());  
14. }   
15. catch (IOException e)  
16. {  
17. e.printStackTrace();  
18. }  
19. }  
20. }  

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

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