General Ledger

August 1, 2017 PERF0005: Oracle error detected in glpsqs() – ORA-20001:An active sequence assignment is required. ORA-06512

Errors/Workarounds-GLGeneral LedgerOracle Functional

ERROR

PERF0005: Oracle error detected in glpsqs() – ORA-20001:An active sequence assignment is required. ORA-06512
(more…)

August 1, 2017 Oracle financials interface tables

Accounts PayablesAccounts ReceivablesAPPS DBAConfigurations-APConfigurations-ARConfigurations-CMConfigurations-FAConfigurations-GLFixed AssetsGeneral LedgerInstallations/Configurations-ApplicationsOracle FunctionalScripts

General Ledger Interface Tables

GL_BUDGET_INTERFACE
GL_DAILY_RATES_INTERFACE
GL_DRM_HIERARCHY_INTERFACE
GL_DRM_SEGVALUES_INTERFACE
GL_IMP_COA_ERR_INTERFACE
GL_IMP_COA_NORM_HIER_INTERFACE
GL_IMP_COA_SEG_VAL_INTERFACE
GL_IEA_INTERFACE
GL_INTERFACE
GL_INTERFACE_CONTROL
GL_INTERFACE_HISTORY
GL_REPORT_INTERFACE
GL_XFR_INTERFACE

Account Payables (AP) Interface Tables

AP_INTERFACE_CONTROLS
AP_INTERFACE_REJECTIONS
AP_INVOICE_INTERFACE
AP_INVOICE_LINES_INTERFACE
OIE_POL_RATES_INTERFACE

Account Receivables (AR) Interface Tables

AR_PAYMENTS_INTERFACE_ALL
AR_TAX_INTERFACE
HZ_PARTY_INTERFACE
HZ_PARTY_INTERFACE_ERRORS
RA_CUSTOMERS_INTERFACE_ALL
RE_INTERFACE_DISTRIBUTION_ALL
RA_INTERFACE_ERRORS_ALL
RA_INTERFACE_LINES_ALL
RA_INTERFACE_SALESCREDITS_ALL
AR_INTERFACE_CONTS_ALL
AR_PMTS_INTERFACE_HEADER_GT
AR_PMTS_INTERFACE_LINES_GT
AR_PMTS_INTERFACE_LINE_DETAILS
HZ_DQM_SH_SYNC_INTERFACE
HZ_DQM_SYNC_INTERFACE
RA_INTERFACE_REQID_GT

Fixed Assets (FA) Interface Tables

FA_BUDGET_INTERFACE
FA_INV_INTERFACE
FA_PRODUCTION_INTERFACE
FA_TAX_INTERFACE
FA_TRANSACTION_INTERFACE

Cash Management (CE) Interface Tables

CE_ARCH_INTERFACE_HEADERS
CE_ARCH_INTERFACE_HEADERS_ALL
CE_ARCH_INTERFACE_LINES
CE_HEADER_INTERFACE_ERRORS
CE_LINE_INTERFACE_ERRORS
CE_STATEMENT_LINES_INTERFACE
CE_UK_VALIDATIONS_INTERFACE

July 1, 2017 Not able to populate retained earning account in ledger setup in 12.2.3 – “Please choose an existing combination”

Errors/Workarounds-GLGeneral LedgerOracle Functional

ERROR

Not able to populate retained earning account in ledger setup in 12.2.3 – “Please choose an existing combination”

(more…)

July 1, 2017 Description for Journal Entry Line not Populated in GL_JE_LINES.REFERENCE10

Errors/Workarounds-GLGeneral LedgerOracle Functional

ERROR

Description for Journal Entry Line not Populated in GL_JE_LINES.REFERENCE10

(more…)