Oracle® Retail Enterprise Inventory Cloud Service Administration Guide Release 18.1 F22920-01 |
|
![]() Previous |
![]() Next |
During normal data seed import process, the oracle database will validate data integrity via database foreign key constraints.
For initial data seeding into EICS, if slowness is observed due to validating data integrity constraints, sysop user can disable the database constraints prior to running initial data seeding (Note: only certain predefined database constraints can be disabled via Data Seeding Console). The database constraints must be enabled after initial data seeding is completed.
To disable database constraints:
Login Oracle Enterprise Inventory Cloud Service page as ECIS System Ops user.
On Main Menu, Select Admin/ Technical Maintenance/Job Admin.
On Job Admin Screen, click Data Seed, this will bring you to the Data Seed screen.
Select Job Name Database Constraints.
From Seed Option drop down list, select Disable Constraint.
Click Start Job.
After data seeding, the EICS database constraints must be enabled. When this occurs, the data that was seeded into the EICS tables will be validated during the enabled of the database constraints.
To enable database constraints:
On Job Admin Screen, click Data Seed, this will bring you to the Data Seed screen.
Select Job Name Database Constraints.
From Seed Option drop down list, select Enable Constraint.
Click Start Job.