{"id":1706,"date":"2016-05-09T21:21:12","date_gmt":"2016-05-10T02:21:12","guid":{"rendered":"https:\/\/bijoos.com\/oraclenotes\/?p=1706"},"modified":"2016-05-09T21:21:12","modified_gmt":"2016-05-10T02:21:12","slug":"ebs-r12-1-3-post-upgrade-invalid-objects","status":"publish","type":"post","link":"https:\/\/bijoos.com\/oraclenotes\/2016\/1706\/","title":{"rendered":"EBS R12.1.3 Post-upgrade Invalid Objects"},"content":{"rendered":"<p>It is common to have many new invalid objects after an EBS upgrade, and many DBAs take it as the new norm. I think a little bit of research can help to clean out the invalid objects &#8211; in fact most of the custom objects that are invalid are pretty much unused by the application and can be dropped right away (take a backup of the code).<\/p>\n<p>We can drop many seeded objects also. Here is a list of invalid seeded objects we found after an EBS upgrade, and related MOS notes identifying them as not needed for application functionality in\u00a0EBS\u00a012.1.<\/p>\n<ul>\n<li>Drop ARP_DDREMIT_FMT_PKG &#8211; Refer to Doc ID 1534108.1<\/li>\n<li>Drop AP_CCE_BANK_UPGRADE &#8211; Refer to BUG 9679899<\/li>\n<li>Drop CSE_PROJ_TRANSFER_PKG &#8211; Refer to Doc ID 1098989.1<\/li>\n<li>Drop CZ_IMP_SINGLE_DEBUG &#8211; Refer to Doc ID 398525.1<\/li>\n<li>Drop EGO_DEMO_PUB &#8211; Refer to Doc ID 2079240.1<\/li>\n<li>Drop FA_JOURNALS_PKG &#8211; Refer to Doc ID 1078410.1<\/li>\n<li>Drop GL_BALANCE_FIX &#8211; Refer to Doc ID 1540767.1<\/li>\n<li>Drop OE_CREDIT_CARD_MIGRATE_UTIL &#8211; Refer to Doc ID 603741.1<\/li>\n<li>Drop OKS_CCENCRYPTION_PKG &#8211; Refer to Doc ID 413213.1<\/li>\n<li>Drop PA_AP_XFER_PKG &#8211; Refer to Doc ID 1674338.1<\/li>\n<li>Drop ZPB_BUILD_METADATA &#8211; Refer to Doc ID 1951646.1<\/li>\n<li>Drop view GMF_END_PRD_HLTH_CHK_MAIN_V &#8211; Refer to Doc ID 1954028.1<\/li>\n<li>Follow the instructions in &#8220;APPS.MSC_DEMANTRA_PKG PACKAGE WILL NOT COMPILE (Doc ID 1067492.1&#8221; to make MSC_DEMANTRA_PKG valid<\/li>\n<li>Package body AP_PAYMENT_EVENT_WF_PKG do not have package definition. Follow instructions in &#8220;PACKAGE APPEWFPB.PLS MISSING AFTER THE UPGRADE TO 12.1.1 (Doc ID 1180533.1)&#8221;<\/li>\n<li>Follow the instructions in &#8221; Unable to Compile WMS_EPC_PVT get &#8216;MGD_IDCOMPONENT_VARRAY&#8217; Must be Declared Error (Doc ID 1070991.1&#8243; to make WMS_EPC_PVT valid.<\/li>\n<\/ul>\n<p>There may be more depending on the patches applied and modules enabled in your database. Do a search with the invalid object name on <a href=\"https:\/\/support.oracle.com\/\">MOS<\/a>. Most likely you will find a note.<\/p>\n<p>Hope this helps&#8230;<\/p>\n<p>B<\/p>\n","protected":false},"excerpt":{"rendered":"<p>It is common to have many new invalid objects after an EBS upgrade, and many DBAs take it as the new norm. I think a little bit of research can help to clean out the invalid objects &#8211; in fact most of the custom objects that are invalid are pretty much unused by the application &#8230; <a title=\"EBS R12.1.3 Post-upgrade Invalid Objects\" class=\"read-more\" href=\"https:\/\/bijoos.com\/oraclenotes\/2016\/1706\/\" aria-label=\"Read more about EBS R12.1.3 Post-upgrade Invalid Objects\">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":[],"class_list":["post-1706","post","type-post","status-publish","format-standard","hentry","category-ebs"],"acf":[],"jetpack-related-posts":[{"id":211,"url":"https:\/\/bijoos.com\/oraclenotes\/2013\/211\/","url_meta":{"origin":1706,"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":3211,"url":"https:\/\/bijoos.com\/oraclenotes\/2026\/3211\/","url_meta":{"origin":1706,"position":1},"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":73,"url":"https:\/\/bijoos.com\/oraclenotes\/2013\/73\/","url_meta":{"origin":1706,"position":2},"title":"EBS Clone Considerations &#8211; Database Refresh","author":"Biju","date":"June 15, 2013","format":false,"excerpt":"When doing database refresh for EBS databases, the following steps may save time on completing the clone faster... Copy the code relevant to your environment to a file and run the script file prior to the clone to save the configuration information. Once database refresh completed, you may restore the\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":3195,"url":"https:\/\/bijoos.com\/oraclenotes\/2026\/3195\/","url_meta":{"origin":1706,"position":3},"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":3192,"url":"https:\/\/bijoos.com\/oraclenotes\/2026\/3192\/","url_meta":{"origin":1706,"position":4},"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":3213,"url":"https:\/\/bijoos.com\/oraclenotes\/2026\/3213\/","url_meta":{"origin":1706,"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\/1706","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=1706"}],"version-history":[{"count":0,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/1706\/revisions"}],"wp:attachment":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/media?parent=1706"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/categories?post=1706"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/tags?post=1706"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}