Oracle® Order Management

Open Interfaces, API, & Electronic Messaging Guide

Release 12
Part No. B31585-01

April 2007
Oracle Order Management Open Interfaces, API, & Electronic Messaging Guide, Release 12

Part No. B31585-01

Copyright © 1996, 2007, Oracle. All rights reserved.

Primary Author:     John Brazier, Pratima Mahtani, John Salvini

Contributing Author:     Alok Singh, Pravin Nair, Rakesh Moharana, Sasi Erla, Anjana Ramachandran

The Programs (which include both the software and documentation) contain proprietary information; they
are provided under a license agreement containing restrictions on use and disclosure and are also protected
by copyright, patent, and other intellectual and industrial property laws. Reverse engineering, disassembly, or
decompilation of the Programs, except to the extent required to obtain interoperability with other
independently created software or as specified by law, is prohibited.

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. This document is not warranted to be error-free.
Except as may be expressly permitted in your license agreement for these Programs, no part of these
Programs may be reproduced or transmitted in any form or by any means, electronic or mechanical, for any
purpose.

If the Programs are delivered to the United States Government or anyone licensing or using the Programs on
behalf of the United States Government, the following notice is applicable:

U.S. GOVERNMENT RIGHTS

Programs, software, databases, and related documentation and technical data delivered to U.S. Government
customers are "commercial computer software" or "commercial technical data" pursuant to the applicable
Federal Acquisition Regulation and agency-specific supplemental regulations. As such, use, duplication,
disclosure, modification, and adaptation of the Programs, including documentation and technical data, shall
be subject to the licensing restrictions set forth in the applicable Oracle license agreement, and, to the extent
applicable, the additional rights set forth in FAR 52.227-19, Commercial Computer Software--Restricted
Rights (June 1987). Oracle Corporation, 500 Oracle Parkway, Redwood City, CA 94065.

The Programs are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently
dangerous applications. It shall be the licensee's responsibility to take all appropriate fail-safe, backup,
redundancy and other measures to ensure the safe use of such applications if the Programs are used for such
purposes, and we disclaim liability for any damages caused by such use of the Programs.

The Programs may provide links to Web sites and access to content, products, and services from third parties.
Oracle is not responsible for the availability of, or any content provided on, third-party Web sites. You bear all
risks associated with the use of such content. If you choose to purchase any products or services from a third
party, the relationship is directly between you and the third party. Oracle is not responsible for: (a) the quality
of third-party products or services; or (b) fulfilling any of the terms of the agreement with the third party,
including delivery of products or services and warranty obligations related to purchased products or services.
Oracle is not responsible for any loss or damage of any sort that you may incur from dealing with any third
party.

Oracle, JD Edwards, PeopleSoft, and Siebel are registered trademarks of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective owners.
  
Contents

Send Us Your Comments

Preface

1 Integrating Your Systems

Overview of Oracle Order Management APIs and Open Interfaces....................................... 1-1
Basic Business Needs................................................................................................................ 1-1
Oracle Order Management Interfaces.......................................................................................1-2
Inbound Open Interface Model.............................................................................................. 1-11
Components of an Open Interface.......................................................................................... 1-13

2 Oracle Advanced Pricing Open Interfaces and APIs

Key of Short Names................................................................................................................... 2-2
Agreements Public Application Program Interface................................................................. 2-2
Functional Overview........................................................................................................... 2-2
Setting Up and Using Parameter Descriptions.....................................................................2-2
Validation of Agreements Public API................................................................................ 2-26
Example of Agreements Public API................................................................................... 2-26
Attribute Mapping Application Program Interface............................................................... 2-26
Functional Overview......................................................................................................... 2-27
Setting Up and Parameter Descriptions............................................................................. 2-28
Business Object for Modifier Setup Application Program Interface.................................... 2-48
Functional Overview......................................................................................................... 2-48
Setting Up and Parameter Descriptions............................................................................. 2-50
Validation of Business Object for Modifier Setup API....................................................... 2-86
Example of Modifier Setup Application Program Interface...............................................2-86

    iii
 Business Object for Pricing Formulas Application Program Interface..................................2-87
Functional Overview......................................................................................................... 2-87
Setting Up and Parameter Descriptions............................................................................. 2-88
Validation of Business Object for Pricing Formulas API....................................................2-99
Example of Pricing Formulas API...................................................................................... 2-99
Business Object for Pricing Limits Application Program Interface.................................... 2-100
Functional Overview....................................................................................................... 2-100
Setting Up and Parameter Descriptions........................................................................... 2-101
Validation of Limits Public API....................................................................................... 2-118
Example of Limits Public API.......................................................................................... 2-119
Create Publish Price Book Application Program Interface.................................................. 2-119
Functional Overview....................................................................................................... 2-119
Setting Up and Parameter Descriptions........................................................................... 2-120
Validation of Create Publish Price Book API................................................................... 2-123
Examples of Create_Publish_Price_Book API.................................................................. 2-126
Get Currency Application Program Interface....................................................................... 2-126
Functional Overview....................................................................................................... 2-126
Setting Up and Parameter Descriptions........................................................................... 2-126
Validation of Get_Currency API...................................................................................... 2-127
Get Custom Price Application Program Interface................................................................ 2-128
Functional Overview....................................................................................................... 2-128
Setting Up and Parameter Descriptions........................................................................... 2-128
Validation of Get Custom Price API................................................................................ 2-130
Get Price Book Application Program Interface ................................................................... 2-133
Functional Overview....................................................................................................... 2-133
Setting Up and Parameter Descriptions .......................................................................... 2-134
Validation of Get Price Book API..................................................................................... 2-144
Examples of Get_Price_Book API.................................................................................... 2-145
Get Price List Application Program Interface.......................................................................2-145
Functional Overview....................................................................................................... 2-145
Setting Up and Parameter Descriptions........................................................................... 2-146
Validation of Get_Price_List API..................................................................................... 2-147
Multi-Currency Conversion Setup Application Program Interface.....................................2-147
Functional Overview....................................................................................................... 2-147
Setting Up and Parameter Descriptions........................................................................... 2-148
Validation of Multi-Currency Conversion API................................................................ 2-156
Example of Multi-Currency Conversion API................................................................... 2-157
Price List Setup Application Program Interface................................................................... 2-157
Functional Overview....................................................................................................... 2-157
Setting Up and Parameter Descriptions........................................................................... 2-159
Validation of Price List Setup API....................................................................................2-178

iv
 Example of Price List Setup API...................................................................................... 2-178
Price List Setup Group Application Program Interface....................................................... 2-179
Functional Overview....................................................................................................... 2-179
Setting Up and Parameter Descriptions........................................................................... 2-180
Validation of Price List Group API.................................................................................. 2-199
Price Request Application Program Interface...................................................................... 2-200
Functional Overview....................................................................................................... 2-201
Setting Up and Parameter Descriptions........................................................................... 2-202
Validation of Price Request API....................................................................................... 2-260
Example of Price Request Application Program Interface............................................... 2-260
Pricing Data Bulk Loader API............................................................................................... 2-263
Functional Overview .......................................................................................................2-263
Setting Up and Parameter Descriptions........................................................................... 2-264
Validation of Pricing Data Bulk Loader .......................................................................... 2-265
Examples of Pricing Data Bulk Loader API..................................................................... 2-267
Pricing Object Security - Check Function API..................................................................... 2-275
Functional Overview....................................................................................................... 2-276
Setting Up and Parameter Descriptions........................................................................... 2-276
Validation of Pricing Object Security API........................................................................ 2-278
Pricing Attributes Application Program Interface............................................................... 2-278
Functional Overview....................................................................................................... 2-278
Attribute Mapping Application Program Interface............................................................. 2-291
Functional Overview....................................................................................................... 2-291
Setting Up and Parameter Descriptions........................................................................... 2-291
Validation of Attribute Mapping API.............................................................................. 2-297
Qualifiers Application Program Interface............................................................................ 2-297
Functional Overview....................................................................................................... 2-297
Setting Up and Parameter Descriptions .......................................................................... 2-298
Validation of Qualifiers API.............................................................................................2-315
Example of Qualifiers API............................................................................................... 2-315
Reverse Limits Application Program Interface.................................................................... 2-315
Functional Overview....................................................................................................... 2-316
Setting Up and Parameter Descriptions........................................................................... 2-316
Validation of Reverse Limits API..................................................................................... 2-321
Example of Reverse Limits API........................................................................................2-322
Round Price Application Program Interface........................................................................ 2-323
Functional Overview....................................................................................................... 2-323
Setting Up and Parameter Descriptions........................................................................... 2-324
Validation of Round Price API......................................................................................... 2-325
Validate Price List with Currency Code Application Program Interface............................ 2-325
Functional Overview....................................................................................................... 2-326

    v
 Setting Up and Parameter Descriptions........................................................................... 2-326
Validation of Validate Price List with Currency Code API.............................................. 2-326

3 Oracle Advanced Pricing XML Transactions

Get Catalog Transaction............................................................................................................ 3-1
Setting up and Parameter Descriptions................................................................................3-2
Validation of Get Catalog Transaction............................................................................... 3-12
Examples of the Get Catalog Transaction ......................................................................... 3-13
Sync Catalog Transaction........................................................................................................ 3-17
Setting Up and Parameter Descriptions............................................................................. 3-18
Validation of Sync Catalog Transaction............................................................................. 3-29
Examples of Sync Catalog Transaction.............................................................................. 3-29

4 Oracle Order Management XML Transactions: Implementation Considerations

Process_PO................................................................................................................................ 4-1
Setup: Customer Setup.........................................................................................................4-1
Installation..................................................................................................................... 4-6
Message Map: Seeded Workflow for Inbound XML Messages............................................4-7
Sample Business Flow for 3A4 Process PO/3A4 Acknowledge PO............................... 4-9
Acknowledge_PO.................................................................................................................... 4-22
Message Map..................................................................................................................... 4-22
Setup: Customer Setup.......................................................................................................4-22
Oracle XML Gateway Details............................................................................................. 4-26
Show_SalesOrder.................................................................................................................... 4-27
Setup.................................................................................................................................. 4-27
Additional User Setup................................................................................................. 4-31
Change_SalesOrder................................................................................................................. 4-39
Setup.................................................................................................................................. 4-39
Data Archive and Purge Procedures........................................................................... 4-43
Change_PO.............................................................................................................................. 4-44
Setup: Customer Setup.......................................................................................................4-44
Implementation Considerations.........................................................................................4-47
Message Map..................................................................................................................... 4-47
Sample Business Flow for 3A4 Process PO/3A4 Acknowledge PO....................................4-76
Cancel_PO............................................................................................................................... 4-86
Setup: Customer Setup ...................................................................................................... 4-86
Implementation Considerations.........................................................................................4-90
Open Interface Tracking ........................................................................................................ 4-90
Setup: Customer Setup.......................................................................................................4-90
Integration Event – oracle.apps.ont.oi.xml_int.status............................................................ 4-91

vi
 User Procedures............................................................................................................... 4-100

5 Oracle Order Management XML Transactions

What is RosettaNet?.................................................................................................................. 5-1
Process_PO ................................................................................................................................ 5-4
Acknowledge_PO.................................................................................................................... 5-41
Show_SalesOrder ................................................................................................................... 5-62
Change_salesorder.................................................................................................................. 5-78
Inbound Change PO Request ................................................................................................ 5-96
Cancel Purchase Order ......................................................................................................... 5-136
CONFIRM BOD.................................................................................................................... 5-139
Message Map................................................................................................................... 5-139
Seeded Workflow for Inbound XML Messages................................................................... 5-148
Message Details .................................................................................................................... 5-150
Extension Tags....................................................................................................................... 5-153
Open Interface Tracking ...................................................................................................... 5-156
Overview......................................................................................................................... 5-156
Major Features................................................................................................................. 5-157
Business Scenarios and Process Flow............................................................................... 5-158
Messages.......................................................................................................................... 5-158
Event/Event Subscription...................................................................................................... 5-161
Seeded workflow OEEM/Open Interface Tracking............................................................. 5-161
Event Parameters & Population............................................................................................ 5-161

6 Oracle Order Management EDI Transactions

Oracle Order Management........................................................................................................ 6-1
Inbound Purchase Order (POI/850/ORDERS).......................................................................... 6-2
Order Import ............................................................................................................................. 6-5
Review and Resolve Order Management Open Interface Exceptions..................................... 6-5

7 Oracle Order Management Open Interfaces and APIs

Integrating Oracle Order Management Using Order Import...................................................7-1
Process Order Application Open Interface........................................................................... 7-110

8 Oracle Order Management: Integration with Other Products

Integrating Oracle Order Management with Oracle Receivables and Invoicing.................... 8-1
Telecommunications Services Orders (MACD) Interfaces.................................................... 8-52

    vii
9 Oracle Release Management XML Transactions
Overview of Oracle Release Management XML...................................................................... 9-1
Planning Schedule Transaction................................................................................................ 9-3
Sample Document Type Definition (DTD) and XML for Planning Schedule.......................9-4
Planning Schedule XML to Database Mapping................................................................... 9-9
Shipping Schedule Transaction.............................................................................................. 9-18
Sample Document Type Definition (DTD) and XML for Shipment Schedule....................9-20
Shipping Schedule XML to Database Mapping................................................................. 9-23

10 Oracle Release Management EDI Transactions

Production Sequence EDI....................................................................................................... 10-1
Shipping Schedule EDI........................................................................................................... 10-1
Planning Schedule EDI........................................................................................................... 10-2
Purpose Codes......................................................................................................................... 10-2
Transaction Descriptions........................................................................................................ 10-4

11 Oracle Release Management Open Interfaces and APIs

Understanding the Demand Processor Interface Tables........................................................ 11-1
Release Management Schedule Headers RLM_INTERFACE_HEADERS_ALL................ 11-1
Release Management Schedule Lines RLM_INTERFACE_LINES_ALL.......................... 11-23

12 Oracle Shipping Execution Open Interfaces and APIs

Overview of API Information................................................................................................. 12-1
Shipment Processing Using APIs........................................................................................... 12-3
Actions, APIs, and Parameters.............................................................................................. 12-16
Application Parameter Initialization.................................................................................... 12-34
Trip Public Application Program Interface.......................................................................... 12-35
Create_Update_Trip API Features................................................................................... 12-35
Functional Overview................................................................................................. 12-35
Trip_Action API Features................................................................................................ 12-41
Functional Overview................................................................................................. 12-41
Trip_Action (overloaded version) API features............................................................... 12-43
Functional Overview................................................................................................. 12-44
Stop Public Application Program Interface.......................................................................... 12-49
Create_Update_Stop API Features...................................................................................12-49
Functional Overview................................................................................................. 12-49
Stop_Action API Features................................................................................................ 12-56
Functional Overview................................................................................................. 12-56

viii
Deliveries Public Application Program Interface................................................................ 12-59
Create_Update_Delivery API Features............................................................................ 12-59
Functional Overview................................................................................................. 12-59
Delivery_Action API Features......................................................................................... 12-70
Functional Overview................................................................................................. 12-70
Generate_Documents API Features................................................................................. 12-76
Functional Overview................................................................................................. 12-76
Setting Up the Generate_Documents API........................................................................ 12-77
Exceptions Application Program Interface........................................................................... 12-78
Exception_Action API Features....................................................................................... 12-78
Functional Overview................................................................................................. 12-78
Setting Up the Exception_Actions API............................................................................ 12-79
Get_Exceptions API Features........................................................................................... 12-87
Functional Overview................................................................................................. 12-87
Setting Up the Get_Exceptions API..................................................................................12-87
Delivery Details Public Application Program Interface...................................................... 12-89
Detail_To_Delivery API Features.................................................................................... 12-90
Functional Overview................................................................................................. 12-90
Split_Line API Features................................................................................................... 12-92
Functional Overview................................................................................................. 12-92
Update_Shipping_Attributes API Features..................................................................... 12-95
Functional Overview................................................................................................. 12-95
Autocreate_Deliveries API Features.............................................................................. 12-107
Autocreate_Del_Trip API Features................................................................................ 12-109
Get_Detail_Status API Features..................................................................................... 12-111
Functional Overview............................................................................................... 12-111
Update_Shipping_Attributes (overloaded version) API................................................ 12-113
Functional Overview............................................................................................... 12-113
Init_Changed_Attribute_Rec API Features.................................................................... 12-125
Functional Overview............................................................................................... 12-125
AUTOCREATE_DEL_TRIP (overloaded version) API Features.................................... 12-136
Functional Overview............................................................................................... 12-136
Container Public Application Program Interface............................................................... 12-138
Create_Containers API Features.................................................................................... 12-139
Functional Overview............................................................................................... 12-139
Update Container API Features..................................................................................... 12-142
Functional Overview............................................................................................... 12-142
Auto_Pack API Features................................................................................................ 12-149
Functional Overview............................................................................................... 12-149
Container_Actions API Features.................................................................................... 12-152
Functional Overview............................................................................................... 12-152

    ix
 Freight Costs Public Application Program Interface..........................................................12-155
Create_Update_Freight_Costs API Features.................................................................. 12-155
Functional Overview............................................................................................... 12-155
Validate_Freight_Cost_Type API Features.................................................................... 12-161
Delete_Freight_Costs API Features................................................................................ 12-162
Functional Overview............................................................................................... 12-162
Pick Release Application Program Interface...................................................................... 12-167
Create_Batch API Features.............................................................................................12-168
Functional Overview............................................................................................... 12-168
Release_Batch API Features........................................................................................... 12-179
Functional Overview............................................................................................... 12-179
Get_Batch_Record API Features.................................................................................... 12-181
Functional Overview............................................................................................... 12-181
Document Public Application Program Interface.............................................................. 12-193
Functional Overview..................................................................................................... 12-193
Custom Public Application Program Interface.................................................................. 12-199
UI_Location_Code API Features.................................................................................... 12-199
Functional Overview............................................................................................... 12-199
Calculate_TP_Dates API Features.................................................................................. 12-203
Functional Overview............................................................................................... 12-203
Example of API Packages and Procedures.......................................................................... 12-204

13 Oracle Shipping Execution XML Transactions

XML Overview........................................................................................................................ 13-1
Oracle XML Gateway Setup.................................................................................................... 13-2
Trading Partners................................................................................................................ 13-3
Code Conversions.............................................................................................................. 13-3
Using XML Messaging with Carrier Manifesting.................................................................. 13-4
ShowShipment Request Transaction for Carrier Manifesting............................................ 13-5
ShowShipment Advice Transaction for Carrier Manifesting............................................. 13-6
Defining Trading Partners for Carrier Manifesting........................................................... 13-7
Overview of XML and DTD for Carrier Manifesting....................................................... 13-10
Document Type Definition (DTD) for Carrier Manifesting..............................................13-10
Sample XML Transaction for Carrier Manifesting........................................................... 13-13
Using XML Messaging with Third Party Warehousing....................................................... 13-88
ShowShipment Request Transaction for Third Party Warehousing................................ 13-89
ShowShipment Advice Transaction for Third Party Warehousing..................................13-90
Defining Trading Partners for Third Party Warehousing................................................ 13-90
Overview of XML and DTD for Third Party Warehousing..............................................13-95
Sample Document Type Definitions (DTD) for Third Party Warehousing...................... 13-95

x
 Sample XML Transactions for Third Party Warehousing................................................ 13-98
Using XML Messaging with International Trade Management........................................ 13-176
ItemSynchronization Request Transaction for ITM....................................................... 13-176
PartySynchronization Request Transaction for ITM...................................................... 13-177
OrderCompliance Request for ITM................................................................................13-177
DeliveryCompliance Request Transaction for ITM........................................................ 13-177
ExportCompliance Response Transaction for ITM........................................................ 13-178
Overview of XML and DTD for ITM............................................................................. 13-179
ITM DTDs...................................................................................................................... 13-179
Sample ITM XML Transactions......................................................................................13-187

14 Oracle Shipping Execution EDI Transactions

DSNO...................................................................................................................................... 14-1

A Oracle Order Management Error and Information Messages

Process_PO and Acknowledge_PO.......................................................................................... A-1
Show_SalesOrder...................................................................................................................... A-2
Cancel_PO................................................................................................................................. A-2
Change SO................................................................................................................................. A-3
Inbound Change PO Request................................................................................................... A-4

    xi
  
Send Us Your Comments

Oracle Order Management Open Interfaces, API, & Electronic Messaging Guide, Release 12
Part No. B31585-01

Oracle welcomes customers' comments and suggestions on the quality and usefulness of this document.
Your feedback is important, and helps us to best meet your needs as a user of our products. For example:
• Are the implementation steps correct and complete?
• Did you understand the context of the procedures?
• Did you find any errors in the information?
• Does the structure of the information help you with your tasks?
• Do you need different information or graphics? If so, where, and in what format?
• Are the examples correct? Do you need more examples?

If you find any errors or have any other suggestions for improvement, then please tell us your name, the
name of the company who has licensed our products, the title and part number of the documentation and
the chapter, section, and page number (if available).
Note: Before sending us your comments, you might like to check that you have the latest version of the
document and if any concerns are already addressed. To do this, access the new Applications Release
Online Documentation CD available on Oracle MetaLink and www.oracle.com. It contains the most
current Documentation Library plus all documents revised or released recently.
Send your comments to us using the electronic mail address: [email protected]
Please give your name, address, electronic mail address, and telephone number (optional).
If you need assistance with Oracle software, then please contact your support representative or Oracle
Support Services.
If you require training or instruction in using Oracle software, then please contact your Oracle local office
and inquire about our Oracle University offerings. A list of Oracle offices is available on our Web site at
www.oracle.com.

    xiii
  
Preface

Intended Audience
Welcome to Release 12 of the Oracle Order Management Open Interfaces, API, & Electronic
Messaging Guide.
This guide assumes you have a working knowledge of the following:
• The principles and customary practices of your business area.

• The Oracle Applications graphical user interface. To learn more about the Oracle
Applications graphical user interface, read the Oracle Applications User's Guide.

See Other Information Sources for more information about Oracle Applications product
information.
See Related Information Sources on page xvi for more Oracle Applications product
information.

TTY Access to Oracle Support Services

Oracle provides dedicated Text Telephone (TTY) access to Oracle Support Services
within the United States of America 24 hours a day, seven days a week. For TTY
support, call 800.446.2398.

Documentation Accessibility
Our goal is to make Oracle products, services, and supporting documentation
accessible, with good usability, to the disabled community. To that end, our
documentation includes features that make information available to users of assistive
technology. This documentation is available in HTML format, and contains markup to
facilitate access by the disabled community. Accessibility standards will continue to
evolve over time, and Oracle is actively engaged with other market-leading technology

    xv
 vendors to address technical obstacles so that our documentation can be accessible to all
of our customers. For more information, visit the Oracle Accessibility Program Web site
at http://www.oracle.com/accessibility/ .

Accessibility of Code Examples in Documentation

Screen readers may not always correctly read the code examples in this document. The
conventions for writing code require that closing braces should appear on an otherwise
empty line; however, some screen readers may not always read a line of text that
consists solely of a bracket or brace.

Accessibility of Links to External Web Sites in Documentation

This documentation may contain links to Web sites of other companies or organizations
that Oracle does not own or control. Oracle neither evaluates nor makes any
representations regarding the accessibility of these Web sites.

Structure
1  Integrating Your Systems
2  Oracle Advanced Pricing Open Interfaces and APIs
3  Oracle Advanced Pricing XML Transactions
4  Oracle Order Management XML Transactions: Implementation Considerations
5  Oracle Order Management XML Transactions
6  Oracle Order Management EDI Transactions
7  Oracle Order Management Open Interfaces and APIs
8  Oracle Order Management: Integration with Other Products
9  Oracle Release Management XML Transactions
10  Oracle Release Management EDI Transactions
11  Oracle Release Management Open Interfaces and APIs
12  Oracle Shipping Execution Open Interfaces and APIs
13  Oracle Shipping Execution XML Transactions
14  Oracle Shipping Execution EDI Transactions
A  Oracle Order Management Error and Information Messages

Related Information Sources

Oracle Order Management User's Guide
Oracle Order Management Implementation Manual
Using Oracle Workflow in Oracle Order Management
Oracle e-Commerce Gateway Implementation Manual
Oracle e-Commerce Gateway User's Guide
Oracle XML Gateway User's Guide
Oracle Integration Repository User's Guide

xvi
 Oracle Configure to Order Process Guide
Oracle Shipping Execution User's Guide
Oracle Advanced Pricing Implementation Manual
Oracle Advanced Pricing User's Guide
Oracle Release Management Implementation Manual
Oracle Release Management User's Guide
Oracle Applications Multiple Organizations Implementation Guide

Integration Repository
The Oracle Integration Repository is a compilation of information about the service
endpoints exposed by the Oracle E-Business Suite of applications. It provides a
complete catalog of Oracle E-Business Suite's business service interfaces. The tool lets
users easily discover and deploy the appropriate business service interface for
integration with any system, application, or business partner.
The Oracle Integration Repository is shipped as part of the E-Business Suite. As your
instance is patched, the repository is automatically updated with content appropriate
for the precise revisions of interfaces in your environment.

Do Not Use Database Tools to Modify Oracle Applications Data

Oracle STRONGLY RECOMMENDS that you never use SQL*Plus, Oracle Data
Browser, database triggers, or any other tool to modify Oracle Applications data unless
otherwise instructed.
Oracle provides powerful tools you can use to create, store, change, retrieve, and
maintain information in an Oracle database. But if you use Oracle tools such as
SQL*Plus to modify Oracle Applications data, you risk destroying the integrity of your
data and you lose the ability to audit changes to your data.
Because Oracle Applications tables are interrelated, any change you make using an
Oracle Applications form can update many tables at once. But when you modify Oracle
Applications data using anything other than Oracle Applications, you may change a
row in one table without making corresponding changes in related tables. If your tables
get out of synchronization with each other, you risk retrieving erroneous information
and you risk unpredictable results throughout Oracle Applications.
When you use Oracle Applications to modify your data, Oracle Applications
automatically checks that your changes are valid. Oracle Applications also keeps track
of who changes information. If you enter information into database tables using
database tools, you may store invalid information. You also lose the ability to track who
has changed your information because SQL*Plus and other database tools do not keep a
record of changes.

    xvii
 1
Integrating Your Systems

This chapter covers the following topics:

• Overview of Oracle Order Management APIs and Open Interfaces
• Basic Business Needs
• Oracle Order Management Interfaces
• Inbound Open Interface Model
• Components of an Open Interface

Overview of Oracle Order Management APIs and Open Interfaces

Oracle Order Management products provide a number of open interfaces that you can
link to, and exchange data with, other Oracle applications and non-Oracle applications
like legacy systems.
This chapter will help you understand the general model that Oracle Order
Management products use for open interfaces. Other chapters in this book provide
information about how to use specific open interfaces. Additional functional
information about the interfaces is available in the user or implementation guide for
each product. Additional technical information on these interfaces is available in the
product-specific e-Technical Reference Manuals.

Basic Business Needs

APIs and open interfaces of the Oracle Order Management Suite provide you with the
features you need to support the following basic business needs:
• Connect to data collection devices. You can collect material movement transactions
such as receipts, issues, quality data, movements, completions, and shipments. This
improves data entry speed and transaction accuracy.

• Connect to other systems such as finite scheduling packages, computer-aided

Integrating Your Systems    1-1

 design systems, and custom and legacy manufacturing systems to create integrated
enterprise wide systems.

• Connect to external systems such as the customer's purchasing system and the
supplier's order entry system to better integrate the supply chain via electronic
commerce.

• Control processing of inbound data imported from outside Oracle applications.

• Validate imported data to maintain data integrity within the application.

• Review, update, and resubmit imported data that failed validation.

• Export data from Oracle Order Management products to external systems.

Oracle Order Management Interfaces

Open Interface Architectures

Oracle Order Management products use three different methods for importing and
exporting data:
• Interface Tables

• Interface Views (Business Views)

• Function Calls or Programmatic Interfaces (Processes)

Interface Tables
Interface tables in Oracle Order Management applications provide a temporary storage
area for loading information from an external source. After the information is loaded,
concurrent programs are executed to validate the information and then apply the
information to the base product tables.
The benefit of an interface table is that it provides a repository where records can be
processed and if errors are found, you can edit the records and resubmit them.
In the Oracle Order Management family of applications you should never write directly
to the product tables. An Oracle Applications validation step is always required. You
may achieve this either by loading information into the interface tables and submitting
a provided concurrent program to validate and process the information or by using a
function call to a programmatic interface.

1-2    Oracle Order Management Open Interfaces, API, & Electronic Messaging Guide
Interface Views (Business Views)
Views simplify the data relationships for easier processing, whether for reporting or
data export. Oracle Order Management products have defined business views that
identify areas of key business interest. You can access this data using a tool of your
choice. The OE_ORDER_HEADERS_BV is an example of a key business view.

Function Calls or Programmatic Interfaces (Processes)

As an alternative to the two step process of writing to an interface table and executing a
program to process the table data, many Oracle Order Management interfaces support
direct function calls. A calling application can pass appropriate parameters and execute
a public function to invoke the application logic.
The benefit of a function call is that the integration is real time, as opposed to interface
tables where the integration is batch.

Summary: Beyond Published Interfaces

The Oracle Cooperative Applications Initiative references many third party products
that provide import and export capabilities and allow varying degrees of integration
with legacy systems, supplier systems, and so on. Contact your Oracle consultant for
more information about system integration.

Some Key Terms and Tables

The lists below provide information on the database tables, views, procedures, and
modules used in data integration.

Table Key

Key Description

Data Flow Direction Inbound means into Oracle Order

Management; Outbound means out from
Oracle Order Management

Iface Man The interface is documented in detail in the

Oracle Order Management Open Interfaces, API,
& Electronic Messaging Guide

e-TRM The tables, views, or modules are described in

the product's e-Technical Reference Manual

Integrating Your Systems    1-3

 Oracle Order Management APIs/Open Interfaces

Interface/API Data Flow Table, View, Iface Man TRM Table, View,
Name Direction Process, or Module
Procedure Name, or
Procedure
Name

ONT ONT ONT ONT ONT ONT

Order Import Inbound Table Yes Yes OE_HEADER

S_IFACE_AL
L

OE_LINES_IF
ACE_ALL

OE_RESERV
TNS_IFACE_
ALL

OE_CREDITS
_IFACE_ALL

OE_PRICE_A
DJS_IFACE_
ALL

OE_LOTSERI
ALS_IFACE_
ALL

OE_ACTION
S_IFACE_AL
L

Process Inbound Process No Yes OE_ORDER_

Order PUB.PROCES
S_ORDER

QP QP QP QP QP QP

1-4    Oracle Order Management Open Interfaces, API, & Electronic Messaging Guide
Interface/API Data Flow Table, View, Iface Man TRM Table, View,
Name Direction Process, or Module
Procedure Name, or
Procedure
Name

Agreement Inbound/Out Procedure Yes Yes OE_PRICING

Public bound _CONT_PUB.
Application PROCESS_A
Program GREEMENT
Interface
OE_PRICING
_CONT_PUB.
GET_AGREE
MENT

OE_PRICING
_CONT_PUB.
LOCK_AGRE
EMENT

Attribute Inbound/Out Procedure Yes Yes QP_ATTR_M

Mapping bound APPING_PU
Application B.BUILD_CO
Program NTEXTS
Interface

Business Inbound/Out Procedure Yes Yes QP_MODIFI

Object for bound ERS_PUB.PR
Modifier OCESS_MOD
Setup IFIERS
Application
Program QP_MODIFI
Interface ERS_PUB.GE
T_MODIFIER
S

QP_MODIFI
ERS_PUB.LO
CK_MODIFI
ERS

Integrating Your Systems    1-5

 Interface/API Data Flow Table, View, Iface Man TRM Table, View,
Name Direction Process, or Module
Procedure Name, or
Procedure
Name

Business Inbound/Out Procedure Yes Yes QP_PRICE_F

Object for bound ORMULA_P
Pricing UB.LOCK_P
Formulas RICE_FORM
Application ULA
Program
Interface QP_PRICE_F
ORMULA_P
UB.PROCESS
_PRICE_FOR
MULA

QP_PRICE_F
ORMULA_P
UB.GET_PRI
CE_FORMUL
A

Business Procedure Yes Yes QP_LIMITS_

Object for PUB.PROCES
Pricing S_LIMITS
Limits
Application QP_LIMITS_
Program PUB.GET_LI
Interface MITS

QP_LIMITS_
PUB.LOCK_L
IMITS

Create Inbound/Out Procedure Yes Yes QP_PRICE_B

Publish Price bound OOK_PUB.C
Book REATE_PUB
Application LISH_PRICE
Program _BOOK
Interface

1-6    Oracle Order Management Open Interfaces, API, & Electronic Messaging Guide
Interface/API Data Flow Table, View, Iface Man TRM Table, View,
Name Direction Process, or Module
Procedure Name, or
Procedure
Name

Custom Inbound/Out Procedure Yes Yes QP_RUNTIM

Runtime bound E_SOURCE.G
Sourcing ET_NUMERI
Application C_ATTRIBUT
Program E_VALUE
Interface

Get Currency Inbound/Out Procedure Yes Yes QP_CURREN

Application bound CY_PUB.GET
Program _CURRENCY
Interface

Get_Attribute Inbound/Out Procedure Yes Yes QP_UTIL_PU

_Text bound B.GET_ATTR
Application IBUTE_TEXT
Program
Interface

Get Custom Inbound/Out Procedure Yes Yes QP_CUSTO

Price (Used in bound M.GET_CUS
Formulas TOM_PRICE
Setup)
Application
Program
Interface

Get Price Inbound/Out Procedure Yes Yes QP_PRICE_B

Book bound OOK.GET_P
Application RICE_BOOK
Program
Interface

Get Price For Inbound/Out Procedure Yes Yes QP_PREQ_P

Line bound UB.PRICE_R
Application EQUEST
Program
Interface

Integrating Your Systems    1-7

 Interface/API Data Flow Table, View, Iface Man TRM Table, View,
Name Direction Process, or Module
Procedure Name, or
Procedure
Name

Get Price List Inbound/Out Procedure Yes Yes QP_UTIL_PU

Currency bound B.GET_CURR
Application ENCY
Program
Interface

Get Price List Inbound/Out Procedure Yes Yes QP_UTIL_PU

Application bound B.GET_PRIC
Program E_LIST
Interface

Multi-Curren Inbound/Out Procedure Yes Yes QP_CURREN

cy bound CY_PUB.
Conversion PROCESS_C
Setup URRENCY
Application
Program
Interface

Price List Inbound/Out Procedure Yes Yes QP_PRICE_L

Setup bound IST_PUB.PR
OCESS_PRIC
E_LIST

QP_PRICE_L
IST_PUB.GET
_PRICE_LIST

QP_PRICE_L
IST_PUB.LO
CK_PRICE_L
IST

Price List Inbound/Out Procedure Yes Yes QP_PRICE_L

Setup Group bound IST_GRP.PR
Application OCESS_PRIC
Program E_LIST
Interface

1-8    Oracle Order Management Open Interfaces, API, & Electronic Messaging Guide
Interface/API Data Flow Table, View, Iface Man TRM Table, View,
Name Direction Process, or Module
Procedure Name, or
Procedure
Name

Price Request Inbound/Out Procedure Yes Yes QP_PREQ_G

Application bound RP.PRICE_R
Program EQUEST
Interface

Pricing Data Inbound/Out Procedure Yes Yes QP_BULK_L

Bulk Loader bound OADER_PUB
API .LOAD_PRIC
ING_DATA

Pricing Inbound/Out Procedure Yes Yes QP_SECURIT

Object bound Y.CHECK_F
Security UNCTION
CHECK_FU
NCTION

Qualifiers Inbound/Out Procedure Yes Yes QP_QUALIFI

Application bound ER_RULES_P
Program UB.PROCESS
Interface _QUALIFIER
_RULES

QP_QUALIFI
ER_RULES_P
UB.LOCK_Q
UALIFIER_R
ULES

QP_QUALIFI
ER_RULES_P
UB.GET_QU
ALIFIER_RU
LES

QP_QUALIFI
ER_RULES_P
UB.COPY_Q
UALIFIER_R
ULES

Integrating Your Systems    1-9

 Interface/API Data Flow Table, View, Iface Man TRM Table, View,
Name Direction Process, or Module
Procedure Name, or
Procedure
Name

Reverse Inbound/Out Procedure Yes Yes QP_UTIL_PU

Limits bound B.REVERSE_
Application LIMITS
Program
Interface

Round Price Inbound/Out Procedure Yes Yes QP_UTIL_PU

Application bound B.ROUND_P
Program RICE
Interface

Validate_Pric Inbound/Out Procedure Yes Yes QP_UTIL_PU

e_list_Curr_c bound B.VALIDATE
ode _PRICE_LIST
Application _CURR_COD
Program E
Interface

RLM RLM RLM RLM RLM RLM

RLM_INTER Inbound Table Yes Yes RLM_INTER

FACE_HEAD FACE_HEAD
ERS ERS

RLM_INTER Inbound Table Yes Yes RLM_INTER

FACE_LINES FACE_LINES

WSH WSH WSH WSH WSH WSH

Trip Public Inbound Procedure Yes No WSH_TRIPS_

API PUB
(Procedure
package)

Stop Public Inbound Procedure Yes No WSH_TRIP_S

API TOPS_PUB
(Procedure
package)

1-10    Oracle Order Management Open Interfaces, API, & Electronic Messaging Guide
 Interface/API Data Flow Table, View, Iface Man TRM Table, View,
Name Direction Process, or Module
Procedure Name, or
Procedure
Name

Deliveries Inbound Procedure Yes No WSH_DELIV

Public API ERIES_PUB
(Procedure
package)

Exceptions Inbound Procedure Yes No WSH_EXCEP

Public API TIONS_PUB
(Procedure
package)

Delivery Inbound Procedure Yes No WSH_DELIV

Details Public ERY_DETAIL
API S_PUB
(Procedure
package)

Container Inbound Procedure Yes No WSH_CONT

Public API AINER_PUB
(Procedure
package)

Freight Costs Inbound Procedure Yes No WSH_FREIG

Public API HT_COSTS_P
UB
(Procedure
package)

Pick Release Inbound Procedure Yes No WSH_PICKI

Application NG_BATCH
Program ES_PUB
Interface API (Procedure
package)

Inbound Open Interface Model

Oracle Order Management products use both inbound and outbound interfaces. For
inbound transactions and data import, interface tables as well as supporting validation,
processing, and maintenance programs are available. For outbound transactions and
data export to external systems, database views are available and the destination
application provides the validation, processing, and maintenance programs.

Integrating Your Systems    1-11

Discussion of Inbound Interfaces
In this manual, we discuss only inbound interfaces in detail. You can find information
about the tables, views, and processes related to outbound interfaces in the e-TRM for
each product. Note that the e-TRMs do not contain detailed, narrative descriptions
about the outbound interfaces.

Open Interface Diagram

This diagram shows the general model for open application interfaces:

Open API Diagram

This diagram illustrates the model used by APIs such as the Service Request interfaces
(Oracle Service):

1-12    Oracle Order Management Open Interfaces, API, & Electronic Messaging Guide
Components of an Open Interface
The components described below are common to most open interfaces. Please note that
the component may be implemented slightly differently than described below.

Source Application
A source application may be an external system or another module in the e-Business
Suite. Data may be processed and stored in a source application.

Destination Application
A destination application may be an external system or another module in the
e-Business Suite. You send data to a destination application so that the application can
perform further processing and storage.

Interface Table
For inbound interfaces, the interface table is the intermediary table where the data from

Integrating Your Systems    1-13

 the source application temporarily resides until it is validated and processed into an
Oracle Order Management product. The various types of interface columns, are listed
below:
Identifier Columns
Identifier columns uniquely identify rows in the interface table and provide foreign key
reference to both the source and destination applications. For example, typical identifier
columns for a move transaction would identify:
• The source application

• The row's unique identifier in the source application

• The destination application's unique identifier.

Control Columns
Control columns track the status of each row in the interface table as it is inserted,
validated, processed with or without errors, and ultimately deleted. Additional control
columns identify who last updated the row and the last update date.
Data Columns
Data columns store the specific attributes that the source application is sending to the
Oracle Order Management products.
Required Columns
Required columns store the minimum information needed by the Oracle Order
Management products to successfully process the interface row.
Some columns are conditionally required based on the specifics of the interface.
Derived Columns
Derived columns are created by the destination application from information in the
required columns. Derived columns are usually required columns that need to contain a
value so that processing may continue.
Optional Columns
The data in optional columns is not mandatory for transaction processing to take place,
however the optional columns may be useful for storing additional information.

Errors Table
For inbound interfaces, the errors table stores all errors generated by the validation and
processing functions. You can either handle multiple error rows or single rows to
resolve the errors.

Database View
Database views are database objects that enable users of destination applications to look

1-14    Oracle Order Management Open Interfaces, API, & Electronic Messaging Guide
 at source application data.
Oracle Order Management products provide predefined views of key data that is likely
to be used by destination applications.
For example, Oracle Cost Management provides work in process valuation and
transaction distribution database views for use by other cost reporting destination
products.

Load Function
For inbound interfaces, the load function is the set of programs that selects and
accumulates data from the source application and inserts it into Oracle Order
Management interface tables. The programming languages and tools used in the load
function are highly dependent on the hardware and system software of the source
application.
For example, if you are passing data between an Oracle based source application and an
Oracle destination application, you would likely use a tool such as Pro*C or PL/SQL
since these tools work in both environments. If you are bringing data from a non-Oracle
based application into a product interface table, you would likely use a procedural
language available on the source application to select the data and convert it into an
ASCII file. Then you could use SQL*Loader to insert that file into the destination
product's interface table.
For outbound interfaces, the load function is the SQL that creates the database view.

Validate Function
The validate function is the set of programs that Oracle Applications destination
products use to ensure the integrity of inbound data. In the source application, you can
typically validate data upon entry using techniques such as forms triggers, not null
columns, data types, and so on. However, since Oracle Applications products may not
be the source of this data, validation programs ensure data integrity.
In addition, the validate function can derive additional columns based on the required
columns and foreign key relationships with data elsewhere in the Oracle destination
application.
The validation programs check the interface table for rows requiring validation, and the
programs validate and update each row indicating whether validation is complete or if
errors were found. If errors were found, validation programs need to write errors to the
error table of the destination application.
When the source application is a product in the e-Business Suite, the destination
application should provide the validate function.

Process Function
The process function is a set of programs that processes the data from the interface table

Integrating Your Systems    1-15

 into the Oracle destination product. The specific processing performed varies by
application. For open transaction interfaces, the processing generally includes recording
the transaction history, updating the inventory and order balances, and charging for
costs.
Interfaces typically let you control both the frequency and the number of validated rows
that the processing programs attempt to process. Upon successful completion of
processing, the process function should delete the processed row from the interface
table.
Occasionally, the process function may need to insert rows into the errors table.
When the source application is a product in the e-Business Suite, the destination
application should provide the process function.

Maintain Function
The maintain function is generally accomplished from a window within an Oracle
application. Most of these windows allow you to query, update, and resubmit interface
records that have failed validation. In general you can use these windows to query
unprocessed or unvalidated rows to check their current status.
When the maintain function is not called explicitly, you can use SQL*Plus to query and
update the interface table rows that are in error.
When the source application is a product in the e-Business Suite, the destination
application should provide the maintain function.

1-16    Oracle Order Management Open Interfaces, API, & Electronic Messaging Guide
 2
Oracle Advanced Pricing Open Interfaces
and APIs

This chapter covers the following topics:

• Key of Short Names
• Agreements Public Application Program Interface
• Attribute Mapping Application Program Interface
• Business Object for Modifier Setup Application Program Interface
• Business Object for Pricing Formulas Application Program Interface
• Business Object for Pricing Limits Application Program Interface
• Create Publish Price Book Application Program Interface
• Get Currency Application Program Interface
• Get Custom Price Application Program Interface
• Get Price Book Application Program Interface
• Get Price List Application Program Interface
• Multi-Currency Conversion Setup Application Program Interface
• Price List Setup Application Program Interface
• Price List Setup Group Application Program Interface
• Price Request Application Program Interface
• Pricing Data Bulk Loader API
• Pricing Object Security - Check Function API
• Pricing Attributes Application Program Interface
• Attribute Mapping Application Program Interface
• Qualifiers Application Program Interface

Oracle Advanced Pricing Open Interfaces and APIs    2-1

 • Reverse Limits Application Program Interface
• Round Price Application Program Interface
• Validate Price List with Currency Code Application Program Interface

Key of Short Names

A key of the short names and definitions used in the API tables are provided in the
following table:

Key of Short Names

Short name Definition

Drv Derived

Req Required

• Yes: This is a required parameter.

• No: This is an optional parameter.

N/A (no entry) No value/not applicable

Agreements Public Application Program Interface

This section explains how to use the Agreements Public API and how it functions in
Oracle Advanced Pricing. The Agreements Public package consists of entities to
support creating and maintaining agreements.

Functional Overview
Process_Agreement processes inserts, updates, and deletes records related to
agreements.

Setting Up and Using Parameter Descriptions

The following tables describe all parameters used by the public Agreements Public API.
All of the inbound and outbound parameters are listed. Additional information on
these parameters follows.

2-2    Oracle Order Management Open Interfaces, API, & Electronic Messaging Guide
PROCESS_AGREEMENT
The following table shows the parameters for this structure.

PROCESS_AGREEMENT Parameters

Parameter Usage Type Req Drv

p_api_version_n IN Number No No
umber

p_init_msg_list IN Varchar2 No No

p_return_values IN Varchar2 No No

p_commit IN Varchar2 No No

x_return_status OUT Varchar2 No No

x_msg_count OUT Number No No

x_msg_data OUT Varchar2 No No

p_Agreement_re IN Agreement_Rec_ No No
c Type

p_Agreement_va IN Agreement_Val_ No No
lue_rec Rec_Type

p_Price_LHeade IN QP_Price_List_P No No
r_rec UB.Price_List_Re
c_Type

p_Price_LHeade IN QP_Price_List_P No No
r_val_rec UB.Price_List_V
al_Rec_Type

p_Price_LLine_t IN QP_Price_List_P No No
bl UB.Price_List_Li
ne_Tbl_Type

p_Price_LLine_v IN QP_Price_List_P No No
al_tbl UB.Price_List_V
al_Tbl_Type

Oracle Advanced Pricing Open Interfaces and APIs    2-3

 Parameter Usage Type Req Drv

p_Pricing_Attr_t IN QP_Price_List_P No No
bl UB.Pricing_Attr_
Tbl_Type

p_Pricing_Attr_v IN QP_Price_List_P No No
al_tbl UB.Pricing_Attr_
Val_Tbl_Type

x_Agreement_re OUT Agreement_Rec_ No No

c Type

x_Agreement_va OUT Agreement_Val_ No No

l_rec Rec_Type

x_Price_LHeader OUT QP_Price_List_P No No

_rec UB.Price_List_Re
c_Type

x_Price_LHeader OUT QP_Price_List_P No No

_val_rec UB.Price_List_V
al_Rec_Type

x_Price_LLine_t OUT QP_Price_List_P No No

bl UB.Price_List_Li
ne_Tbl_Type

x_Price_LLine_v OUT QP_Price_List_P No No

al_tbl UB.Price_List_Li
ne_Val_Tbl_Typ
e

x_Pricing_Attr_t OUT QP_Price_List_P No No

bl UB.Pricing_Attr_
Tbl_Type

x_Pricing_Attr_v OUT QP_Price_List_P No No

al_tbl UB.Pricing_Attr_
Val_Tbl_Type

AGREEMENT_REC_TYPE
The following table shows the parameters for this structure.

2-4    Oracle Order Management Open Interfaces, API, & Electronic Messaging Guide
REC_TYPE

Parameter Usage Type Req Drv

accounting_rule_ Null Number No No

id

agreement_conta Null Number No No

ct_id

agreement_id Null Number Yes1 No

agreement_num Null Varchar2(50) No No

agreement_sourc Null Varchar2(30) No No

e_code

agreement_type_ Null Varchar2(30) No No

code

attribute1 Null Varchar2(150) No No

attribute2 Null Varchar2(150) No No

attribute3 Null Varchar2(150) No No

attribute4 Null Varchar2(150) No No

attribute5 Null Varchar2(150) No No

attribute6 Null Varchar2(150) No No

attribute7 Null Varchar2(150) No No

attribute8 Null Varchar2(150) No No

attribute9 Null Varchar2(150) No No

attribute10 Null Varchar2(150) No No

attribute11 Null Varchar2(150) No No

Oracle Advanced Pricing Open Interfaces and APIs    2-5

 Parameter Usage Type Req Drv

attribute12 Null Varchar2(150) No No

attribute13 Null Varchar2(150) No No

attribute14 Null Varchar2(150) No No

attribute15 Null Varchar2(150) No No

comments Null Varchar2(30) No No

context Null Varchar2(30) No No

created_by Null Number Yes No

creation_date Null Date Yes No

sold_to_org_id Null Number No No

end_date_active Null Date No No

freight_terms_co Null Varchar2(30) No No

de

invoice_contact_i Null Number No No

d

invoice_to_org_i Null Number No No

d

invoicing_rule_i Null Number No No

d

last_updated_by Null Number Yes No

last_update_date Null Date Yes No

last_update_logi Null Number No No

n

name Null Varchar2(30) Yes No

2-6    Oracle Order Management Open Interfaces, API, & Electronic Messaging Guide
Parameter Usage Type Req Drv

orig_system_agr Null Number No No

_id

override_arule_fl Null Varchar2(1) Yes No

ag

override_irule_fl Null Varchar2(1) Yes No

ag

price_list_id Null Number Yes2 No

pricing_contract Null Number No No

_id

purchase_order_ Null Varchar2(50) No No

num

revision Null Varchar2(50) Yes No

revision_date Null Date Yes No

revision_reason_ Null Varchar2(30) No No

code

salesrep_id Null Number No No

s