{"id":11,"date":"2011-11-21T03:08:00","date_gmt":"2011-11-21T03:08:00","guid":{"rendered":"https:\/\/bijoos.com\/oraclenotes\/?p=11"},"modified":"2026-02-07T15:11:03","modified_gmt":"2026-02-07T21:11:03","slug":"oracle-ebs-housekeeping-jobs","status":"publish","type":"post","link":"https:\/\/bijoos.com\/oraclenotes\/2011\/11\/","title":{"rendered":"Oracle EBS Housekeeping Jobs"},"content":{"rendered":"
For a long time, I searched for a\u00a0comprehensive\u00a0list of housekeeping jobs [Standard EBS jobs provided by Oracle] that should be scheduled periodically on the EBS instance. Since I could not find a single source, came up with my own after a lot of reading… There may be more, but these should be scheduled on the EBS to keep the instance performing healthy… The arguments and run interval may need to be modified to suit the workload and business requirement… but this will get you started… Few jobs may need multiple scheduling with different parameters…<\/p>\n

Job \u00a0 \u00a0 \u00a0 : Gather Schema Statistics\u00a0<\/span>
Executable: FNDGSCST\u00a0<\/span>
Frequency : Daily\u00a0<\/span>
Parameters: ALL, 10, , NOBACKUP, , LASTRUN, GATHER AUTO, , N\u00a0<\/span>
Frequency : Weekly\u00a0<\/span>
Parameters: ALL, 10, 4, NOBACKUP, , LASTRUN, GATHER, , Y \u00a0<\/span>

<\/span>
Job \u00a0 \u00a0 \u00a0 :<\/span>\u00a0<\/span>JTF Item InterMedia Index Optimizing operation<\/span>
Executable:<\/span>\u00a0JTFOPTI\u00a0<\/span>
Frequency :<\/span>\u00a0Weekly\u00a0<\/span>
Parameters:<\/span>\u00a0FULL, 2\u00a0<\/span>

<\/span>
Job \u00a0 \u00a0 \u00a0 :\u00a0<\/span>JTF Item InterMedia Index Sync Operation<\/span>
Executable:<\/span>\u00a0JTFSYNC\u00a0<\/span>
Frequency :<\/span>\u00a0<\/span>Weekly\u00a0<\/span>
Parameters:<\/span>\u00a0(None)\u00a0<\/span>

<\/span>
Job \u00a0 \u00a0 \u00a0 :\u00a0<\/span>MES InterMedia Index Sync Operation<\/span>
Executable:<\/span>\u00a0AMVSYNC\u00a0<\/span>
Frequency :<\/span>\u00a0Weekly\u00a0<\/span>
Parameters:<\/span>\u00a0(None)\u00a0<\/span>

<\/span>
Job \u00a0 \u00a0 \u00a0 :\u00a0<\/span>OCM InterMedia Index Synchronizing for Attribute Bundles\u00a0<\/span>
Executable:<\/span>\u00a0IBCSYNCATTR\u00a0<\/span>
Frequency :<\/span>\u00a0Weekly\u00a0<\/span>
Parameters:<\/span>\u00a0(None)\u00a0<\/span>

<\/span>
Job \u00a0 \u00a0 \u00a0 :<\/span>\u00a0Purge Debug Log and System Alerts FNDLGPRG\u00a0<\/span>
Frequency :<\/span>\u00a0<\/span>Weekly\u00a0<\/span>
Parameters:<\/span>\u00a0(<\/span>Date – 30 days)<\/span>

<\/span>
Job \u00a0 \u00a0 \u00a0 :<\/span>\u00a0Purge FND_STATS History Records\u00a0<\/span>
Executable:<\/span>\u00a0FNDPGHST\u00a0<\/span>
Frequency :<\/span>\u00a0<\/span>Weekly\u00a0<\/span>
Parameters:<\/span>\u00a0DATE, 01-Jan-00, 30-JUN-11\u00a0<\/span>

<\/span>
Job \u00a0 \u00a0 \u00a0 :<\/span>\u00a0Purge Obsolete Generic File Manager Data\u00a0<\/span>
Executable:<\/span>\u00a0FNDGFMPR Daily\u00a0<\/span>
Parameters:<\/span>\u00a0Y, ,\u00a0 <\/span>

<\/span>
Job \u00a0 \u00a0 \u00a0 :<\/span>\u00a0<\/span>Purge Obsolete Workflow Runtime Data FNDWFPR\u00a0<\/span>
Frequency :<\/span>\u00a0<\/span>Weekly<\/span>
Parameters:<\/span>\u00a0, , 60, PERM, N, 500, N Weekly , , 60, TEMP, N, 500, N\u00a0<\/span>

<\/span>
Job \u00a0 \u00a0 \u00a0 :<\/span>\u00a0Purge Signon Audit data FNDSCPRG\u00a0<\/span>
Frequency :<\/span>\u00a0<\/span>Weekly\u00a0<\/span>
Parameters:<\/span>\u00a0(<\/span>Date – 60 days)<\/span>

<\/span>
Job \u00a0 \u00a0 \u00a0 :\u00a0<\/span>Workflow Agent Activity Statistics Concurrent Program \u00a0<\/span>
Executable:\u00a0<\/span>FNDWFAASTATCC\u00a0<\/span>
Frequency :<\/span>\u00a0<\/span>Daily\u00a0<\/span>
Parameters:<\/span>\u00a0(None)\u00a0<\/span>

<\/span>
Job \u00a0 \u00a0 \u00a0 :<\/span>\u00a0Workflow Background Process\u00a0<\/span>
Executable:<\/span>\u00a0FNDWFBG\u00a0<\/span>
Frequency :<\/span>\u00a012 HOURS\u00a0<\/span>
Parameters:<\/span>\u00a0, , , N, N, Y\u00a0<\/span>
Frequency :<\/span>\u00a01 HOUR<\/span>
Parameters:<\/span>\u00a0, , , N, Y, N\u00a0<\/span>
Frequency :<\/span>\u00a05 MINUTES\u00a0<\/span>
Parameters:<\/span>\u00a0, , , Y, N, N\u00a0<\/span>

<\/span>
Job \u00a0 \u00a0 \u00a0 :<\/span>\u00a0Workflow Control Queue Cleanup\u00a0 <\/span>
Executable:\u00a0<\/span>FNDWFBES_CONTROL_QUEUE_CLEANUP\u00a0<\/span>
Frequency :<\/span>\u00a0<\/span>\u00a012 HOURS\u00a0<\/span>
Parameters:<\/span>\u00a0(None)\u00a0<\/span>

<\/span>
Job \u00a0 \u00a0 \u00a0 :<\/span>\u00a0Workflow Directory Services User\/Role Validation<\/span>
Executable:<\/span>\u00a0FNDWFDSURV\u00a0<\/span>
Frequency :<\/span>\u00a0<\/span>Daily\u00a0<\/span>
Parameters:\u00a0<\/span>10000, Y, Y, Y\u00a0<\/span>

<\/span>
Job \u00a0 \u00a0 \u00a0 :<\/span>\u00a0Workflow Mailer Statistics Concurrent Program<\/span>
Executable:<\/span>\u00a0FNDWFMLRSTATCC\u00a0<\/span>
Frequency :<\/span>\u00a0<\/span>Daily\u00a0<\/span>
Parameters:<\/span>\u00a0(None)\u00a0<\/span>

<\/span>
Job \u00a0 \u00a0 \u00a0 :<\/span>\u00a0Workflow Work Items Statistics Concurrent Program<\/span>
Executable:<\/span>\u00a0FNDWFWITSTATCC\u00a0<\/span>
Frequency :<\/span>\u00a0<\/span>Daily\u00a0<\/span>
Parameters:<\/span>\u00a0(None) \u00a0<\/span>

<\/span>
Enjoy!<\/span>

<\/span><\/div>\n","protected":false},"excerpt":{"rendered":"

For a long time, I searched for a\u00a0comprehensive\u00a0list of housekeeping jobs [Standard EBS jobs provided by Oracle] that should be scheduled periodically on the EBS instance. Since I could not find a single source, came up with my own after a lot of reading… There may be more, but these should be scheduled on the … Read more<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[10],"tags":[143,43],"class_list":["post-11","post","type-post","status-publish","format-standard","hentry","category-ebs","tag-concurrent-jobs","tag-ebs"],"acf":[],"jetpack_featured_media_url":"","jetpack-related-posts":[],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/11","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/comments?post=11"}],"version-history":[{"count":1,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/11\/revisions"}],"predecessor-version":[{"id":2966,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/11\/revisions\/2966"}],"wp:attachment":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/media?parent=11"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/categories?post=11"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/tags?post=11"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}