Purpose
This section explains how to configure the pre-settings needed to work with the E&PI(BOM) module. General settings are defined by means of DBA settings, and project specific settings are defined by means of the project defaults.
Exercise
-
Open the A.60.04 DBA Settings screen from the menu branch Administration > A.60 Utilities.
-
Check the following settings on the General Database Settings and Application Server Specific Settings tabs. Correct the values if necessary. The Active indicator must be selected.
General Database Setting |
Setting Value |
---|---|
BOM_IMPORT_GET_FILE |
Y |
BOM_IMPORT_PATH |
d:\oradata\sdbdin\utl |
SQLLDR_EXECUTABLE |
sqlldr |
SQLLDR_MIN_SYNC_TIME |
300 |
OMI_INDEX_METHOD |
CRNP |
Application Server Specific Setting |
Setting Value |
BOM_UPLOAD_DEST |
C:\smatAS\download\ |
BOM_UPLOAD_URL |
<app-server>/marian_download |
Replace <app-server> with your server name.
-
If you have entered or modified values, save the changes using the Save button.
-
Close the screen by selecting File > Close All or Close from the main menu.
-
Open the A.20.12 Projects Defaults screen from the menu branch Administration > A.20 Project/Product Group.
-
On A.20.12, the login project TRAINPROJ should be displayed in the first block. If not, click the Enter Query button to change to query mode, open the LOV using the List of Values button, and select the project from the list. Then click OK to close the LOV.
-
Click the Run Query button to display the selected specification with its details.
-
Click the E+PI (BOM) tab to display the project defaults relevant for the BOM module.
-
Double-click in the Value field of project default ZB_1MSTR to open the LOV, select Y, and click OK to close the LOV and copy the selected value to the Value field. In the same way, set the following project defaults:
Project Default
Value
ZB_BOMHIER
N
ZB_LPSTART
10
ZB_LP_INC
10
ZB_COMMIT
Y
ZB_TAGPART
TP AV
ZB_UNIT_ID
pc
-
Save the changes using the Save button.
-
Close the screen by selecting File > Close All or Close from the main menu.
-
Open the A.20.06.11 Attribute Security screen from the menu branch Administration > A.20 Project/Product Group > A.20.06 User Security.
-
Click the New Record button, and enter the name of the new view āTRAIN-PIPā in the View Name field and the description āPipingā in the Short Desc and Description fields.
-
Click the Save button to save the new list view.
-
Click in the Attr Name field of the second (View Attributes) block, and click the List of Values button to open the LOV.
-
On the left side, select an attribute to be added to the list view, and click the button to move it to the selection list on the right. Add these attributes to the list:
To move a selected attribute up or down in the list, use the and buttons.
-
When you have selected all attributes, click the button to copy these attributes to the A.20.06.11 screen.
-
Change the sequence number in the Ord Seq field as needed, and then click the Save button to save the view attributes.
-
Close the screen by selecting File > Close All or Close from the main menu.
-
Open the A.20.06.02 User Security for Projects screen from the menu branch Administration > A.20 Project/Product Group > A.20.06 User Security.
-
Click the Enter Query button, and enter your user name in the User field and TRAINPROJ in the Project field, or open the LOV using the List of Values button and select TRAINPROJ from the list. Then, click the Run Query button to view the selected records.
-
Click in the View Name field, open the LOV using the List of Values button, select TRAIN-PIP from the list, and click OK.
-
Click the Save button to save the changes.
-
Close the screen by selecting File > Close All or Close from the main menu.