44655703 oracle apps rice development basics

8/6/2019 44655703 Oracle Apps RICE Development Basics

1/27

ORACLE APPS RICE

DEVELOPMENT BASICS

Author: Abhijit Ray


2/27

ORACLE PL/SQL CONCURRENTPROGRAMS


3/27


4/27

ORACLE REPORTS


5/27

Oracle Reports5

Oracle Reports is a powerful enterprise reporting tool usedto build reports that dynamically retrieve, format, anddistribute information stored in the database.

It enables you to: Web publish high quality reports.

Perform unlimited data formatting.

Take advantage of application server based reporting.

Meet user needs with an integrated business intelligence solution.

You can create reports in a combination of styles and publishthem in a variety of widely used formats, including HTML andPDF.


6/27

Registering Reports in Oracle

Applications6

1. Develop Oracle Reports in Report Builder

2. Place the .rdf file in the correct directory of your applications basedirectory. (For Example CUS_TOP\11.5.0\reports\US\ .rdfPO_TOP\11.5.0\reports\US\ .rdf )

3. Connect to the Application and select system administrator orApplication Developer Responsibility

4. Define a concurrent program executable.

5. Define your concurrent program.

6. Enter and update the program parameters that you wish to pass to the

report.7. Attach the concurrent program defined to a Request Group.

8. Run the report from Forms or Standard Request Submission.


7/27

Executable Window7


8/27

Concurrent Program Window8


9/27

Concurrent Program Parameter

Window9


10/27

INTERFACE & CONVERSION


11/27

Data Migration and Data Conversion

11

Data Migration can be defined as a process of moving required (and mostoften very large) volumes of data from our clients existing systems to newsystems. Existing systems can be anything from custom-built IT infrastructuresto spreadsheets and standalone databases.

Data conversion can be defined as a process of converting data from onestructural form to another to suit the requirements of the system to which it ismigrated.

Process where existing data from the clients old system is extracted, cleansed,formatted, and installed into a new system.

These can be manual or automated.

The big difference is that these are One-time only process that requiresextensive testing and preparation.

They must be executed and performed before a system goes into production.


12/27

Interface12

Programs for enabling multiple systems to synchronize

data.

Programs can be Manual, Batch or Real-Time.

Programs are used repeatedly

Programs can be triggered by an event (Such as

running a Concurrent Program) or scheduled.


13/27

Interface and Conversion Differences

13

Frequency Conversions are a one time event

Interfaces are ongoing

Occurrence in the project timeline Conversions executed before production go-live

Interfaces executed post production go-live

Manner of execution Conversions are batch processes

Interfaces may be batch process or real time processes

Performance

Conversion programs need to focus on performance as the volume of data is very high. Interfaces programs need to focus on performance as the volume of data is very high

Maintenance Conversions do not need maintenance as these programs are discarded after go-live

Interfaces need maintenance throughout their lifetime


14/27

Types of Interface : Inbound14

An inboundinterface receives data from one system (legacy) and inserts

into Oracle open interface tables.

A typical inbound interface would follow these steps:

Extract data from legacy system into a flat file.

Use SQL*Loader or equivalent tool to upload information into a temporary

table.

Write a PL/SQL program to take data from the temp table and insert into the

Open Interface Tables.

Through the concurrent manager in Oracle Applications, run the standard Oracle

Interface program to transform interface tables into Oracle data.


15/27

Types of Interface : Outbound15

An outbound interface takes data from Oracle tables and

inserts it into an external system (via tables or flat file).

A typical outbound interface would follow these steps:

Write a PL/SQL program to extract data from Oracle base tables into

a flat file.

Use a custom program to read that data and post it into the legacy

system


16/27

Life Cycle of conversion and Interface16


17/27

Standard methods of Interfacing17

Open Interface is a table based interface registered as a concurrent program

process records in batches.

spawned(Pro-C) or PL/SQL based programs.

API (Application Program Interface) is a parameter based stored procedure

directly impacts base database tables. may be called from Oracle open interfaces,Forms, Reports.

EDI (Electronic Data Interchange) uses industry standard datadefinitions(US/ANSI/X.12) for transmission of documents such as POs, Invoices,Sales Order, etc.Oracle provides some EDI transactions through EDI Gateway.

Enterprise Application Integration (EAI) solutions are often used when complexintegration requirements exist.


18/27

Open Interface Table18

For inbound interfaces, the interface table is the

intermediary table where data from the source

application temporarily resides until it is validated and

processed into an Oracle base table through astandard import concurrent program.

Open Interface Tables are standard Oracle tables.

Oracle uses Open Interface tables to provide a simple

interface to Oracle base tables.


19/27

Import Programs19

Most Oracle modules have standard import programs (concurrent processes) to facilitatecustom inbound interfaces. The specific processing performed varies by application.

These programs pull data from the open interface tables, validate the data, and then insertinto one or more Oracle base tables.

Upon successful completion of processing, the program deletes the processed rows from theinterface table or marks them as completed.

Depending on the import, errors can be viewed in various ways (exception reports, errortables, forms, etc).

Examples of standard import programs: GL: Journal Import

AP: Payables Open Interface

AR: Customer Interface

AR - Autoinvoice


20/27

CEMLI


21/27

Overview21

CEMLI is Defined as Configurations,Extensions,Modifications,Localizations and Integrations, all of whichrefer to recommended ways in which the standard oracleapplications solutions could be modified, if required.

CEMLI is Oracles published guidelines for developing andimplementing custom extensions to Oracle Applications.

Oracle defined the CEMLI Framework, which translates into20 classes of extensions that customers can add to theirOracle systems.


22/27

Overview (2)22

Configurations The configuration means you are changing Oracle Applications

processing using profiles options flex fields and folder definitions tocater your requirement.

Typical example is like enabling or disabling flex field.Changing profile

options.

Personalization This is changing the Oracle Applications Forms and framework user

interfaces .

Extension Changing the Oracle Applications Forms and Framework logic

These are typically a program that is in addition to an exiting standardprogram but that does not change core code or objects.


23/27

Customization23

A customization is when an Oracle delivered product component is changed by thecustomer and that change is effected by a patch application or an Applicationupgrade.

Concerning Oracle Applications there are two types of Customizations:

Extensions are components developed using the development features provided byOracle within the E-business Suite. Oracle has provided guidelines and standards forcreating extensions. It is extremely recommended that those are followed; it will certifythat the new objects (extensions) are kept separate from standard E-business components.

Modifications are changes done in the standard E-business suite objects or code. Forexample, A customer creates a database trigger within Oracle Applications database. When customers

follow this approach it is very difficult to identify the changes that have been done in the OracleApplications, and this will affect future upgrades.


24/27

Common extensions on Oracle

eBusiness Suite24

Alerts: Oracle Alerts facilitates the flow of information within a customers organization. Oracleworkflow is used to develop new alerts.

DatabaseObjects: when the functionality is not available in Oracle Applications, it is possible tocreate a set of database objects. If the creation is necessary, it has to be done carefully, once it couldimpact the performance and the integrity of the system.

File Systemand Custom Directory: Create a new directory ($CUSTOM_TOP) and store all thecustomization in there.

Forms: provides a way of populating custom tables. Oracle has provided a guideline for itsimplementation that must be followed. It has to be coded and tested properly; otherwise it can

compromise the data integrity.

Reports: Oracle provides the most usual reports and every company has to develop to their specificformats. Oracle Reports builder is the tool to be used and there are some risks in case of an upgrade.


25/27

Localizations25

Localizations, are extensions consisting of additional forms, reports, or database

objects. The localizations provide the functionality needed to meet the uniquebusiness needs of a region, whether one country or a group of countries.

Localization Directories: For product files, each localization region is treated like a separate product.

Module files are stored in the region

directory trees. The figure illustrates

the directory tree for European localizations

(je). For this directory tree, AutoInstall

sets the environment setting JE_TOP to

#APPL_TOP#\je\11.0.28


26/27

Globalizations26

Globalizations

Globalizations are standard product features being

part of the fresh installation or released via a

Maintenance Pack, and they are available to allcustomers.


27/27

The author would love to get your comments on

abhijit673 @

Thank you27

44655703 oracle apps rice development basics

Documents