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. |