{"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_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":[],"class_list":["post-1706","post","type-post","status-publish","format-standard","hentry","category-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\/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}]}}