STAR to PACE Direct provides a number of maintenance tasks. Options include viewing and rebuilding the Delta Trigger logs; listing, deleting, and purging price or foreign exchange rate exceptions; and, listing, adding, changing, and deleting entity price overrides.
To locate a panel for data maintenance:
- In Accounting Center, in the left navigation pane, click Setup > Admin > STAR to PACE Maintenance.
You see a list of available options. Options include:
- List Delta Log – Summary Level
- List Delta Log – Detail Level
- Rebuild Delta Trigger Log
- Add Source Interface
- List Price and FX Exceptions
- Delete Price and FX Exceptions
- Purge Price and FX Exception Table
- Add Entity Price Override
- Change Entity Price Override
- Delete Entity Price Override
- List Entity Price Override
- Select the option you want to use.
- Complete the fields on the selected panel and click Submit.
The Status window appears that shows you the status of your request.
When you transfer accounting data using the Delta mode, the system accesses the ESTAR database, using records in the SPD_DELTA_TRIGGER LOG table to determine which positions to update. The system also updates the SPD_DELTA_TRIGGER_LOG_HIST table. This table provides an audit trail of the data transfer. You can also rebuild the Delta Trigger Log. You must regularly purge the SPD_DELTA_TRIGGER_LOG table to keep the Delta process running efficiently, but it is not a requirement to purge the SPD_DELTA_TRIGGER_LOG_HIST table.
Contact your Relationship Manager for recommendations about scheduling and operating STAR to PACE Direct table purges for your installation.
Add Comment