{"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":"<div dir=\"ltr\" trbidi=\"on\">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&#8230; There may be more, but these should be scheduled on the EBS to keep the instance performing healthy&#8230; The arguments and run interval may need to be modified to suit the workload and business requirement&#8230; but this will get you started&#8230; Few jobs may need multiple scheduling with different parameters&#8230;<\/p>\n<p><span>Job \u00a0 \u00a0 \u00a0 : Gather Schema   Statistics\u00a0<\/span><br \/><span>Executable: FNDGSCST\u00a0<\/span><br \/><span>Frequency : Daily\u00a0<\/span><br \/><span>Parameters: ALL, 10, , NOBACKUP, , LASTRUN, GATHER   AUTO, , N\u00a0<\/span><br \/><span>Frequency : Weekly\u00a0<\/span><br \/><span>Parameters: ALL, 10, 4, NOBACKUP, , LASTRUN, GATHER, , Y \u00a0<\/span><br \/><span><br \/><\/span><br \/><span>Job \u00a0 \u00a0 \u00a0 :<\/span><span>\u00a0<\/span><span>JTF Item InterMedia   Index Optimizing operation<\/span><br \/><span>Executable:<\/span><span>\u00a0JTFOPTI\u00a0<\/span><br \/><span>Frequency :<\/span><span>\u00a0Weekly\u00a0<\/span><br \/><span>Parameters:<\/span><span>\u00a0FULL, 2\u00a0<\/span><br \/><span><br \/><\/span><br \/><span>Job \u00a0 \u00a0 \u00a0 :\u00a0<\/span><span>JTF Item InterMedia Index Sync Operation<\/span><br \/><span>Executable:<\/span><span>\u00a0JTFSYNC\u00a0<\/span><br \/><span>Frequency :<\/span><span>\u00a0<\/span><span>Weekly\u00a0<\/span><br \/><span>Parameters:<\/span><span>\u00a0(None)\u00a0<\/span><br \/><span><br \/><\/span><br \/><span>Job \u00a0 \u00a0 \u00a0 :\u00a0<\/span><span>MES InterMedia Index Sync Operation<\/span><br \/><span>Executable:<\/span><span>\u00a0AMVSYNC\u00a0<\/span><br \/><span>Frequency :<\/span><span>\u00a0Weekly\u00a0<\/span><br \/><span>Parameters:<\/span><span>\u00a0(None)\u00a0<\/span><br \/><span><br \/><\/span><br \/><span>Job \u00a0 \u00a0 \u00a0 :\u00a0<\/span><span>OCM InterMedia Index Synchronizing for   Attribute Bundles\u00a0<\/span><br \/><span>Executable:<\/span><span>\u00a0IBCSYNCATTR\u00a0<\/span><br \/><span>Frequency :<\/span><span>\u00a0Weekly\u00a0<\/span><br \/><span>Parameters:<\/span><span>\u00a0(None)\u00a0<\/span><br \/><span><br \/><\/span><br \/><span>Job \u00a0 \u00a0 \u00a0 :<\/span><span>\u00a0Purge Debug Log and System Alerts   FNDLGPRG\u00a0<\/span><br \/><span>Frequency :<\/span><span>\u00a0<\/span><span>Weekly\u00a0<\/span><br \/><span>Parameters:<\/span><span>\u00a0(<\/span><span>Date &#8211; 30 days)<\/span><br \/><span><br \/><\/span><br \/><span>Job \u00a0 \u00a0 \u00a0 :<\/span><span>\u00a0Purge FND_STATS History Records\u00a0<\/span><br \/><span>Executable:<\/span><span>\u00a0FNDPGHST\u00a0<\/span><br \/><span>Frequency :<\/span><span>\u00a0<\/span><span>Weekly\u00a0<\/span><br \/><span>Parameters:<\/span><span>\u00a0DATE, 01-Jan-00, 30-JUN-11\u00a0<\/span><br \/><span><br \/><\/span><br \/><span>Job \u00a0 \u00a0 \u00a0 :<\/span><span>\u00a0Purge Obsolete Generic File Manager Data\u00a0<\/span><br \/><span>Executable:<\/span><span>\u00a0FNDGFMPR   Daily\u00a0<\/span><br \/><span>Parameters:<\/span><span>\u00a0Y, ,\u00a0      <\/span><br \/><span><br \/><\/span><br \/><span>Job \u00a0 \u00a0 \u00a0 :<\/span><span>\u00a0<\/span><span>Purge Obsolete Workflow Runtime Data   FNDWFPR\u00a0<\/span><br \/><span>Frequency :<\/span><span>\u00a0<\/span><span>Weekly<\/span><br \/><span>Parameters:<\/span><span>\u00a0, , 60, PERM, N, 500, N             Weekly   , , 60, TEMP, N, 500, N\u00a0<\/span><br \/><span><br \/><\/span><br \/><span>Job \u00a0 \u00a0 \u00a0 :<\/span><span>\u00a0Purge Signon Audit data   FNDSCPRG\u00a0<\/span><br \/><span>Frequency :<\/span><span>\u00a0<\/span><span>Weekly\u00a0<\/span><br \/><span>Parameters:<\/span><span>\u00a0(<\/span><span>Date &#8211; 60 days)<\/span><br \/><span><br \/><\/span><br \/><span>Job \u00a0 \u00a0 \u00a0 :\u00a0<\/span><span>Workflow Agent Activity Statistics   Concurrent Program  \u00a0<\/span><br \/><span>Executable:\u00a0<\/span><span>FNDWFAASTATCC\u00a0<\/span><br \/><span>Frequency :<\/span><span>\u00a0<\/span><span>Daily\u00a0<\/span><br \/><span>Parameters:<\/span><span>\u00a0(None)\u00a0<\/span><br \/><span><br \/><\/span><br \/><span>Job \u00a0 \u00a0 \u00a0 :<\/span><span>\u00a0Workflow Background Process\u00a0<\/span><br \/><span>Executable:<\/span><span>\u00a0FNDWFBG\u00a0<\/span><br \/><span>Frequency :<\/span><span>\u00a012 HOURS\u00a0<\/span><br \/><span>Parameters:<\/span><span>\u00a0, , , N, N, Y\u00a0<\/span><br \/><span>Frequency :<\/span><span>\u00a01 HOUR<\/span><br \/><span>Parameters:<\/span><span>\u00a0, , , N, Y, N\u00a0<\/span><br \/><span>Frequency :<\/span><span>\u00a05 MINUTES\u00a0<\/span><br \/><span>Parameters:<\/span><span>\u00a0, , , Y, N, N\u00a0<\/span><br \/><span><br \/><\/span><br \/><span>Job \u00a0 \u00a0 \u00a0 :<\/span><span>\u00a0Workflow Control Queue Cleanup\u00a0  <\/span><br \/><span>Executable:\u00a0<\/span><span>FNDWFBES_CONTROL_QUEUE_CLEANUP\u00a0<\/span><br \/><span>Frequency :<\/span><span>\u00a0<\/span><span>\u00a012 HOURS\u00a0<\/span><br \/><span>Parameters:<\/span><span>\u00a0(None)\u00a0<\/span><br \/><span><br \/><\/span><br \/><span>Job \u00a0 \u00a0 \u00a0 :<\/span><span>\u00a0Workflow Directory Services User\/Role   Validation<\/span><br \/><span>Executable:<\/span><span>\u00a0FNDWFDSURV\u00a0<\/span><br \/><span>Frequency :<\/span><span>\u00a0<\/span><span>Daily\u00a0<\/span><br \/><span>Parameters:\u00a0<\/span><span>10000, Y, Y, Y\u00a0<\/span><br \/><span><br \/><\/span><br \/><span>Job \u00a0 \u00a0 \u00a0 :<\/span><span>\u00a0Workflow Mailer Statistics Concurrent   Program<\/span><br \/><span>Executable:<\/span><span>\u00a0FNDWFMLRSTATCC\u00a0<\/span><br \/><span>Frequency :<\/span><span>\u00a0<\/span><span>Daily\u00a0<\/span><br \/><span>Parameters:<\/span><span>\u00a0(None)\u00a0<\/span><br \/><span><br \/><\/span><br \/><span>Job \u00a0 \u00a0 \u00a0 :<\/span><span>\u00a0Workflow Work Items Statistics Concurrent   Program<\/span><br \/><span>Executable:<\/span><span>\u00a0FNDWFWITSTATCC\u00a0<\/span><br \/><span>Frequency :<\/span><span>\u00a0<\/span><span>Daily\u00a0<\/span><br \/><span>Parameters:<\/span><span>\u00a0(None) \u00a0<\/span><br \/><span><br \/><\/span><br \/><span>Enjoy!<\/span><br \/><span><br \/><\/span><\/div>\n","protected":false},"excerpt":{"rendered":"<p>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&#8230; There may be more, but these should be scheduled on the &#8230; <a title=\"Oracle EBS Housekeeping Jobs\" class=\"read-more\" href=\"https:\/\/bijoos.com\/oraclenotes\/2011\/11\/\" aria-label=\"Read more about Oracle EBS Housekeeping Jobs\">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_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_hide_featured_image":false,"_jetpack_featured_image_duplicate_dismissed":0,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"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-related-posts":[{"id":211,"url":"https:\/\/bijoos.com\/oraclenotes\/2013\/211\/","url_meta":{"origin":11,"position":0},"title":"MOS Docs to Review for EBS DB Upgrade to 11gR2 (Latest Patch Release)","author":"Biju","date":"October 7, 2013","format":false,"excerpt":"If you are considering Oracle database upgrade from 9i\/10g to 11gR2 or applying release patches (11.2.0.1 to 11.2.0.3 or 11.2.0.4), several issues can be avoided by applying the recommended patches and PSU. \u00a0And if you are not on the latest 11gR2 release (11.2.0.3 or 11.2.0.4), I strongly recommend getting there,\u2026","rel":"","context":"In &quot;Oracle Database&quot;","block_context":{"text":"Oracle Database","link":"https:\/\/bijoos.com\/oraclenotes\/category\/oracledb\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":3195,"url":"https:\/\/bijoos.com\/oraclenotes\/2026\/3195\/","url_meta":{"origin":11,"position":1},"title":"Part 1: The EBS Cloud Reality Check \u2014 Why &#8220;Lift and Shift to VMs&#8221; Doesn&#8217;t Work for ERP","author":"biju.thomas","date":"March 15, 2026","format":false,"excerpt":"Managing Oracle E-Business Suite (EBS) is challenging, particularly with cloud migration due to licensing complexities, rigid VM sizing, and co-location requirements. EBS relies on interconnected systems that necessitate low-latency environments. Oracle Database@Azure addresses these issues by offering managed services on Exadata infrastructure, allowing for cohesive migration without excessive costs. Smaller\u2026","rel":"","context":"In &quot;Multi-Cloud &amp; Hybrid&quot;","block_context":{"text":"Multi-Cloud &amp; Hybrid","link":"https:\/\/bijoos.com\/oraclenotes\/category\/multicloud-hybrid\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2026\/02\/ODBA-Part1-Cover.png?fit=1200%2C800&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2026\/02\/ODBA-Part1-Cover.png?fit=1200%2C800&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2026\/02\/ODBA-Part1-Cover.png?fit=1200%2C800&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2026\/02\/ODBA-Part1-Cover.png?fit=1200%2C800&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2026\/02\/ODBA-Part1-Cover.png?fit=1200%2C800&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":2043,"url":"https:\/\/bijoos.com\/oraclenotes\/2013\/2043\/","url_meta":{"origin":11,"position":2},"title":"Active or Recently Used Printers in Oracle EBS","author":"Biju","date":"April 17, 2013","format":false,"excerpt":"Recently had a request from one of the admins for list of printers used in the EBS application and how many jobs are directed to a printer. The following SQL provided what the admin needed, thought a good one to share... select distinct fcr.printer, fu.user_name,\u00a0 \u00a0 \u00a0 \u00a0 \u00a0fu.description, count(*)\u2026","rel":"","context":"In &quot;Oracle E-Business Suite&quot;","block_context":{"text":"Oracle E-Business Suite","link":"https:\/\/bijoos.com\/oraclenotes\/category\/ebs\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":3192,"url":"https:\/\/bijoos.com\/oraclenotes\/2026\/3192\/","url_meta":{"origin":11,"position":3},"title":"The Last Datacenter Exit: Migrating Oracle E-Business Suite to Azure with Database@Azure","author":"biju.thomas","date":"March 15, 2026","format":false,"excerpt":"For years, \u201cAzure-first\u201d organizations had a last holdout in their cloud portfolio: Oracle E-Business Suite (EBS). While web apps, data platforms, and modern microservices moved to Azure with relative ease, EBS often stayed behind\u2014tethered to the real-world economics of Oracle licensing, workload sizing, and the unforgiving performance requirements of a\u2026","rel":"","context":"In &quot;Multi-Cloud &amp; Hybrid&quot;","block_context":{"text":"Multi-Cloud &amp; Hybrid","link":"https:\/\/bijoos.com\/oraclenotes\/category\/multicloud-hybrid\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2026\/03\/Migrating-Oracle-E-Business-Suite-to-Azure-1.png?fit=1024%2C1024&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2026\/03\/Migrating-Oracle-E-Business-Suite-to-Azure-1.png?fit=1024%2C1024&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2026\/03\/Migrating-Oracle-E-Business-Suite-to-Azure-1.png?fit=1024%2C1024&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2026\/03\/Migrating-Oracle-E-Business-Suite-to-Azure-1.png?fit=1024%2C1024&ssl=1&resize=700%2C400 2x"},"classes":[]},{"id":3211,"url":"https:\/\/bijoos.com\/oraclenotes\/2026\/3211\/","url_meta":{"origin":11,"position":4},"title":"Part 4: EBS Platform Move \u2014 Unix to Azure Linux with Smaller Cutovers \u2014 Migrating Oracle EBS from Legacy Unix to Oracle Database@Azure","author":"biju.thomas","date":"March 15, 2026","format":false,"excerpt":"Migrating Oracle E-Business Suite (EBS) from legacy Unix systems to Oracle Database@Azure involves overcoming significant challenges due to the Big Endian and Little Endian differences in data storage. Organizations must ensure character set alignment, address custom objects in SYSTEM or SYSAUX tablespaces, and consider encrypted tablespaces early in the process.\u2026","rel":"","context":"In &quot;Multi-Cloud &amp; Hybrid&quot;","block_context":{"text":"Multi-Cloud &amp; Hybrid","link":"https:\/\/bijoos.com\/oraclenotes\/category\/multicloud-hybrid\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2026\/02\/ChatGPT-Image-Feb-28-2026-10_19_06-PM.png?fit=1200%2C800&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2026\/02\/ChatGPT-Image-Feb-28-2026-10_19_06-PM.png?fit=1200%2C800&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2026\/02\/ChatGPT-Image-Feb-28-2026-10_19_06-PM.png?fit=1200%2C800&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2026\/02\/ChatGPT-Image-Feb-28-2026-10_19_06-PM.png?fit=1200%2C800&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2026\/02\/ChatGPT-Image-Feb-28-2026-10_19_06-PM.png?fit=1200%2C800&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":3213,"url":"https:\/\/bijoos.com\/oraclenotes\/2026\/3213\/","url_meta":{"origin":11,"position":5},"title":"Part 5: Picking the Right Database@Azure Service for EBS \u2014 A Decision-Maker&#8217;s Guide to Sizing and Licensing","author":"biju.thomas","date":"March 15, 2026","format":false,"excerpt":"The final part of the series on Oracle Database@Azure focuses on financially optimizing the program through careful selection of service tiers, sizing, and licensing. It highlights the significance of understanding the differences between OCPUs and ECPUs, and the impact of BYOL versus License Included models on costs. Additionally, it discusses\u2026","rel":"","context":"In &quot;Multi-Cloud &amp; Hybrid&quot;","block_context":{"text":"Multi-Cloud &amp; Hybrid","link":"https:\/\/bijoos.com\/oraclenotes\/category\/multicloud-hybrid\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2026\/02\/ChatGPT-Image-Feb-28-2026-11_21_49-PM.png?fit=1200%2C800&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2026\/02\/ChatGPT-Image-Feb-28-2026-11_21_49-PM.png?fit=1200%2C800&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2026\/02\/ChatGPT-Image-Feb-28-2026-11_21_49-PM.png?fit=1200%2C800&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2026\/02\/ChatGPT-Image-Feb-28-2026-11_21_49-PM.png?fit=1200%2C800&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2026\/02\/ChatGPT-Image-Feb-28-2026-11_21_49-PM.png?fit=1200%2C800&ssl=1&resize=1050%2C600 3x"},"classes":[]}],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_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}]}}