Free Essay

Oracle Apps R12

In: Computers and Technology

Submitted By khuma82
Words 1521
Pages 7
Oracle Inventory - Release 11i.4 Logical Data Model has initialization information initialization information for a inventory adjustment

ITEM CATEGORY TYPE

assigned to an item by

ABC ASSIGNMENT GROUP is class for classifies inventory for

ABC CLASS inventory classification for

CYCLE COUNT

results in results from contains

CYCLE COUNT ADJUSTMENT

ITEM CATALOG GROUP

stores count tabulations in

PHYSICAL INVENTORY

SUBINVENTORY REPLENISH COUNT owned by

COST GROUP owns has assigned to it

owned by

EXTERNAL ORGANIZATION has assigned in for groups basis for

assigned to item

categorizes has owned by attributes generates

categorizes

adjusted by

assigned by

derives

counts items for

CUSTOMER

SUPPLIER

for

owns has based on based on belongs to belongs to has

groups basis for

CUSTOMER SITE sells to attributes for adjusts source of results from for generates replenished from assigns derived from assigns

SUPPLIER SITE

assigned to

has class assignment

group assignment for used in compiled for

item assigned to

tabulates count for contained in grouped count for

describe location of

ITEM CATEGORY PO COMMODITY CODE owned by assigned to an item by

ABC ASSIGNMENT GROUP CLASS

ABC ASSIGNMENT

CYCLE COUNT CLASS

CYCLE COUNT ITEM

PHYSICAL INVENTORY ITEM COUNT

PHYSICAL INVENTORY ADJUSTMENT

located

ITEM REPLENISH COUNT

replenished from

COST GROUP ASSIGNMENT

HR LOCATION has source having

is location for is located at

replenishes

replenishes replenishes is destination for

abc assignment for

owned by

effects cycle count for adjusts count of adjusts located at count charges for for adjustment to

owns is source for owns container items for

container items belong to

categorizes located at has default model of assigns category from assigns category type from belongs to has abc assignment is categorized by

is categorized by is cycle counted as on has has primary UOM of is based on has has status is detail container for is sourced from is master container for has model is produced as is issued has from has instance has has revision has has has default container is categorized by catalog group counted by default container for count adjusted by has has is reserved by received on is moved by has owns replenishes has has has owns is of owns owns has inventory classification has assigned to it is source for from distribution source org from distribution org to distribution source org to distribution org is destination for used by uses

has destination

CUSTOMER ITEM

default model for

ITEM CATEGORY ASSIGNMENT categorizes is categorized by

ITEM CONTAINER TYPE

ORGANIZATION ITEM

INTERNAL ORGANIZATION BUSINESS GROUP

owns owns has inventory classified by

owned by customer goes into detail container

INVENTORY ORGANIZATION

INTERORG SHIPPING INFORMATION

has

has source of

INTERORG LEAD TIME

has destination

is associated by

goes into master container

is equivalent to has primary UOM of non-base to base unit

LEGAL ENTITY

has status

revised by

is the source for

of belongs to

OPERATING UNIT referenced purchases from owns owned by owns has reserved manages has

source source used by

has stocking area for is source

SHIP METHOD

stores balance for

is a stocking area within has items counted by has source has source is source for assigned to

records inventory adjustment

associates

item belongs to

converts non-base to base units for is a revision of

uses as source has revision of adjusted count having for for is adjustment account for replenished from

has

for

owned by

supplies replenishes

CUSTOMER ITEM CROSS REFERENCE

UOM CONVERSION is equivalent to based on

ITEM REVISION

ORGANIZATION ITEM REVISION

MATERIAL TRANSACTION HISTORY is reserved by

has has belongs to is referenced by has

MFG MATERIAL TRANSACTION MFG MATERIAL ISSUE TXN results in references

ONHAND MATERIAL COST UPDATE TXN ONHAND MATERIAL STD COST UPDATE TXN

PO RECEIPT MATERIAL TXN

source for

for

INVENTORY ONHAND BALANCE at has

SUBINVENTORY

for

KANBAN LOCATION ITEM

having has for is used by

GL ACCOUNT

LICENSE PLATE TRANSACTION results in

replenish source loc replenish demand loc replenish from replenish to replenish to destination for to

receives cost distribution for

for results from

generated by

INTERNAL RECEIPT

LPN TRANSFER TXN LPN UNPACK TXN located at

is reserved by

has location for location for subject of

transfer source is inventory source for inventory destination receives transfer

replenish has

has alias is distribution account for is transportation dist account for

results from replenishes

has inventory source sends inventory to

designated

MFG ORDER COMPLETION TXN

ONHAND MATERIAL AVG COST UPDATE TXN INTERNAL SHIPMENT

having used by

LPN PACK TXN

has transportation dist account is distributed

has a stock location

MFG SCRAP TXN has for instance of has

of

is has balance at

INVENTORY ADJUSTMENT TXN is generated by

is generated by

LOT MERGE

is transacted located at is a stock location within replenish demand loc has source replenish source loc replenish demand loc replenish source loc for replenish to replensih from

FUTURE EFFECTIVE ITEM STATUS assigns UOM CLASS

of has parent

ITEM UNIT of LOT production batch of

RMA TXN transacted by

OTHER MATERIAL TXN

SALES ORDER SHIPMENT MATERIAL TXN

reserves

is located at

location for

for

orders replenishment from has is owned by

LOT SPLIT

is transacted

is alias for

INVENTORY RESERVATION reserved reserves is at has

location has

INVENTORY LOCATOR

KANBAN CARD GL ACCOUNT ALIAS

has

is parent of has parent

SERIAL NUMBER

is stored at has transacted by having

transacts

reserves supply

is for has reserved against it has history is transportation dist account for

is reserved by

transacts is generated by creates included in

having is located at

built by

is distributed by

for

classified by

has history for transportation generates dist account

reserves

reserves for uom reserved by

referenced is location for for stores inventory for receiving location for

is replenished by

having replenished by

reserves has demand source

is reserved against

primary UOM for

is assigned to

has uom

includes

is demand source for

classifies is for

ix txn type

of txn

is of

is received at

transfer from

history for

has

UNIT OF MEASURE basis for

GENEALOGY is forparent

ITEM MODEL UNIT

is a model of used by

INVENTORY TXN SOURCE

has

INVENTORY TRANSACTION TYPE

MATERIAL MOVE ORDER MTL MOVE ORDER PUTAWAY MTL MOVE ORDER ISSUE MTL MOVE ORDER RECEIPT MTL MOVE ORDER PICK WAVE is source of

INVENTORY SUPPLY transfer uses

KANBAN CARD ACTIVITY HISTORY

for

orders replenishment from managed by has source source from

MANUFACTURING LINE

primary UOM for

SERIAL COMPOSITION

created by generates generates

created by

REQUISITION SUPPLY is of has source

INTRANSIT SHIPMENT SUPPLY

UOM for is the ordering unit for

MTL MOVE ORDER REPLENISHMENT

MTL MOVE ORDER BALANCE RECONCILLIATION

MTL MOVE ORDER MOVE

PO SUPPLY

includes is weight UOM for has source UOM of to organization inventoried in UOM to organization

WIP SUPPLY

supplied from

is gross UOM for

is status of is assigned to is for is status for is for distributes

cost is distributed to

replenishes

has

belongs to has has

ITEM STATUS ATTRIBUTE VALUE

for has

ITEM STATUS

AVAILABLE TO PROMISE RULE

PICK RELEASE RULE

MATERIAL MOVE ORDER LINE MFG/MATERIAL TRANSACTION DISTRIBUTION MATERIAL TRANSACTION DISTRIBUTION MFG TRANSACTION DISTRIBUTION has moves archived as transferred MTL MOVE ORD LINE ACCT TFR

MTL MOVE ORD LINE MOVE

MTL MOVE ORD LINE ISSUE

MTL MOVE ORD LINE SUBASSEMBLY MOVE

has

has designated for it has

MTL MOVE ORD LINE UNPACK CONTAINER

MTL MOVE ORD LINE CROSS DOCK

MTL MOVE ORD LINE FIXED ASSET MOVE

MTL MOVE ORD LINE PICK

has

referenced by

MTL MOVE ORD LINE OWNER CHANGE

MTL MOVE ORD LINE RECEIPT

MTL MOVE ORD LINE PUTAWAY

MTL MOVE ORD LINE PACK CONTAINER

has referenced by

uses

supplies

is reserved by split into has split from orders in has is included in for for reserved for

supply for

a parent of a child of creates

generated

has

source for

PROJECT CONTRACT PROJECT

references

SALES ORDER LINE generates MFG ORDER builds RECEIVING TRANSACTION

INBOUND SHIPMENT INTRANSIT INVENTORY SHIPMENT FROM SUPPLIER SHIPMENT BLANKET RELEASE SHIPMENT DISTRIBUTION source for

PURCHASE ORDER SHIPMENT DISTRIBUTION STANDARD PO SHIPMENT DISTRIBUTION

WIP JOB

REPETITIVE SCHEDULE

FLOW SCHEDULE

RETURN TO RECEIVING

INSPECTION

for

has

CORRECTION

RETURN TO VENDOR

is top task for is for stores inventory at

has weight UOM

has gross

INVOICE PO MATCH

RECEIPT

generated

INTERNAL ORDER SHIPMENT

DELIVERY owned by organization composed of

PROJECT TASK has top task

having is parent of

PLANNED PO SCHEDULED SHIPMENT DIST

has parent

contains

in

PLANNED PO SHIPMENT DISTRIBUTION send to

INBOUND SHIPMENT LINE grouped by references container contains container of has subinventory references to have source for is for

DELIVERY LINE split from includes split into

DELIVERY LINE ITEM packed in

DELIVERY LINE CONTAINER contains Click here for instructions on ordering a printing of the diagram from Kinkos
C o p y r ig h t © 2 0 0 0 , 2 0 0 1 O r a c le C o r p o r a tio n . A ll R ig h ts R e s e r v e d T h is lo g ic a l d a ta m o d e l is s u b je c t to c h a n g e w ith o u t n o tic e .

Similar Documents

Free Essay

Senior Database Administrator

...success. Education  (2003- 2007) Bachelor’s degree in computer information system from Jordan University with GPA: 3. 35 out of 4 (very good).  Studying MBA at German Jordanian University -Talal abu Ghazaleh Graduate School of business (expected date to graduate 2014). Certifications/Exams  Pass University achievement exam with rank 49 out of 906 students.  Oracle DB 10g: oracle certified professional.  Oracle DB 11g: oracle certified associate.  Oracle E-Business Suite R12 Applications Database administrator certified professional.  Oracle DB 10g: Managing oracle on Linux certified expert.  Oracle E-Business Suite R12 system administrator certified expert.  Pass Oracle enterprise linux fundmental exam as a prerequisite for oracle enterprise linux system administrator certified associate.  Pass ITILV3 Foundation exam.  Oracle DB 10g: Administering Real application clusters certified expert.  Oracle DB: SQL Certified Expert. Professional Experience From To Title& Duties May 2011 Present @Umniah Senior database administrator Duties: Administration on Oracle E-business suite release R11.5.10.1 - Support/Maintain/Troubleshoot Umniah...

Words: 1191 - Pages: 5

Free Essay

Oracle Apps

...|Current Location |Hyderabad | |Current Employer |Tata Consultancy Services | Executive Summary: My ambition is to work for the leading consulting firms within the IT industry as I believe I am skilled and have much to offer potential employers and their clients. Currently, I am a System Engineer with Tata Consultancy Services Limited. Primary Skills: 2years & 9 Months of experience as Technical Consultant in Oracle E-Business Suite Applications. Resume Details: • 2 years and 9 month of analysis, design, development and support experience in Oracle apps. • Has exposure in working with Onsite – Offshore models. • Experience in all phases of the system development /implementation life cycle. • Experience in Oracle Apps...

Words: 1310 - Pages: 6

Free Essay

Teri Maa Ki Behen Ka Bhai

... | Career Objective: To take a challenging post for understanding business change needs, assessing the impact of those changes, capturing, analyzing and documenting requirements and then supporting the communication and delivery of those requirements with relevant parties. Professional summary: ✓ 2.8 years of experience in the field of IT on as Functional Consultant Oracle Applications ERP and Business Analyst for Bespoke Applications. ✓ Extensive experience in Requirement gathering, Analysis and understanding of AS-IS and TO-BE models, Documentation (like BRD’s, Wireframes, Use cases, Test cases, and Test Plans) and High Level Design. ✓ Experience in preparing Functional requirement document, High Level Design and Test Cases. ✓ Exposure to Backend system with working knowledge of PL/SQL. ✓ Extensively worked on Oracle Applications Project Costing and Billing Module. ✓ Good knowledge on Order to Cash Process. ✓ A highly motivated, energetic individual and a team player with excellent communication and...

Words: 805 - Pages: 4

Free Essay

Child Labour

...Professional Summary: • Over 6 years of professional experience as Oracle EBS R12/11i Technical and Functional Consultant with expertise in Oracle Financials modules (GL, AP, AR, FA and PA), Manufacturing Modules (OM, INV, Shipping, BOM, WIP, PO). • Good expertise in RICE (Reports, Interfaces, Conversions, Extensions) components. • Good knowledge in Order to Cash (O2C) and Procure to Pay (P2P) business flows. • Excellent knowledge of AOL (Application Object Library)/FND and System Administration Modules. • Experience in creating and customizing existing reports using BI and Reporting Tools like Oracle Discoverer, Reports 10g/6i/4i and XML/BI Publisher tools. • Good technical development skills in developing Reports, Interfaces, Conversions and Extensions (RICE components) in the domain of Oracle Applications E-Business Suite. • Expertise in Design and Development of interfaces and conversion programs to integrate Oracle Applications modules to import data from various sources into Oracle Applications using PL/SQL, SQL*Loader etc. • Strong experience in Data Conversions and Design/Development of Interfaces using Oracle open interfaces and Oracle Public API’s. • Very Good understanding of Trading Community Architecture (TCA). • Familiar with Oracle Applications Framework (OA) technology, especially with personalization of existing OA Framework pages. • Experience in Application System Administration activities like managing concurrent managers, defining......

Words: 2129 - Pages: 9

Premium Essay

Obia Installation

...Oracle® Business Intelligence Applications Installation Guide for Informatica PowerCenter Users Release 7.9.6.4 E35271-01 November 2012 Provides the steps to install and set up Oracle Business Intelligence Applications Release 7.9.6.4. Oracle Business Intelligence Applications Installation Guide for Informatica PowerCenter Users, Release 7.9.6.4 E35271-01 Copyright © 2009, 2012, Oracle and/or its affiliates. All rights reserved. Primary Author: P Brownbridge This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited. The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing. If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, the following notice is applicable: U.S. GOVERNMENT END USERS: Oracle programs, including any operating system, integrated software, any programs......

Words: 60905 - Pages: 244