## Maintaining Fulfillment Status

Step | Action
1. | Begin by navigating to the Maintain Fulfillment Status page. Click the Links link.
2. | Click the Maintain Service Data link.
3. | Use the Maintain Fulfillment Status page to modify the fulfillment status codes made available when reviewing or closing a service request.
4. | First, add a fulfillment status code. Click the Add button.
5. | Lookup Codes are unique keys in data tables and are built into the logic of Oracle ISR. Click in the Lookup Code field.
6. | A Lookup Code can be upper or lower case. Enter the desired information into the Lookup Code field. Enter a valid value e.g. "Closed_Unfulfilled_Legal".
7. | Next, specify a short description. Short descriptions appear when the fulfilling employee reviews or closes a service request. Click in the Short Description field.
8. | Enter the desired information into the Short Description field. Enter a valid value e.g. "Unable to Fulfill, Legal Issue, Closed".
9. | Click the Active option.
10. | Click the Fulfillment Status Type list.
11. | Next, specify a fulfillment status type. Click the Closed list item.
12. | Use the Description field to add an optional description. Click in the Description field.
13. | Enter the desired information into the Description field. Enter a valid value e.g. "Unable to Fulfill, Legal Issue, Closed".
14. | Use the Revert button to cancel adding a fulfillment status code. This only works if the fulfillment status code has not been saved.
15. | Save the fulfillment status code to make it available on the Review Service Request and Close Service Request pages. Click the Save button.
16. | The fulfillment status code Closed_Unfulfilled_Legal is now added.
17. | Next, modify the description for the Closed_Unfulfilled_Legal fulfillment status code. By default, the first row is automatically selected. When modifying or deleting a status code, ensure that the row you want to take action on is selected. You can click anywhere in the row to select it. Click the row header.
18. | Click in the Description field.
19. | Enter the desired information into the Description field. Enter a valid value e.g. ", Confidential".
20. | Click the Save button.
21. | The Closed_Unfulfilled_Legal lookup code is now modified.
22. | There are two types of delete, a hard delete and soft delete. A hard delete removes the fulfillment status code from the database table, provided it is not used in a service request. First, perform a hard delete on the code Closed_Unfulfilled_Legal. Click the row header.
23. | Click the Delete button.
24. | The fulfillment status code Closed_Unfulfilled_Legal is now deleted.
25. | A soft delete is used for inactivating a fulfillment status code already used in service requests. Inactivated codes are not displayed as options on the Review Service Request and Close Service Request pages. Next, perform a soft delete on the Closed_Unfulfilled_Policy code. Click the row header.
26. | Click the Active option.
27. | Confirm that you want to make the Closed_Unfulfilled_Policy code inactive. Click the OK button.
28. | The fulfillment status code Closed_Unfulfilled_Policy is now inactive.
29. | Click the Save button.
30. | Next, query the Closed fulfillment status codes. Click the Query By Example button.
31. | You can query on any field by clicking into that field. Click in the Fulfillment Status Type field.
32. | You can query using whole or partial words. Enter the desired information into the Fulfillment Status Type field. Enter a valid value e.g. "Closed".
33. | Press the Enter key to initiate the query. Press [Enter].
34. | Only the Closed fulfillment status codes appear.
35. | You must clear the queried data to view the full list of fulfillment status codes. Click in the Fulfillment Status Type field.
36. | Select the queried data. Press [Shift+Home].
37. | Press [Delete].
38. | Press [Enter].
39. | The full list of fulfillment status codes is viewable again. The Query By Example button can be toggled on or off.
40. | You have completed the Maintaining Fulfillment Status Codes topic. End of Procedure.