Oracle Pedigree and Serialization Manager Process Guide Release 1.2 Part Number E36379-01 | Contents | Previous | Next |
This appendix covers the following topics:
These tables list all of the Lookup Types and Codes used in Oracle Pedigree and Serialization Manager (OPSM).
For information on how to maintain lookup types and codes, see Maintaining Lookup Types and Codes.
Lookup Type | Lookup Type Meaning | Lookup Type Description | Lookup Codes |
---|---|---|---|
PAS_CONTAINER_TYPE | Container Type | The type of container or package for the product. This is typically the lowest saleable unit packaging type (e.g. Bottle, Blister Pack, etc.). | None by default. |
PAS_CUSTOM_LOOKUP_TYPE | Custom Lookup Type | Available for customer-defined use (such as a cross-reference within custom serial generation). This lookup type will not be referenced by OPSM during standard processing. | None by default. |
PAS_CUSTOM_SERIAL_METHOD | Custom Serial Method | A lookup available for customer-defined use within the custom serial generation algorithm which will indicate which custom serial algorithm to use. This lookup must be configured by the end user for use in custom serial generation. | None by default. |
PAS_DESTINATION_GROUPS | Destination Groups | Identifies a destination group which is used to organize like serial destinations for management of destination rules. |
|
PAS_DOCUMENT_TYPE | Document Type | The type of document (e.g. Invoice Number, Shipping Number, Work Order, etc.). | None by default. |
PAS_DOSAGE_FORM | Dosage Form | The dosage form of the product is the physical form of the product that is packaged (e.g. Pill, Capsule, etc.). | None by default. |
PAS_LABEL_PRINT_FORMAT | Label Print Format | The format for printing the label. | None by default. |
PAS_LOCATION_TYPE | Location Type | The type of location. | None by default. |
PAS_LOT_EXTRACT | Lot Extract | Identifies the Oracle Data Integrator (ODI) scenario that will be used for the lot information extract. | None by default. Oracle provides these lookup codes for the integration between Oracle E-Business Suite and OPSM:
|
PAS_PACKAGE_UNIT | Package Unit Type | The type of packaging unit of the serialized product or higher level serialized container. | None by default. |
PAS_PRODUCT_CATEGORY | Product Category | The category of product. | None by default. |
PAS_PRODUCT_EXTRACT | Product Extract | Identifies the Oracle Data Integrator (ODI) scenario that will be used for the product information extract. | None by default. Oracle provides these lookup codes for the integration between Oracle E-Business Suite and OPSM:
|
PAS_PRODUCT_UOM | Product Unit of Measure | The Product UOM or Product Packaging Unit of the serialized product. This lookup will be a subset of the PAS_PACKAGING_UNIT lookup (e.g. Bottle, Blister Pack, Box, Case). | None by default. |
PAS_SERIAL_USAGE | Serial Usage | The current usage of the serialized item. | None by default. |
PAS_SOURCE_SYSTEM | Source System | The identifier used to distinguish different transactional or ERP systems. |
|
PAS_WORK_ORDER_EXTRACT | Work Order Extract | Identifies the Oracle Data Integrator (ODI) scenario that will be used for the work order extract. | None by default. Oracle provides these lookup codes for the integration between Oracle E-Business Suite and OPSM:
|
Lookup Type | Lookup Type Meaning | Lookup Type Description | Lookup Code, Meaning, and Description |
---|---|---|---|
PAS_EPC_TYPE | EPC Number Type | Type of EPC Number | GTIN, GTIN-14, GTIN-14 EPC Number |
PAS_LABEL_TYPE | Label Type | The type of identifier on the serialized product or serialized container. |
|
PAS_PRODUCT_CODE_TYPE | Product Code Type | The type of product code (e.g. GTIN, NDC442, NDC542, etc). |
|
PAS_REASON_CODE | Reason Code | The reason code identifying why the serial was decommissioned. |
|
PAS_SERIAL_TYPE | Serial Type | The format of the serial number (e.g. SGTIN-96, etc.). |
|
PAS_SERIAL_TYPE_GROUP | Serial Type Group | Identifies a serial group which is used to group like serial types for management of serial ranges. |
|
Lookup Type | Lookup Type Meaning | Lookup Type Description | Lookup Code, Meaning, and Description |
---|---|---|---|
PAS_ACTION_CODE | Action Code | Identifies the action to be taken when processing a record from the interface table. | MERGE, Merge Product and Item into OPSM, Merge Product and Item into OPSM |
PAS_ADDRESS_CODE | Address Code | The code of the address (i.e. source, destination, etc.). |
|
PAS_ADDRESS_TYPE | Address Type | The type of address (i.e. shipping, business, etc.). |
|
PAS_COMPOSITE_ALERT_CONTROL | Composite Alert Control | Reserved for future use. Indicates when e-mail alerts are sent during the SOA Composite fault processing. |
|
PAS_COUNTERFEIT_STATUS | Counterfeit Status | The status of the serial with regards to counterfeiting. |
|
PAS_DIGITAL_SIGN_METHOD | Digital Signature Method | If digital signature functionality will be used, set the Digital Signature Method to Session. | SESSION, Session, Digitally Sign documents based on session |
PAS_DIGITAL_SIGN_YESNO | Signed Document Attached | Identifies signed and unsigned pedigree documents. |
|
PAS_EPC_CODE_TYPES | Code Type | EPCIS Code Type |
|
PAS_EPC_EVENT_TYPES | Event Type | EPCIS Event Type |
|
PAS_EPC_PURE_TYPES | Pure Type | EPCIS Pure Type |
|
PAS_EPC_SGTIN-96_FILTER | EPC SGTIN-96 Filter Value | EPC SGTIN-96 Filter used during generation of EPC Serial Numbers. |
|
PAS_ERROR_STATUS | Transaction Error Status | Transaction Error Status |
|
PAS_GENERATION_STATUS | Generation Status | Status of the serial generation request. |
|
PAS_GEN_REQUEST_METHOD | Generation Request Method | The method used to create the Serial Generation Request. |
|
PAS_INITIATING_OPERATION | Initiating Operation | The operation that initiated the transaction. |
|
PAS_JOB_STATUS | Job Status | The status of the Job. |
|
PAS_JOB_TYPE | Job Type | Job Type |
|
PAS_LOT_SYNCH_ACTIONS | Actions for Lot Synchronization | Actions for Lot Synchronization (Extract, Merge, etc.) |
|
PAS_METHOD_OF_COMM | Method of Communication | The method of communicating the serialized items (e.g. Web service, File exchange, etc.). |
|
PAS_ON_OFF | On or Off Flag | Flag used to identify an "on" or "off" status. This profile option is used to determine the checked (on) and the unchecked (off) values in check boxes for several pages in OPSM. For example:
|
|
PAS_ON_OFF_ALL | On or Off or All Flag | Reserved for future use. Flag used to identify an "on" or "off" or "all" status. This profile option is used specifically for flags within several pages in OPSM. |
|
PAS_PRIMARY_NONPRIMARY | Primary Identifiers Only | Indicates whether to display primary identifiers only. | 1, Yes, Yes |
PAS_PRODUCT_SYNCH_ACTIONS | Actions for Product Synch | Actions for Product Synchronization. |
|
PAS_PRODUCT_UNIT_ID_FORMULA | Product Unit ID Formula | Identifies the structure of the Product Unit Identifier. |
|
PAS_QUANTITY_OR_RANGE | Quantity or Range | The method used for requesting serials on the serial generation request. |
|
PAS_RANGE_LEVEL_CONTROL | Range Level Control | The serial range control level. |
|
PAS_RULES_TRANS_TYPE | Destination Rules Transaction Type | Transaction Types for transmission of serials to a destination. |
|
PAS_SERIAL_CONTAINER | Include Containers/Product Serials | Indicates whether to display containers, product serials or both. |
|
PAS_SERIAL_CONTROL | Serial Control | Indicates how serials can be created. |
|
PAS_SERIAL_INCREASE_TYPE | Serial Increase Type | The type of serial increase used when supporting an overage of serials during generation. |
|
PAS_SERIAL_STATE | Serial State | The current state of the serialized item. |
|
PAS_SERIAL_STATUS | Serial Status | The status of the serialized item. |
|
PAS_SIGNED_DOCUMENT_STATUS | Signed Document Status | Identifies signed and unsigned pedigree documents |
|
PAS_SOURCE_SYSTEM_PRECEDENCE | Source System Precedence | Indicates whether the Product or Product Detail information can be changed by any source system or only the owning source system. |
|
PAS_TIME_PERIODS | Dashboard Time Periods | Time periods, specified in days, for filtering information displayed in the dashboard components |
|
PAS_TRANSACTION_EXCEPTION | Transaction Exception | Indicates if an exception exists against the transaction. |
|
PAS_TRANSACTION_STATUS | Transaction Status | The status of the transaction in the OPSM system. (e.g. Pending, Confirmed, etc.) |
|
PAS_TRANSACTION_TYPE | Serial Transaction Type | The type of transaction performed against the serialized item. |
|
PAS_UNIQUE_SERIAL_METHOD | Unique Serial Number Method | The method the system uses to determine the unique serial number. |
|
PAS_WEB_SERVICES | Web Services for Exception Handling Review | Web Services for Exception Handling Review |
|
PAS_WO_SERIALIZATION_ACTIONS | Actions for Work Order Serialization | Actions for Work Order Serialization. |
|
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.