Skip Headers

Oracle Pedigree and Serialization Manager Process Guide
Release 1.2
Part Number E36379-01		Go to Table of Contents
Contents 		Go to previous page
Previous 		Go to next page
Next

Lookup Types and Codes

This appendix covers the following topics:

Lookup Types and Codes

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.

OPSM Lookup Types and Codes - User Defined Access Level
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.

  • EPCIS, EPCIS Destinations, Destination Group containing one or more EPCIS destinations

  • NON_EPCIC, Non-EPCIS Destinations, Destination Group containing one or more Non-EPCIS destinations

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:

  • EBS_LOT_SYNC_DISCRETE_FULL, EBS Discrete Full, EBS Discrete Full Load

  • EBS_LOT_SYNC_DISCRETE_INCR, EBS Discrete Incremental, EBS Discrete Incremental Load

  • EBS_LOT_SYNC_PROCESS_R11_FULL, EBS R11 Process Full, EBS R11 Process Full Load

  • EBS_LOT_SYNC_PROCESS_R11_INCR, EBS R11 Process Incremental, EBS R11 Process Incremental Load

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:

  • EBS_PROD_SYNC_FULL, EBS Full, EBS Product Full Load

  • EBS_PROD_SYNC_INCR, EBS Incremental, EBS Product Incremental Load

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.

  • EBIZ_01, EBIZ_01, Oracle E-Business Suite

  • OPSM, OPSM, OPSM

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:

  • EBS_WO_SERIAL_DISCRETE_FULL, EBS Discrete Full, EBS Discrete Full Load

  • EBS_WO_SERIAL_DISCRETE_INCR, EBS Discrete Incremental, EBS Discrete Incremental Load

  • EBS_WO_SERIAL_PROCESS_FULL, EBS Process Full, EBS Process Full Load

  • EBS_WO_SERIAL_PROCESS_INCR, EBS Process Incremental, EBS Process Incremental Load

OPSM Lookup Types and Codes - Extensible Access Level
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.

  • SGTIN-198, SGTIN-198, SGTIN-198

  • SGTIN-96, SGTIN-96, SGTIN-96

  • USN-1, USN-1, USN-1

PAS_PRODUCT_CODE_TYPE Product Code Type The type of product code (e.g. GTIN, NDC442, NDC542, etc).

  • GTIN, GTIN, Global Trade Identification Number

  • NDC442, NDC442, National Drug Code using the 4-4-2 configuration.

  • NDC532, NDC532, National Drug Code using the 5-3-2 configuration.

  • NDC541, NDC541, National Drug Code using the 5-4-1 configuration.

  • NDC542, NDC542, National Drug Code using the 5-4-2 configuration.

PAS_REASON_CODE Reason Code The reason code identifying why the serial was decommissioned.

  • VOIDED, Voided, Serial was voided

PAS_SERIAL_TYPE Serial Type The format of the serial number (e.g. SGTIN-96, etc.).

  • SGTIN-198, SGTIN-198, SGTIN-198

  • SGTIN-96, SGTIN-96, SGTIN-96

  • USN-1, UNIQUE SERIAL NUMBER, UNIQUE SERIAL NUMBER

PAS_SERIAL_TYPE_GROUP Serial Type Group Identifies a serial group which is used to group like serial types for management of serial ranges.

  • SGTIN, SGTIN, SGTIN

  • USN, USN, UNIQUE SERIAL NUMBER

OPSM Lookup Types and Codes - System Access Level
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.).

  • DESTINATION, Destination Address, Destination Address

  • SOURCE, Source Address, Source Address

PAS_ADDRESS_TYPE Address Type The type of address (i.e. shipping, business, etc.).

  • BUSINESS, Business Address, Business Address

  • SHIPPING, Shipping Address, Shipping Address

PAS_COMPOSITE_ALERT_CONTROL Composite Alert Control Reserved for future use.
Indicates when e-mail alerts are sent during the SOA Composite fault processing.

  • BOTH, Send E-mail for Business Process and Composite Faults, Provide an e-mail alert whenever the business process or the SOA composite has failed

  • BUSINESS_PROCESS, Send E-mail for Business Process Faults, Provide an e-mail alert whenever the business process being performed within a SOA composite has failed

  • COMPOSITE, Send E-mail for Composite Faults, Provide an e-mail alert whenever the SOA composite has failed. This can occur if services used by the composite are down, the database is down, etc.

PAS_COUNTERFEIT_STATUS Counterfeit Status
The status of the serial with regards to counterfeiting.

  • COUNTERFEIT, Counterfeit, Counterfeit

  • NOTCOUNTERFEIT, Verified Not Counterfeit, Verified Not Counterfeit

  • SUSPECT, Suspect Counterfeit, Suspect Counterfeit

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.

  • 0, No, Yes/No

  • 1, Yes, Yes/No

PAS_EPC_CODE_TYPES Code Type EPCIS Code Type

  • 0, parentID, Allow all EPC Codes in parentID tag

  • 1, epcList, Allow all EPC Codes in epcList tag

  • 100, noepc, Allow all entries without EPC codes

  • 2, childEPCs, Allow all EPC Codes in childEPCs tag

  • 3, epcClass, Allow all EPC Codes in epcClass tag

PAS_EPC_EVENT_TYPES Event Type EPCIS Event Type

  • 0, ObjectEvent, Captures event information pertaining to one or more physical objects identified by EPCs

  • 1, AggregationEvent, Captures the event details for objects that have been physically aggregated to one another

  • 100, Unknown, Unknown

  • 2, QuantityEvent, Captures event details regarding a specified quantity of an object class

  • 3, TransactionEvent, Captures event details where there is an association or disassociation of physical objects to one or more business transactions

PAS_EPC_PURE_TYPES Pure Type EPCIS Pure Type

  • 0, GID, General Identifier [urn:epc:id:gid:GeneralManagerNumber.ObjectClass.SerialNumber]

  • 1, SGTIN, General Identifier [urn:epc:id:sgtin:CompanyPrefix.ItemReference.SerialNumber]

  • 2, SSCC, General Identifier [urn:epc:id:sscc:CompanyPrefix.SerialReference]

  • 3, SGLN, General Identifier [urn:epc:id:sgln:CompanyPrefix.LocationReference.ExtensionComponent]

  • 4, GRAI, General Identifier [urn:epc:id:grai:CompanyPrefix.AssetType.SerialNumber]

  • 5, GIAI, General Identifier [urn:epc:id:giai:CompanyPrefix.IndividualAssetReference]

  • 6, GSRN, General Identifier [urn:epc:id:giai:CompanyPrefix.ServiceReference]

  • 7, GDTI, General Identifier [urn:epc:id:giai:CompanyPrefix.DocumentType.SerialNumber]

PAS_EPC_SGTIN-96_FILTER EPC SGTIN-96 Filter Value EPC SGTIN-96 Filter used during generation of EPC Serial Numbers.

  • 0, All Others, All Others

  • 1, Point of Sale (POS) Trade Item, Point of Sale (POS) Trade Item

  • 2, Full Case for Transport, Full Case for Transport

  • 3, Reserved, Reserved

  • 4, Inner Pack Trade Item Grouping for Handling, Inner Pack Trade Item Grouping for Handling

  • 5, Reserved, Reserved

  • 6, Unit Load, Unit Load

  • 7, Unit not intended for individual sale, Unit inside Trade Item or component inside a product not intended for individual sale

PAS_ERROR_STATUS Transaction Error Status Transaction Error Status

  • CLEARED, Cleared, Cleared

  • DETECTED, Detected, Detected

PAS_GENERATION_STATUS Generation Status Status of the serial generation request.

  • ERRORS, Error(s) Exist, Error(s) exist for serial generation request

  • INPROGRESS, In Progress, Serial generation request is in progress

  • REQUESTED, Generation Requested, Serial generation request is waiting to be processed

  • SUBMITTED, Generation Submitted, Serial generation request is submitted to be processed

  • SUCCESS, Successful Generation, Serial generation request completed successfully

  • SYNC_REQ_SUBMITTED, Synchronous Request Submitted, Synchronous serial generation request is submitted to be processed

  • TERMINATED, Abnormal Termination, Serial generation request has abnormally terminated

  • WARNINGS, Warning(s) Exist, Warning(s) exist for serial generation request

PAS_GEN_REQUEST_METHOD Generation Request Method The method used to create the Serial Generation Request.

  • SERIALGENERATIONREQUESTUI, User Interface, Serial Generation Request User Interface

  • WEBSERVICEREQUEST, Web Service Request, Web Service Request

  • WORKORDERIMPORT, Work Order Import, Work Order Import

PAS_INITIATING_OPERATION Initiating Operation The operation that initiated the transaction.

  • UPDATEDOC, Serial Update by Primary Document, Serial Update by Primary Document,

  • UPDATELABEL, Serial Update by Label, Serial Update by Label

  • UPDATELIST, Serial Update by List, Serial Update by List

PAS_JOB_STATUS Job Status The status of the Job.

  • COMPLETE, Complete, Job was completed

  • ERRORS, Error(s) Exist, Error(s) exist for job processed

  • INPROGRESS, In Progress, Job is in processing

  • SUBMITTED, Submitted, Job was submitted

  • TERMINATED, Abnormal Termination, Job has abnormally terminated

  • WARNINGS, Warning(s) Exist, Warning(s) exist for job processed

PAS_JOB_TYPE Job Type Job Type

  • LOTSYNCH, Lot Synchronization, Lot Synchronization

  • PRODUCTSYNCH, Product Synchronization, Product Synchronization

  • WEBSERVICES, Web Service Exceptions, Web Service Exceptions

  • WOSERIALREQUEST, Work Order Serialization, Work Order Serialization,

PAS_LOT_SYNCH_ACTIONS Actions for Lot Synchronization Actions for Lot Synchronization (Extract, Merge, etc.)

  • EXTRACT, Extract Lots, Extract, Lots

  • EXTRACTANDMERGE, Extract Lots and Merge Lots, Extract Lots and Merge Lots from Lot Interface table

  • MERGE, Merge Lots, Merge Lots from Lot Interface table

PAS_METHOD_OF_COMM Method of Communication The method of communicating the serialized items (e.g. Web service, File exchange, etc.).

  • FILEEXCHANGE, File Exchange, Exported/Imported using a File

  • WEBSERVICE, Web Service, Transmitted using Web Service

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:

  • Require Product for Generation check box on the Create Location and Edit Location pages.

  • Controlled Substance, Record Internal Shipments, and Record Internal Returns check boxes on the Create Product and Edit Product pages.

  • 0, Off, Off

  • 1, On, On

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.

  • ALL, All, All

  • OFF, Off, Off

  • ON, On, On

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.

  • EXTRACT, Extract Items, Extract Items

  • EXTRACTANDMERGE, Extract Items and Merge Product and Item Cross Reference, Extract Items and Merge Product and Item Cross Reference

  • MERGE, Merge Product and Item Cross Reference, Merge Product and Item Cross Reference

PAS_PRODUCT_UNIT_ID_FORMULA Product Unit ID Formula Identifies the structure of the Product Unit Identifier.

  • EPCNUMBER, EPC Number, EPC Number

  • PRODUCT, Product Code + Product Code Type + Product Code Variant, Product Code + Product Code Type + Product Code Variant

  • PRODUCTPKGUNIT, Product Code + Product Code Type + Product Code Variant + Packaging Unit, Product Code + Product Code Type + Product Code Variant + Packaging Unit

PAS_QUANTITY_OR_RANGE Quantity or Range The method used for requesting serials on the serial generation request.

  • QUANTITY, Quantity, Quantity

  • SERIALNUMBERRANGE, Serial Number Range, Serial Number Range

PAS_RANGE_LEVEL_CONTROL Range Level Control The serial range control level.

  • LOCATION, Location Level, Location Level

  • LOCATIONPRODUCT, Location and Product Level, Location and Product Level

  • NORANGE, No Range, No Range

PAS_RULES_TRANS_TYPE Destination Rules Transaction Type Transaction Types for transmission of serials to a destination.

  • GENERATE, Serial Generation, Serial Generation

  • IMPORT, Import Serials, Import Serials

  • RETURN, Return, Return

  • SHIPMENT, Shipment, Shipment

PAS_SERIAL_CONTAINER Include Containers/Product Serials Indicates whether to display containers, product serials or both.

  • 0, Containers, Containers

  • 1, Product Serials, Product Serials

PAS_SERIAL_CONTROL Serial Control Indicates how serials can be created.

  • EXTERNALLYGENERATED, Externally Generated, Externally Generated

  • OPSMSERIALIZED, OPSM Serialized, OPSM Serialized

PAS_SERIAL_INCREASE_TYPE Serial Increase Type The type of serial increase used when supporting an overage of serials during generation.

  • PERCENT, Percent, Percent

  • QUANTITY, Quantity, Quantity

PAS_SERIAL_STATE Serial State The current state of the serialized item.

  • RETURNED, Returned, Returned

  • SHIPPED, Shipped, Shipped

PAS_SERIAL_STATUS Serial Status The status of the serialized item.

  • COMMISSIONED, Commissioned, The serialized item is currently commissioned

  • DECOMMISSIONED, Decommissioned, The serialized item is currently decommissioned

  • RESERVED, Reserved, The serialized item is currently reserved

PAS_SIGNED_DOCUMENT_STATUS Signed Document Status Identifies signed and unsigned pedigree documents

  • 0, Pending Signature, Unsigned pedigree documents

  • 1, Signed Documents, Signed 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.

  • ALL, Any Source System, Any source systems can update the product or product detail information.

  • OWNING, Owning Source System, Only the owning source system can update the product or product detail information.

PAS_TIME_PERIODS Dashboard Time Periods Time periods, specified in days, for filtering information displayed in the dashboard components

  • LAST30DAYS, Last 30 Days, Display activity on the dashboard that has occurred within the past 30 days

  • LAST365DAYS, Last 365 Days, Display activity on the dashboard that has occurred within the past 365 days

  • LAST60DAYS, Last 60 Days, Display activity on the dashboard that has occurred within the past 60 days

  • LAST7DAYS, Last 7 Days, Display activity on the dashboard that has occurred within the past 7 days

  • LAST90DAYS, Last 90 Days, Display activity on the dashboard that has occurred within the past 90 days

PAS_TRANSACTION_EXCEPTION Transaction Exception Indicates if an exception exists against the transaction.

  • ERRORS, Errors, Errors

  • NOEXCEPTION, No Exceptions, No Exceptions

  • WARNINGS, Warnings, Warnings

PAS_TRANSACTION_STATUS Transaction Status The status of the transaction in the OPSM system. (e.g. Pending, Confirmed, etc.)

  • DISREGARD, Disregarded, Disregarded

  • INPROGRESS, In Progress, In Progress

  • PENDING, Pending, Pending

  • PROCESSED, Processed, Processed

  • SUBMITTED, Submitted, Submitted

PAS_TRANSACTION_TYPE Serial Transaction Type The type of transaction performed against the serialized item.

  • COMMISSION, Commission Serials, Commission Serials

  • DECOMMISSION, Decommission Serials, Decommission Serials

  • GENERATE, Serial Generation, Serial Generation

  • IMPORT, Import Serials, Import Serials

  • RESERVE, Reserve Serials, Reserve Serials

  • RETURN, Return, Return

  • SERIALEDIT, Edit Serials, Edit Serials

  • SHIPMENT, Shipment, Shipment

  • TRANSMIT, Serial Transmission, Serial Transmission

PAS_UNIQUE_SERIAL_METHOD Unique Serial Number Method The method the system uses to determine the unique serial number.

  • NEXTNUMBER, Use Next Number, Use the next available number

  • RANDOM, Use Random Number, Use a generated random number

PAS_WEB_SERVICES Web Services for Exception Handling Review Web Services for Exception Handling Review

  • CAPTUREEPCISDOC, captureEpcisDoc, captureEpcisDoc Web Service

  • CREATETRANSACTION, createTransaction, createTransaction Web Service

  • EDITSERIALDOC, Edit Serial by Primary Document Web Service, Edit Serial by Primary Document Web Service

  • EDITSERIALLABEL, Edit Serial by Label Web Service, Edit Serial by Label Web Service

  • EDITSERIALLIST, Edit Serial by List Web Service, Edit Serial by List Web Service

  • HTTPPOST, HTTPPost, HTTPPost EPCIS Capture Service

  • MERGELOT, mergeLot, mergeLot Web Service

PAS_WO_SERIALIZATION_ACTIONS Actions for Work Order Serialization Actions for Work Order Serialization.

  • EXTRACT, Extract Work Orders, Extract Work Orders

  • EXTRACTANDPROCESS, Extract Work Orders and process Work Order Serialization, Extract Work Orders and process Work Order Serialization

  • PROCESS, Process Work Order Serialization, Process Work Order Serialization

Contents   |   Previous   |   Top of Page   |   Next

Oracle Logo
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.