Oracle Work in Process Technical Reference Manual

Oracle Work In Process Technical Reference Manual-Free PDF

  • Date:27 Jun 2020
  • Views:8
  • Downloads:0
  • Pages:454
  • Size:1.22 MB

Share Pdf : Oracle Work In Process Technical Reference Manual

Download and Preview : Oracle Work In Process Technical Reference Manual


Report CopyRight/DMCA Form For : Oracle Work In Process Technical Reference Manual


Transcription:

Oracler Work in Process,Technical Reference,RELEASE 11i. December 1999, Oracler Work in Process Technical Reference Manual. Release 11i,To order this book ask for Part No A81185 01. Copyright E 1994 1999 Oracle Corporation All rights reserved. Major Contributors Biju Baby Reena Bankar Boulus Harb Serena Li Rui Liu. Contributors Daryl Breen Jung Min Ha, This Technical Reference Manual TRM in any form software or printed matter contains proprietary information of Oracle Corporation it is. provided under an Oracle Corporation agreement containing restrictions on use and disclosure and is also protected by copyright patent and. other intellectual property law Restrictions applicable to this TRM include but are not limited to a exercising either the same degree of care to. safeguard the confidentiality of this TRM as you exercise to safeguard the confidentiality of your own most important Confidential Information or. a reasonable degree of care whichever is greater b maintaining agreements with your employees and agents that protect the Confidential. Information of third parties such as Oracle Corporation and instructing such employees and agents of these requirements for this TRM c. restricting disclosure of this TRM to those of your employees who have a need to know consistent with the purposes for which this TRM was. disclosed to you d maintaining this TRM at all times on your premises e not removing or destroying any proprietary or confidential legends. or markings placed upon this TRM in whatever form software or printed matter and f not reproducing or transmitting this TRM in any form or. by any means electronic or mechanical for any purpose without the express written permission of Oracle Corporation You should not use this. TRM in any form software or printed matter to create software that performs the same or similar functions as any Oracle Corporation products. The information in this TRM is subject to change without notice If you find any problems in the TRM in any form software or printed matter. please report them to us in writing Oracle Corporation does not warrant that this TRM is error free This TRM is provided to customer as is. with no warranty of any kind This TRM does not constitute Documentation as that term is defined in Oracle s agreements. Reverse engineering of the Programs software and documentation associated with this TRM are prohibited The Programs associated with this. TRM are not intended for use in any nuclear aviation mass transit medical or other inherently dangerous applications It shall be licensee s. responsibility to take all appropriate fail safe back up redundancy and other measures to ensure the safe use of such applications if the. Programs are used for such purposes and Oracle disclaims liability for any damages caused by such use of the Programs. Restricted Rights Legend, This TRM and the Programs associated with this TRM delivered subject to the DOD FAR Supplement are commercial computer software and.
use duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the licensing restrictions set forth in the. applicable Oracle license agreement Otherwise this TRM and the Programs associated with this TRM delivered subject to the Federal. Acquisition Regulations are restricted computer software and use duplication and disclosure of the TRM and the Programs associated with this. TRM shall be subject to the restrictions in FAR 52 227 14 Rights in Data General including Alternate III June 1987 Oracle Corporation 500. Oracle Parkway Redwood City CA 94065, Oracle is a registered trademark and CASE Exchange Enabling the Information Age Hyper SQL NLS Workbench Oracle7 Oracle8 Oracle 8i. Oracle Access Oracle Application Object Library Oracle Discoverer Oracle Financials Oracle Quality Oracle Web Customers Oracle Web. Employees Oracle Work in Process Oracle Workflow PL SQL Pro Ada Pro C Pro COBOL Pro FORTRAN Pro Pascal Pro PL I SmartClient. SQL Connect SQL Forms SQL Loader SQL Menu SQL Net SQL Plus and SQL Report are trademarks or registered trademarks of Oracle. Corporation Other names may be trademarks of their respective owners. T his Technical Reference Manual in any form software or. printed matter contains proprietary confidential information. that is the exclusive property of Oracle Corporation If you do not. have a valid contract with Oracle for the use of this Technical Reference. Manual or have not signed a non disclosure agreement with Oracle. covering this Technical Reference Manual then you received this. document in an unauthorized manner and are not legally entitled to. possess or read it, Use duplication and disclosure are subject to restrictions stated in. your contract with Oracle Corporation,Chapter 1 Introduction 1 1. Chapter 2 High Level Design 2 1,Overview of High Level Design 2 2. Summary Database Diagram 2 5,Database Diagrams 2 9.
Public Table List 2 20,Public View List 2 28,Forms and Table View List 2 30. Internal View List 2 32,Single Organization View List 2 34. Module List 2 35,Chapter 3 Detailed Design 3 1,Overview of Detailed Design 3 2. Table and View Definitions 3 3, Oracle Proprietary Confidential Information Use Restricted by Contract. Contents v, Oracle Proprietary Confidential Information Use Restricted by Contract.
vi Oracle Work in Process Technical Reference Manual. 1 Introduction, T he Oracle Work in Process Technical Reference Manual provides the. information you need to understand the underlying structure of. Oracle Work in Process After reading this manual you should be able. to convert your existing applications data integrate your existing. applications with Oracle Work in Process and write custom reports for. Oracle Work in Process as well as read data that you need to perform. other tasks, This chapter introduces you to the Oracle Work in Process Technical. Reference Manual and explains how to use it, Oracle Proprietary Confidential Information Use Restricted by Contract. Introduction 1 1,Introduction, At Oracle we design and build applications using Oracle Designer our. systems design technology that provides a complete environment to. support developers through all stages of a systems life cycle Because. we use a repository based design toolset all the information regarding. the underlying structure and processing of our applications is available. to us online Using Oracle Designer we can present this information to. you in the form of a technical reference manual, This Oracle Work in Process Technical Reference Manual contains detailed.
up to date information about the underlying structure of Oracle Work. in Process As we design and build new releases of Oracle Work in. Process we update our Oracle Designer repository to reflect our. enhancements As a result we can always provide you with an Oracle. Work in Process Technical Reference Manual that contains the latest. technical information as of the publication date Note that after the. publication date we may have added new indexes to Oracle Work in. Process to improve performance,About this Manual, This manual describes the Oracle Applications Release 11i data model. as used by Work in Process it discusses the database we include with a. fresh install of Oracle Applications Release 11i If you have not yet. upgraded to Release 11i your database may differ from the database. we document in this book, If you have upgraded from a previous release you might find it helpful. to use this manual with the appropriate Oracle Applications Product. Update Notes manual The product update notes list database changes. and seed data changes in Oracle Work in Process between releases The. Oracle Applications Product Update Notes Release 11 manual describes the. changes between Release 10 7 and Release 11 and the Oracle. Applications Product Update Notes Release 11i manual describes the. changes between Release 11 and Release 11i, You can contact your Oracle representative to confirm that you have. the latest technical information for Work in Process You can also use. OracleMetaLink which is accessible through Oracle s Support Web. Center http www oracle com support elec sup, Oracle Proprietary Confidential Information Use Restricted by Contract. 1 2 Oracle Work in Process Technical Reference Manual. Finding the Latest Information, The Oracle Work in Process Technical Reference Manual contains the latest.
information as of the publication date For the latest information we. encourage you to use OracleMetaLink which is accessible through. Oracle s Support Web Center http www oracle com support elec sup. The Oracle Work in Process Technical Reference Manual provides useful. guidance and assistance to,Technical End Users,Consultants. Systems Analysts,System Administrators,Other MIS professionals. This manual assumes that you have a basic understanding of. structured analysis and design and of relational databases It also. assumes that you are familiar with Oracle Application Object Library. and Oracle Work in Process If you are not familiar with the above. products we suggest that you attend one or more of the training. classes available through Oracle Education see Other Information. Sources page 1 8,How This Manual is Organized, This manual contains two major sections High Level Design and. Detailed Design,High Level Design, This section Chapter 2 contains database diagrams and lists each. database table and view that Work in Process uses This chapter also. has a list of modules, Oracle Proprietary Confidential Information Use Restricted by Contract.
Introduction 1 3,Detailed Design, This section Chapter 3 contains a detailed description of the Work in. Process database design including information about each database. table and view you might need for your custom reporting or other data. requirements, Oracle Proprietary Confidential Information Use Restricted by Contract. 1 4 Oracle Work in Process Technical Reference Manual. How to Use This Manual, The Oracle Work in Process Technical Reference Manual is a single. centralized source for all the information you need to know about the. underlying structure and processing of Oracle Work in Process For. example you can use this manual when you need to,Convert existing application data. Integrate your Work in Process application with your other. applications systems,Write custom reports,Define alerts against Oracle Applications tables.
Configure your Oracle Self Service Web Applications. Create views for decision support queries using query tools. Create business views for Oracle Discoverer, You need not read this manual cover to cover Use the table of contents. and index to quickly locate the information you need. How Not To Use This Manual,Do not use this manual to plan modifications. You should not use this manual to plan modifications to Oracle Work in. Process Modifying Oracle Work in Process limits your ability to. upgrade to future releases of your Work in Process application In. addition it interferes with our ability to give you the high quality. support you deserve, We have constructed Oracle Work in Process so that you can customize. it to fit your needs without programming and you can integrate it with. your existing applications through interface tables However should. you require program modifications you should contact our support. team see Other Information Sources page 1 8 They can put you. in touch with Oracle Services the professional consulting organization. of Oracle Their team of experienced applications professionals can. make the modifications you need while ensuring upward compatibility. with future product releases, Oracle Proprietary Confidential Information Use Restricted by Contract. Introduction 1 5,Do not write data into non interface tables.
Oracle reserves the right to change the structure of Oracle Applications. tables and to change the meaning of add or delete lookup codes and. data in future releases Do not write data directly into or change data. in non interface tables using SQL Plus or other programming tools. because you risk corrupting your database and interfering with our. ability to support you, Moreover this version of the Oracle Work in Process Technical Reference. Manual does not contain complete information about the dependencies. between Work in Process applications tables Therefore you should. write data into only those tables we identify as interface tables If you. write data into other non interface tables you risk violating your data. integrity since you might not fulfill all the data dependencies in your. Work in Process application, You are responsible for the support and upgrade of the logic within the. procedures that you write which may be affected by changes between. releases of Oracle Applications, Do not rely on upward compatibility of the data model. Oracle reserves the right to change the structure of Oracle Work in. Process tables and to change the meaning of add or delete lookup. codes and other data in future releases We do not guarantee the. upward compatibility of the Oracle Work in Process data model For. example if you write a report that identifies concurrent requests that. end in Error status by selecting directly from Oracle Application Object. Library tables we do not guarantee that your report will work properly. products we suggest that you attend one or more of the training classes available through Oracle Education see Other Information Sources page 1 8 How This Manual is Organized This manual contains two major sections High Level Design and Detailed Design High Level Design This section Chapter 2 contains database diagrams and lists each database table and view that Work in

Related Books