ENGINATICS
SYSTEM_ADMINISTRATOR
SYSADMIN
AE8D7268AD3904D2E0530100007F2786
FND Audit Additional Info Table (audit table dependent)
Y
select distinct
y.table_name value,
null description
from
(
select
ft.table_name,
fpkc.primary_key_id,
fc.column_name,
max(nvl2(x.column_name,null,'Y')) over (partition by fpkc.primary_key_id) column_missing
from
fnd_tables ft,
fnd_primary_key_columns fpkc,
fnd_columns fc,
(
select
fc0.column_name
from
fnd_tables ft0,
fnd_audit_columns fac,
fnd_columns fc0
where
ft0.table_name=:$flex$.audit_table and
ft0.table_id=fac.table_id and
ft0.application_id=fac.table_app_id and
fac.schema_id=-1 and
fac.table_app_id=fc0.application_id and
fac.table_id=fc0.table_id and
fac.column_id=fc0.column_id
) x
where
ft.table_name<>:$flex$.audit_table and
ft.application_id=fpkc.application_id and
ft.table_id=fpkc.table_id and
fpkc.application_id=fc.application_id and
fpkc.table_id=fc.table_id and
fpkc.column_id=fc.column_id and
fc.column_name=x.column_name(+)
) y
where
y.column_missing is null
order by
y.table_name
US
A790D197B7482C46E0530100007F95AF
FND Audit Table
Y
select distinct
ft.table_name value,
ft.user_table_name description
from
fnd_tables ft,
fnd_audit_tables fat,
fnd_audit_groups fag
where
ft.table_id=fat.table_id and
ft.application_id=fat.table_app_id and
fat.audit_group_app_id=fag.application_id and
fat.audit_group_id=fag.audit_group_id and
fat.state in ('E','G','N') and
fag.state in ('E','G','N')
order by
ft.table_name
AR
تم تمكين جداول FND حاليًا للتدقيق
D
FND-Tabellen, die derzeit für das Auditing freigegeben sind
E
Tablas FND actualmente habilitadas para la auditoría
F
Tableaux FND actuellement habilités pour l'audit
I
Tabelle FND attualmente abilitate all'auditing
JA
現在、監査のために使用されているFNDテーブル
KO
현재 감사를 위해 활성화 된 FND 테이블
PTB
Tabelas FND atualmente preparadas para auditoria
RU
Таблицы ФНД, позволяющие в настоящее время проводить одитинг
S
FND-tabeller som för närvarande är godkända för granskning
TR
Şu anda denetim için etkinleştirilen FND tabloları
US
FND tables currently enabed for auditing
ZHS
目前用于审计的FND表。
AE999C5FFF4A756BE0530100007FE9B7
FND Columns (audit info table dependent)
Y
select distinct
fc.column_name value,
fc.user_column_name description
from
fnd_tables ft,
fnd_columns fc
where
ft.table_name=:$flex$.additional_info_table and
ft.application_id=fc.application_id and
ft.table_id=fc.table_id
order by
fc.column_name
US
AE999A20C5877767E0530100007F7707
FND Columns (audit table dependent)
Y
select distinct
fc.column_name value,
fc.user_column_name description
from
fnd_tables ft,
fnd_columns fc
where
ft.table_name=:$flex$.audit_table and
ft.application_id=fc.application_id and
ft.table_id=fc.table_id
order by
fc.column_name
US
8E2FF36EDE8479D2E0530100007F1FF2
FND User Name
Y
Y
select
fu.user_name value,
trim(coalesce(
trim(papf.first_name||' '||papf.last_name),
fu.description,
fu.email_address,
papf.email_address
)||fu.inactive) description
from
(select case when sysdate between fu.start_date and nvl(fu.end_date,sysdate) then null else ' (inactive)' end inactive, fu.* from fnd_user fu) fu,
(select papf.* from per_all_people_f papf where sysdate between papf.effective_start_date and papf.effective_end_date) papf,
(
select distinct
furg.user_id,
count(*) over (partition by furg.user_id) resp_count,
max(fr.responsibility_key) over (partition by furg.user_id) max_responsibility_key
from
fnd_responsibility fr,
fnd_user_resp_groups_direct furg
where
fr.responsibility_id=furg.responsibility_id and
fr.application_id=furg.responsibility_application_id
) furg
where
fu.employee_id=papf.person_id(+) and
fu.user_id=furg.user_id(+) and
not (furg.resp_count=1 and furg.max_responsibility_key='IRC_EXT_CANDIDATE')
order by
fu.inactive desc,
fu.user_name
US
FND user names, excluding iRecruitment candidates.
A790D194F1302B5BE0530100007F1E26Y
select
:audit_table audit_table,
xxen_util.client_time(aud_a.audit_timestamp) audit_timestamp,
xxen_util.meaning(aud_ac1.audit_transaction_type,'FND_AUDIT_TRANS_TYPE',0) audit_transaction_type,
xxen_util.user_name(aud_ac1.audit_user_name) audit_transaction_user,
&sel_xinfo_table_user_cols
&sel_table_user_cols
&sel_audit_key_cols
&sel_audit_cols
to_char(aud_a.row_key) audit_row_key,
aud_a.audit_session_id,
aud_a.audit_sequence_id,
aud_a.audit_commit_id
from
&from_tables
where
aud_a.row_key=aud_ac1.row_key and
&join_audit_tab_key_cols
&join_xinfo_table_key_cols
1=1
order by
aud_a.row_key desc
/*&dummy*/
AR
FND Audit Table Changes by Record
الإبلاغ عن جميع التغييرات على جدول تطبيق مدقق.
يحتوي التقرير على صف واحد لكل معاملة تدقيق يعرض القيم القديمة والجديدة لجميع الأعمدة التي تم تدقيقها في صف واحد.
D
FND Audit Table Changes by Record
Meldet alle Änderungen an einer geprüften Anwendungstabelle.
Der Bericht enthält eine Zeile pro Audit-Transaktion, in der die alten und neuen Werte für alle geprüften Spalten in einer einzigen Zeile angezeigt werden.
E
FND Audit Table Changes by Record
Informa de todos los cambios en una tabla de aplicación auditada.
El informe tiene una fila por transacción de auditoría que muestra los valores antiguos y nuevos de todas las columnas auditadas en una sola fila.
F
FND Audit Table Changes by Record
Rapporte tous les changements à un tableau de demande vérifié.
Le rapport comporte une ligne par opération d'audit, indiquant les anciennes et les nouvelles valeurs pour toutes les colonnes contrôlées sur une seule ligne.
I
FND Audit Table Changes by Record
Riporta tutte le modifiche a una tabella di applicazione controllata.
Il rapporto ha una riga per transazione di audit che mostra i valori vecchi e nuovi per tutte le colonne sottoposte ad audit in una singola riga.
JA
FND Audit Table Changes by Record
監査されたアプリケーションテーブルへのすべての変更をレポートします。
レポートは、監査トランザクションごとに1行で、すべての監査済みカラムの新旧の値を1行で表示します。
KO
FND Audit Table Changes by Record
감사 된 애플리케이션 테이블에 대한 모든 변경 사항을보고합니다.
보고서에는 감사 트랜잭션 당 하나의 행이 있으며 단일 행의 모든 감사 열에 대한 이전 값과 새 값을 보여줍니다.
PTB
FND Audit Table Changes by Record
Relata todas as mudanças em uma tabela de aplicação auditada.
O relatório tem uma linha por transação de auditoria mostrando os valores antigos e novos para todas as colunas auditadas em uma única linha.
RU
FND Audit Table Changes by Record
Сообщает обо всех изменениях в таблице проверенных приложений.
В отчете одна строка на каждую аудиторскую операцию, показывающую старое и новое значения для всех проверяемых столбцов в одной строке.
S
FND Audit Table Changes by Record
Rapporterar alla ändringar i en granskad applikationstabell.
Rapporten har en rad per granskningstransaktion som visar de gamla och nya värdena för alla granskade kolumner i en rad.
TR
FND Audit Table Changes by Record
Tüm değişiklikleri denetlenmiş bir uygulama tablosuna raporlar.
Rapor, denetlenen tüm sütunların eski ve yeni değerlerini tek bir satırda gösteren bir denetim işlemi başına bir satıra sahiptir.
US
FND Audit Table Changes by Record
Reports all changes to an audited application table.
The report has one row per audit transaction showing the old and new values for all audited columns in a single row.
ZHS
FND Audit Table Changes by Record
报告经审核的申请表格的所有变化。
报告中每个审计事务有一行，在一行中显示所有审计列的旧值和新值。
Enginatics
&dummy
&from_tables
&join_audit_tab_key_cols
&join_xinfo_table_key_cols
&sel_audit_cols
&sel_audit_key_cols
&sel_table_user_cols
&sel_xinfo_table_user_cols
1=1
:audit_table
1
10
:audit_table
LOV
FND Audit Table
A790D197B7482C46E0530100007F95AF
Y
select distinct
ft.table_name value,
ft.user_table_name description
from
fnd_tables ft,
fnd_audit_tables fat,
fnd_audit_groups fag
where
ft.table_id=fat.table_id and
ft.application_id=fat.table_app_id and
fat.audit_group_app_id=fag.application_id and
fat.audit_group_id=fag.audit_group_id and
fat.state in ('E','G','N') and
fag.state in ('E','G','N')
order by
ft.table_name
Y
F
Table d'audit
US
Audit Table
2
&from_tables
select
lower(
substr(:audit_table,1,24)||'_a aud_a,'||chr(10)||
substr(:audit_table,1,24)||'_ac1 aud_ac1,'||chr(10)||
:audit_table||' tab'
) text
from dual
F
Table d'audit
US
Audit Table
3
&join_audit_tab_key_cols
select
case when fc.null_allowed_flag='Y' and fc.primary_key_sequence>1 then
'nvl(aud_a.'||fc.column_name||','||decode(fc.column_type,'D','sysdate','N','-99','''x''')||')=nvl(aud_ac1.'||fc.column_name||','||decode(fc.column_type,'D','sysdate','N','-99','''x''')||') and'||chr(10)||
'nvl(aud_a.'||fc.column_name||','||decode(fc.column_type,'D','sysdate','N','-99','''x''')||')=nvl(tab.'||fc.column_name||'(+)'||','||decode(fc.column_type,'D','sysdate','N','-99','''x''')||') and' else
'aud_a.'||fc.column_name||'=aud_ac1.'||fc.column_name||' and'||chr(10)||
'aud_a.'||fc.column_name||'=tab.'||fc.column_name||'(+) and'
end text
from (
select distinct
lower(fc.column_name) column_name,
fac.sequence_id,
fc.column_type,
fc.null_allowed_flag,
fpkc.primary_key_sequence
from
fnd_tables ft,
fnd_audit_tables fat,
fnd_audit_columns fac,
fnd_columns fc,
fnd_primary_key_columns fpkc
where
ft.table_name=:audit_table and
ft.application_id=fat.table_app_id and
ft.table_id=fat.table_id and
fat.state in('E','G','N') and
fat.table_id=fac.table_id and
fat.table_app_id=fac.table_app_id and
fac.state='K' and
fac.sequence_id>=0 and
fac.table_app_id=fc.application_id and
fac.table_id=fc.table_id and
fac.column_id=fc.column_id and
fc.application_id=fpkc.application_id and
fc.table_id=fpkc.table_id and
fc.column_id=fpkc.column_id
order by
fac.sequence_id
) fc
F
Table d'audit
US
Audit Table
4
&sel_audit_cols
select
'case when aud_a.'||fc.column_name||' is null and nvl(substr(aud_a.audit_true_nulls,'||to_char(fc.sequence_id+1)||',1),''N'')=''N'' then null else aud_a.'||fc.column_name||' end old_'||substr(fc.column_name,1,26)||',
case aud_a.audit_transaction_type when ''D'' then null when ''I'' then aud_ac1.'||fc.column_name||' else case when aud_a.'||fc.column_name||' is null and nvl(substr(aud_a.audit_true_nulls,'||to_char(fc.sequence_id+1)||',1),''N'')=''N'' then null else aud_ac1.'||fc.column_name||' end end new_'||substr(fc.column_name,1,26)||',' columns
from
(
select distinct
lower(fc.column_name) column_name,
fac.sequence_id
from
fnd_tables ft,
fnd_audit_tables fat,
fnd_audit_columns fac,
fnd_columns fc
where
ft.table_name=:audit_table and
ft.application_id=fat.table_app_id and
ft.table_id=fat.table_id and
fat.state in('E','G','N') and
fat.table_app_id=fac.table_app_id and
fat.table_id=fac.table_id and
fac.state='N' and
fac.sequence_id>=0 and
fac.table_app_id=fc.application_id and
fac.table_id=fc.table_id and
fac.column_id=fc.column_id
order by fac.sequence_id
) fc
F
Table d'audit
US
Audit Table
5
&sel_table_user_cols
select distinct
'tab.'||lower(fc.column_name)||','
from
xxen_report_parameters_tl xrpt,
xxen_report_run_param_values xrrpv,
fnd_tables ft,
fnd_columns fc
where
xrpt.parameter_name='Informational Audit Table Columns' and
xrpt.language='US' and
xrpt.parameter_id=xrrpv.parameter_id and
xrrpv.run_id=:run_id and
xrrpv.value is not null and
ft.table_name=:audit_table and
ft.application_id=fc.application_id and
ft.table_id=fc.table_id and
not exists (select null from fnd_audit_columns fac where fc.application_id=fac.table_app_id and fc.table_id=fac.table_id and fc.column_id=fac.column_id and fac.state='K') and --exclude key columns. these are always displayed anyway
instr(':'||translate(replace(replace(xrrpv.value,'<multiple_values>',null),chr(10),':'),',;:|','::::')||':',':'||fc.column_name ||':')>0
order by 1
F
Table d'audit
US
Audit Table
6
20
1=1
aud_a.audit_timestamp>=:date_from
DateTime
F
Date de l'audit Du
US
Audit Date From
7
30
1=1
aud_a.audit_timestamp<=:date_to
DateTime
F
Date de l'audit au
US
Audit Date To
8
40
1=1
aud_a.audit_user_name=:audited_user
LOV
FND User Name
8E2FF36EDE8479D2E0530100007F1FF2
Y
Y
select
fu.user_name value,
trim(coalesce(
trim(papf.first_name||' '||papf.last_name),
fu.description,
fu.email_address,
papf.email_address
)||fu.inactive) description
from
(select case when sysdate between fu.start_date and nvl(fu.end_date,sysdate) then null else ' (inactive)' end inactive, fu.* from fnd_user fu) fu,
(select papf.* from per_all_people_f papf where sysdate between papf.effective_start_date and papf.effective_end_date) papf,
(
select distinct
furg.user_id,
count(*) over (partition by furg.user_id) resp_count,
max(fr.responsibility_key) over (partition by furg.user_id) max_responsibility_key
from
fnd_responsibility fr,
fnd_user_resp_groups_direct furg
where
fr.responsibility_id=furg.responsibility_id and
fr.application_id=furg.responsibility_application_id
) furg
where
fu.employee_id=papf.person_id(+) and
fu.user_id=furg.user_id(+) and
not (furg.resp_count=1 and furg.max_responsibility_key='IRC_EXT_CANDIDATE')
order by
fu.inactive desc,
fu.user_name
F
Utilisateur vérifié
US
Audited User
9
60
&dummy
x=:dummy1
LOV
FND Columns (audit table dependent)
AE999A20C5877767E0530100007F7707
Y
select distinct
fc.column_name value,
fc.user_column_name description
from
fnd_tables ft,
fnd_columns fc
where
ft.table_name=:$flex$.audit_table and
ft.application_id=fc.application_id and
ft.table_id=fc.table_id
order by
fc.column_name
F
Colonnes du tableau d'audit informatif
US
Informational Audit Table Columns
10
70
:additional_info_table
LOV
FND Audit Additional Info Table (audit table dependent)
AE8D7268AD3904D2E0530100007F2786
Y
select distinct
y.table_name value,
null description
from
(
select
ft.table_name,
fpkc.primary_key_id,
fc.column_name,
max(nvl2(x.column_name,null,'Y')) over (partition by fpkc.primary_key_id) column_missing
from
fnd_tables ft,
fnd_primary_key_columns fpkc,
fnd_columns fc,
(
select
fc0.column_name
from
fnd_tables ft0,
fnd_audit_columns fac,
fnd_columns fc0
where
ft0.table_name=:$flex$.audit_table and
ft0.table_id=fac.table_id and
ft0.application_id=fac.table_app_id and
fac.schema_id=-1 and
fac.table_app_id=fc0.application_id and
fac.table_id=fc0.table_id and
fac.column_id=fc0.column_id
) x
where
ft.table_name<>:$flex$.audit_table and
ft.application_id=fpkc.application_id and
ft.table_id=fpkc.table_id and
fpkc.application_id=fc.application_id and
fpkc.table_id=fc.table_id and
fpkc.column_id=fc.column_id and
fc.column_name=x.column_name(+)
) y
where
y.column_missing is null
order by
y.table_name
F
Tableau d'informations supplémentaires
US
Additional Info Table
11
&from_tables
select ','||chr(10)||lower(:additional_info_table)||' xtab' from dual
F
Tableau d'informations supplémentaires
US
Additional Info Table
12
&join_xinfo_table_key_cols
select
z.text
from
(
select
min(y.primary_key_id) over () min_primary_key_id,
y.primary_key_id,
y.primary_key_sequence,
' '||chr(10)||lower(y.text) text
from
(
select
ft.table_name,
fpkc.primary_key_id,
fpkc.primary_key_sequence,
case when fc.null_allowed_flag='Y' and fpkc.primary_key_sequence>1 then
'nvl(tab.'||fc.column_name||','||decode(fc.column_type,'D','sysdate','N','-99','''x''')||')=nvl(xtab.'||fc.column_name||'(+)'||','||decode(fc.column_type,'D','sysdate','N','-99','''x''')||') and' else
'tab.'||fc.column_name||'=xtab.'||fc.column_name||'(+) and'
end text,
max(nvl2(x.column_name,null,'Y')) over (partition by fpkc.primary_key_id) column_missing
from
fnd_tables ft,
fnd_primary_key_columns fpkc,
fnd_columns fc,
(
select
fc0.column_name
from
fnd_tables ft0,
fnd_audit_columns fac,
fnd_columns fc0
where
ft0.table_name=:audit_table and
ft0.table_id=fac.table_id and
ft0.application_id=fac.table_app_id and
fac.schema_id=-1 and
fac.table_app_id=fc0.application_id and
fac.table_id=fc0.table_id and
fac.column_id=fc0.column_id
) x
where
ft.table_name=:additional_info_table and
ft.application_id=fpkc.application_id and
ft.table_id=fpkc.table_id and
fpkc.application_id=fc.application_id and
fpkc.table_id=fc.table_id and
fpkc.column_id=fc.column_id and
fc.column_name=x.column_name(+)
) y
where
y.column_missing is null
) z
where
z.primary_key_id=z.min_primary_key_id
order by
z.primary_key_sequence
F
Tableau d'informations supplémentaires
US
Additional Info Table
13
&sel_xinfo_table_user_cols
select distinct
'xtab.'||lower(fc.column_name)||' "'||substr(:additional_info_table||'.'||fc.column_name,1,xxen_report.max_column_length)||'",'
from
xxen_report_parameters_tl xrpt,
xxen_report_run_param_values xrrpv,
fnd_tables ft,
fnd_columns fc
where
xrpt.parameter_name='Additional Info Table Columns' and
xrpt.language='US' and
xrpt.parameter_id=xrrpv.parameter_id and
xrrpv.run_id=:run_id and
xrrpv.value is not null and
ft.table_name=:additional_info_table and
ft.application_id=fc.application_id and
ft.table_id=fc.table_id and
instr(':'||translate(replace(replace(xrrpv.value,'<multiple_values>',null),chr(10),':'),',;:|','::::')||':',':'||fc.column_name ||':')>0
F
Tableau d'informations supplémentaires
US
Additional Info Table
14
80
&dummy
x=:dummy2
LOV
FND Columns (audit info table dependent)
AE999C5FFF4A756BE0530100007FE9B7
Y
select distinct
fc.column_name value,
fc.user_column_name description
from
fnd_tables ft,
fnd_columns fc
where
ft.table_name=:$flex$.additional_info_table and
ft.application_id=fc.application_id and
ft.table_id=fc.table_id
order by
fc.column_name
F
Colonnes du tableau d'informations supplémentaires
US
Additional Info Table Columns
:$flex$.additional_info_table
Additional Info Table
Additional Info Table Columns
:$flex$.audit_table
Audit Table
Additional Info Table
:$flex$.audit_table
Audit Table
Informational Audit Table Columns