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 Order Entry 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 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 Financial module is divided into the following sub-modules:
The Oracle Accounts Payable module works with other Oracle Financial modules to provide a complete set of transactions and reports for maintaining accounts payable control.
Oracle Interface Tables — Oracle provides the following Interface Table for Requisitions:
ap_invoices_interface
ap_invoice_lines_interface
Java CAPS Staging Tables — The Oracle Applications Adapter sets up the following staging table, corresponding to the Oracle Open Interface Table listed above:
sb_ap_invoices_interface
sb_ap_invoice_lines_interface
Pre-Validation Scripts — The scripts corresponding to the Java CAPS Staging Tables listed above are packaged within the following files:
sb_validate_ap_inv_pkg.sql
sb_validate_ap_inv_lines_pkg.sql
These files are controlled by the following master validation file:
sb_validate_payable_pkg.sql
The Oracle Accounts Receivable module works with other Oracle Financial modules to provide a complete set of transactions and reports for maintaining accounts receivable control.
Oracle Interface Tables — Oracle provides the following Interface Table for Requisitions:
ra_interface_distributions
ra_interface_lines_all
ra_interface_salescredits_all
Java CAPS Staging Tables — The Oracle Applications Adapter sets up the following staging table, corresponding to the Oracle Open Interface Table listed above:
sb_ra_interface_distributions
sb_ra_interface_lines_all
sb_ra_interface_salescredits_all
Pre-Validation Scripts — The scripts corresponding to the Java CAPS Staging Tables listed above are packaged within the following files:
sb_validate_ra_dist_pkg.sql
sb_validate_ra_lines_pkg.sql
sb_validate_ra_sales_cr_pkg.sql
This file is controlled by the following master validation file:
sb_validate_auto_inv_pkg.sql
Oracle Interface Tables — Oracle provides the following Interface Table for Requisitions:
ar_payments_interface_all
Java CAPS Staging Tables — The Oracle Applications Adapter sets up the following staging table, corresponding to the Oracle Open Interface Table listed above:
sb_ar_payments_interface_all
Pre-Validation Scripts — The scripts corresponding to the Java CAPS Staging Tables listed above are packaged within the following file:
sb_validate_ar_payments_pkg.sql
This file is controlled by the following master validation file:
sb_validate_auto_lock_pkg.sql
Oracle Interface Tables — Oracle provides the following Interface Table for Requisitions:
ra_customers_interface
ra_contact_phones_int_all
ra_cust_pay_method_interface
ra_customer_banks_int_all
ra_customer_profiles_interface
Java CAPS Staging Tables — The Oracle Applications Adapter sets up the following staging table, corresponding to the Oracle Open Interface Table listed above:
sb_ra_customers_interface
sb_ra_contact_phones_int_all
sb_ra_cust_pay_method_interface
sb_ra_customer_banks_int_all
sb_ra_customer_profiles_interface
Pre-Validation Scripts — The scripts corresponding to the Java CAPS Staging Tables listed above are packaged within the following files:
sb_validate_cust_pkg.sql
sb_validate_contact_phones_pkg.sql
sb_validate_cust_pay_mtd_pkg.sql
sb_validate_cust_banks_pkg.sql
sb_validate_cust_profiles_pkg.sql
This file is controlled by the following master validation file:
sb_validate_customers_pkg.sql
The Oracle Cash Management module works with other Oracle Financial modules to provide a complete set of transactions and reports for maintaining cash management control.
Oracle Interface Tables — Oracle provides the following Interface Table for Requisitions:
ce_statement_headers_int_all
ce_statement_lines_interface
Java CAPS Staging Tables — The Oracle Applications Adapter sets up the following staging table, corresponding to the Oracle Open Interface Table listed above:
sb_ce_statement_headers_int_all
sb_ce_statement_lines_interface
Pre-Validation Scripts — The scripts corresponding to the Java CAPS Staging Tables listed above are packaged within the following files:
sb_validate_stmt_headers_pkg.sql
sb_validate_stmt_lines_pkg.sql
These files are controlled by the following master validation file:
sb_validate_bank_stmt_pkg.sql
The Oracle Fixed Assets module works with other Oracle Financial modules to provide a complete set of transactions and reports for maintaining fixed asset control.
Oracle Interface Tables — Oracle provides the following Interface Table for Requisitions:
fa_categories_b
Java CAPS Staging Tables — The Oracle Applications Adapter sets up the following staging table, corresponding to the Oracle Open Interface Table listed above:
sb_fa_categories_b
Pre-Validation Scripts — The scripts corresponding to the Java CAPS Staging Tables listed above are packaged within the following file:
sb_validate_cat_pkg.sql
This file is controlled by the following master validation file:
sb_validate_fa_categories_pkg.sql
Oracle Interface Tables — Oracle provides the following Interface Table for Requisitions:
fa_locations
Java CAPS Staging Tables — The Oracle Applications Adapter sets up the following staging table, corresponding to the Oracle Open Interface Table listed above:
sb_fa_locations
Pre-Validation Scripts — The scripts corresponding to the Java CAPS Staging Tables listed above are packaged within the following files:
sb_validate_loc_pkg.sql
These files are controlled by the following master validation file:
sb_validate_fa_locations_pkg.sql
Oracle Interface Tables — Oracle provides the following Interface Table for Requisitions:
fa_mass_additions
Java CAPS Staging Tables — The Oracle Applications Adapter sets up the following staging table, corresponding to the Oracle Open Interface Table listed above:
sb_fa_mass_additions
Pre-Validation Scripts — The scripts corresponding to the Java CAPS Staging Tables listed above are packaged within the following files:
sb_validate_additions_pkg.sql
These files are controlled by the following master validation file:
sb_validate_fa_mass_add_pkg.sql
The Oracle General Ledger module works with other Oracle Financial modules to provide a complete set of transactions and reports for maintaining general ledger control.
Oracle Interface Tables — Oracle provides the following Interface Table for Requisitions:
gl_budget_interface
Java CAPS Staging Tables — The Oracle Applications Adapter sets up the following staging table, corresponding to the Oracle Open Interface Table listed above:
sb_gl_budget_interface
Pre-Validation Scripts — The scripts corresponding to the Java CAPS Staging Tables listed above are packaged within the following files:
sb_validate_gl_budget_pkg.sql
These files are controlled by the following master validation file:
sb_validate_budget_pkg.sql
Oracle Interface Tables — Oracle provides the following Interface Table for Requisitions:
gl_daily_rates_interface
Java CAPS Staging Tables — The Oracle Applications Adapter sets up the following staging table, corresponding to the Oracle Open Interface Table listed above:
sb_gl_daily_rates_interface
Pre-Validation Scripts — The scripts corresponding to the Java CAPS Staging Tables listed above are packaged within the following files:
sb_validate_gl_daily_rates_pkg.sql
These files are controlled by the following master validation file:
sb_validate_dailyrates_pkg.sql
Oracle Interface Tables — Oracle provides the following Interface Table for Requisitions:
gl_interface
Java CAPS Staging Tables — The Oracle Applications Adapter sets up the following staging table, corresponding to the Oracle Open Interface Table listed above:
sb_gl_interface
Oracle Applications Adapter — The scripts corresponding to the Java CAPS Staging Tables listed above are packaged within the following files:
sb_validate_gl_int_pkg.sql
These files are controlled by the following master validation file:
sb_validate_journal_pkg.sql