Technical Overview
PROCESSIT interacts with Oracle E-Business Suite Database to fulfil the purpose of automating the Business Flow of documents, for instance invoices with associated images, into Oracle Accounts Payable.
The default setting is to connect to Oracle E-Business Suite Database (EBSDB) with the user APPS. It is recommended to use the customized user XXD4_APPS, which has to be created in the EBSDB. The chosen user must be used consistently throughout the configuration. Either connect to APPS or to XXD4_APPS both in WebLogic, BPEL Datasouces, EBSAdapter and Database Link.
During PROCESSIT installation
The <INST_TOP>/config/processit.properties file is the PROCESSIT install configuration file. It contains information about the EBSDB: SID, listener port and user to connect to (APPS or XXD4_APPS). The properties file can be encrypted after installation is complete.
The <INST_TOP>/common/EBSAdapter/EBSAdapter.xml controls connetion to EBSDB.
Runtime Integration
Host file on PROCESSIT server(s)
EBSDB host is referenced in local hostfile(s) with IP Address and appropriate alias, for instance company.servers.ebs.
WebLogic
Connects to Oracle E-Business Suite using jdbc. Connects to APPS with encrypted password. Alternative is to connect to XXD4_APPS. jdbc/D4_OEBS_APPS
SOA Suite BPEL
Connects to Oracle E-Business Suite using jdbc. Connects to APPS with password in configuration file. Alternative is to connect with XXD4_APPS. File $SOA_HOME/j2ee/oc4j_soa/config/data-sources.xml
EBSAdapter
Connects to Oracle E-Business Suite using jdbc. Connects to APPS with password in configuration file. Alternative is to connect with XXD4_APPS. File $SOA_HOME/j2ee/oc4j_soa/applib/EBSAdapter.xml
Database Link
The Database Link in PROCESSIT Database (SOADB) is named EBSDB. It is created in the D4-schema. Default is to connect to APPS. Alternative it can be connected to XXD4_APPS.
Usage
Creation and refresh of MVIEWS (materialized views) read-only. MVIEWS are recommended for environments that utilizes remote Data Center(s) for EBSDB.
Creation of VIEWS read-only. This is recommended for environments that utilize local data center(s) for EBSDB).
EBSDB
User/schema XXD4_APPS is created in the EBSDB during PROCESSIT install. This requires the EBSDB system user and password in processit.properties. It is recommended to have a local DBA run the script xxd4_apps_oebs.sql
prior to PROCESSIT installation. The DBA should modify the script to create appropriate DEFAULT TABLESPACE for user XXD4_APPS.
- Grants to necessary objects is given to XXD4_APPS in the script.
- Synonyms for necessary objects is created in XXD4_APPS schema
- The following objects are created in the EBSDB
- 5 PACKAGES /programs
- 2 Tables
API
Application Programming Interface API used is AP Interface. Invoice Data is written to AP_INTERFACE and imported to AP with standard AP Concurrent Program. Invoices are validated in AP with standard Concurrent Program.
Documents/Images storage
Imported invoice image are stored in either SOADB or on a File Server according to configuration. This is controlled by configuration parameters.
Link to the stored documents/ images is available in Oracle E-Business Suite via an encrypted URL link.