apps useful ref

8/6/2019 Apps Useful Ref

http://slidepdf.com/reader/full/apps-useful-ref 1/47



lecture 4 2

How Will You Automate Your

Enterprise?By Robert L. Scheier JANUARY 06, 2003

• Whatever the problems, a report last year from Boston-based AMR Research Inc. predicted that ERP spending will remainsteady at about $16 billion per year between now and 2006,

and Computerworld 's Premier 100 IT Leaders ranked ERPsystems as their top project for 2003.

• Advices:

– Make sure end users are willing to pay for the project. Thatway, they too have “skin in the game” and an incentive tomake the project work.

– Deliver bad news early – don’t wait for a formal meeting. No

one likes to be surprised. – Minimize the amount of data you convert to the format and

data descriptions required by the new system, because notall the data will be converted properly.



lecture 4 3

How Will You Connect With

Customers?By Stacy Collett JANUARY 06, 2003

• Computerworld 's Premier 100 IT Leaders will also spend big onCRM, enough to rank such projects second on their priority lists

for 2003.• Companies worldwide will spend $15.4 billion on CRM initiatives

this year, according to research firm Aberdeen Group Inc. inBoston.

• Advices:

– Minimize customization of off-the-shelf software.

– Don’t add technical features just because they’re available.

– Manage data movement, and insist on data integrity.



lecture 4 4

How Will You Integrate

Technology With Business?By Bob Violino JANUARY 06, 2003

• EAI involves using software to connect a variety of applications into acohesive unit and thereby helps enterprises align systems more closelywith business processes. It's become a critical part of the IT strategy at

many organizations looking to meld disparate systems and quicklydeliver data to employees, customers and partners.

• Some analysts say companies can expect to spend $200,000 to$400,000 on an EAI project, including software and installation costs.

• Advices:

– Manage and control EAI implementation from a central group, withinput from IT and business managers.

– Have the skills and/or training programs in place to implement andmaintain EAI software.

– Have IT staff work in conjunction with other departments, such ascustomer service or sales, in the implementation of EAI.



lecture 4 5

How Will You Build Business on

the Web?By STEVE ALEXANDER JANUARY 06, 2003

• Computerworld 's Premier 100 IT Leaders ranked e-commerce projectsfourth on their list of top priorities for 2003. But the rules havechanged. Required-payback times are shorter, often no more than ayear. E-business initiatives tend to focus on improving order or sales-lead management, tuning the sales channel or creating businesspartner self-service portals.

• New York-based e-business research firm eMarketer Inc. projects that2003 worldwide e-business IT expenditures will be $245 billion, up 49%from $164 billion in 2002. Premier 100 IT Leaders who have reaped thebenefits of e-business projects share some tips for success.

• Advices: – Check out the financial status of vendors, and leave extra time for

project completion.

– Market your e-business project to customers, and follow up withtraining.



lecture 4 6

How Will You Improve Your Core

Systems?By AMY HELEN JOHNSON JANUARY 06, 2003

• Upgrades of core systems are among the top five projects thePremier 100 IT Leaders said they'll tackle this year. Getting

things right is important because core system upgrades aren'tcheap.

• Advices:

– Involve the people “who leave fingerprints on the

keyboards.”

– Sell the project often by making a compelling argument infavor of “soft” benefits.

– A good manager with a mediocre crew can “run ringsaround a poor manager with a high-quality crew.”

– Interim checkpoints are a must.



lecture 4 7

Oracle Applications Products

••Oracle General Ledger Oracle General Ledger

••Oracle AssetsOracle Assets

••Oracle ReceivablesOracle Receivables••Oracle PayablesOracle Payables

••Oracle PurchasingOracle Purchasing

••Human ResourcesHuman Resources

••PayrollPayroll

••Oracle InventoryOracle Inventory

••Oracle Bills of MaterialsOracle Bills of Materials

••Oracle Order EntryOracle Order Entry••Oracle Work in ProcessOracle Work in Process

••Oracle Cost ManagementOracle Cost Management

••Oracle Sales and MarketingOracle Sales and Marketing

••Oracle Sales CompensationOracle Sales Compensation

••Oracle Sales AnalysisOracle Sales Analysis

••Project CostingProject Costing

••Project BillingProject Billing

FinancialsFinancials Manufacturing Manufacturing

Human ResourcesHuman Resources Project Accounting Project Accounting

SalesSales



lecture 4 8

Oracle Applications Integration

GENERALGENERAL

LEDGER LEDGER

Fixed AssetsFixed Assets

Project Project

Accounting Accounting

Purchasing Purchasing

Cost Cost

Management Management

Set of BooksSet of Books

Exchange RatesExchange Rates

Set of BooksSet of Books

Exchange RatesExchange Rates

Accounts

Payables

Order Entry Order Entry

Accounts Accounts

ReceivablesReceivables

HumanHuman

ResourcesResources

Inventory Inventory



lecture 4 9


GENERAL LEDGER GENERAL LEDGER

•• BudgetingBudgeting•• MulticurrencyMulticurrency

•• Global Consolidation SystemGlobal Consolidation System

•• Financial Statement Generator Financial Statement Generator

•• Chart of AccountsChart of Accounts

•• Journal EntriesJournal Entries•• Financial ReportsFinancial Reports



lecture 4 10

Oracle Financials

GENERALGENERALLEDGER LEDGER

Fixed AssetsFixed Assets Accounts Accounts

PayablesPayables

•Journal Entries

•Invoices

•Payments

Inventory Inventory

•Journal Entries

•Inventory/

WIP activity HumanHumanResourcesResources

•Journal Entries

•Payroll

•Journal Entries•Additions/Retirements

•Depreciation

•Adjustments

Purchasing Purchasing Accounts Accounts


•Journal Entries•Invoices

•Receipts

Project Project


•Journal Entries

•Revenue

•Labor Costs

•Usage Costs

•Journal Entries•Accrued

Receipts



lecture 4 11

Oracle Project Accounting

Accounts Accounts

PayablesPayablesPurchasing Purchasing

Accounts Accounts


Project Project


HumanHuman

ResourcesResources

General General

Ledger Ledger

•Revenue•Labor Costs

•Usage Costs

•Expense Reports

•Vendor Data

•Vendor Invoices

•Report

Commited Costs

•Report Balance

•Payroll Information

•Set of Books Information

•Employee Data•Organizations

•Jobs

•Customer Data

•Invoicing

•Project Related

Requisitionsand PO’s



lecture 4 12

Oracle Human Resources

HumanHuman

ResourcesResources

Project Project

Accounting Accounting General General

Ledger Ledger •Employee Information

•Organizations•Jobs and Positions

•Hierarchies

•Locations

•Payroll

Information•Employee Information

•Locations

•Set of Books Information

Accounts Accounts

PayablesPayablesPurchasing Purchasing

Fixed Fixed

Assets Assets

•Employee Information

•Employee Information

•Jobs and Positions

•Locations



lecture 4 13

Oracle Manufacturing

Accounts Accounts


Purchasing Purchasing

Bill of Bill of

MaterialsMaterials

Order Order

Entry Entry

Inventory Inventory

General General

Ledger Ledger

•Invoice Information

•Returns/Credits•Booked Orders

Work inWork inProcessProcess

•Model

Structure

- Bills

- Routings

- Calendar

•Shipment

•Reservation

•Demands•Item Information

•Units of Measure

•ATP/On Hand

•Internal Requisitions

•Receipts

•Item Information

•Units of Measure

•ATP/On Hand

•Customer Information

•Credit Information

•Sales Reps.•Payment Terms

•Model

Structure

•Inventory and WIP

Transactions

- Bills

- Routings

- Calendar

•Item

Info•Units of

Measure

•Reservations

Demand

•JE

- Invoices

- Receipts

•Items Information•Unit of Measure

•Final Assembly Order

O l A li i I i



lecture 4 14


Oracle

General Ledger *

Oracle

Order Entry

Oracle

Receivables

Oracle

Inventory

•Customer Information•Credit Information•Sales Reps.•Payment Terms

•Invoice Information•Returns/Credits•Booked Orders

•Shipment•Reservation•Demands

•Units of Measure•Item Information•ATP/On Hand

•Journal Entries- Invoices- Receipts

Oracle

Assets

Oracle

Purchasing

Oracle

Payables

•VendorsInformation

•Journal Entries- Invoices- Payments

•Journal Entries- Additions- Retirements- Depreciation- Adjustments

•Assets Information(from Invoices)

Oracle

Bill of Material

•Model Structure

•Items Info/Units of Measure

•Model Structure•Final Assembly

Orders

•Reservations

•Demand

•Item Information•Units of Measure


•Sales Orders

• Requisitions

• Purchase Orders

Oracle

Project

Accounting

•Revenue•Adjustments

•Accrued Receipts

•Expense Reports

•Journal Entries(inventory and work in process activity)

Oracle

Human

Resources

•Journal Entries

•Employee Data

External

Systems**

•Units of Measure•Item Information•ATP/On Hand

•Inventory

Transactions(Receipts)

•Invoice Information(from PO’s)

OracleWork in Process

•Purchase Orders(Outside Processing)

•Internal Requisitions

OracleMaster

Scheduling

•PlannedOrders

•Invoice Informationer Data•Custom

•Vendor Data•Vendor Invoices



lecture 4 15

Oracle Inventory

Order Order

Entry Entry

General General

Ledger Ledger Purchasing Purchasing

Bill of Bill of

MaterialsMaterials

Work inWork in

ProcessProcess

•Model Structure

•Material

Transactions

- Bills

- Routings

- Calendar

•Item Information

•Units of Measure

•Issues/Receipts

Inventory Inventory

•Items Information

•Unit of Measure


•ATP/On Hand

•Shipment•Reservation

•Demands

•Inventory and WIP

Transactions

•Receipts

•Item Information

•Units of Measure•ATP/On Hand



lecture 4 16

Oracle Applications Data Flow

OracleOracle

InventoryInventory

Oracle Server Oracle Server

Data entryData entry OracleOracle

General Ledger General Ledger

FormsForms TablesTables



lecture 4 17

System Administration Functions

ApplicationsApplications

signsign--ononForms andForms and

functionsfunctionsProgramsPrograms

andand

reportsreportsDefineDefine

applications privilegesapplications privileges

Save outputSave output

as OS fileas OS file

OnlineOnlineBalance online andBalance online and

concurrent processingconcurrent processing

DefaultDefault

printer printer

Set applicationSet applicationdefaults or defaults or

user profilesuser profiles

ProgramsPrograms

andand

reportsreports



lecture 4 18

Managing Application Security:

OverviewWindowsWindows

ReportsReports

OracleOracle

ApplicationApplication

ResponsibilityUser



lecture 4 19

Responsibility Components

Request securitygroup

Data group

Menu

Exclusions



lecture 4 20

Defining a New Responsibility

You must assign the following to your new

responsibility:

• A data group to supply the form, report, and program connect privileges

• A menu to supply access to forms within an

application• Any function or menu exclusions to control access

to the functionality of the application

• A report security group to control access to reportsand concurrent programs



lecture 4 21

Using Responsibilities

Defineor modify

responsibility

Excludefunctions

and menus

Defineapplication

user

Defineor modify

data group

Using Custom ResponsibilityUsing Custom ResponsibilityUsing PredefinedUsing Predefined

Responsibility Defineor modify

request group

Responsibility Defineor modify

menu

Defineapplication

user



lecture 4 22



lecture 4 23



lecture 4 24



lecture 4 25



lecture 4 26

Data Group

• What Is a Data Group?

– A data group is a collection of pairings of an application with an

Oracle ID. Data groups automatically support concurrent

processing and cross-application reporting. They guarantee that anapplication connects to a unique application database account.

• Data Groups and Application Object Library

– Application Object Library owns the database tables referred toduring concurrent processing and the standard submission of

reports by any Oracle Application. Therefore all applications need

access to the Application Object Library tables. When you are

defining a data group, the application Application Object Library isautomatically included. The Application Object Library’s Oracle

ID cannot be updated or deleted.



lecture 4 27

Data Groups Serve Two Purposes

– Identify the Oracle ID to which forms connect

when users select the responsibility. Choose

one application-Oracle ID pair from the data

group to associate with your responsibility’swindows.

– Concurrent managers use a data group to match

the application that owns a report or concurrent program with a unique Oracle ID.



lecture 4 28



lecture 4 29

Overview the Flexfields

• Using Flexfields to Customize Applications

– A flexfield is a customizable field that opens in a

window from a regular Oracle Applications window.

Defining flexfields enables you to tailor OracleApplications to your own business environment. You

can easily define flexfields to modify or extend Oracle

Applications without programming. By using flexfieldswithin Oracle Applications you can:

• Structure certain identifiers required by Oracle

Applications according to your own businessenvironment

• Collect and display additional information for your

business as needed



lecture 4 30

Customizing Oracle Applications

Oracle General Ledger Oracle Assets

ApplicationApplication

windowswindows

User User --defined flexfield windowsdefined flexfield windows



lecture 4 31

Flexfield Structures and Flexfield

Segments

Item Information FlexfieldItem Information Flexfield

__ Item Information _______________

CategoryItem

Color

Computer Monitor

Light tan

COM876

LTN

Segments:Segments:

(Category,(Category,Item,Item,

Color)Color)

Structure:Structure:(Category Segment + Item Segment + Color Segment)(Category Segment + Item Segment + Color Segment)



lecture 4 32

Key and Descriptive Flexfields __ Item Information _________

Category

Item

Color

Computer

Monitor

Light tan

COM876

LTN

Key flexfieldsKey flexfields

build uniquebuild unique

entity identifiersentity identifiers

Descriptive flexfieldsDescriptive flexfields

gather additionalgather additional

informationStoreDept

Number

Exp. Dt

Payment Type CC

54321987

4958-2938-4747

12 - 99

information

Key Flexfields



lecture 4 33

yIn Oracle Applications you use key flexfields as identifiers for

entities. Generally, the identifier you create using a key flexfield isrequired by the application (for example, the Accounting Flexfield

builds the account number used by Oracle General Ledger).

StandardStandardwindowwindow

KeyKeyflexfieldflexfield

windowwindow

__ Sales Information ______________________

Transaction

Item

Payment Type

Description

Customer Jane Doe

Computer - Monitor - Light Tan [ ]

COM-876-LTN

3987

__ Item Information _______________

Item

Color

Computer

Monitor

Light tan

COM

876

LTN

Category

K Fl fi ld E l



lecture 4 34

Key Flexfield Example:

Accounting FlexfieldThe Accounting Flexfield is used to create and display account

numbers. The Accounting Flexfield is owned by Oracle General

Ledger, but Accounting Flexfield values are used by many of the

financial applications. The example shows an Accounting Flexfield

structure consisting of five segments.



lecture 4 35

Descriptive Flexfields



lecture 4 36

You use descriptive flexfields to collect information beyond that

collected by Oracle Applications. Using descriptive flexfields

allows you to gather additional specialized information required by

your business. The use of descriptive flexfields is optional.

Transaction

Item

Payment Type

Description

Customer

CC3987

Jane Doe

Computer - Monitor - Light Tan

COM-876-LTN

[ ]

Second ID

Number

Payment TypeStore

Dept

Number

Store

Dept

Exp. Dt

Payment TypeCK CC54321

987

4958-2938-4747

12 - 99

54321

987

1028

MC 4565-3939

__ Sale Information ____________________

Storing Flexfield Data Internally



lecture 4 37

Storing Flexfield Data InternallyIn general, key flexfields store their data in columns called

SEGMENTn, where n is a number. In general, descriptive flexfields

store their data in columns called ATTRIBUTEn, where n is a number.

Attribute1Attribute1 Attribute2Attribute2 ............

Oracle Applications base tablesOracle Applications base tables

Descriptive flexfieldDescriptive flexfieldKey flexfieldKey flexfield

Segment1Segment1 Segment2Segment2...... ......



lecture 4 38

Validating Input Using Value Sets

__ Item Information _________

Category

Item

Computer

Monitor

COM

876

COM APPL FURN

876755 933

CategoryCategory value setvalue set

Item value setItem value set



lecture 4 39



lecture 4 40

T f V l S



lecture 4 41

Types of Value Sets

• You can define several types of value sets depending on how you needyour values to be checked. All value sets perform minimal checking; some

value sets also check against the actual values, if you have provided any.

• None - A value set of the type None has no list of approved values

associated with it. A None value set performs only minimal checking of,for example, data type and length.

• Independent - Independent type value sets perform basic checking but also

check a value entered against the list of approved values you define.

• Dependent - A Dependent value set is associated with an Independent

value set. Dependent value sets ensure that all dependent values are

associated with a value in the related Independent value set.

• Table - Table value sets obtain their lists of approved values from existingapplication tables. When defining your table value set, you specify a SQL

query to retrieve all the approved values from the table.

• Special - This specialized value set provides another flexfield as a value set

for a single segment.



•Value Set Usage by Descriptive Flexfields



lecture 4 43

The SQL*Plus query below can be used to show whichsegments of which structures of which descriptive

flexfields use different value sets. This report does not

show any information for flexfields used with SRS.

•Value Set Usage by Descriptive Flexfields

•desc apps.fnd_id_flexs ;select d.flex_value_set_name "Value Set",

a.id_flex_name "Flexfield",

e.id_flex_structure_name "Structure",

c.segment_name "Segment"

from apps.fnd_id_flexs a,

apps.fnd_id_flex_structures b,

apps.fnd_id_flex_segments c,

apps.fnd_flex_value_sets d,

apps.fnd_id_flex_structures_tl e

where a.application_id = b.application_id

and a.id_flex_code = b.id_flex_codeand b.application_id = c.application_id

and b.id_flex_code = c.id_flex_code

and b.id_flex_num = c.id_flex_num

and c.flex_value_set_id = d.flex_value_set_id

and c.application_id = e.application_id

and c.id_flex_code = e.id_flex_codeorder by d.flex_value_set_name, a.id_flex_name,

e.id_flex_structure_name;

Don't try at

home



lecture 4 44

Oracle Applications Key Flexfields

Bank Details

Cost Allocation

People Group

Oracle

PayrollCategory

Asset

Location

Oracle

Assets

Territory

Sales Tax LocationOracle

ReceivablesAccounting

Oracle

General

Ledger

Oracle Service ItemOracle

ServiceAccount Aliases

Item Catalogs

Item Categories

Sales Orders

Stock Locators

System Items

Oracle

Inventory

Grade

Job

Personal Analysis

PositionSoft Coded

Oracle

Human

Resources

Key Flexfield Application Tables

This SQL*Plus query can be used to show Oracle Applications key flexfields and the tables in which they store their code

combinations.



lecture 4 45

ID_FLEX_NAME APPLICATION_TABLE_NAME

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

Accounting Flexfield GL_CODE_COMBINATIONS

Category Flexfield FA_CATEGORIES_B

Asset Key Flexfield FA_ASSET_KEYWORDS

Location Flexfield FA_LOCATIONS

Oracle Service Item Flexfield MTL_SYSTEM_ITEMS_B

Territory Flexfield RA_TERRITORIES

Sales Tax Location Flexfield AR_LOCATION_COMBINATIONS

Item Categories MTL_CATEGORIES_B

Account Aliases MTL_GENERIC_DISPOSITIONS

Item Catalogs MTL_ITEM_CATALOG_GROUPS

Sales Orders MTL_SALES_ORDERS

System Items MTL_SYSTEM_ITEMS_B

Stock Locators MTL_ITEM_LOCATIONS

Grade Flexfield PER_GRADE_DEFINITIONS

Job Flexfield PER_JOB_DEFINITIONS

Personal Analysis Flexfield PER_ANALYSIS_CRITERIA

Position Flexfield PER_POSITION_DEFINITIONS

Soft Coded KeyFlexfield HR_SOFT_CODING_KEYFLEX

Bank Details KeyFlexField PAY_EXTERNAL_ACCOUNTS

Cost Allocation Flexfield PAY_COST_ALLOCATION_KEYFLEX

People Group Flexfield PAY_PEOPLE_GROUPS

Some Oracle Applications



lecture 4 46

pp

Descriptive Flexfields

Calendar Types

Bonus Rates

Price Indexes

Oracle

Assets

Bank Branch

Payment Terms

Site Address

Oracle

Payables

Daily Rates

Oracle

General

Ledger

Credit History

InformationOracle

Receivables

Activity

Information

Item CostInformation

Shift Time

Information

Oracle

Bills of Material

Employee Labor

Rate

Shop Floor

Status

WIP Parameters

Oracle

Work inProgress

D i ti Fl fi ld A li ti



lecture 4 47

Descriptive Flexfield Application

TablesThis is a partial report for one application (Oracle General Ledger - application ID101) and does not show any information for flexfields used with SRS.

TITLE APPLICATION_TABLE_NAME------------------------------ ---------------------------- Accounting Calendar: Calendar GL_PERIOD_SETS Accounting Calendar: Periods GL_PERIODS AutoAccounting Rules GL_IEA_AUTOGEN_MAP AutoAllocation Batch GL_AUTO_ALLOC_BATCHES AutoPost Criteria GL_AUTOMATIC_POSTING_OPTIONS AutoReversal Criteria GL_AUTOREVERSE_OPTIONS Automatic Posting Sets GL_AUTOMATIC_POSTING_SETS

Budget Types GL_BUDGET_TYPESBudget Versions GL_BUDGET_VERSIONSBudgetary Control Group: Group GL_BC_OPTIONSBudgetary Control Group: Rules GL_BC_OPTION_DETAILSCommon Stocks: Share Activity GL_SHARES_ACTIVITY

Conversion Rate Types GL_DAILY_CONVERSION_TYPES

apps useful ref

Documents