Oracle Apps RICEW Component

RICEW Component

sql & plsql
Module Knowledge(Flow)
RICEW Component

Reports
========
--Oracle RDF reports
--Oracle XML reports
Oracle Discovery Reports
--Oracle PL SQL Reports

Interface
=========
--Flate file -->(sql loader)(Inbound) --> Staging table
--Staging table --> (PL Sql with Validation)--> Interface tables
--Interface tables--> (Standard CP) --> Base Tables

Conversion
==========
--Staging table (For Data Store and error)
--Sql Loader for data load
--utl files  for data load
--write procedure to validate and load data to interface table.
--run standard program to transfer data to base table

Extensions
==========
Oracle New Form Development
--Oracle Form Customization
--Oracle Form Personalization
--Using Custom.pll to meet the requirement.

Work Flow
==========
Creating new workflow.
Customizing existing workflow.