Pages Used With the Utility
| Page Name | Definition Name | Navigation | Usage |
|---|---|---|---|
|
Comparison Methods |
SCC_DISCREP_METHOD |
|
Maintain the list of available methods for comparing table data between two different databases. |
|
Resolution Methods |
SCC_DISCREP_APPMTH |
|
Maintain the list of methods used to apply winners to resolve data discrepancies. |
|
Data Sources |
SCC_DISCREPDSRC |
|
Provide connection information for an external data source. |
|
Database Link Maps |
SCC_DISCREP_LNK |
|
Define mappings from a record name to a database link record name. |
|
Record Maps |
SCC_DISCREP_MAP |
|
Define a view used to compare data for the same table on two different databases. Views may be used instead of the base table when only certain columns or rows are desired for comparison. |
|
Winner Rules |
SCC_DISCREP_RULE |
|
Maintain rule definitions for determining how to resolve data discrepancies between the same table on two different databases. |
|
CS Permission Maps |
SCC_PERMISN_MAP |
|
Set comparison and discrepancy resolution security by mapping record names to permission lists in CS. |
|
HCM Permission Maps |
HCI_PERMISN_MAP |
|
Set comparison and discrepancy resolution security by mapping record names to permission lists in HCM. |
|
Run Discrepancy Comparison |
SCC_DISCREPRCTL |
|
Run the comparison process to determine data discrepancies in the specified tables between two databases. |
|
Integration Discrepancies |
SCC_INTGR_DSCRPNCY |
|
Display data discrepancies found between the same table on two different databases and specify the winner for resolution. |
|
Discrepancy Details |
SCC_INTGR_DSCRFLDS |
Click the Show Fields link for any row on the Integration Discrepancies page. |
Show data discrepancy details for a selected row. |
|
Resolve Discrepancies |
SCC_DISCREP_RUNRUL |
|
Run the process to apply the winner rule to all discrepancy rows in the specified table or resolve discrepancies. |
|
Resolution Log |
SCC_RESOLVE_LOG |
|
View a log of transactions that have resolved data discrepancies. |
|
Purge Resolution Log |
SCC_RSLVLOGPRUNCTL |
|
Run the process to delete data discrepancy resolved transaction logs. |