Oracle Apps Technical and Functional

Memory for your laptop

2009-11-01T23:47:00.000-08:00

The more applications you install on your laptop the speed/performance will be degraded in your laptop. To improve the speed of your laptop you need to upgrade your lap top memory. Those who wants to up gradate their laptop memory to improve their laptop speed can visit laptop memory.com. You can purchase the memory for lap top for the reasonable price with high quality. The best thing about them is that they give limited lifetime warranty for the part your purchase. For the schools and govt they offer 30 day terms. The website provides user friendly navigation to find out the suitable memory for lap top. They also provide rams for different types of laptop brands available in the market. There you also can chat with support team to know better about the deals or details of service etc.

This site also provides with the search where you can search the brand or any keywords related to laptop memory. The price is listed in a tabular format with part number, description and price which gives clear idea about it. The site looks simple and decent. Once you have chosen your memory you can purchase it online without any hassles with secured online payment gateway. Overall this is the best place to buy lap top memory online. Hence, we recommend this seller for all branded laptop memory.

Unable to see the concurrent program request

2007-11-14T03:57:00.001-08:00

Issue: Unable to see the concurrent program request

Details: A User has submitted a Concurrent program request from XXX responsibility later when other user wants to see the same concurrent program request submitted by the earlier user. But, he unable to see the request in the same responsibility (Querying with Request Id in SRS view request screen)

Reason: When User submits the concurrent program from "others-->request --> run” screen others cannot see the concurrent request when they are in the same responsibility with the same request id

If user submits the concurrent program from SRS (STATDARD REQUEST SUBMISSION) window then we can see the request with out any issues.

If user submits the concurrent program from Request --> Run in the Menu of responsibility then others cannot able to view the concurrent program request even though they are in the same responsibility.

Oracle Apps Very Important Technical Questions

2007-09-02T21:30:00.000-07:00

The below link has Oracle Apps Technical Interview Questions in purchasing, HRMS etc which are very rare.

http://easyapps.blogspot.com

OverLoading concept in Oracle PLSQL

2007-08-28T06:07:00.000-07:00

Overloading concept in Oracle PL/SQL

Overloading concept means, it allows you to overload procedures or functions in package with same name but different in data type and order of the parameters. When you call an over load subprogram, compiler determines which subprogram to call based on the data type which used in subprograms.

Single sub programs cannot be overloaded.

Example:

create or replace package testpack
is
Procedure test1(p_num NUMBER, p_name VARCHAR2);
Procedure test1(p_num NUMBER, p_name VARCHAR2,p_num2 NUMBER);
end testpack;
/

show error

create or replace package body testpack
is
Procedure test1(p_num NUMBER, p_name VARCHAR2)
IS
BEGIN
DBMS_OUTPUT.put_line('Test1');
END;

Procedure test1(p_num NUMBER, p_name VARCHAR2,p_num2 NUMBER)
IS
BEGIN
DBMS_OUTPUT.put_line('Test2');
END;
end testpack;
/
show error

Oracle apps Interview Questions and Report Standards

2007-06-19T08:34:00.000-07:00

Find the link for oracle apps interview questions.

http://easyapps.blogspot.com

Customizing Report: Standards for Oracle apps

http://oraclehere.googlepages.com/ReportsTechnicalStandards.pdf

Oracle Apps Functional(Finance) Curriculum at HTS Technologies

2007-03-22T02:19:00.000-07:00

ORACLE APPLICATION 11i (FINANCIAL)

FUNCTIONAL

ORACLE GENERAL LEDGER
* Introduction
* Chart of Accounts
* Calendar
* Currency
* Set of Books
* Periods
* Journals & Posting
* Translation
* Revaluation
* Budgets
* Mass Allocation, Mass Budgets
* Consolidation (GCS)
* MRC
* Inter Company Accounts, Security Rules, CVR
* Summary Accounts, Rollup Groups
* FSG
* Interfaces

ORACLE INVENTORY
* Defining Items
* Defining Sub-Inventory
* Categories (Overview)
* Items Costs (Standard Cost)

ORACLE HRMS
* Defining Job
* Defining Position
* Enter / Maintain Employee
* Position Hierarchy / Employee Supervision

ORACLE HRMS
* Defining Job
* Defining Position
* Enter / Maintain Employee
* Position Hierarchy / Employee Supervision

MULTI ORG
* Designing Organization Structure
* Creating Organization Structure
* (Location, LE, OU, inv org, responsibilities)

ORACLE PURCHASING
* Purchasing Options
* Financial Options
* Inventory Parameters
* Receiving Options
* Approval Assignments, Groups
* Document Types
* Requisitions
* Auto Create
* Purchase Order
* RFQ Quotation
* Receipts

ORACLE PAYABLES
* Payables Options
* Payment Terms
* Distribution sets
* Holds, Tolerances
* Invoices
* Bank, Bank Accounts
* Payments

ORACLE RECEIVABLES
* System Option
* Transaction types, Sources
* Payment Terms, Limit
* Profile Classes
* Customer definition
* Transaction
* Receipt Classes, Sources
* Bank, Receipts

ORACLE CASH MANAGEMENT
* Systems Parameters
* Bank Reconciliation
* Forecasting

ORACLE FIXED ASSETS
* Book Controls
* Prorate Conventions, Depreciation, Prorate
* Asset Addition
* Revaluation
* Retirements, Resistances
* Depreciation, GL Transfers, Gain Loss Calculation

An Oracle Apps Forum for all Queries

2007-02-02T20:46:00.000-08:00

Hi,

There is a web site called http://www.orafaq.com this helps in finding almost every oracle related query.

Try it

Thanks
Rao

Oracle Apps Technical Curriculum

2007-01-11T02:04:00.000-08:00

Oracle Applications 11i (Technical)

ERP INTRODUCTION

ORACLE APPLICATIONS ARCHITECTURE

APPS FILE SYSTEM

DESIGNING CUSTOM APPLICATION

* Create & Register DB User
*Create Base Path

TABLE CREATION & REGISTRATION
*WHO Columns

APPLICATION DEVELOPER
* Form Design & Registration
* Define Functions
* Create Menus

SYSTEM ADMINISTRATOR
* Create Application Users
* Create Responsibilities
* Create Data Groups

MAINTAIN APPLICATION SECURITY
* Non Form Function
* Menu Exclusions

IMPLEMENTING LOV

IMPLEMENTING ROW LOV

IMPLEMENTING QUERY FIND WINDOW

IMPLEMENTING MASTER DETAIL

CONCURRENT PROGRAMS
* Requests
* Define Request Groups
* Request Sets
* Value Set
* Reports

CONCURRENT PROCESSING
* Overview of Concurrent Processing
* Life Cycle of a Concurrent Request
* Concurrent Managers
* Parallel Concurrent Processing

CUSTOMIZE SUBMIT REQUEST WINDOW FLEXFIELDS
* Descriptive Flexfields (Enable Existing DFF)
* Descriptive Flexfields (Creation)
* Key Flexfields Concepts

INTERFACES
* Inbound Interface
* Outbound Interface

ORACLE 11i ALERTS

PROFILE OPTIONS
MESSAGE DICTIONARY
DOCUMENT SEQUENCES
MULTI ORG CONCEPTS
WORK FLOW CONCEPTS

ORACLE APPS MANUFACTURING TRAINING CURRICULUM

2006-10-27T02:01:00.000-07:00

TRAINING AVAILABLE FOR ORACLE APPS TECHNICAL

ORACLE APPS MANUFACTURING CURRICULUM

ORACLE INVENTORY

* Item Master
* Item definition thru Item-type templates
* Setups
* Cross-references
* Multi-Org
* UOM
* Master Organization ~ Child organization setups
* Item
* DFFs Descriptive Flex-Fields with-out /with Value-sets
* KFFs Key Flex-Fields
* Item revision tracking & setup
* Manufacturing Part Number MPNs
* On-hand inventory
* Physical Counting ~ tagging ~ Inventory adjustments
* Material Transactions
* Issues thru Move-Orders
* Miscellaneous Issues / Miscellaneous Receipts
* Item categories / Item sub-inventories
* Report & Requests

ORACLE BILLS OF MATERIAL (BOM)

* Bills of Material Multi-level Multi Org
* BOM Explosion Indented Bills
* BOM Implosion Item Where Used
* Bills copying
* Bills / Items / Routings deletion using Delete Groups
* Reference Designators
* Bills comparisons
* esources
* Departments
* Routings
* OSP Bills / Manufacturing Bills
* Primary Bills & Alternate Bills
* Concepts of Back-Flushing
* Product Costing
* Setups
* Reports & Requests
* Attachments
* Creating BOM Matrix

ORACLE ENGINEERING (ENGINEERING CHANGE MANAGEMENT)

* ECO
* Engineering Item Master
* Prototypes
* Engineering BOM
* Engineering Routing
* Set ups
* ECO Integration with BOM & Oracle Inventory
* Inventory
* ECO Form Customization Using DFFs
* ECO Life Cycle Mgm.
* ECO Implementation
* ECO Cancellation
* ECO Integration with Work Flow

ORACLE WIP (WORK IN PROCESS)
* Discrete Job Orders
* Materials Requirements
* Move Transactions
* WIP Transactions
* Job Completions
* Closing Discrete jobs

ORACLE QUALITY
* Quality Control Plans
* Collection Plans
* Collection Elements
* Setups
* Quality Results
* Quality Data Analysis
* Quality Online Reports

List of PLSQL Web site

2006-10-21T23:16:00.000-07:00

List of PLSQL Web site:

http://otn.oracle.co.kr/docs/oracle78/main.htm
http://asktom.oracle.com/pls/ask/f?p=4950:1:
http://www.cse.unsw.edu.au/~cs9804/Oracle/faq.html
http://www.engin.umich.edu/caen/wls/software/oracle/server.901/a90192/ch06.htm#1007544
http://www.orafaq.com/faq2.htm
http://certification.about.com/gi/dynamic/offsite.htm?site=http%3A%2F%2Fwww.oraclefans.com
http://www.oreilly.com/catalog/orsqlpluspr2/chapter/ch01.html
http://www.dbaoncall.net/index_files/index_oracle.html
http://www.oreilly.com/catalog/orsqlloader/chapter/ch01.html
http://www.arikaplan.com/oracle.html
http://www.oracletuning.com/
http://www.techonthenet.com/oracle/functions/index.htm
http://www.dbatoolz.com/scripts_desc.htm
http://www.ss64.com/orasyntax/functions.html
http://www.jusungyang.com/ORACLEfolder/PLSQL.html
http://www.engin.umich.edu/caen/wls/software/oracle/appdev.901/a89856/07_errs.htm
http://www-db.stanford.edu/~ullman/fcdb/oracle/or-plsql.html#basic%20structure%20of%20pl/sql
http://www.unix.org.ua/orelly/oracle/advprog/
http://www.techonthenet.com/Oracle/
http://www.csee.umbc.edu/help/oracle8/server.815/a67792/ch05.htm#1272
http://www.comp.nus.edu.sg/~ooibc/courses/sql/sqlplus.htm
http://otn.oracle.co.kr/docs/oracle78/server71x/SVMSG/ch11.htm#toc127
http://www.csis.gvsu.edu/GeneralInfo/Oracle/appdev.920/a96630/sdo_objload.htm