You are browsing the archive for Oracle Application Object Library.

Backup/Restore CBO Statistics

 

NAME: Backup/Restore CBO Statistics
SHORT CODE: FNDBKRST
MODULE: Oracle Application Object Library

Description: Backup/Restore CBO Statistics To/From the Stat table.
Navigation: Oracle Application Object Library Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • Action : Choose Action
  • Schemaname : Schema Name
  • Tablename : Table Name
  • Stattab : Statistics Table Name
  • Statid : Statistic Id

 

AuditTrail Report for Audit Group Validation

 

NAME: AuditTrail Report for Audit Group Validation
SHORT CODE: FNDATRPT
MODULE: Oracle Application Object Library

Description: Report for Audit Group Validation
Navigation: Oracle Application Object Library Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • GROUP_NAME : Audit Group Name
  • PROGNM : Audit Trail Report Program Name

 

Audit Trail Report

 

NAME: Audit Trail Report
SHORT CODE: FNDATREP
MODULE: Oracle Application Object Library

Description: Audit Trail Report
Navigation: Oracle Application Object Library Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • P_REP_ID : Report ID
  • P_AUDIT_GROUP : Audit Group
  • P_TABLE_NAME : Table Name
  • P_USERNAME : User Name
  • P_TRANS_TYPE : Transaction Type
  • P_FROM_DATE : From Date
  • P_TO_DATE : To Date