For PL/SQL PrOgram Coding

For PL/SQL PrOgram Coding

Finding the path Means AP/AR/GL

select variable_name, value

from   fnd_env_context

where  variable_name like '%\_TOP' escape '\'

and    concurrent_process_id =

     ( select max(concurrent_process_id) from fnd_env_context )

order by 1

/

col variable_name format a15

col value format a64

select variable_name, value

from   fnd_env_context

where  variable_name like '%\_TOP' escape '\'

and    concurrent_process_id =

     ( select max(concurrent_process_id) from fnd_env_context )

order by 1;

VARIABLE_NAME   VALUE

--------------- ----------------------------------------------------------------

AD_TOP          /d01/oracle/VIS/apps/apps_st/appl/ad/12.0.0

AF_JRE_TOP      /d01/oracle/VIS/apps/tech_st/10.1.3/appsutil/jdk/jre

AHL_TOP         /d01/oracle/VIS/apps/apps_st/appl/ahl/12.0.0

AK_TOP          /d01/oracle/VIS/apps/apps_st/appl/ak/12.0.0

ALR_TOP         /d01/oracle/VIS/apps/apps_st/appl/alr/12.0.0

AME_TOP         /d01/oracle/VIS/apps/apps_st/appl/ame/12.0.0

AMS_TOP         /d01/oracle/VIS/apps/apps_st/appl/ams/12.0.0

AMV_TOP         /d01/oracle/VIS/apps/apps_st/appl/amv/12.0.0

AMW_TOP         /d01/oracle/VIS/apps/apps_st/appl/amw/12.0.0

APPL_TOP        /d01/oracle/VIS/apps/apps_st/appl

AP_TOP          /d01/oracle/VIS/apps/apps_st/appl/ap/12.0.0

AR_TOP          /d01/oracle/VIS/apps/apps_st/appl/ar/12.0.0

Who deleted the data and commited

SELECT NAME, value FROM v$parameter WHERE NAME LIKE 'audit%';
SQL> SELECT NAME, value FROM v$parameter WHERE NAME LIKE 'audit%';
NAME
----------------------------------------------------------------------
VALUE
----------------------------------------------------------------------
audit_sys_operations
FALSE
audit_file_dest
E:\ORACLE\PRODUCT\10.2.0\ADMIN\XP10R2JAN\ADUMP
audit_trail
DB
The audit is being done to the DB
SQL> desc dba_audit_trail;
SELECT userid, action#, STATEMENT, OBJ$NAME, To_Char (timestamp#, 'mm/dd/yyyy hh24:mi:ss')
FROM sys.aud$ ORDER BY timestamp# asc;

Apps World

Apps World

For PL/SQL PrOgramming

For PL/SQL PrOgramming

Good For Onaccount AR

Good For Onaccount AR

Good For Theory

Good For Theory