List of files in Linux to be stored in Oracle database table

 We can use external table as below:

CREATE TABLE GLFILESLIST

(

  FILE_NAME  VARCHAR2(1000 BYTE)

)

ORGANIZATION EXTERNAL

  (  TYPE ORACLE_LOADER

     DEFAULT DIRECTORY CONC_OUT_DIR

     LOCATION (CONC_OUT_DIR:'glFilesList.dat')

  )

REJECT LIMIT UNLIMITED;

In Linux shell:

ls -ltrA gl_import | awk '{print $9}'| tail -n +2   > glFilesList.dat

We can put the above command to refresh the list based on 5 minutes frequency as below:

*/5 * * * *  ls -ltrA gl_import | awk '{print $9}'| tail -n +2   > glFilesList.dat

The output will be stored in glFilesList.dat and later will be a source for the table

EBS R12.2 Granting privileges on an object may cause object invalidation's in the current edition(Use AD_ZD.GRANT_PRIVS Only)

 To Grant:

SQL> exec AD_ZD.grant_privs('SELECT', 'FND_USER', 'XXUSER');

PL/SQL procedure successfully completed.

To Revoke:

SQL> exec AD_ZD.revoke_privs('SELECT', 'FND_USER', 'XXUSER');

ORA-04065: not executed, altered or dropped package body ORA-06508: PL/SQL: could not find program unit being called

 

Issue:1:

" sql-2 excepitpon  of sql+   ORA-04068: existing state of packages has been discarded

ORA-04061: existing state of package body "CTEST.ADMC_OTL_UTIL_PKG" has been invalidated

ORA-04065: not executed, altered or dropped package body "CTEST.ADMC_OTL_UTIL_PKG"

" - restart the application  

 

Issue:2:

exception: ORA-06508: PL/SQL: could not find program unit being called

- increase the connection pool in SOA Console