This chapter describes the lookup values and settings that are required for successful implementation of Oracle Supplier Ship and Debit. Lookups supply the content of many of the lists of values (LOVs) in the Oracle Supplier Ship and Debit user interface. Most lookups are predefined (seeded in the application). The seeded values can be left as is, or you can customize them to fit your business needs. Lookup values make choosing information quick and easy, they ensure that you enter only valid data.
If the existing lookup is not a system lookup, you can create a new lookup type, add values to an existing lookup type, or prevent existing values from appearing in a lookup type. To do this, use the Application Utilities Lookups window. You must log out and log in again to see the effect of your changes. You can set the Enable flag for a value to No, so that the value no longer appears in the list of values, or you can use the start date and end date to control when a value appears in a list.
To define a new lookup type and lookup value, log in to Oracle Trade Management with the Oracle Trade Management Administrator responsibility. Click on Lookups under Setups.
• Global security group: Un-check to add lookup values specific to the security group/business group linked to your current responsibility. Existing lookup values are available to all business groups.
Tag: Leave blank.
The following table lists all of the Oracle Supplier Ship and Debit lookups for the User access level. This table also lists the values for each Lookup. Some values list the meaning (in parentheses) next to the value if the value warrants further description.
| Lookup Name/Code | Access Level | Values |
|---|---|---|
| Supplier Ship and Debit Batch Line Status OZF_SDB_LINE_STATUS |
User | APPROVED REJECTED |
| Supplier Ship and Debit Batch Reject Reason OZF_SDB_REJECT_REASON_CODE | User | Industry rejection codes for problems in price, cost, shipping location or date, credit, no response from supplier |
| Supplier Ship and Debit Batch Status OZF_SDB_STATUS | User | APPROVED CLOSED NEW REJECTED SUBMITTED |
| Supplier Ship and Debit Request OZF_SD_REQ_VEN_APPR | User | YES NO |
| Supplier Ship and Debit Request Communication Types in Supplier Trade Profile OZF_REQ_COMMUNICATION | User | MANUAL XML |
| Supplier Claim Communication Types in Supplier Trade Profile OZF_CLAIM_COMMUNICATION | User | WEBADI XML |
The following table lists all of the Oracle Supplier Ship and Debit lookups for the extensible access level. This table also lists the values for each lookup. Some values list the meaning (in parentheses) next to the value if the value warrants further description.
| Lookup Name/Code | Key | Values |
|---|---|---|
| Supplier Ship and Debit Request Line Rejection Code OZF_SD_REQ_LINE_REJECT_CODE | Extensible | NO RESPONSE |