Syed Saad Ali
Syed Saad Ali

Oracle ACE Pro

Oracle Solution Architect

Oracle E-Business Suite

Oracle Cloud Infrastructure

Oracle Fusion Middleware

Oracle Database Administration

Oracle Weblogic Administration

Syed Saad Ali
Syed Saad Ali

Oracle ACE Pro

Oracle Solution Architect

Oracle E-Business Suite

Oracle Cloud Infrastructure

Oracle Fusion Middleware

Oracle Database Administration

Oracle Weblogic Administration

AppsDBA CV Download CV Contact Me

Accounts Receivables

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

 

 

August 1, 2017 An attempt has been made to enter a null value into a column that requires data
Accounts ReceivablesErrors/Workarounds-AROracle Functional

ERROR

 

An attempt has been made to enter a null value into a column that requires data. Please correct to ensure that only valid values are entered for the column.

(more…)

July 1, 2017 How to create Employee as a customer in AR
Accounts ReceivablesConfigurations-AROracle Functional

How to create Employee as a customer in AR

 

Step 1. Set the Profile option AR: Show Parties Without Accounts In DQM at site level.

 

 

Step 2. Now, Query the Employee Name in the Customer Screen with Person as a header selection.

 

 

July 1, 2017 Please Define a Party Tax Profile for Operating Unit ORG_ID
Accounts ReceivablesErrors/Workarounds-AROracle Functional

ERROR

Please Define a Party Tax Profile for Operating Unit ORG_ID

(more…)

All Rights Reserved