Basics-Apps

 How to find front end url through backend

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

select * from icx_parameters;  ---- http://ebs.example.com:8000/OA_HTML/AppsLogin

select * from fnd_product_groups; --- find the release_name of version R12 EBIZ

select * from V$version;  --- find out the database Version

========================================================================

Type of projects ?

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

it's a development project

get requirement from client and analyze requirement and prepare MD070 and DEVELOP CODE

IN DEV INSTANCE

and working on code migration and unit testing.

working on new development includes reports, interface, conversion and xml publisher reports

Day to day work

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

My role is Technical consultant

my work is day to day IS WORKING ON FINANCE AND SCM MODULES DEVELOPMENT WORK

Like,CUSTOMIZED AR INVOICE REPORT

I worked ON Item conversion

I DEVELOPED SALES ORDER INTERFACE

I DEVELOPED ITEMS INTERFACE

I WORKED ON SUPPLIER AND SITES CONVERSION.

I WORKED ON FORMS PERSONALIZATION ON PO FORM

I WORKED ON GL OUTBOUND INTERFACE TO SEND JOURNAL DATA TO PWC company

=================================================================================================

Abbrevations

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

SRS - Standard Request Submission

FND - Fundation

MD - Module Desgin

AOL - Application Object Library

AIM - Application Implementation Methodology

MD050 - Functional Design Document

MD070 - Technical Desgin Document

MD0120 - Migration Document

TE020 -- Unit Testcase Document

Execution Methods in Oracle Apps

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

There are 12 execution methods in executable.

1.Host

2.PL/SQL Stored procedure

3.Oracle Reports

4.SQL *Loader

5.SQL *Plus

6.Java Stored Procedure

7.Java Concurrent Program

8.Immediate

9.Multi Language Function

10.Spawned

11.Request Set Stage Function

12.Perl  Concurrent Program