Skip Navigation Links | |
Exit Print View | |
Designing with Oracle Java CAPS Application Adapters Java CAPS Documentation |
Designing with Application Adapters
Building an Oracle Applications Custom Pre-Validation Package
Oracle Applications Adapter Pre-Validation Scripts
Oracle Application Adapter Pre-Validation Procedures
To Build a Custom Pre-Validation Package for a Non-Supported Open Interface
Oracle Application Adapter Concurrent Manager Request Function
Oracle Applications Adapter Template DTD
Naming Conventions for the Oracle Interface
Concurrent Manager Request Function
Oracle Applications Manufacturing Modules
Oracle Applications Inventory Module
Customer Items Cross-Reference
Oracle Applications Purchase Order Import Module
Oracle Applications Financial Module
Oracle Applications Accounts Payable Module
Oracle Applications Accounts Receivable Module
Oracle Applications Cash Management Module
Oracle Applications Fixed Assets Module
Oracle Applications General Ledger Module
Oracle Applications Validation Error Codes
Oracle Applications Manufacturing Error Codes
Oracle Applications Financial Budget-GL Error Codes
Accounts Receivable Error Codes
Configuring the PeopleSoft Server for the PeopleSoft Adapter Projects
Configuring PeopleSoft for Enterprise Service Bus Posting
Additional HTTP Configurations
Starting and Stopping the JMS Listening Connector
Verifying PeopleSoft Server Logs
Notes on PeopleSoft Server Disconnections for JMS
To Create PeopleSoft Nodes to Receive Enterprise Service Bus HTTP Posts
To Activate the Message Definition to Receive Enterprise Service Bus Posts
Defining Message Channel Routing Rules
Adding the PeopleSoft Subscription Handler
Creating an HTTP Adapter Message Node
Activating the Message Definition for Subscription
Defining the Message Channel Routing Rules
Adding the HTTP Publication Handler
Accessing Non-Local Queue Managers and Non-Local Queues
To Connect to a Remote WebSphere MQ Queue.
Creating the WebSphere MQ Queue
To Create the WebSphere MQ Queue
IBM WebSphere MQ Server and Queue Manager Limits and Settings
The Manufacturing module is divided into the following sub-modules:
The Oracle Inventory module works with other Oracle Manufacturing modules to provide a complete set of transactions and reports for maintaining inventory control.
Oracle Interface Table — Oracle provides the following Interface Table for Customer Items: mtl_ci_interface
Java CAPS Staging Table — The Oracle Applications Adapter sets up the following staging table, corresponding to the Oracle Open Interface Tables listed above: sb_mtl_ci_interface
Pre-Validation Script — The scripts corresponding to the Java CAPS Staging Tables listed above are packaged within the following file: sb_validate_cust_items_pkg.sql
Oracle Interface Table — Oracle provides the following Interface Table for Customer Item Cross-References: mtl_ci_xrefs_interface
Java CAPS Staging Table — The Oracle Applications Adapter sets up the following staging table, corresponding to the Oracle Open Interface Tables listed above:sb_mtl_ci_xrefs_interface
Pre-Validation Script — The scripts corresponding to the Java CAPS Staging Tables listed above are packaged within the following file: sb_validate_ci_xrefs_pkg.sql
Oracle Interface Table — Oracle provides the following Interface Table for Cycle Count Entries: mtl_cc_entries_interface
Java CAPS Staging Table— The Oracle Applications Adapter sets up the following staging table, corresponding to the Oracle Open Interface Table listed above: sb_mtl_cc_entries_interface
Pre-Validation Script— The scripts corresponding to the Java CAPS Staging Table listed above are packaged within the following file: sb_validate_cc_entries_pkg.sql
Oracle Interface Tables— Oracle provides the following Interface Tables for items: mtl_system_items_interface and mtl_item_revisions_interface
Java CAPS Staging Tables— The Oracle Applications Adapter sets up the following staging tables, corresponding to the Oracle Open Interface Tables listed above: sb_mtl_system_items_interface and
sb_mtl_item_revisions_int
Pre-Validation Scripts — The scripts corresponding to the Java CAPS Staging Tables listed above are packaged within the following files: sb_validate_items_pkg.sql and sb_validate_invrev_pkg.sql
Oracle Interface Tables — Oracle provides the following Interface Tables for Item Replenishment: mtl_replenish_headers_int and mtl_replenish_lines_int
Java CAPS Staging Tables — The Oracle Applications Adapter sets up the following staging tables, corresponding to the Oracle Open Interface Tables listed above: sb_mtl_replenish_headers_int and
sb_mtl_replenish_lines_int
Pre-Validation Scripts — The scripts corresponding to the Java CAPS Staging Tables listed above are packaged within the following files: sb_validate_rep_headers_pkg.sql and sb_validate_rep_lines_pkg.sql
These files are controlled by the following master validation file:
sb_validate_rep_pkg.sql
Oracle Interface Tables — Oracle provides the following Interface Tables for Transactions:
mtl_transactions_interface
mtl_transaction_lots_interface
mtl_serial_numbers_interface
Java CAPS Staging Tables — The Oracle Applications Adapter sets up the following staging tables, corresponding to the Oracle Open Interface Tables listed above:
sb_mtl_transactions_interface
sb_mtl_transaction_lots_inter
sb_mtl_serial_numbers_interface
Pre-Validation Scripts — The scripts corresponding to the Java CAPS Staging Tables listed above are packaged within the following files:
sb_validate_trans_pkg.sql
sb_validate_trans_lots_pkg.sql
sb_validate_serial_nos_pkg.sql
These files are controlled by the following master validation file:
sb_validate_tran_all_pkg.sql
The Oracle Purchase Order Import module works with other Oracle Manufacturing modules to provide a complete set of transactions and reports for maintaining inventory control.
Oracle Interface Tables — Oracle provides the following Interface Tables for Purchase Order Import:
po_headers_interface
po_lines_interface
Java CAPS Staging Tables — The Oracle Applications Adapter sets up the following staging tables, corresponding to the Oracle Open Interface Tables listed above:
Pre-Validation Scripts — The scripts corresponding to the Java CAPS Staging Tables listed above are packaged within the following files:
sb_validate_poi_hdrs_pkg.sql
sb_validate_poi_lines_pkg.sql
These files are controlled by the following master validation file:
sb_validate_poi_pkg.sql
Oracle Interface Tables — Oracle provides the following Interface Tables for Receiving:
Java CAPS Staging Tables — The Oracle Applications Adapter sets up the following staging tables, corresponding to the Oracle Open Interface Tables listed above:
Pre-Validation Scripts — The scripts corresponding to the Java CAPS Staging Tables listed above are packaged within the following files:
sb_validate_rcv_hdr_pkg.sql
sb_validate_rcv_trans_pkg.sql
These files are controlled by the following master validation file:
sb_validate_rcv_pkg.sql
Oracle Interface Table — Oracle provides the following Interface Table for Requisitions: po_requisitions_interface_all
Java CAPS Staging Table — The Oracle Applications Adapter sets up the following staging table, corresponding to the Oracle Open Interface Table listed above: sb_po_requisitions_interface_a
Pre-Validation Script — The scripts corresponding to the Java CAPS Staging Table listed above are packaged within the following file: sb_validate_por_req_pkg.sql
The Oracle Order Entry module works with other Oracle Manufacturing modules to provide a complete set of transactions and reports for maintaining order entry control.
Oracle provides the following Interface Table for Order Entry:
oe_headers_interface
oe_lines_interface
oe_actions_interface
oe_credits_interface
oe_price_adjs_interface
oe_lotserials_interface
oe_reservtns_interface
sb_oe_headers_interface
sb_oe_lines_interface
sb_oe_actions_interface
sb_oe_credits_interface
sb_oe_price_adjs_interface
sb_oe_lotserials_interface
sb_oe_reservtns_interface
The scripts corresponding to the Java CAPS Staging Tables listed above are packaged within the following file:
sb_validate_oe_pkg.sql
This file is controlled by the following master validation file:
sb_validate_oi_pkg.sql