Oracle Manufacturing APIs and Open Interfaces Manual

Oracle? Manufacturing APIs and Open Interfaces Manual

Volume 1

Release 11i

February 2001

Part No. A88838-01

Oracle? Manufacturing APIs and Open Interfaces Manual, Release 11i

Part No. A88838-01

Copyright ? 1999, 2000 Oracle Corporation. All rights reserved.

Contributing Authors:

Sonczalla

Contributors:

Jill Arehart, Rachel Haas, Elizabeth Looney, Tom Myers, Susan Saperstein, Amy

David Reitan

The programs 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.

This Program contains proprietary information of Oracle Corporation; it is provided under a license

agreement containing restrictions on use and disclosure and is also protected by copyright, patent and

other intellectual property law. Reverse engineering of the software is prohibited.

Program Documentation is licensed for use solely to support the deployment of the Programs and not for

any other purpose.

The information contained in this document is subject to change without notice. If you find any problems

in the documentation, please report them to us in writing. Oracle Corporation does not warrant that this

document is error free. No part of this document may be reproduced or transmitted in any form or by

any means, electronic or mechanical, for any purpose, without the express written permission of Oracle

Corporation

If this Program is delivered to a U.S. Government Agency of the Department of Defense, then it is

delivered with Restricted Rights and the following legend is applicable:

Restricted Rights Legend Programs delivered subject to the DOD FAR Supplement are ¡°commercial

computer software¡± and use, duplication and disclosure of the Programs shall be subject to the licensing

restrictions set forth in the applicable Oracle license agreement. Otherwise, Programs delivered subject to

the Federal Acquisition Regulations are ¡°restricted computer software¡± and use, duplication and

disclosure of the Programs 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 Oracle Applications, Oracle Inventory, Oracle EDI Gateway, Oracle

Payables, Oracle Purchasing, Oracle Self-Service Purchasing, Oracle Self-Service Web Applications,

Context, Financial Analyzer, Oracle7, Oracle8, Oracle Alert, Oracle Applications, Oracle Discoverer,

Oracle Financials, Object Library, Oracle Work in Process, Oracle Workflow, SmartClient, PL/SQL,

SQL*Calc, SQL*Forms, SQL*Loader, SQL*Menu, SQL*Net, SQL*Plus, SQL*Report, SQL*ReportWriter,

Oracle Web Employees, and SQL*QMX are trademarks or registered trademarks of Oracle Corporation.

Windows NT is a registered trademark of Microsoft Corporation. All other company or product names

mentioned are used for identification purposes only and may be trademarks of their respective owners.

Contents

Send Us Your Comments ................................................................................................................... xi

Preface........................................................................................................................................................... xiii

About This Manual.........................................................................................................................

Audience for This Manual............................................................................................................

Do Not Use Database Tools to Modify Oracle Applications Data .........................................

Other Information Sources............................................................................................................

1

xiii

xiv

xiv

xv

Integrating Your Systems

Overview of Oracle Manufacturing APIs and Open Interfaces ................................................

Basic Business Needs ...................................................................................................................

Oracle Manufacturing Interfaces................................................................................................

Inbound Open Interface Model ..................................................................................................

Components of an Open Interface .............................................................................................

1-2

1-2

1-2

1-7

1-9

2 Oracle ASCP and Oracle Global ATP Server Open Interfaces

ODS Load API Features.....................................................................................................................

Functional Overview..........................................................................................................................

Setting Up the ODS Load API..........................................................................................................

Parameter Descriptions................................................................................................................

2-2

2-7

2-7

2-8

3 Bills of Material Business Object Interface

Overview .............................................................................................................................................. 3-2

iii

Bills of Material Entity Diagram.....................................................................................................

Business Object APIs ....................................................................................................................

Business object interface Design.................................................................................................

Detailed Business object interface Design.................................................................................

Overall Import Description .......................................................................................................

Columns Exposed to User .........................................................................................................

Import Mechanics .............................................................................................................................

Launching the Import ................................................................................................................

Package Interaction ....................................................................................................................

Import Error Handling and Messaging...................................................................................

Bill of Material Export API ........................................................................................................

Launching the Export.................................................................................................................

Export Error Handling and Messaging ...................................................................................

3-3

3-5

3-6

3-9

3-11

3-15

3-21

3-26

3-32

3-35

3-45

3-45

3-46

4 Oracle Cost Management Open Interfaces

Periodic Cost Open Interface............................................................................................................

Functional Overview....................................................................................................................

Setting Up the Interface.....................................................................................................................

Create Indexes for Performance .................................................................................................

Periodic Cost Open Interface Runtime Options...........................................................................

Inserting into the Periodic Cost Interface Tables .........................................................................

Periodic Costs Interface Table Description ...............................................................................

Periodic Cost Detail Interface Table Description .....................................................................

Required Data................................................................................................................................

Derived Data..................................................................................................................................

Validation .............................................................................................................................................

Importing Additional Periodic Cost Details ...........................................................................

Reviewing Failed Rows ...................................................................................................................

Log File Messages .......................................................................................................................

4-2

4-2

4-3

4-3

4-4

4-4

4-4

4-7

4-8

4-9

4-9

4-12

4-12

4-12

5 Engineering Change Order Business Object Interface

Features .................................................................................................................................................

ECO Business Object ....................................................................................................................

Business Object APIs .........................................................................................................................

Process Flow ..................................................................................................................................

iv

5-2

5-3

5-6

5-9

Entity Process Flows.........................................................................................................................

ECO Headers...............................................................................................................................

ECO Revisions.............................................................................................................................

Revised Items ..............................................................................................................................

Revised Components .................................................................................................................

Reference Designators................................................................................................................

Substitute Components..............................................................................................................

New API Packages .....................................................................................................................

Launching the Import ................................................................................................................

Package Interaction ....................................................................................................................

Sample Launch Package ............................................................................................................

Import Error Handling and Messaging...................................................................................

Error Handling Concepts ..........................................................................................................

API Messaging ............................................................................................................................

Error Handler ..............................................................................................................................

5-13

5-14

5-15

5-17

5-19

5-22

5-23

5-24

5-27

5-32

5-35

5-46

5-46

5-55

5-56

6 Oracle Inventory Open Interfaces and APIs

Open Transaction Interface...............................................................................................................

Functional Overview....................................................................................................................

Setting Up the Transaction Interface .........................................................................................

Inserting into the Transaction Interface Tables ........................................................................

MTL_TRANSACTION_LOTS_INTERFACE..........................................................................

MTL_SERIAL_NUMBERS_INTERFACE................................................................................

CST_COMP_SNAP_INTERFACE..........................................................................................

Validation ....................................................................................................................................

Resolving Failed Transaction Interface Rows ........................................................................

Open Replenishment Interface......................................................................................................

Functional Overview..................................................................................................................

Setting Up the Replenishment Interface..................................................................................

Inserting into the Replenishment Interface Tables ................................................................

Replenishment Headers Interface Tables................................................................................

Validation ....................................................................................................................................

Viewing Failed Transactions.....................................................................................................

Fixing Failed Transactions ........................................................................................................

Open Item Interface .........................................................................................................................

6-2

6-2

6-6

6-7

6-22

6-23

6-25

6-26

6-26

6-28

6-28

6-29

6-29

6-30

6-35

6-36

6-37

6-38

v

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download