Overview
The ICIXR Analysis and Repair program checks for the integrity of the Requirements (ICIXR) object and the various system supply and demand records that it represents. The program will count and optionally resolve any discrepancies.
Navigation
ICIXR Analysis and Repair
Processing
There are two modes to perform the ICIXR Analysis and Repair.
Mode 1: The program can be run from a UI where the user chooses from checkbox parameters which of the below seven types(supply/demand) are to be analyzed, and has an option to review and report only, or also to fix any discrepancies found.
The user can select the Repair Bad/Missing Indexes checkbox to repair bad/missing ICIXR records.
NOTE When running the program in repair mode, the system deletes the ICIXR records having status 9. In addition, the system will also delete the ICIXR records having a status other than 9 based on the conditions mentioned below:
-
When 'PO Supply' is checked and if the associated Purchase Order Line is at status 9, the system deletes the respective ICIXR record(s).
-
When 'Work Order Supply' is checked and if the associated Work Order is at status 9, the system deletes the respective ICIXR record(s).
-
When 'Sales Order Demand' is checked and if the associated Sales Order Demand is at status 9, the system deletes the respective ICIXR record(s).
-
When 'WO Demand' is checked and if the associated Work Order Component is at status 9, the system deletes the respective ICIXR record(s).
-
When 'Subcontract PO Demand' is checked and if the associated PO Component Demand is at status 9, the system deletes the respective ICIXR record(s).
The user can choose the Create Detail for Errors checkbox to create a new SYRESULT record for each missing/incorrect/extra ICIXR in each category.
NOTE In repair mode, when a problem cannot be fixed (regardless of the
Create Detail for Errors checked/unchecked), an SYRESULTD record is created with the detailed reasons why it cannot be fixed.
Click the Perform Analysis button to run a back-end process that performs the analysis and repairs, monitors the progress, and upon completion, displays the Post Processing Results on the display page.
Mode 2:
The ICIXR Analysis and Repair program can be run as a scheduled process. The process accepts the Division and the UI checkbox parameters as inputs. Specify the Schedule Name and Cron Expression as described below, and then click the Schedule Analysis button to create a scheduled job. The Analysis and Repair program will run at intervals based on the Cron Expression.
Schedule Name: Specify a name for Scheduled Analysis and Repair.
Cron Expression: A CRON expression is a string of five or six fields separated by white spaces representing a set of times, generally as a schedule to execute some routine.
1. Seconds - Second Start
-
Values: 0-59
-
Special Characters: None
2. Minutes - Minute Start
-
Values: 0-59
-
Special Characters: None
3. Hours - Hour Start (Uses 24-hour clock)
4. Day_of_month - Day of the month Start
5. Month - Month Start
-
Values: 1-12 or JAN/FEB/MAR/APR/MAY/JUN/JUL/AUG/SEP/OCT/NOV/DEC
-
Special Characters (see below): , - * /
6. Day_of_week - Day of the week Start
7. Optional_year - Start year
The special characters are defined below,
|
Special Character
|
Description
|
|---|
|
,
|
Delimits values. For example, use JAN, MAR, APR to specify more than one month.
|
|
-
|
Specifies a range. For example, use JAN-MAR to specify more than one month.
|
|
*
|
Specifies all values. For example, if the Month is specified as *, the job is scheduled for every month.
|
|
?
|
Specifies no specific value. This is only available for Day_of_month and Day_of_week and is generally used when specifying a value for one and not the other.
|
|
/
|
Specifies increments. The number before the slash specifies when the interval will begin, and the number after the slash is the interval amount. For example, if you specify 1/5 for Day_of_month, the Analysis and Repair job runs every fifth day of the month, starting on the first of the month.
|
|
L
|
Specifies the end of a range (last). This is only available for Day_of_month and Day_of_week. When used with Day of the month, L always means the last day of the month, such as January 31, February 29 for leap years, and so on. When used with Day_of_week by itself, it always means 7 or SAT. When used with a Day_of_week value, it means the last of that type of day in the month. For example, if you specify 2L, you are specifying the last Monday of the month. Do not use a range of values with L as the results might be unexpected.
|
|
W
|
Specifies the nearest weekday (Monday-Friday) of the given day. This is only available for Day_of_month. For example, if you specify 20W, and the 20th is a Saturday, the Analysis and Repair runs on the 19th. If you specify 1W, and the first is a Saturday, the Analysis and Repair job does not run in the previous month, but on the third, which is the following Monday.
Tip: Use the L and W together to specify the last weekday of the month.
|
|
#
|
Specifies the nth day of the month, in the format weekday#day_of_month. This is only available for Day_of_week. The number before the # specifies weekday (SUN-SAT). The number after the # specifies the day of the month. For example, specifying 2#1 means the Analysis and Repair job runs on the first Monday of every month.
|
Examples:
|
Expression
|
Description
|
|---|
|
0 0 10 ? * * *
|
Perform Analysis and Repair at 10:00 AM every day.
|
|
0 0-5 15 * * ?
|
Perform Analysis and Repair for every minute starting at 3:00 PM and ending at 3:05 PM every day.
|
|
0 0 20 * * ? 2021
|
Perform Analysis and Repair every day at 8 PM during the year 2021.
|
|
0 0 18 ? * MON-FRI
|
Perform Analysis and Repair Monday through Friday at 6:00 PM.
|
SEE ALSO
Requirements
