List of File Types in : Oracle E-Business Suite

File Type	IDE Used For Development
Forms (.fmb files)	Oracle Forms Developer
Library (.pll files)	Oracle Forms Developer
Reports (.rdf files)	Oracle Report Builder
Java (.class files)	Jdeveloper
Java Server Pages (.jsp files)	Jdeveloper
Oracle Application Framework (OAF) Pages (.xml files)	Jdeveloper – With OA Extension
Oracle Application Framework (OAF) Personalizations (.xml files)	Oracle Ebusiness Instance
Workflow Definition (.wft files)	Oracle Workflow Builder
Workflow Business Event System Object Definitions (.wfx files)	Oracle Workflow Builder
BI Publisher Reports - Layout template formats	MSWord  with BI Publisher Plugin
XML Style Sheets (.xsl files)
XML Publisher PDF templates (.pdf files)
XML Publisher Excel templates (.xls files)
XML Publisher RTF templates (.rtf files)
BI Publisher Reports - Data Definition formats
XML Publisher (XDO) XML (.xml files)
XML Schema Definition (.xsd files)

Product Family Name	Product Family Abbreviation	Product Short names
Applications Technology	ATG	AD, AK, ALR, AZ, BNE, EC, ECX, FND, FRM, IZU, JTF, JTS, SHT, XDO
Projects	PJ	FPA, GMS, IPA, PA, PN
Financials	FIN	AMW, AP, AR, AX, CE, CUA, FA, FUN, FV, GCS, GHG, GL, IA, IBY, IEX, IGC, IGI, IGW, IMC, IPM, ITA, JA, JE, JG, JL, LNS, OKL, PSA, PSB, QRM, RG, XLA, XLE, XTR, ZX
Procurement	PRC	CHV, ICX, PO, POM, PON, POS
Supply Chain Management	SCM	AHL, BOM, CLN, CMI, CRP, CSD, CSE, CSI, CZ, DDD, DDR, DNA, DOM, EAM, EDR, EGO, ENG, FLM, FTE, GMA, GMD, GME, GMF, GMI, GML, GMO, GMP, GR, INL, INV, ITG, JMF, MFG, MRP, MSC, MSD, MSO, MSR, MST, MTH, MWA, OE, OKC, OKE, OKS, OKX, ONT, PJM, QA, QP, QPR, RLM, RRS, SHT, VEA, WIP, WMS, WPS, WSH, WSM, YMS
Human Resources Suite	HRMS	AME, BEN, DT, FF, GHR, HXC, HXT, IRC, OTA, PAY, PER, PQH, PQP, PSP, SSP
Financial Services Applications	FSA	FEM, FTP, PFT, ZFA, ZPB, ZSA
Customer Relationship Management	CRM	AMS, AMV, AS, ASF, ASG, ASL, ASN, ASP, AST, CCT, CN, CS, CSC, CSF, CSL, CSM, CSP, CSR, CUG, DPP, IBC, IBP, IBU, IEB, IEC, IEM, IEO, IES, IEU, JTM, OZF, PRP, PV, QOT, XDP, XNB, XNP

Following is the information from Oracle MOS About Finding the right version of Jdeveloper for Ebiz.

 How to Find the Correct Version of JDeveloper to Use with E-Business Suite 11i or Release 12.x (Doc ID 416708.1)

Release 11i

OA Framework 5.10 patch	Oracle JDeveloper 9i Patch
ATG.PF.H (patch 3438354 or Oracle Applications 11.5.10)	Patch 4045639 9IJDEVELOPER WITH OA EXTENSION ARU FOR FWK.H
ATG PF CU1 (patch 4017300)	Patch 4141787 9IJDEVELOPER WITH OA EXTENSION ARU FOR CU1
ATG PF CU2 (patch 4125550)	Patch 4573517 Oracle9i JDeveloper with OA Extension for 11.5.10 CU2
11i.ATG_PF.H RUP3 (patch 4334965)	Patch 4725670 9IJDEVELOPER WITH OA EXTENSION ARU FOR 11i10 RUP3
11i.ATG_PF.H RUP4 (patch 4676589)	Patch 5455514 9IJDEVELOPER WITH OA EXTENSION ARU FOR 11i10 RUP4
11i.ATG_PF.H RUP5 (patch 5473858)	Patch 6012619 9IJDeveloper With OA Extension ARU FOR 11i10 RUP5
11i.ATG_PF.H.RUP6 (patch 5903765)	Patch 6739235 9IJDeveloper With OA Extension ARU FOR 11i10 RUP6 Patch 6469392 9IJDEVELOPER WITH OA EXTENSION ARU FOR 11I10 RUP6
11i.ATG_PF.H.delta.7 (patch 6241631)	Patch 8751878 9I JDEVELOPER WITH OA EXTENSION ARU FOR 11I RUP7

Release 12.0

ATG Release 12 Version	Oracle JDeveloper 10g Patch
12.0.0	Patch 5856648 10g Jdev with OA Extension
12.0.1  (patch 5907545)	Patch 5856648 10g Jdev with OA Extension
12.0.2  (patch 5484000 or 5917344)	Patch 6491398 10g Jdev with OA Extension ARU for R12 RUP2 (replaces 6197418)
12.0.3  (patch 6141000 or 6077669)	Patch 6509325 10g Jdev with OA Extension ARU for R12 RUP3
12.0.4 (patch 6435000 or 6272680)	Patch 6908968 10G JDEVELOPER WITH OA EXTENSION ARU FOR R12 RUP4
12.0.5 (No new ATG code released)	No new JDev patch required
12.0.6  (patch 6728000 or patch 7237006)	Patch 7523554 10G Jdeveloper With OA Extension ARU for R12 RUP6

Release 12.1

ATG Release 12.1 Version	Oracle JDeveloper 10g Patch
12.1 (Controlled Release - only included for completeness)	Patch 7315332 10G Jdev with OA Extension ARU for R12.1 (Controlled Release)
12.1.1 (rapidInstall or patch 7303030)	Patch 8431482 10G Jdeveloper with OA Extension ARU for R12.1.1
12.1.2 (patch 7303033 or patch 7651091)	Patch 9172975 10G JDEVELOPER WITH OA EXTENSION ARU FOR R12.1.2
12.1.3 (patch 9239090 or patch 8919491)	Patch 9879989 10G JDEVELOPER WITH OA EXTENSION ARU FOR R12.1.3
12.1.3.1 (patch 11894708)	Patch 9879989 10G JDEVELOPER WITH OA EXTENSION ARU FOR R12.1.3
12.1.3.2 (patch 15880118)	Patch 9879989 10G JDEVELOPER WITH OA EXTENSION ARU FOR R12.1.3

Release 12.2

ATG Release 12.2 Version	Oracle JDeveloper 10g Patch
12.2	Patch 17513160 10G JDeveloper with OA Extension ARU for R12.2, certfied on Windows 7, Windows XP-SP2, and Linux. Preferred web browser is Microsoft Internet Explorer 6.0 or above.
12.2.3	Patch 17888411 10G JDeveloper with OA Extension ARU for R12.2.3, certfied on Windows 7, Windows XP-SP2, and Linux. Preferred web browser is Microsoft Internet Explorer 8.0 or above for the Skyros Look-and-Feel and Internet Explorer 6.0 or above for the Swan Look-and-Feel.

Oracle Apps

How to Enable DFF on Lookup

1.Developing Mobile APps using ADF Mobile is easy... i have been following this link : http://docs.oracle.com/cd/E18941_01/tutorials/buildmobileappscontent/adfmobiletutorial_1.html for the same. But the major issue i faced is the deployment issue. At last i solved it by googling..etc.. Following is for your reference.

Java ME CDC : Connected Device Configuration


Strange Behavior in ADF Mobile
Unable to import custom class created in ApplicationController Project to ViewController Project.

Got to know, settings in ViewController should be changed to access the custom classes created in ApplicaitonModule.

Following is the setting :

Right click your ViewController project > Project properties > Dependencies > Select Model and click the pencil. Here you select 'Build output' and press OK twice. Rebuild your application and you should be able to access classes from your model in your viewcontroller.

Facebook Login Sample

How to include FB Social Plugin
Check This Page https://developers.facebook.com/docs/plugins/like-box-for-pages/

Share Button

Comments Plugin

FB Feed FB Feeed

List of Important Links For : Oracle Apps

1. http://www.applikast.net/

Comparing Different Frameworks/Architectures.

For learning any java framework : if we understand the layers carefully it becomes easier for the developer to visualize and implement the application easily.

let me give you some info the different frameworks which iam aware.

AM --> Application Module

PG --> Page File

CO --> Controller File (java)

EO --> Entity Object

VO --> View Object

OAF --> Oracle Application Framework

ADF--> Application Development Framework

JSF--> Java Server Faces

Framework	Technology Used	IDE/Editor Used	MVC ?	Layers -Navigation From FrontEnd to BackEnd
OAF	Java,XML	Jdeveloper9i,Jdeveloper10i	Yes Full MVC	OAFPG-->CO-->AM-->VO(EO)-->DB
ADF	JSF,XML	Jdeveloper9i,Jdeveloper10i,Jdeveloper11i, Jdeveloper12c	Yes Full MVC	ADF(JSFPG)-->CO-->AM-->VO(EO)-->DB(Services{ex:SOA services)
Java Struts	Java	Eclipse, RAD(IBM)	Not Full MVC	JSPPG-->Action&Form-->Services-->DAO-->DB

ADF How to pass the parameter from one page to another.


You can find the source code for the same here:

https://docs.google.com/file/d/0B1HLsOv1s5WFVUlZRjFBeDRRbzQ/edit?usp=sharing

You can find the step by step by Tutorial @ http://www.youtube.com/watch?v=4eyzBiIf5MM

Consider HR Schema for the above sample.

Error While Starting Oracle Service

Error while starting Oracle Service

Execute the below command in DOS prompt

C:\Documents and Settings\sridhar>oradim -STARTUP -SID ORCL -SYSPWD system


Find more info @ http://www.dba-oracle.com/t_start_oracle_windows_services.htm

Configuring Struts on Tomcat 7.*

I used to work on Tomcat 7.* for running JSP pages.

I was not aware not that we can configure Tomcat to run Struts.

I found the below wonderful article which clearly explained how to configure Struts on the Tomcat Server.

http://www.ntu.edu.sg/home/ehchua/programming/java/Struts2.html

Dependent LOV

Concept : when we select a value from one LOV field ,based on that value, another LOV field will show filtered results.

Here, I have used two LOVs: one for PO Headers and another for PO Lines.
So first, user will select a PO Header Id from LOV1.
As we are making these dependent, so LOV2 will show only those PO Lines that are related to PO header Id selected.

1) Create a new OA page:
==========================
Right click on project (xxcus) --> New --> Web Tier --> OA Components --> select 'Page' item. Click OK. (This will open a popup window)
We are creating Dependent LOV page, so specify the details of page as below:
          Name: DependentLovPG
          Package: xxcus.oracle.apps.fnd.dpndntlov.webui

2) Create two new view objects (VO):
==========================

First for PO Headers

Right click (dpndntlov) --> New View Object (This will open a wizard having 7 steps).

Step 1
        Package: xxcus.oracle.apps.fnd.dpndntlov.lov.server
        Name: PoHeaderLovVO
        Choose the radio button 'Read-only Access' (as we are not performing  any DML operation). Click Next.

Step 2
       Enter the below query in 'Query Statement':
    select PO_HEADER_ID from po_headers_all where rownum <50

As there is no need to generate VOImpl/VORowImpl, keep defaults for step3, 4, 5, 6 & 7 and click Finish. Save All.

Second for PO Lines

Right click --> New View Object

Step 1
         Package: xxcus.oracle.apps.fnd.dpndntlov.lov.server
         Name: PoLinesLovVO
         Choose the radio button 'Read-only Access'. Click Next.

Step 2
        Enter the below query in 'Query Statement':
        select PO_HEADER_ID, PO_LINE_ID from po_lines_all

Keep defaults for step3, 4, 5, 6 & 7 and click Finish. Save All.

3) Create a new Application Module (AM):
==========================
Step 1
        Package: xxcus.oracle.apps.fnd.dpndntlov.server
        Name: DependentLovAM. Click Next.

Step 2
        Here we will add an instance of the VOs created in (2).
        Select PoHeaderLovVO & PoLinesLovVO from 'Available View Objects' and shuttle it to 'Data Model' using ">" button.

Keep defaults for all other steps (3, 4). Click Finish.

4) Creating the Page Layout & Setting its Properties:
==========================
1) Create a new region under pageLayout of type defaultSingleColumn.
2) Create 2 items under defaultSingleColumn region (messageLovInput, messageLovInput).

Now change the properties for each field from property inspector as shown below:

pageLayout:
         ID: pageLayoutRN
         AM Definition: xxcus.oracle.apps.fnd.dpndntlov.server.DependentLovAM
         Window Title: Dependent LOV Demo Page
         Title: Dependent LOV Demo

defaultSingleColumn: 
         ID: singleColRN; Text: PO Lines Dependent on PO Header

messageLovInput (for PO Header): 
         ID: poHearderLov
         Prompt: PO Header ID

messageLovInput (for PO Lines):
         ID: poLineLov
         Prompt: PO Line ID
  
Creating LOV regions:

Expand poHearderLov LOV, right click on region1 and create a new region using wizard.

Step 1
select 'DependentLovAM' from Application Module drop down and select 'PoHeaderLovVO1' in available view usages. Click Next.

Step 2
choose region style as 'table' from drop down. Click Next.

Step 3
Shuttle all the fields from available to selected attributes. Click Next.
Also modify the prompt to make it more user friendly (like PO Header ID).

This will create an item 'PoHeaderId' under 'PoHeaderLovVO1' table region.
Set search allowed property to TRUE for the item created.
      lovMap1:
            LOV region item: PoHeaderId
            Return item: poHearderLov
            Criteria item: poHearderLov

Similarly, create LOV region for poLineLov choosing DependentLovAM as AM and PoLinesLovVO1 as view object.
Modify the prompt to PO Lines ID.

This will create 2 items 'PoHeaderId1' & 'PoLineId' under PoLinesLovVO1' table region.
Set search allowed property of 'PoLineId' to TRUE.

      lovMap2:
            LOV region item: PoLineId
            Return item: poLineLov
            Criteria item: poLineLov

Here, in lovMap3, we are making this dependent on first LOV by setting criteria item as value of first LOV field.
      lovMap3:
            LOV region item:PoHeaderId1
            Criteria item: poHearderLov

Now select a value (PO Header Id) from LOV1 such as 4 (as shown in above screenshot).

Perform a search on PO Line ID LOV. This will show only those lines whose header Id is 4.

regards 

Rekha Kasyap .