BY ORDER OF THE SECRETARY OF THE AIR FORCE AIR FORCE HANDBOOK 23-123 ...

933 Pages·2017·14.17 MB·English

by  Neha Sharma

AIR FORCE HANDBOOK 23-123,
BY ORDER OF THE
VOLUME 2, PART 4
SECRETARY OF THE AIR FORCE
8 AUGUST 2013
Incorporating Change 3, 3 OCTOBER 2017
Certified Current 20 December 2021
Materiel Management
INTEGRATED LOGISTICS SYSTEM-
SUPPLY (ILS-S), ANCILLARY
COMPONENTS
ACCESSIBILITY: Publications and forms are available on the e-Publishing website at
www.e-publishing.af.mil.
RELEASABILITY: There are no releasability restrictions on this publication.
OPR: AF/A4LR Certified by: AF/A4LR
(Col David A. Biggs)
Pages: 933
This handbook facilitates implementation of AFI 23-101, Air Force Materiel Management and
AFMAN 23-122, Materiel Management Procedures. It addresses the Air Force Supply Central
Database (AFSCDB) and the Enterprise Solution-Supply (ES-S). This part of the handbook
provides detailed information on the AFSCDB. Additionally, an introduction to the ES-S and link
to the online ES-S handbook is provided. This guidance applies to all personnel (military, civilian,
and contractors) working for the United States Air Force (USAF) including major commands
(MAJCOMs), direct reporting units (DRU), field operating agencies (FOA) and other individuals
or organizations as required by binding agreement or obligation with the Department of the Air
Force (DAF). This publication applies to Air Force Reserve Command (AFRC) and Air National
Guard (ANG) Units. This handbook should be used in conjunction with AFI 23-101 and AFMAN
23-122 in the execution of materiel management operations. Refer recommended changes and
questions about this publication to the Office of Primary Responsibility (OPR) using AF Form
847, Recommendation for Change of Publication; route AF Forms 847 from the field through the
appropriate functional’s chain of command. Ensure that all records created as a result of processes
prescribed in this publication are maintained in accordance with Air Force Manual (AFMAN) 33-
363, Management of Records, and disposed of in accordance with the Air Force Records
Disposition Schedule (RDS) located in the Air Force Records Information Management System
(AFRIMS) https://www.my.af.mil/afrims/afrims/afrims/rims.cfm. In accordance with the
Paperwork Reduction Act and DoD policy, ensure that reports of information collections that are
collected and/or are compiled and transmitted from the general public are cleared and licensed by
2 AFH23-123V2PT4 8 AUGUST 2013
the Office of Management and Budget prior to collection. Information that is collected from other
DoD components or Federal agencies must be approved by DoD and licensed with a report control
symbol. The use of the name or mark of any specific manufacturer, commercial product,
commodity, or service in this publication does not imply endorsement by the Air Force.
SUMMARY OF CHANGES
This interim change revises AFH 23-123 Volume 2 Part 4, by updating critical specific information
pertaining to access and security, Base Assignment Codes, Due-Out Validation, SBSS Codes
Table, and deletion of MAJCOM Codes. Administrative changes for references throughout to
change “AFMC SCM-R Activity” to “AFMC”.

Chapter 1— SUPPLY MODERNIZATION SUMMARY 26
Section 1A— Purpose Of Supply Modernization. 26
1.1. Chapter Summary. ................................................................................................ 26
1.2. Overview. ................................................................................................................ 26
1.3. ILS-S Features and Capabilities. ............................................................................. 26
Section 1B— ILS-S Controls. 27
1.4. Controls. .................................................................................................................. 27
Chapter 2— ACCESS AND SECURITY 28
Section 2A— Purpose and Overview. 28
2.1. Chapter Summary. .................................................................................................. 28
2.2. Overview. ................................................................................................................ 28
Section 2B— Sign On And Access. 28
2.3. Section Summary. ................................................................................................... 28
2.4. Web Access. ............................................................................................................ 28
2.5. Oracle Access. ........................................................................................................ 29
2.6. Access Levels and Permissions. ............................................................................. 29
2.7. User Identification Structure. .................................................................................. 29
Table 2.1. Base Assignment. .................................................................................................... 30
Table 2.2. DELETED. ............................................................................................................. 39
Section 2C— Security. 39
2.8. Overview ................................................................................................................. 39
AFH23-123V2PT4 8 AUGUST 2013 3
2.9. Secure Socket Layer (SSL). .................................................................................... 39
2.10. Password Assignment. ............................................................................................ 39
2.11. Password Administration. ....................................................................................... 40
Section 2D— User Administrator. 40
2.12. Overview. .............................................................................................................. 40
2.13. Appointment. .......................................................................................................... 41
2.14. Duties and Responsibilities. .................................................................................... 41
2.15. User Creation Policy and Procedures. .................................................................... 42
2.16. Access/Authorized User Audits. ............................................................................. 42
Section 2E— User Management User’s Manual. 43
2.17. Overview. ................................................................................................................ 43
2.18. New User Creation. ................................................................................................. 43
Figure 2.1. Form Layout. .......................................................................................................... 43
Table 2.3. User Account Name Search Fields. ........................................................................ 44
Figure 2.2. Form Usage. ............................................................................................................ 45
Figure 2.3. Form Usage. ............................................................................................................ 46
Figure 2.4. Screen 2 – Initial User Data Form Layout. ............................................................. 46
Table 2.4. Initial User Data Screen – Data Fields. ................................................................... 47
Figure 2.5. Form Usage. ............................................................................................................ 48
Figure 2.6. Screen 3 – Confirm Create User Form Layout. ...................................................... 48
Figure 2.7. Form Usage. ............................................................................................................ 49
Figure 2.8. Screen 4 – Add/Remove User Access Privileges Form Layout. ............................. 50
Figure 2.9. Form Usage. ............................................................................................................ 52
Figure 2.10. Screen Image. .......................................................................................................... 53
Figure 2.11. Screen Image. .......................................................................................................... 53
Figure 2.12. Screen Image. .......................................................................................................... 53
Figure 2.13. Screen Image. .......................................................................................................... 53
Figure 2.14. Screen Image. .......................................................................................................... 54
Figure 2.15. Screen Image. .......................................................................................................... 54
4 AFH23-123V2PT4 8 AUGUST 2013
Figure 2.16. Login Menu List Quick Reference Tables. ............................................................. 55
2.19. Existing User Management. .................................................................................... 55
Figure 2.17. Form Layout. .......................................................................................................... 56
Figure 2.18. Form Layout. .......................................................................................................... 57
Figure 2.19. Form Layout. .......................................................................................................... 57
Figure 2.20. Form Layout. .......................................................................................................... 58
Figure 2.21. Form Layout. .......................................................................................................... 60
Figure 2.22. Form Layout. .......................................................................................................... 61
Figure 2.23. Form Layout. .......................................................................................................... 61
Figure 2.24. Form Layout. .......................................................................................................... 62
Figure 2.25. Form Layout. .......................................................................................................... 63
Figure 2.26. Form Layout. .......................................................................................................... 63
Figure 2.27. Form Layout. .......................................................................................................... 64
Figure 2.28. Screen 4 – Kill User Sessions - Form Layout. ........................................................ 65
Figure 2.29. Screen Image. .......................................................................................................... 66
Figure 2.30. Screen Image. .......................................................................................................... 66
Figure 2.31. Screen Image. .......................................................................................................... 67
Figure 2.32. Screen Image. .......................................................................................................... 67
Figure 2.33. Form Layout. .......................................................................................................... 67
Figure 2.34. Form Layout. .......................................................................................................... 68
Figure 2.35. Form Layout. .......................................................................................................... 68
Figure 2.36. Screen Image. .......................................................................................................... 69
Chapter 3— MIGRATION PROCEDURES 70
Section 3A— Overview And Summary. 70
3.1. Chapter Summary. .................................................................................................. 70
Section 3B— Data Migration Validation Program (NGV301V). 70
3.2. Section Summary. ................................................................................................... 70
Table 3.1. NGV301V Processing. ............................................................................................ 70
AFH23-123V2PT4 8 AUGUST 2013 5
Section 3C— Supply Records Download And Transfer (NGV301M). 71
3.3. Section Summary. ................................................................................................... 71
Table 3.2. Gang number. .......................................................................................................... 71
Table 3.3. NGV301M Setup. ................................................................................................... 71
Table 3.4. NGV301M-MD Processing. ................................................................................... 73
Table 3.5. NGV301M-TO Processing. .................................................................................... 73
Table 3.6. NGV301M-LT Processing. ..................................................................................... 74
3.4. Upload to AFSCDB ................................................................................................ 74
3.5. Air Force Data Services Missing Transactions – Recovery Instructions ................ 75
Section 3D— Supply Web Migration Procedures. 76
3.6. Section Summary. ................................................................................................. 76
Table 3.7. Web Migration Combinations................................................................................. 76
Figure 3.1. Web Welcome Screen. ............................................................................................ 76
3.7. Web Migration Menu Options. ............................................................................... 77
Figure 3.2. Web Migration Options. ......................................................................................... 77
Figure 3.3. Download Status Report. ........................................................................................ 77
Figure 3.4. Download Stat - View All of Report ...................................................................... 78
Figure 3.5. Upload Status Report .............................................................................................. 78
Figure 3.6. Upload Stat – All of Report. ................................................................................... 79
Figure 3.7. Upload Stat – Last Part of the Report. .................................................................... 79
Figure 3.8. Upload 704 Status Report. ...................................................................................... 80
Figure 3.9. Upload 704 Status Report – All of Report. ............................................................. 80
Figure 3.10. Upload Status Report – Last Part of Report. ........................................................... 81
Figure 3.11. Detailed Error/OK Files. ......................................................................................... 81
Figure 3.12. Detailed Error/OK Files. ......................................................................................... 82
Figure 3.13. Example Error/OK File. .......................................................................................... 82
Figure 3.14. Restart Upload. ....................................................................................................... 83
Figure 3.15. Restart Upload – Confirmation Message. ............................................................... 83
Figure 3.16. Restart 704 Upload. ................................................................................................ 84
6 AFH23-123V2PT4 8 AUGUST 2013
Figure 3.17. Restart 704 Upload – Confirmation Message. ........................................................ 84
Figure 3.18. View All Active Migration Stats. ........................................................................... 85
Figure 3.19. Overall View of Migrations. ................................................................................... 85
Figure 3.20. View All Migrations – Migration Upload Stat Report. .......................................... 86
3.8. NGV301V – Validation Rules. ............................................................................... 86
Table 3.8. Validation Rules. .................................................................................................... 86
3.9. NGV301V – Error Messages. ................................................................................. 111
Table 3.9. NGV301V Output Messages. ................................................................................. 111
3.10. NGV301V – AFMC/LRS Corrective Actions for NGV301V Errors. .................... 115
Table 3.10. NGV301V Errors. ................................................................................................... 115
3.11. NGV301M Downloaded Record Codes ................................................................. 126
Table 3.11. NGV301M Downloaded Record Codes. ................................................................ 126
Chapter 4— DISCOVERER USERS MANUAL AND PROGRAM RESUMES 130
Section 4A— Chapter Summary And Discoverer Plus Basic Concepts. 130
4.1. Chapter Summary. ................................................................................................. 130
4.2. Overview. ................................................................................................................ 130
4.3. How Discover Works. ............................................................................................. 130
Figure 4.1. Oracle Discoverer. .................................................................................................. 131
4.4. Starting Discoverer. ................................................................................................ 133
Table 4.1. Starting Discover. ................................................................................................... 133
Figure 4.2. Discoverer Plus Connection Page. .......................................................................... 134
Figure 4.3. User-ID & Password Page. ..................................................................................... 135
Figure 4.4. Create Connection: Connection Details. ................................................................. 136
4.5. What You See on the Screen. ................................................................................. 138
Figure 4.5. Workbook Window. ................................................................................................ 138
Figure 4.6. Tool Tips. ................................................................................................................ 139
Figure 4.7. Figure 2-3 Discoverer Table Layout. ...................................................................... 140
Figure 4.8. Discoverer Table Layout With Page Items. ............................................................ 141
Figure 4.9. Cross Tab Layout With Page Items. ....................................................................... 142
AFH23-123V2PT4 8 AUGUST 2013 7
Figure 4.10. Drop-Down List on Page Axis Items. ..................................................................... 143
Figure 4.11. See Next Page of Data. ........................................................................................... 144
Figure 4.12. See Next page of Data. ........................................................................................... 144
Figure 4.13. Workbook Wizard Format Panel. ........................................................................... 145
Figure 4.14. Format Data, With Number, and Dialog Box. ........................................................ 146
Figure 4.15. Format Data with Text Dialog Box. ....................................................................... 148
Figure 4.16. Workbook Wizard Format Panel. ........................................................................... 149
Figure 4.17. Format Heading Dialog box.................................................................................... 150
Figure 4.18. Workbook Wizard Format Panel. ........................................................................... 151
Figure 4.19. Edit Heading Dialog Box. ....................................................................................... 152
Figure 4.20. Rename Worksheet Dialog Box.............................................................................. 152
Figure 4.21. Move Worksheets Dialog Box. ............................................................................... 153
Figure 4.22. Window Resize Arrow. ........................................................................................... 154
Figure 4.23. Workbook Properties Dialog Box. .......................................................................... 155
4.6. Getting the Data You Want..................................................................................... 155
Figure 4.24. Welcome to Discoverer Page. ................................................................................. 156
Figure 4.25. Connect to Oracle Discoverer. ................................................................................ 157
Figure 4.26. Workbook Wizard. .................................................................................................. 157
Figure 4.27. Open Workbook Dialog Box. ................................................................................. 158
Figure 4.28. Select a Workbook to Open. ................................................................................... 158
Figure 4.29. Run Query Confirmation. ....................................................................................... 159
Figure 4.30. Time Estimate. ........................................................................................................ 159
Figure 4.31. Query Progress Indicator. ....................................................................................... 160
Figure 4.32. Discoverer Workbook. ............................................................................................ 160
Figure 4.33. Open Workbook Dialog Box. ................................................................................. 161
Figure 4.34. Open Scheduled Workbook Dialog Box. ................................................................ 162
Figure 4.35. Example of Query Using Parameter Values. .......................................................... 164
Figure 4.36. Example of Query Using Parameter Values. .......................................................... 165
Figure 4.37. Select Values Dialog Box. ...................................................................................... 166
8 AFH23-123V2PT4 8 AUGUST 2013
Figure 4.38. Another Example of Query Using Parameter Values. ............................................ 167
Figure 4.39. Edit Parameter Values Dialog Box with Two Parameters. ..................................... 168
Figure 4.40. Edit worksheet with Parameters Tab Highlighted. ................................................. 169
Figure 4.41. New Parameter Dialog Box. ................................................................................... 170
Figure 4.42. Edit Worksheet Dialog Box. ................................................................................... 172
Figure 4.43. Edit Parameter Dialog Box. .................................................................................... 173
Figure 4.44. Edit Worksheet, Conditions Tab Dialog Box. ........................................................ 175
Figure 4.45. Choosing Conditions Relating to Items. ................................................................. 175
Figure 4.46. Condition Incompatibility Warning Box. ............................................................... 176
Figure 4.47. New Condition Dialog Box. ................................................................................... 177
Figure 4.48. Data Items Drop Down List. ................................................................................... 178
Figure 4.49. Condition Operator Dialog Box. ............................................................................. 178
Figure 4.50. Values Selection Dialog Box. ................................................................................. 179
Table 4.2. Condition Expressions. ........................................................................................... 179
Figure 4.51. New Condition Dialog Box. ................................................................................... 182
Figure 4.52. Example of Advanced Condition Statement. .......................................................... 183
Figure 4.53. Example of Condition Nesting................................................................................ 184
Figure 4.54. Apply Existing Condition. ...................................................................................... 185
Figure 4.55. Create Worksheet Wizard. ...................................................................................... 188
Figure 4.56. Select Items Wizard. ............................................................................................... 189
Figure 4.57. See Available Items. ............................................................................................... 190
Figure 4.58. Example of Selected Items...................................................................................... 191
Figure 4.59. Join Folders Dialog Box. ........................................................................................ 192
Figure 4.60. Edit Worksheet Dialog Box. ................................................................................... 193
Figure 4.61. Examples of Table and Cross Tab Layout. ............................................................. 194
Figure 4.62. Examples of Rearranging Columns on a Table. ..................................................... 196
Figure 4.63. Switch to Another Worksheet. ................................................................................ 197
Figure 4.64. Open a Worksheet. .................................................................................................. 198
Figure 4.65. Save Work Book Reminder. ................................................................................... 198
AFH23-123V2PT4 8 AUGUST 2013 9
Figure 4.66. Save Workbook to Database Dialog Box. .............................................................. 199
Figure 4.67. Delete Workbooks from Database Dialog Box....................................................... 200
4.7. Presenting Data on a Graph. ................................................................................... 200
Figure 4.68. Example Data Configuration for a Bubble Graph. ................................................. 203
Figure 4.69. Example Data Configuration for a High-Low Stock Chart. ................................... 204
Figure 4.70. Example Data Configuration for a Dual-Y Bar Graph. .......................................... 204
Figure 4.71. Graph Wizard: Graph Type. ................................................................................... 205
Figure 4.72. Graph Wizard Titles, Totals, and Series. ................................................................ 206
Figure 4.73. Pie Chart Options. ................................................................................................... 207
Figure 4.74. Graph Wizard X - Axis. .......................................................................................... 208
Figure 4.75. Graph Wizard Y-Axis. ............................................................................................ 209
Figure 4.76. Graph Wizard: Plot Area. ....................................................................................... 210
Figure 4.77. Graph Wizard: Legend. ........................................................................................... 211
Table 4.3. Font Options Dialog Box. ....................................................................................... 211
Figure 4.78. Title Font Dialog Box. ............................................................................................ 212
4.8. Analyzing Data. ...................................................................................................... 213
Figure 4.79. Pivoting Items on a Table. ...................................................................................... 214
Figure 4.80. Worksheets after Pivoting Data on a Table. ........................................................... 215
Figure 4.81. Page Item Drop-Down List. .................................................................................... 216
Figure 4.82. Example Cross Tab Worksheet & Layout. ............................................................. 217
Figure 4.83. Another Example, Cross Tab Worksheet & Layout. .............................................. 218
Figure 4.84. Example of Simple Table Sort. ............................................................................... 221
Figure 4.85. Sort Dialog Box. ..................................................................................................... 222
Figure 4.86. Example of Group Sorting. ..................................................................................... 223
Figure 4.87. Sort Dialog Box. ..................................................................................................... 224
Figure 4.88. Example of Cross Tab Sort. .................................................................................... 226
Figure 4.89. Cross Tab Sort Dialog Box. .................................................................................... 227
Figure 4.90. Example of Edit Calculation Dialog Box. .............................................................. 229
Figure 4.91. Display of Calculated Item. .................................................................................... 230
10 AFH23-123V2PT4 8 AUGUST 2013
Figure 4.92. Edit Worksheet Dialog Box. ................................................................................... 231
Figure 4.93. Example of Totaled Data. ....................................................................................... 232
Figure 4.94. Edit Worksheet, Totals Tab. ................................................................................... 233
Figure 4.95. New Total Dialog Box. ........................................................................................... 234
Table 4.4. Examples. ................................................................................................................ 236
Figure 4.96. Example of Using Percentages. .............................................................................. 237
Figure 4.97. Edit Worksheet, Percentages Dialog Box. .............................................................. 238
Figure 4.98. Edit Percentage Dialog Box. ................................................................................... 239
Table 4.5. Options. ................................................................................................................... 239
Figure 4.99. Percentage Label Dialog. ........................................................................................ 240
Table 4.6. Examples. ................................................................................................................ 241
4.9. Sharing Results With Others. .................................................................................. 241
Figure 4.100. Print Wizard; Select Objects. .................................................................................. 242
Figure 4.101. Print Wizard; Define Graph Details. ....................................................................... 243
Figure 4.102. Print Wizard, Edit Parameter Values. ..................................................................... 244
Figure 4.103. Print Wizard, Supervise. ......................................................................................... 245
Figure 4.104. Export Wizard, Select Objects. ............................................................................... 246
Figure 4.105. Export Wizard, Define File Details. ....................................................................... 247
Figure 4.106. Export Wizard, Define Graph Details. .................................................................... 248
Figure 4.107. Export Wizard, Parameter Values. .......................................................................... 249
Figure 4.108. Export Log. ............................................................................................................. 250
Figure 4.109. File Download Dialog Box. .................................................................................... 251
Figure 4.110. Share Workbooks, Workbook to User dialog Box. ................................................ 252
Figure 4.111. Share Workbooks, User to Workbook Dialog Box. ................................................ 253
4.10. Using Lists of Values (LOVs). ............................................................................... 253
Figure 4.112. Example of LOV. .................................................................................................... 254
Figure 4.113. Edit Parameters Values Dialog Box. ...................................................................... 255
Figure 4.114. Using LOVs in a Condition Statement. .................................................................. 255
Figure 4.115. Using LOVs in Item Navigator. .............................................................................. 256