Ideas

1. Develop onemillion dollor website like that for oracle links
2. Develop Web ADI for interfaces
3. 
   

OAF Short Keys

1.  type sop and then ctrl enter to get the sop command for debugging
2. type vo. and then ctrl spacebar to get the existing methods
3. project settings => URL Parameters for testing
4. Inside jdev unzip jdev doc for tutorial and sample code
5. 
   

Where to open Inventory Period?
Inventory-->Accounting Close Cycle-->Inventory Accounting Periods

Where to enter quantity for an item?
Create miscellaneous transaction of type 'Account alias receipt' using Inventory-->Transactions--> Miscellaneous transaction

JDeveloper Version for R12.1.x

Find the correct version of JDeveloper

In order to find the correct version of JDeveloper to use with eBusiness Suite 11i or Release 12.x,

you should refer to metalink note with ID 416708.1

For example, for Release 12.1 : 

ATG Release 12.1 Version	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

List of Oracle AIM (Appl Impl Methodology) Templates

• MD050– Functional Design
• MD070 –Technical Design
• System Integration Testing
• CV010 – Data conversion Strategy
• CV060 – Data Conversion Templates
• PM010 –Transition Strategy
• TE040 –Test Scripts
• BR110 – Security Profiles (Roles and Responsibility Matrix)
• User Acceptance Testing (UAT)
• Cutover and Production Migration Plan
• End User Training (End User Manual)
• BR100 –Application Set up
• CR010 – Project Management Plan / Project Plan (WM020)
• Overview Training
• RD010 – Organization Structure
• RD020 – Business Requirement Gathering
• RD050 / BR030 – MAP Business Requirements
• TA040 –Application Architecture Strategy
• CRP Session I
• BP080 – Future Business Model
• BR010 – GAP Analysis
• CRP Session II

Tips:

1. Follow the documentation principle like Preparer, reviewer with dates and approvers with version controls details in all documents.
2. Try to avoid Word, Excel, PPT attachments to the templates.
3. Collect enough details from client to prepare the process flow.
4. Stick on to the Project schedule to submit the documents on time.
5. Ensure to fill the open and closed issues on all updates if any.
6. Follow the uniformity in using templates across all modules.
7. Avoid providing internal intranet URL etc for reference.
8. Follow the Oracle Custom standards while preparing Technical Docs.
9. Documents prepared by one person must be reviewed by another before submitting to Client.
10. Get a sign off from client and as well as from PM on all docs

OBIEE Installation and Configuration

We can not install OBIA Directly in Linux server. Due to this we need to install OBIA first in Windows.

We need to install OBIEE 11g first before install OBIA

Before OBIA, we need to install 11g DB and RCU (Repository creation utility)

So below is the sequence of installation products in windows

1. 11g DB
2. RCU
3. OBIEE 11g
4. OBIA (7.9.6.3)
5. Informatica Version 9
6. DAC(D/w Admin Console) 11g

Similarly we need to install same in Linux

Informatica is ETL tool used to design jobs with mapping between source tables and target tables

Once jobs are created in ETL, we need to schedule these as Tasks in DAC. DAC is implemental aware and incremental aware intelligent tool

OLTP (Source DB --> Oracle ERP or Peoplesoft or JDEdwards or SAP or any other DB)

OLAP (D/W DB, which is used for Analytics)

Tables in this D/W DB are suffixed with _F, _FS, _D and _DS (Fact, FactStage, Dimension and DimensionStage)

SDE_Extractor --> Source Dependent Extractor

Tip: What If I want to rerun full load of few table or entire database?
Ans: If you want to rerun full load for single table --> Find out the task in execution plan and reset the execution date as Null and run it again
If you want to rerun full load for full database --> Reset the dataset and rerun the execution plan

You can find out the table/column mapping using Data Leanage document from metalink

Subject Area is nothing but collection of tasks
Execution Plan is collection of SAs

Customization Process (How to add extra dimension)
1. Create custom folders for SDE/SILO/PLP (source dependent extract) (source independent load) (post load process)
xx_sde
xx_silo
xx_plp

copy all the folders to above custom folders

2. Add column to fact table with the help of data leanage file

3. Customize SDE Mapping

4. Customize SILO Mappling

5. Run the execution plan or task