Including User Defined Functions in SQL Queries

Functions are a great and fun way to implement any functionality in our code. Not only are they easy to code and include almost anywhere we need them, their reusability and the large acceptance of return datatypes make them a coder's superpower.

One of the benefits of user defined functions is that they can be included in sql queries just like any other oracle predefined functions.

Continue reading
  0 Comments

How to register and deploy a new domain under Oracle Weblogic Server in Oracle EBS Environment for a specific application.















Post Weblogic Server Installation, Follow the steps below to create the new domain to deploy EBS apps:

Note: To create new Weblogic domain using GUI, you need to have enabled x11 ssh forwarding in the server and ensure to have any of third party tool like x-shell, humming bird etc.

Continue reading
  0 Comments

fapostimportaad.sql taking too long to complete - R12.2.0 to R12.2.4 upgrade

b2ap3_thumbnail_1.jpg

Issue

Upgrade patch 17919161 is taking very long time to apply (upgrading from R12.2.0 to 12.2.4). It has been already over 2 days but some scripts seem to got hung under the patch.

Continue reading
  0 Comments

Weblogic bsu utility Unable to locate any supported product installations

b2ap3_thumbnail_weblogic_bsu_error.jpg

Issue

Following error is thrown when Weblogic bsu utility gets launched for applying patches:

Continue reading
  0 Comments

Oracle HTTP Server (OHS) instance - adapcctl.sh: exiting with status 204

b2ap3_thumbnail_http_server_error.jpg

Issue

Error while running ADOP cutover phase while applying pre-upgrade AD and TXK Patches (for upgrading from R12.2.0 to 12.2.4)

Continue reading
  0 Comments