You are browsing the archive for Oracle Application Object Library.

Delete Diagnostic Logs

 

NAME: Delete Diagnostic Logs
SHORT CODE: DELDIAGLOG
MODULE: Oracle Application Object Library

Description: Delete Diagnostic log reports from the JTF_DIAGNOSTIC_LOG 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:

  • DAYSEXPIRE : Logs older than this number of days will be deleted
  • APPSHORTNAMES : Space-delimited list of App Short Names that will have their expired logs deleted
  • aborted/longPending : Logs of executions in pending status for long will be purged

 

FND User employee customer fix

 

NAME: FND User employee customer fix
SHORT CODE: AFSCUFIX
MODULE: Oracle Application Object Library

Description: Fixes employee_id and customer_id inside fnd_user 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:

  • class_of_error : class of error that you want to fix
  • action : action to take

 

Rebuild Help Search Index

 

NAME: Rebuild Help Search Index
SHORT CODE: AFLOBBLD
MODULE: Oracle Application Object Library

Description: Purge orphaned help documents and rebuild the interMedia search index
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:

  • APPLSYS schema name : APPLSYS schema name
  • APPS schema name : APPS schema name