PROCESSIT 7.4 R1
For Oracle Fusion Middleware 11g

Oracle E-Business Suite Integration

©2025 Copyright ReadSoft AG (publ). All rights reserved. The contents of this document are subject to change without notice. ReadSoft is a registered trademark of ReadSoft AB. Other product and company names herein may be the trademarks or registered trademarks of their respective owners.
Questions or comments about this document may be emailed to documentation@readsoft.com.

ReadSoft AB (Head office) | Södra Kyrkogatan 4 | SE-252 23 Helsingborg | Sweden | Phone: +46 42 490 21 00 | Fax: +46 42 490 21 20
ReadSoft AG | Falkstrasse 5 | 60487 Frankfurt | Germany | Phone: +49 69 1539402-0 | Fax: +49 69 1539402-13
info@readsoft.com | www.readsoft.com

Runtime IntegrationHost file on PROCESSIT server(s)WebLogicSOA Suite BPELEBSAdapterDatabase LinkUsageEBSDBAPIDocuments/Images storage

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.