Oracle Solutions

 

We develop solutions for our clients using:  JDeveloper, Developer 2000 Suite, Oracle Workflow, Oracle BI Publisher, Oracle PL/SQL, Oracle Application Framework, EBS, Web ADI, EBS & E-Business Suite.

JDeveloper:  is an integrated development environment (IDE) developed by Oracle.  The main features of JDeveloper are that it offers functionalities for development in Java, JavaScript, SQL, PL/SQL, HTML, XML, PHP & BPEL.

Developer 2000 Suite:  is a client | server application development system.  It integrates programs from Oracle Forms, Oracle Reports, Oracle Graphics & Oracle Discoverer for inquiries.

Oracle Workflow:  manages business processes according to the rules that are defined.  Rules are what we call a workflow process definition, including the activities that occur in the process and the relationship between those activities.

Oracle BI Publisher:  is a web tool that allows the creation, management and distribution of reports quickly and easily.  It's as an embedded product within the Oracle Business Intelligence Suite or can be used as a stand-alone product.  This tool allows us to offer information from different systems based on heterogeneous technologies  SQL Queries, Web Services Queries, Excel & XML Databases ... to serve as a basis for our analytic activities.

Oracle SQL:  a graphical tool to develop, or simply to execute SQL queries or scripts, both DML and DDL, on the basis of Oracle data.

Oracle PL/SQL:  are Cloud ONLY Oracle Database Schema Service scripts to load data from external generic web services, to retrieve and upload data from other cloud services such as Oracle's Fusion Cloud or Salesforce.com.  The API can be called from PL | SQL code created using the SQL Workshop which is a robust developer tool used to create easy-to-remember front-end applications for executing complex database operations.

Oracle Application Framework (OAF):  is a proprietary framework for customizations in application development within the Oracle E-Business Suite (EBS).

Web ADI:  stands for Applications Desktop Integrator, it's an Excel-based interface through which users can upload and view data in Oracle.  To access the database, users must use their standard Oracle username and password.

Data Load Oracle EBS:  Data PayLoad refers to the component of ETL.   Once the data is retrieved and combined from various sources, cleaned, and formatted, it's uploaded to a storage system, such as a cloud data warehouse.  ETL aids in the data integration process by standardizing diverse and disparate data types so that they are available for query, manipulation, or reporting to many different people and teams.  As today's organizations increasingly rely on their own data to make smarter and faster business decisions, ETL must be scalable and optimized to deliver the greatest benefit.

We provide Oracle solutions in these areas:  Financials, Human Resources, Management in Process | Manufacturing | Inventory | Purchasing | Quality | Sales & Product Technology.