[EBS] ITA (Information Technology Audit)

Check License ITA

ITA is setup as follows:
  1. Concurrent program 'Audit Trail Update Tables' has been run
  2. Profile option 'AuditTrail:Activate' has been enabled
  3. Concurrent program 'Enable Setup Change tracking' using parameter 'FND_PROFILE_OPTION_VALUES' has been run


727208.1 - AuditTrail Update Tables fails on View AP_SYSTEM_PARAMETERS_ALL_AC1
  1. Navigate to the audit group tables, and query back the table as before
  2. Set the Group state to "Disable - Purge Table" for SQLAP.AP_SYSTEM_PARAMETERS_ALL. This option Disable - Purge Table Drops the auditing triggers and views and deletes all data from the shadow table.
  3. Run the "AuditTrail Update Tables" concurrent program.


TABLE_NAME DESCRIPTION
------------------------------- -------------------------------------------------------------
FND_PROFILE_OPTION_VALUES Values of user profile options defined at different profile levels
FA_SYSTEM_CONTROLS System-wide controls that affect all assets
AP_SYSTEM_PARAMETERS_ALL Payables system defaults and parameters
FINANCIALS_SYSTEM_PARAMS_ALL Oracle Financials system parameters and defaults
PO_SYSTEM_PARAMETERS_ALL Purchasing options
RCV_PARAMETERS Organization-level receiving controls
AR_SYSTEM_PARAMETERS_ALL Oracle Receivables system options
MTL_PARAMETERS Inventory control options and defaults
WSH_SHIPPING_PARAMETERS Shipping Parameters
FV_SYSTEM_PARAMETERS Stores Federal System parameters
GL_LEDGERS Ledger definition
ZX_PRODUCT_OPTIONS_ALL This table store the tax system options for multiple applications. Each record stores tax options of an operating unit for a specific application.
AP_SUPPLIERS AP_SUPPLIERS stores information about your supplier level attributes.
AP_SUPPLIER_SITES_ALL AP_SUPPLIER_SITES_ALL stores information about your supplier site level attributes.
AP_PRODUCT_SETUP AP_PRODUCT_SETUP contains the options and defaults you define for operating your Oracle Payables application system across all operating units.
This table contains information such as your default payment terms and payment method. Your Orac
CE_SYSTEM_PARAMETERS System options