Technology
It is all about the proper setup of the Oracle Tools. Oracle EBS build with the below tools, and hence in need of sample code, the most complex code is available in Oracle EBS. It is the repository of the complexity. Here the topics discussed are normal procedures for Oracle EBS, and not limited to the same. Prerequisite for the Oracle Tools is right version of Java SDK. Of course most of our basic need is Microsoft Office. Microsoft office is basic requirement for BI Publisher, and OUM Templates, and CEMLI Tracker.

Basic tools required for Oracle EBS are

  • Oracle Developer Suite for Forms and Reports
  • Workflow Builder
  • SQL Developer to query the database
  • JDeveloper with OAF Components for OAF or ADF Page developments
  • BI Publisher Desktop, and if needed Spreadsheet Add-on
  • FTP and Terminal Windows softwares if needed
Before installing Developer Suite, Workflow Builder, OAF or BI Publisher please verify the right version of the software with respect to the Oracle EBS. RICE Elements are Reports, Interfaces, Conversion and Enhancements. Further enhancements can be classified as extension, customization, and personalization.

Workflow Builder is also needed to do any modification in the Oracle EBS workflow. Common enhancements are made in Requisition Approval Workflow, PO Approval Workflow, OM Order Header, and OM Order Lines.

In Quality Modules, custom actions can be triggered to make call Workflow and Oracle Alerts, Setting default values, and validations.

Before proceeding any changes in the standard Oracle EBS, all the future consequences should be studied. Even though extensions and personalization are supported by Oracle, future patching, and upgrade process may cause the rework in the custom objects.