---------------------------------

Oracle Apps Technical Consultant

---------------------------------
Interfaces, Conversions
-----------------------------------------------
PLSQL, SQL LOADER, Shell Script
-----------------------------------------------
Flat File,
--
Inbound Interface and Conversion
------------------------------------------------
1) Standard Import programs and Interface tables
EX- Item Import, Requisition Import, Order Import, Journal Import
Steps
----
1. If the data is buildin flat file then a SQL LOADER control file[.ctl].
2. Move the control file into XXX1_TOP/bin/
3. Register the executable and executable type {SQL LOADER} and file name is
control file name.
4. Register concurrent program and add that concurrent program to request
group.
5. run the sql loader program and verify the standard interface tables and
error tables[gl_interface, mtl_item_interface]
6. run the Item Import/Journal Import/Order Import [It will validate the
standard validation and load the data into standard base tables]
7. Verify the data from application or back end standard tables.

2) Using Staging or Custom table to add custom add validation

Steps
----
0. Create the custom table in data base and
1. If the data is in flat file then build a SQL LOADER control file[.ctl].
2. Move the control file into XXX1_TOP/bin/
3. Register the executable and executable type {SQL LOADER} and file name is
control file name.
4. Register concurrnt program and add that concurrent program to request
group.
5. run the sql loader program and verify the custom staging tables and error
tables
6. plsql package procedure for custom validations
7. Register PLSQL Executable - excutbale PLSQL Procedure - Register the
concurrent program - add to request group
8. run the PLSQL Program for csutom validations then verify the standard
interface tables [gl_interface, mtl_item_interface]
9. run the Item Import/Jouranl Import/Order Import [It will validate the
standard validation and load the data into standard base tables]
10. Verify the data from application or back end standard tables.

3) using standard API

Steps
----
0. Create the custom table in data base
1. If the data is in flat file then build a SQL LOADER control file[.ctl].
2. Move the control file into XXX1_TOP/bin/
3. Register the executable and executable type {SQL LOADER} and file name is
control file name.
4. Register concurrnt program and add that concurrent program to request
group.
5. run the sql loader program and verify the custom staging tables and error
tables
6. plsql package procedure for custom validations and to insert data into EBS
using standard API
7. Register PLSQL Executable - excutbale PLSQL Procedure - Register the
concurrent program - add to request group
8. run the PLSQL Program for csutom validations then vrify the data from
application or back end standard tables.
-----------------------------------------------
Outbound - UTL_FILE - [Report]
Steps
----
0. create a DBA directory for the custom top server path - where we are going
to create the files.
1. Write a PLSQL package with procedures to create the file, write the data
into file and save file using UTL standard packages.
2. Register PLSQL Executable - excutbale PLSQL Procedure - Register the
concurrent program - add to request group
3. Run the program then go to server path and verfiy the output files

-----------------------------------------------
Reports
------------------------------------------------
XML Publisher, RDF Reports, Discoverer[Admin&Desktop]
------------------------------------------------
1) RDF Report out put type is XML then data definition and template
Steps
----
1. Build the SQL queries for the data in report
2. Build the RDF report
3. Move the RDF Report into server xxx1_top/reports/US/
4. Register the executable and executable type is Oracle Reports and
executbale type is Report name[.rdf file name]
5. Register the concurrent with XML output type
6. Run the sample program and save the XML output into local system
7. Open MS word and go to ADD INS - Load XML data from File - Insert All
Fields - Save the template as .rtf file.
8. Go XML Publisher responsibility - data definitions - give the code as a
concurrent program short name - save
9. Go to Templates - give the code as a data dafinition name - add the
template file[.rtf] from local machine - save
10. Add concurrent program to reuqest group - run the program

2) Data Template [Data Definition File] - XDODTEXE - Concucrrent Program - Data

Definition - Template
Steps
----
1. Build the SQL queries for the data in report
2. Build the .xml data template file
3. Register the concurrent with XML output type and executable should be
XDODTEXE
4. Go XML Publisher responsibility - data definitions - give the code as a
concurrent program short name - add the data template file
5. Run the sample program and save the XML output into local system
6. Open MS word and go to ADD INS - Load XML data from File - Insert All
Fields - Save the template as .rtf file.
7. Go to Templates - give the code as a data dafinition name - add the
template file[.rtf] from local machine - save
8. Add concuurent program to reuqest group - run the program
3) PLSQL we create XML output - Data Defination - Template
Steps
----
1. Build the SQL queries for the data in report
2. Build the PLSQL package with procedure and procedure errorbuf and retcode
4. Register the executable and executbale type plsql procedure and executbale
file name [packagename.procedure]
5. Register the concurrent with XML output type
6. Run the sample program and save the XML output into local system
7. Open MS word and go to ADD INS - Load XML data from File - Insert All
Fields - Save the template as .rtf file.
8. Go XML Publisher responsibility - data definitions - give the code as a
concurrent program short name - save
9. Go to Templates - give the code as a data dafinition name - add the
template file[.rtf] from local machine - save
10. Add concuurent program to reuqest group - run the program
------------------------
Forms
------------------------
------------------------------------------------
Oracle Forms, HTML Pages[JSP,OAF,ADF]
------------------------------------------------
Development of a New Form
Steps
----
1. APPSSTAND.fmb and Template.fmb and entire resource folder [.plls and .plx]
has to copy to local drive.
2. Open Form Builder and Remove the standard objects and add the regions,
fields and logic in triggers
` 3. Save the form file with extension .fmb
4. Move the file to $AU_TOP/forms/US/
5. compile the .fmb using frmcmpl commnad then it will create .fmx
6. Register Form in Application Developer responsibility - then register form
function
7. Add the form function to respective menu, else define new menu and add the
form function
8. run the form

Customize the existing form

Steps
----
1. APPSSTAND.fmb and Template.fmb and entire resource folder [.plls and .plx]
has to copy to local drive.
2. Open Form Builder with existing form then make the change in adding/remove
field, region, button and trigger logic.
` 3. Save the form file with extension .fmb
4. Move the file to $AU_TOP/forms/US/
5. compile the .fmb using frmcmpl commnad then it will create .fmx
6. Register Form in Application Developer responsibility - then register form
function
7. Add the form function to respective menu, else define new menu and add the
form function
8. run the form

Form Personalization
Steps
----
1. Open the form and go to Help - Diagnostics - Custom Code - Personalize -
It will open form personalization window for that form.
 2. Add the personalization header information [Squence, Description about
personalization and make it active]
3. Go to Conditions select the Event and Even on Object then provide
condition and level
4. Go to Actions select the Action type[Property, meesgae, Builtin,MENU] and
do the respective action and save then validate and apply now.
5. Close the form and reopen again to see the effect.
------------------------
Workflow
------------------------------------------------
Approvals, Integrations, AME-Approval Management Engine
------------------------------------------------
Development of a New workflow
Steps
----
1. Open the Workflow Builder and connect to data base.
2. Go to New - New Process - Give the process name ans short name.
3. Add the logic for the process like [Item Attributes, Lookup Types,
messages, notification, functions]
4. Add all the above into process and save the workflow into a file with
extension .wft
5. Move the file into server and run the command WFLDR or save to data base
directly from the wokflow builder client.

Customize the existing workflow

Steps
----
1. Open the Workflow Builder and connect to data base.
2. Go to Open - select the existing Process
3. Add the logic change for the existing process like [Item Attributes,
Lookup Types, messages, notification, functions]
4. Add all the above into process and save the workflow into a file with
extension .wft
5. Move the file into server and run the command WFLDR or save to data base
directly from the wokflow builder client.
------
Wokflow monitoring
-----
Go to workflow Administration resposnibility - Workflow Adiministration - status
monitor - Search with Item Key and based on status - check the error and fix it.
------------------------

------------------------
Alerts
------------------------
Development of a New Alert
Steps
----
1. Go to Alert Manager responsibility - Alert - Define - Select the
application name - give the name of alert - select periodic/Event
2. Add the condition query to fire the alert - verify
3. Add the actions and action details [email to,cc,bcc,subject and body] and
save

Customize the existing Alert

Steps
----
1. Go to Alert Manager responsibility - Alert - Define - Select the
application name - give the name of alert - select periodic/Event
 2. Add the condition query to fire the alert - verify
3. Add the actions and action details [email to,cc,bcc,subject and body] and
save

------------------------
FNDLOAD
------------------------
SQL and PLSQL
------------------------
------------------------
AOL and SYSADMIN
1. Value Sets
2. LOOKUPS
3. Flex Fields [DFF, KFF]
4. Profiles
5. Users
6. Responsibility
7. Applications
8. Form, Function, Menu
9. messages
10.Document categories
11.Custom table registration in Apps [AD_DD]
12.Audit Enable for tables
13.Executables, Concurrent Programs, Reuqest Set, Request Group
14.Data Definitions, Templates, Bursting
15.Business Events
16.Cachieing Framework [Functional Administrator]
17.Concurrent Manager, Logs
------------------------
OAF
------------------------
New OAF page Developerment
Customizing Vo, CO and AM
---------------------------------------------------------
Implementation, Upgrade, Support [Supprot+Customizations]
---------------------------------------------------------

P2P - Procure 2 Pay

------------------------------------------------------
Requistion
Auto Create Option
Purchase Order
Receipt
Invoice
Payment
Transfer to Journal
------------------------------------------------------
O2C - Order 2 Cash
------------------------------------------------------
Order Entered
Order Booked
Pick Release
Ship Confirm
Invoice
Reconsilation
Transfer to GL
===

------------------------------------------------------
P2P - Procure 2 Pay
------------------------------------------------------
Requisition
po_requisition_headers_all
po_requisition_lines_all
po_req_distributions_all
Auto Create Option
Purchase Order
po_headers_all
po_lines_all
po_line_locations_all
po_distributions_all
Receipt
rcv_shipment_headers
rcv_shipment_lines
rcv_transactions
Invoice
ap_invoices_all
ap_invoice_lines_all
ap_invoice_distributions_all
Payment
ap_invoice_payments_all
ap_payment_distributions_all
Transfer to Journal
gl_je_headers
gl_je_lines
gl_je_batches

------------------------------------------------------
O2C - Order 2 Cash
------------------------------------------------------
Order Entered
oe_order_headers_All
Order Booked
oe_order_lines_All
Pick Release
wsh_delivery_details
wsh_delivery_assignments
Ship Confirm
wsh_new_deliveries
Invoice
ra_cutomer_trx_all
ra_cutomer_trx_lines_all
Reconsilation
payments
AR_PAYMENT_SCHEDULES_ALL
Transfer to GL
gl_je_headers
gl_je_lines
gl_je_batches