EBS R12.1.3 Post-upgrade Invalid Objects

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 – 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).

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 EBS 12.1.

  • Drop ARP_DDREMIT_FMT_PKG – Refer to Doc ID 1534108.1
  • Drop AP_CCE_BANK_UPGRADE – Refer to BUG 9679899
  • Drop CSE_PROJ_TRANSFER_PKG – Refer to Doc ID 1098989.1
  • Drop CZ_IMP_SINGLE_DEBUG – Refer to Doc ID 398525.1
  • Drop EGO_DEMO_PUB – Refer to Doc ID 2079240.1
  • Drop FA_JOURNALS_PKG – Refer to Doc ID 1078410.1
  • Drop GL_BALANCE_FIX – Refer to Doc ID 1540767.1
  • Drop OE_CREDIT_CARD_MIGRATE_UTIL – Refer to Doc ID 603741.1
  • Drop OKS_CCENCRYPTION_PKG – Refer to Doc ID 413213.1
  • Drop PA_AP_XFER_PKG – Refer to Doc ID 1674338.1
  • Drop ZPB_BUILD_METADATA – Refer to Doc ID 1951646.1
  • Drop view GMF_END_PRD_HLTH_CHK_MAIN_V – Refer to Doc ID 1954028.1
  • Follow the instructions in “APPS.MSC_DEMANTRA_PKG PACKAGE WILL NOT COMPILE (Doc ID 1067492.1” to make MSC_DEMANTRA_PKG valid
  • Package body AP_PAYMENT_EVENT_WF_PKG do not have package definition. Follow instructions in “PACKAGE APPEWFPB.PLS MISSING AFTER THE UPGRADE TO 12.1.1 (Doc ID 1180533.1)”
  • Follow the instructions in ” Unable to Compile WMS_EPC_PVT get ‘MGD_IDCOMPONENT_VARRAY’ Must be Declared Error (Doc ID 1070991.1″ to make WMS_EPC_PVT valid.

There may be more depending on the patches applied and modules enabled in your database. Do a search with the invalid object name on MOS. Most likely you will find a note.

Hope this helps…

B

#OTNYathra 2016 – A Diary

OTNYathraYathra simply means travel or journey. OTNYathra did cover many miles! OTNYathra is my first conference tour, organized by Oracle Technology Network. First and foremost, I would like to thank AIOUG and OTN for having me as a speaker, Oracle ACE Program for taking care of my travel and accommodation, and OneNeck IT Solutions for all the support.

The Chennai event was on April 23rd. I reached Chennai on the morning of the 22nd and hence had time to visit Chennai before the conference. Thanks to AIOUG team – Sai and Hari – for taking us to Mamallapuram and showing us around. Had a good time visiting the historic sculptures and temples. The first day’s lunch was superb, and pretty much every day the food was great and I put on a few pounds in a week 🙁

The conference venues were carefully picked. The Chennai event was at the prestigious Loyola-ICAM College of Engineering and Technology (LICET) campus. The volunteers of Chennai AIOUG chapter came early and set everything up and were ready. Kudos to all volunteers, I learned that the Chennai chapter is a very active chapter with regularly organized meetings and conferences. Good job; I am sure Chennai Chapter will produce many Oracle ACEs in the near future.

My two presentations were well received by the Chennai crowd. By the way, Chennai had the largest crowd and the organizers stopped accepting more participants as all seats were sold out. It was a bit tiring to travel to Bengaluru after the Chennai conference and then be ready for Bengaluru conference on Sunday 9 A.M.

The Bengaluru event was at the Symbiosis Institute of Business Management in Electronics City. The main event hall was like a theater. Thanks to all the AIOUG Bengaluru chapter volunteers. After the conference, I took some personal time and visited my sister in Marathahalli.

Monday, April 25th was a day of relaxation and travel. The flight was on time, and we reached Hyderabad by 2 P.M.  We started off our Hyderabad visit by having the famous Hyderabad Biriyani for lunch. The drive to the hotel in HiTec city was quick.  The Hyderabad airport, highway to HitTec city and the hotel were in a different world, totally different world from the normal Hyderabad.  I visited the Golgonda fort and Charminar with the team. It was a great evening.

The Hyderabad event was at the Tech Mahindra Danube Auditorium. It is an excellent high tech facility with big screen projection. I met many friends whom I know only through social media or email. It was very nice of Saurabh Gupta to autograph and present a copy of his most recent book to me. Thank you Satya for taking us shopping and for the delicious dinner.

April 27th was pretty much spent waiting in the airport! The flight was 3+ hours delayed, but I had the opportunity to travel with the Pune IPL team lead by M. S. Dhoni! My sister gave me a surprise by coming to receive me at the airport.

The Pune event was at the Oracle Financial Services Software office. The office is on top of a beautiful hill. We saw a lot of very enthusiastic attendees in Pune. It was kind of sad to leave the OTNYathra without completing the next two cities – Mumbai and Gurgaon, but I had to honor prior commitment and be in Dallas on April 30th evening.

It was a great honor meeting many seasoned speakers, including Chetan Vithlani, Nassyam Basha, Veeratteshwaran Sridhar, Saurabh Gupta, Prabhaker Gongloor, and Satyendra Kumar. I enjoyed the opportunity to connect with the attendees and speakers in all four cities.

I enjoyed the company of Oracle experts and my fellow speakers Connor McDonald and Riyaj Shamsudeen. I’m grateful to the AIOUG organizers Sai, Hariharaputhran and Veeratteshwaran for taking care of all aspects of the Yathra- from airport pickup, taxis, food, site seeing, conference schedule, pretty much all logistics of the conference from the day I landed in Chennai. OTNYathra was an excellent experience! A great technical journey…

Once again, many thanks to AIOUG, Oracle ACE Program, Oracle Technology Network and OneNeck IT Solutions… and thanks to all my session attendees – you are awesome!