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

Oracle

...nls_date_format = 'DD-MON-YYYY HH24:mi:ss'; ALTER SYSTEM KILL SESSION 'sid,serial#'; ALTER SYSTEM KILL SESSION 'sid,serial#@inst_id'; SELECT * FROM (SELECT b.poc_cde, a.*, row_number() over(PARTITION BY b.poc_cde ORDER BY b.poc_cde, a.batch_trans_dte) r FROM pbr_prcsng_org_batch_run_sched a, pop_prcsng_org_pay_period b WHERE a.pop_ident = b.pop_ident AND a.batch_trans_stat_cde = 'S') WHERE r = 1 select level lev from dual connect by level 0 THEN pipe ROW(SUBSTR(l_list, 1, l_idx -1)); l_list := SUBSTR(l_list, l_idx + LENGTH(p_del)); ELSE pipe ROW(l_list); EXIT; END IF; END LOOP; RETURN; END split; / TABLESPACE SIZE/DATA FILE ERRORS : ALTER TABLESPACE my_ts ADD DATAFILE 'D:\app\Administrator\oradata\vw\my_ts2.dbf' SIZE 10M AUTOEXTEND ON NEXT 200K MAXSIZE 200M; +++++ LOCKED OBJECTS -- view all currently locked objects: SELECT username U_NAME, owner OBJ_OWNER, object_name, object_type, s.osuser, DECODE(l.block, 0, 'Not Blocking', 1, 'Blocking', 2, 'Global') STATUS, DECODE(v.locked_mode, 0, 'None', 1, 'Null', 2, 'Row-S (SS)', 3, 'Row-X (SX)', 4, 'Share', 5, 'S/Row-X (SSX)', 6, 'Exclusive', TO_CHAR(lmode) ) MODE_HELD FROM gv$locked_object v, dba_objects d, gv$lock l, gv$session s WHERE v.object_id = d.object_id AND (v.object_id = l.id1) AND v.session_id = s.sid ORDER BY username, session_id; -- list current locks SELECT......

Words: 1277 - Pages: 6

Free Essay

Bank Technical Details in R12

...TECHNICAL DETAILS OF BANK SETUPS Impact of Upgrade from R11 to R12 With Upgrade, banks and branches migrated to TCA parties; banks are merged if the following attributes are all the same: a. b. c. d. e. f. g. h. Bank Number Institution type Country Bank admin email Bank name alt Tax payer ID Tax reference number Description, Effective dates Bank accounts, Bank account uses are migrated into cash management. Transactions are stamped with the bank account uses identifiers as part of the upgrade Oracle Tables Involved Bank Data in R11i was stored in the following tables: 1. AP_BANK_BRANCHES 2. AP_BANK_ACCOUNT_USES_ALL 3. AP_BANK_ACCOUNTS_ALL The new equivalent tables in R12 are now under Cash Management product as follows: 1. CE_BANK_ACCOUNTS: contains Legal Entity Level bank account information. Each bank account must be affiliated with one bank branch. 2. CE_BANK_ACCT_USES_ALL: stores Operating Unit level bank account use information 3. CE_PAYMENT_DOCUMENTS: Payment Documents to be used for Printed type Payments 4. CE_BANK_BRANCHES_V: view: Bank/Branches Info 5. CE_BANK_ACCT_USES_OU_V: view: Internal Bank Account Uses Info The following tables are obsolete: 1. AP_BANK_BRANCHES 2. AP_BANK_ACCOUNTS_ALL 3. AP_BANK_ACCOUNTS_USES_ALL Note: The bank setup has been moved from AP CE module, and one should use a Cash Management responsibility with all grants and permissions to create and maintain bank accounts. The grants must be done by Sysadmin in User management......

Words: 543 - Pages: 3

Free Essay

Oracle Payables

...EBS R12 Upgrades Presented By Susan Behn VP, Oracle Practice Objectives/Agenda  Provide a high level view of topics to consider when upgrading to R12  When is a “technical” upgrade possible  What do I need to research more  When is the right time for training  What do I include in my budget/timeline  Functional Topics  Technical Topics 2 Overview  Are you aware that…  There are over 1500 new features in R12    A responsibility can now access data in multiple organizations R12.1 was released in April 2009    How does this impact custom Responsibilities How will all these new features be “discovered” Quicker data entry for shared services organizations   The user interface to the Oracle Diagnostics scripts was rewritten in OA Framework in R12.0.6   12.0 focused on Financials 12.1 focused on everything else including HR Utilizes role-based access control requiring role grants from the user management responsibility Setup reports in diagnostics can help you find missing setups 3 FINANCIALS - GL 4 Financials - GL  Legal Entities have significant functionality in R12  Should reflect legal corporate structure  Utilized by Accounting Functions, E-Business Tax, Intercompany, and Bank Account  Balancing segment is associated with legal entity – not ledger  Bank account is owned by legal entity  Align your Ledger structure with your business plan  Operating units are associated with ledgers in R12 –......

Words: 3253 - Pages: 14

Free Essay

Apps

...operated by the owner of the mobile operating system, such as the Apple App Store, Google Play, Windows Phone Store, and BlackBerry App World. Usually, they are downloaded from the platform to a target device, such as an iPhone, BlackBerry, Android phone or Windows Phone, but sometimes they can be downloaded to laptops or desktops. Mobile apps were originally offered for general productivity reasons, including email, calendar, contacts, stock market and weather information. However, public demand and the availability of developer tools drove rapid expansion into other categories, such as mobile games, factory automation, GPS and location-based services, banking, order-tracking, and ticket purchases. For this assignment I will focus on two apps, Swell Radio and MyFitnessPal. I am a person who is just getting my feet wet when it comes to the tech sector. I am a beginner, and so far I seem to enjoy apps that are rather simple and productivity based. MyFitnessPal Available on: Website myfitnesspal.com Founded 2005 Founder Albert Lee, Mike Lee Product Czar Warren Wan MyFitnessPal is very useful and is a must have when I want to keep track of my calories consumed and burned on a daily basis. The app’s aim is to make good health attainable and sustainable for everyone. Used by more than 40 million people, MyFitnessPal is the leading resource for taking charge of daily health. This free mobile app started as a website in 2005, when co-founder Mike Lee and his......

Words: 1388 - Pages: 6

Free Essay

Oracle Apps

...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 R12,11i,Fusion • Worked in projects having R12 Implementation, Upgrades and Oracle Fusion • Experience of Development Data Conversions and Implementation • Proficient in, Packages writing stored procedures and functions using SQL & PL/SQL.  • Experience of Developing Reports (PL/SQL Reports). • Have good Knowledge on BI Publisher Reports • Have knowledge on Oracle Reports • Self-motivated, excellent team player with proven leadership skills. • Excellent communication and interpersonal skills. Project Summary: CIGNA HEALTH CARE |Description |Cigna is a Re-implementation or Oracle EBS Applications from R11.5.10.2 to R12.1.3. Like to Like Re-Implementation, with no | | |business process changes, except for standard functionalities that come with R12 – SLA. The main work includes the | | |Re-implementation of Finance module......

Words: 1310 - Pages: 6

Free Essay

Oracle

...The History of Oracle | Founded in August 1977 by Larry Ellison, Bob Miner, Ed Oates and Bruce Scott, Oracle was initially named after "Project Oracle" a project for one of their clients, the C.I.A, and the company that developed Oracle was dubbed "Systems Development Labs", or SDL.   Although they may not have realized it at the time, these four men would change the history of database management forever. In 1978 SDL was renamed Relational Software Inc (RSI) to market their new database.  1979 - Oracle release 2 The first commercial RDBMS was built using PDP-11 assembler language. Although they created a commercial version of RDBMS in 1977, it wasn't available for sale until 1979 with the launch of Oracle version 2. The company decided against starting with version 1 because they were afraid that the term "version 1" might be viewed negatively in the marketplace.  USA Air Force and then CIA were the first customers to use Oracle 2. In 1982 there was another change of the company’s name, from RSI to Oracle Systems Corporation so as to match its popular database name.  The current company name comes from a CIA project that Larry Ellison had previously worked on code named Oracle. 1983 - Oracle release 3 The Oracle version 3 was developed in 1983. This version was assembled using C programming language and could run in mainframes, minicomputers, and PCs or any hardware with a C compiler. It supported the execution of SQL statements and transactions. This version also......

Words: 1424 - Pages: 6

Free Essay

Oracle

...COMPANY PROFILE Oracle Corporation REFERENCE CODE: C0CB6D9E-4EFE-4621-B998-73B241B46317 PUBLICATION DATE: 23 May 2014 www.marketline.com COPYRIGHT MARKETLINE. THIS CONTENT IS A LICENSED PRODUCT AND IS NOT TO BE PHOTOCOPIED OR DISTRIBUTED. Oracle Corporation TABLE OF CONTENTS TABLE OF CONTENTS Company Overview..............................................................................................3 Key Facts...............................................................................................................3 SWOT Analysis.....................................................................................................4 Oracle Corporation © MarketLine Page 2 Oracle Corporation Company Overview COMPANY OVERVIEW Oracle Corporation (Oracle or “the company”) is a provider of enterprise software, computer hardware products and services. The company operates in more than 145 countries across the world. Oracle is headquartered in Redwood Shores, California and employed 120,000 people as of May 31, 2013. The company recorded revenues of $37,180 million during the financial year ended May 2013 (FY2013), an increase of 0.2% over FY2012. The increase in revenues was due to an increase in Oracle’s software business revenues. The operating profit of the company was $14,684 million in FY2013, an increase of 7.1% over FY2012. The net profit was $10,925 million in FY2013, an increase of 9.5% over FY2012. KEY FACTS Head Office Oracle......

Words: 3160 - Pages: 13

Premium Essay

Oracle

...Israel Garcia Professor Neil Librock Finance 3300 21 October 2014 Oracle Corporation Most widely known for their Java software, the #1 development platform, Oracle is the so called leader in database software. Their business expands, however, from software to hardware with products such as storage equipment, servers, operating systems, virtualization software, middleware, and many more. It was founded in 1977 and today it is headquartered in our very own Golden state in Redwood City. We look first at measures of financial leverage, which is important because debt can increase or decrease returns to shareholders. Financial leverage is usually measured by the ratio of long-term debt to total long-term capital. Oracles long-term debt ratio for 2014 is 33%, an increase from 29% in 2013. This number tells us that for every dollar in the form of long-term capital, 33 cents is in the form of debt. This measure, however, ignores Oracle’s short-term debt. To take short-term debt into account we measure its total debt ratio, in this case Oracle’s total debt ratio is 47%. Ultimately, these numbers tell us that Oracle is financed 47% with long-term and short-term debt and 53% with equity. We want equity here to be higher than debt since the less money the company borrows, the less interest it pays. Next, we take a look at Oracle’s liquidity ratios. Liquid assets can be converted into cash quickly, which is why it is important to measure to see how quickly a company can bring......

Words: 652 - Pages: 3

Free Essay

Oracle for Dummies

...™ Everything Easier! Making cle 11g Ora ® Learn to: • Set up and manage an Oracle database • Maintain and protect your data • Understand Oracle database architecture • Troubleshoot your database and keep it running smoothly Chris Zeis Chris Ruel Michael Wessler www.it-ebooks.info www.it-ebooks.info Oracle 11g ® FOR DUMmIES ‰ www.it-ebooks.info www.it-ebooks.info Oracle 11g ® FOR DUMmIES by Chris Zeis, Chris Ruel, and Michael Wessler ‰ www.it-ebooks.info Oracle® 11g For Dummies® Published by Wiley Publishing, Inc. 111 River Street Hoboken, NJ 07030-5774 www.wiley.com Copyright © 2009 by Wiley Publishing, Inc., Indianapolis, Indiana Published by Wiley Publishing, Inc., Indianapolis, Indiana Published simultaneously in Canada No part of this publication may be reproduced, stored in a retrieval system or transmitted in any form or by any means, electronic, mechanical, photocopying, recording, scanning or otherwise, except as permitted under Sections 107 or 108 of the 1976 United States Copyright Act, without either the prior written permission of the Publisher, or authorization through payment of the appropriate per-copy fee to the Copyright Clearance Center, 222 Rosewood Drive, Danvers, MA 01923, (978) 750-8400, fax (978) 646-8600. Requests to the Publisher for permission should be addressed to the Permissions Department, John Wiley & Sons, Inc., 111 River Street, Hoboken, NJ 07030, (201) 748-6011, fax (201) 748-6008, or......

Words: 106399 - Pages: 426

Premium Essay

Apps

...the key questions in the United States v. Microsoft antitrust trial was whether Microsoft's Internet Explorer web browser was part of its Windows operating system or a separable piece of application software. As another example, the GNU/Linux naming controversy is, in part, due to disagreement about the relationship between the Linux kernel and the operating systems built over this kernel. In some types of embedded systems, the application software and the operating system software may be indistinguishable to the user, as in the case of software used to control a VCR, DVD player or microwave oven. The above definitions may exclude some applications that may exist on some computers in large organizations. For an alternative definition of an app: see Application Portfolio Management. [edit] Application software classificationApplication software falls into two general categories; horizontal applications and vertical applications. Horizontal applications are the most popular and widespread in departments or companies. Vertical applications are niche products, designed for a particular type of business or division in a company. There are many types of application software: An application suite consists of multiple applications bundled together. They usually have related functions, features and user interfaces, and may be able to interact with each other, e.g. open each other's files. Business applications often come in suites, e.g. Microsoft Office, OpenOffice.org and......

Words: 899 - Pages: 4

Premium Essay

Oracle

...Oracle Systems Corporation is a database management software company that found success in the 1980’s from being an innovator in multiplatform software development. Oracle’s business strategy focused on building its technical expertise and customer service to provide performance standards that could not be matched by competitors. Oracle adopted a first mover competitive advantage when it was the first company to deliver multiple-interface software along with a range of accounting applications - all at record-setting speeds. An incentive-driven sales force was established in order to market to large corporations that would benefit the most from its software. In return, Oracle saw growth rates as sales increased by nearly 700 million dollars from 1988 to 1990. Oracle’s key successes and risk factors can both be traced to their marketing and R&D costs, as well as expanding licensing agreements with hardware manufacturers and value-added resellers (VARs). The first mover advantage that Oracle established with its software allowed the company to venture into a wide arrange of services such as maintenance, consulting, and systems integration before its competitors. These services created a company that could specialize in both product quality and customer service. This instant expansion also came with its own set of problems. Customer satisfaction dropped due to an inability of the sales force to adapt to new territories and new software was being criticized for a number of...

Words: 580 - Pages: 3

Free Essay

Apps

...ORACLE Apps DBA How to confirm if Apps Listener is Up and Running ? execute below command lsnrctl status APPS_$SID (replcae SID with your Instance Name) How to compile Invalid Objects in database ? You can use adadmin utility to compile or you can use utlrp.sql script shipped with Oracle Database to compile Invalid Database Objects. How to compile JSP in Oracle Applications ? You can use ojspCompile.pl perl script shipped with Oracle Applications to compile JSP files. This script is under $JTF_TOP/admin/scripts. Sample compilation method is perl ojspCompile.pl --compile --quiet What is difference between ADPATCH and OPATCH ? # ADPATCH is utility to apply ORACLE application Patches whereas # OPATCH is utility to apply database patches Can you use both ADPATCH and OPATCH in application ? Yes you have to use both in application , for application patches you will use ADPATCH UTILITY and for applying database patch in application you will use opatch UTILITY. How to start Applications listener ? In Oracle 11i, you have script adalnctl.sh which will start your apps listener. You can also start it by command lsnrctl start APPS_$SID (Replace sid by your Instance SID Name) What is difference between ICM, Standard Managers and CRM in Concurrent Manager ? # ICM stand for Internal Concurrent Manager, which controls other managers. If it finds other managers down , it checks and try to restart them. You can say it as administrator to other......

Words: 2172 - Pages: 9

Free Essay

Oracle

...Oracle Database 11g Release 2 (11.2) Installation On Oracle Linux 6 This article describes the installation of Oracle Database 11g Release 2 (11.2) (64-bit) on Oracle Linux 6 (64-bit). The article is based on a server installation with a minimum of 2G swap, with both SELinux and the firewall disabled. The following package groups were included for this installation. * Base System * Base * Debugging Tools * Directory Client * Hardware monitoring Client * Large Systems Performance * Network file system client * Performance Tools * Perl Support * Servers * Server Platform * System administration tools * Desktops * Desktop * Desktop Platform * Fonts * General Purpose Desktop * Graphical Administration Tools * X Windows System * Applications * Internet Browser * Development * Development Tools An example of this type of Linux installations can be seen here. Alternative installations may require more packages to be loaded, in addition to the ones listed below. Note. At the time of writing Oracle have not certified any of their database products on OL6 or RHEL6, so you shouldn't use these operating systems for anything important until the certification is complete. * Download Software * Unpack Files * Hosts File * Set Kernel Parameters * Setup * Installation * Post Installation Download Software Download......

Words: 1320 - Pages: 6

Premium Essay

Apps

...platform for Apple's email servers and calendars. Third-party iOS and OS X app developers are able to implement iCloud functionality in their apps through the iCloud API.[25] Backup and restore[edit] iCloud allows users to back up the settings and data on iOS devices running iOS 5 or later.[26] Data backed up includes photos and videos in the Camera Roll, device settings, app data, messages (iMessage, SMS, and MMS), ringtones, and Visual Voicemails. Backups occur daily when the device is locked and connected to Wi-Fi and a power source. In case of a malfunction of any Apple device, during the restoration process, iCloud offers to restore all data along with App data only if the device was synced to iCloud and backed up. Back to My Mac[edit] Main article: Back to My Mac Back to My Mac, also previously part of MobileMe, is now part of iCloud.[27] As before, this service allows users to log in remotely to other computers that have Back to My Mac enabled and are configured with the same Apple ID. Email[edit] As with MobileMe (and .Mac and iTools before it), an iCloud account includes an email account. Unlike MobileMe and its previous iterations, an email address is an optional part of an iCloud account, in that the user can choose not to use it but can still use the email as their iCloud Apple ID. The email account can be accessed using any standard IMAP-compatible email client, as well as the online web app mail client at the iCloud.com. Additionally, on an iOS device,......

Words: 3611 - Pages: 15

Premium Essay

Oracle

...Oracle 11g PL/SQL New Features PL/SQL "continue" keyword - This will allow a "C-Like" continue in a loop, skipping an iteration to bypass any "else" Boolean conditions. A nasty PL/SQL GOTO statement is no longer required to exit a Boolean within a loop. Oracle professional Jurgen Kemmelings has an excellent PL/SQL example of the PL/SQL continue clause in-action: begin for i in 1..3 loop dbms_output.put_line(’i=’||to_char(i)); if ( i = 2 ) then continue; end if; dbms_output.put_line(’Only if i is not equal to 2′); end loop; end; Disabled state for PL/SQL - Another 11g new feature is a "disabled" state for PL/SQL (as opposed to "enabled" and "invalid" in dba_objects). Easy PL/SQL compiling - Native Compilation no longer requires a C compiler to compile your PL/SQL. Your code goes directly to a shared library. Source: Lewis Cunningham Improved PL/SQL stored procedure invalidation mechanism - A new 11g features will be fine grained dependency tracking, reducing the number of objects which become invalid as a result of DDL. Scalable PL/SQL - The next scalable execution feature is automatic creation of "native" PL/SQL (and Java code), with just one parameter for each type with an "on/off" value. This apparently provides a 100% performance boost for pure PL/SQL code, and a 10%-30% performance boost for code containing SQL. Mark Rittman Enhanced PL/SQL warnings - The 11g PL/SQL compiler will issue a......

Words: 269 - Pages: 2