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