Skip to main content

Appendix: Database Objects

This appendix provides a list of database objects for the Oracle E-Business Suite source system.

Database Object Object Type Description

GET_REV_DOC_NUM

Function

Reverses document details for Journal Reversal.

GET_AMOUNT_DUE_REMAINING

Function

Processes due amount from AR invoices.

XX_AP_PAY_SINGLE_INVOICE_PKG

Package

Processes AP Payments from cFIN to EBS that are loaded into ap_payment_interface table.

GL_LARGE_AMT_SPLIT

Procedure

Splits GL document lines amount that is greater than 11 digits (99999999999) and split the documents to the amount less than 99999999999.

OT_FIN_VALIDATION_CHK

Procedure

Enters fin_error documents into EBS_STG_ERROR_LOG table.

EBS_GL_STG_VALIDATION_CHK

Procedure

Validates that amounts are balanced and mandatory columns check for GL documents.

S4_EBS_AR_PAY_REPL

Procedure

Initiates standard API in Oracle E-Business Suite.

S4_EBS_AP_PAY_REPL

Procedure

Initiates package XX_AP_PAY_SINGLE_INVOICE_PKG.

OT_EBS_GL_OPENITEM_STG

Procedure

Loads the GL open items.

POP_REPROCESS_DATA

Procedure

Extracts the failed transactions from RECORDS_TO_REPROCESS table and loads into respective OT_EBS_AP_STG, OT_EBS_AR_STG, OT_EBS_GL_STG tables.

SEQ_CFINRPLDPURORDACCTASSGMT

Sequence

Creates the number for purchase order.

SEQ_SUPLRINVCITEMACCTASGNMENT

Sequence

Creates the number for supplier invoice.

ap_payment_interface

Synonym

Acts as the synonym of the table AP_PAYMENT_INTERFACE.

CDCGL_JE_HEADERS

Table

CDC table for the standard table GL_JE_HEADERS.

OT_EBS_GL_STG

Table

Source temp table for GL documents.

OT_EBS_GL_STG_TEMP

Table

Source temp table for GL documents for inserting unique ID.

EBS_STG_ERROR_LOG

Table

Loads the failed transactions at the source validation.

FIN_ERROR

Table

Loads the failed transactions at the stage validation.

SCT_CALENDAR

Table

Indicates the date calendar from the source.

XXAR_PAYMENT_INTERFACE

Table

Indicates the payment documents needs to be loaded from CFIN.

AP_PAYMENT_INTERFACE

Table

Indicates the payment documents needs to be loaded from CFIN.

GL_OPEN_ITEM_ACCTS

Table

Loads accounts for GL open items processing.

GL_OPEN_ITEM_DOCS

Table

Loads JE_HEADER_IDs for GL open items processing.

RECORDS_TO_REPROCESS

Table

Loads documents that failed validation for reprocessing.

COA_INFO

View

Captures company code, cost center, GL account numbers, and use them in other extraction views.

CDC_EBS_VIEW

View

Indicates the GL Journals AR Invoices, Receipts AP Invoices, and Payments in a single extraction view.

GL_ACCT_BALANCES

View

Indicates the GL Balances Extraction view.

CUST_BALANCES

View

Indicates the Customer Balances Extraction view for the AR Invoice payments that are due.

AP_UNAPPLY_PREPAY_VIEW

View

Fetches only Prepayment invoices for AP invoices and used it in VEND_BALANCES view.

VEND_BALANCES

View

Indicates the Vendor Balances extraction view for the AP invoice payments that are due.

OT_EBS_CI_VIEW

View

Extracts the customer invoice details one time.

OT_EBS_CO_VIEW

View

Extracts the customer order details one time.

OT_EBS_PO_VIEW

View

Extracts the purchase order details one time.

OT_EBS_SI_VIEW

View

Extracts the supplier invoice details one time.

Was this article helpful?

We're sorry to hear that.