Maintaining Lots

This chapter covers the following topics:

Understanding the Lot Definition Process

Lot information is essential when managing and tracking serial data. The lot number is uniquely identified by the Lot Number, Source System, Location (optional), Product Code, Product Code Type, Product Code Variant, and Packaging Unit. The lot must be identified on a serial when it is commissioned, shipped, received, or returned.

Lot information is essential when managing and tracking serial data. The lot number is uniquely identified by the Lot Number, Source System, Location (optional), Product Code, Product Code Type, Product Code Variant, and Packaging Unit. The lot must be identified on a serial when it is commissioned, shipped, or returned. A valid lot expiration date is required for shipment and return of the serials.

Oracle Pedigree and Serialization Manager (OPSM) stores duplicate lots, where a separate lot definition is kept for each location and source system. The identification of the location on the lot is optional. When the lot is not identified, a duplicate lot will be stored for each source system interfacing with OPSM. When a transaction is recorded in OPSM, the source system and location identified on the transaction is used to retrieve the appropriate lot information.

OPSM also gives you the option to secure lot information based on the lot locations attached to the lots. If you choose to use location security, the Maintain Lots, Create Lot, Edit Lot, and View Lot pages are secured based on the locations attached to the lots that you are authorized for in the Location Security Setup page. When searching for and viewing lots, you will only be able to search for lots and view lot information associated to the lot locations you have at a minimum read access to in the Location Security Setup page. When creating lots or editing lots, you will only be able to create lots or edit lots associated to the locations that you have update access to in the Location Security Setup page and you will only be able to select product codes associated to the product detail locations or location groups you have update access to in the Location Security Setup page. When deleting lots, you will only be able to delete lots associated to the locations that you have delete access to in the Location Security Setup page. If you are using location security and create a lot without a location, the only user who will be able to search for and maintain that lot in the future is a super user (a user that has been defined with all of the OPSM roles and has access to the Maintain Users page in OPSM).

For more information on location security, see Location Security Overview.

Lot information can be created in OPSM using one of these methods:

OPSM Integration with Oracle E-Business Suite

The Oracle Serialization and Tracking Integration Pack for Oracle Pedigree and Serialization Manager and Oracle E-Business Suite 3.1 can be used to synchronize lot information from Oracle E-Business Suite to OPSM using one of the following methods:

Searching for Lots

Use the Maintain Lots page in Oracle Pedigree and Serialization Manager (OPSM) to search for existing lots. You can view the lots in a multitude of ways by using the search criteria fields that include, lot number, parent lot, location, item number, product code, product name, packaging unit, lot source, origination date, and expiration date.

Plus, using the advanced search functionality you can search for a range of lots by using the operator field (equal to, contains, ends with, starts with, and so on) associated with the search criteria fields.

If you are using location security, you will only be able to search for lots associated to the lot locations you have at a minimum read access to in the Location Security Setup page. Lots that were defined without locations can only be accessed by a super user.

For more information on location security, see Location Security Overview.

Use these procedures to search for lots:

Prerequisites

To Search for Lots (Basic Search)

  1. Navigate to the Maintain Lots page.

    Maintain Lots page (Basic Search)

    the picture is described in the document text

  2. In the Search: Lots region, enter the search criteria for the lots using one or more of these fields:

    Field Name Description
    Lot Number Enter the lot number.
    Partial lot numbers can be entered. If you enter a partial lot number the system will display all the lots that start with that partial lot number in the Search Results region.
    If you are using location security, you will only be able to search for lot numbers that are associated to locations that you have at a minimum read access to in the Location Security Setup page.
    For more information on location security, see Location Security Overview.
    Parent Lot Enter the parent lot associated with the lot number.
    Location Select the location associated with the lot number.
    If you are using location security, you will only be able select locations that you have at a minimum read access to in the Location Security Setup page.
    For more information on location security, see Location Security Overview.
    Product Code Select the product code associated with the lot number.

    Maintain Lots page (Basic Search)

    the picture is described in the document text

  3. (Optional) In the Search: Lots region, further specify the lots search criteria by entering one or more of these fields:

    Field Name Description
    Item Number Select the item number for the lot.
    This is the transactional systems item number. It is used to find the Product Code to perform the search. The item number search is merely a way for you to search for the correct product code. When you select the Item Number, the Product Code and Product Name fields are automatically populated. If you clear the Item Number, then the Product Code and Product Name fields get cleared as well. You cannot enter both the Item Number and the product fields (Product Code and Product Name) on the search.
    Product Name Enter the product name associated with the product.
    Packaging Unit Select the packaging unit associated with the product.
    Lot Source Select the source for the lot.
    Origination Date Select the origination date for the lot.
    Expiration Date Select the expiration date for the lot.

  4. Click the Search button.

    Maintain Lots page (Basic Search)

    the picture is described in the document text

    All of the lots that match the search criteria appear in the Search Results: Lots region in a table format. An Actions column appears in the table at the end of the row with an Edit Lot icon and a Delete Lot icon.

    If you are using location security, all of the lots with a lot location that you have at a minimum read access to in the Location Security Setup page will display. The Edit Lot icon and Delete Lot icon in the actions column will be available if you have update and delete access to the lot location associated to the lot in the Location Security Setup page. Otherwise, the icons will not be available. In addition, the Edit and Delete options in the Actions menu are available if you have update and delete access to the lot location in the Location Security Setup page.

    For more information on location security, see Location Security Overview.

  5. Click the Advanced button to perform an advanced search.

To Search for Lots (Advanced Search)

Use the Advanced Search functionality to perform a more detailed search for specific lots. Field operators associated with the search criteria fields can be used during an Advanced Search so that a range of lots can be easily retrieved.

  1. Navigate to the Maintain Lots page.

  2. Click the Advanced button located at the top of the page.

    Note: Clicking the Advanced or Basic button will keep the values in the base criteria fields.

    Maintain Lots page (Advanced Search)

    the picture is described in the document text

  3. In the Search: Lots region, enter the search criteria for the lots using one or more of these fields:

    Field Name Description
    Lot Number Select the field operator and then enter the lot number. Operators are:

    • Not equal to

    • Not between

    • Contains

    • Is not blank

    • Equal to

    • Less than

    • Greater than

    • Is blank

    • Less than or equal to

    • Greater than or equal to

    • Does not contain

    • Starts with

    • Ends with

    • Between


    If you are using location security, you will only be able to search for lot numbers that are associated to locations that you have at a minimum read access to in the Location Security Setup page.
    For more information on location security, see Location Security Overview.
    Parent Lot Select the field operator and then enter the parent lot associated with the lot number.
    The field operators are the same as that for the Lot Number field.
    Location Select the field operator and then select the location associated with the lot number.
    The field operators are the same as that for the Lot Number field.
    If you are using location security, you will only be able select locations that you have at a minimum read access to in the Location Security Setup page.
    For more information on location security, see Location Security Overview.
    Product Code Select the field operator and then select the product code associated with the lot number.
    The field operators are the same as that for the Lot Number field.

  4. (Optional) In the Search: Lots region, further specify the lots search criteria by entering one or more of these fields:

    Field Name Description
    Item Number Select the field operator and then select the item number for the lot.
    This is the transactional systems item number. It is used to find the Product Code to perform the search. The item number search is merely a way for you to search for the correct product code. When you select the Item Number, the Product Code, Product Name, Product Code Type and Product Code Variant fields are automatically populated. If you clear the item number, then the Product Code, Product Name, Product Code Type, and Product Code Variant fields get cleared as well. You cannot enter both the item number and the product fields (Product Code, Product Name, Product Code Type and Product Code Variant) on the search.
    The field operators are the same as that for the Lot Number field.
    Product Name Select the field operator and then enter the product name associated with the product.
    The field operators are the same as that for the Lot Number field.
    Product Code Type Select the field operator and then select the product code type associated with the product.
    The field operators are the same as that for the Lot Number field.
    Product Code Variant Select the field operator and then enter the product code variant associated with product.
    The field operators are the same as that for the Lot Number field.
    Packaging Unit Select the field operator and then select the packaging unit associated with the product.
    The field operators are the same as that for the Lot Number field.
    Lot Source Select the field operator and then select the source for the lot.
    The field operators are the same as that for the Lot Number field.
    Origination Date Select the field operator and then select the origination date for the lot. Operators are:

    • Not equal to

    • Is blank

    • On or After

    • Before

    • Not between

    • Is not blank

    • On or Before

    • After

    • Between

    • Equal to

    Expiration Date Select the field operator and then select the expiration date for the lot.
    The field operators are the same as that for the Origination Date field.

  5. (Optional) To enter additional search criteria fields, click the Add Fields button and select the field you would like to add to the search criteria.

    The selected field appears as a search criteria field.

    Note: To remove the additional field, click the Remove icon next to the field. The field will be removed from the search criteria.

  6. (Optional) Enter search criteria for the additional fields.

  7. Click the Search button.

    Maintain Lots page (Advanced Search)

    the picture is described in the document text

    All of the lots that match the search criteria appear in the Search Results: Lots region in a table format. An Actions column appears in the table with an Edit Lot icon and a Delete Lot icon.

    If you are using location security, all of the lots with a lot location that you have at a minimum read access to in the Location Security Setup page will display. The Edit Lot icon and Delete Lot icon in the actions column will be available if you have update and delete access to the lot location associated to the lot in the Location Security Setup page. Otherwise, the icons will not be available. In addition, the Edit and Delete options in the Actions menu are also available if you have update and delete access to the lot location in the Location Security Setup page.

  8. Click the Basic button to have the page hide the advanced search criteria fields and re-display the basic search criteria fields.

    Note: Clicking the Reset button clears the values in all of the criteria fields.

Viewing Lot Detail Information

Use the View Lot page in Oracle Pedigree and Serialization Manager (OPSM) to view all the detail information for the lot.

If you are using location security, you will only be able to view lot detail information for lots associated to the lot locations that you have at a minimum read access to in the Location Security Setup page.

For more information on location security, see Location Security Overview.

Use this procedure to view lot detail information:

Prerequisites

To View Lot Detail Information

  1. Navigate to the Maintain Lots page.

  2. Enter search criteria for the lots you want to view and click the Search button.

    If you are using location security, you will only be able to search for and view lots associated to the lot locations you have at a minimum read access to in the Location Security Setup page.

    For more information on location security, see Location Security Overview.

    All of the lots that match the search criteria appear in the Search Results: Lots table in a table format.

  3. Select the lot in the table that you want to view.

  4. Click the Lot Number link.

    View Lot page

    the picture is described in the document text

    The View Lot page appears.

  5. Select the different sub tabs (Lot Details and User Defined Fields) to the view that particular type of information for the lot.

  6. Click the Cancel button to return back to the Maintain Lots page.

Creating Lots

Use the Create Lot page in Oracle Pedigree and Serialization Manager (OPSM) to create lots. Lots can also be created through lot synchronization from the transactional system or through Lot Web Services.

If you are using location security, you can create a lot if you have functional access to the Create Lot page but you can only associate it to a location that you have update access to in the Location Security Setup page. In addition, the product codes you can select to associate to the lots are based on product detail locations or location groups that you have update access to in the Location Security Setup page.

For more information on location security, see Location Security Overview.

Use this procedure to create lots:

Prerequisites

To Create Lots

  1. Navigate to the Maintain Lots page.

  2. Select Create from the Actions menu or click the Create icon located at the top of the Search Results: Lots region.

    Create Lot page

    the picture is described in the document text

    The Create Lot page appears.

  3. Enter the following information:

    Field Name Description
    Lot Number Enter the lot number.
    Location (Optional) Select the location for the lot.
    If you are using location security, you will only be able to select locations that you have update access to in the Location Security Setup page.
    If you are using location security, and define a lot without a location only a super user will be able to access that lot.
    For more information on location security, see Location Security Overview.
    Lot Source Select the transactional system that was the source for the lot.
    Lot source appears by default from the location if location is entered for the lot and cannot be changed. If no location is entered for the lot, you can select a lot source from the drop down list.
    Product Code Select the product code for the lot.
    After you select the product code the system displays by default the product code type, product code variant, product name, and packaging unit associated with the product code.
    If you are using location security, you will only be able to select product codes that are associated to product detail locations or location groups that you have update access to in the Location Security Setup page.
    For more information on location security, see Location Security Overview.
    Product Name The product name appears by default from the product code you select.
    Product Code Type The product code type appears by default from the product code you select.
    Product Code Variant The product code variant appears by default from the product code you select.
    Packaging Unit The packaging unit appears by default from the product code you select.
    Parent Lot (Optional) Enter the parent lot for the lot.
    Origination Date (Optional) Select the date the lot originated.
    Origination Date must be earlier than Sell By Date, Best By Date, and Expiration Date.
    Expiration Date (Optional) Select the date the lot will expire.
    Expiration Date must be the same as or later than Sell By Date and Best By Date.
    Best By Date (Optional) Select the best by date for the lot.
    Sell By Date (Optional) Select the sell by date for the lot.
    Retest Date (Optional) Select the retest date for the lot.

    Create Lot page - Lot Details tab

    the picture is described in the document text

  4. Select the User Defined Fields tab.

  5. Enter user-defined data using any of the fields in the Character, Numeric, and Date/Time regions of the page.

    Create Lot page - User Defined Fields tab

    the picture is described in the document text

  6. Save your work. Choose one of these options:

    • Click the Save and Close button to save this lot and return back to the Maintain Lots page.

    • Click Save and Create Another button to save this lot and to stay on this page so you can create another lot. The system displays a message that the lot was saved successfully and it clears all of the values in the fields.

    Note: You can also create duplicate lots. The system will issue a warning to the user that a duplicate lot will be created. Duplicate lots allow the definition of one or more lots with the same lot number and product detail record but for a different location.

Editing Lots

Use the Edit Lot page in Oracle Pedigree and Serialization Manager (OPSM) to edit lot information for a lot.

If you are using location security, you will only be able to edit lots associated to the lot locations you have update access to in the Location Security Setup page.

For more information on location security, see Location Security Overview.

Use this procedure to edit lots:

Prerequisites

To Edit Lots

  1. Navigate to the Maintain Lots page.

  2. Enter search criteria for the lots you want to edit and click the Search button.

    If you are using location security, you will only be able to edit lots associated to locations that you have update access to in the Location Security Setup page.

    For more information on location security, see Location Security Overview.

    All of the lots that match the search criteria appear in the Search Results: Lots table in a table format.

  3. Select the lot in the table that you want to edit.

  4. Select Edit in the Actions menu or click the Edit Lot icon associated with the lot in the Actions column of the results table.

    If you are using location security, the Edit Lot icon and Edit option in the Actions menu are only available if you have update access to the location associated to the lot in the Location Security Setup page.

    For more information on location security, see Location Security Overview.

    Edit Lot page - Lot Details sub tab

    the picture is described in the document text

    The Edit Lot page appears displaying all of the existing information for the lot.

  5. Edit the lot fields.

    You can only edit these fields:

    • Parent Lot

    • Origination Date

      Origination Date must be earlier than Sell By Date, Best By Date, and Expiration Date.

    • Expiration Date

      Expiration Date must be the same as or later than Sell By Date and Best By Date.

    • Best By Date

    • Sell By Date

    • Retest Date

    • User Defined fields using the User Defined Fields sub tab

  6. Click the Save and Close button to save the changes you made to the lot information and to return back to the Maintain Lots page.

    Note: The system will display a warning message if you are editing fields for a lot associated to a serial that has already been shipped.

Deleting Lots

Use the Maintain Lots page in Oracle Pedigree and Serialization Manager (OPSM) to delete lots. You cannot delete a lot if it has been associated to any serials in the system.

If you are using location security, you will only be able to delete lots associated to the lot locations you have delete access to in the Location Security Setup page.

For more information on location security, see Location Security Overview.

Use this procedure to delete lots:

Prerequisites

To Delete Lots

  1. Navigate to the Maintain Lots page.

  2. Enter search criteria for the lots you want to delete and click the Search button.

    If you are using location security, you will only be able to delete lots associated to locations that you have delete access to in the Location Security Setup page.

    For more information on location security, see Location Security Overview.

    All of the lots that match the search criteria appear in the Search Results: Lots table in a table format.

  3. Select the lot in the table that you want to delete.

    Note: You cannot delete a lot if it has been associated to any serials in the system.

  4. Select Delete in the Actions menu or click the Delete Lot icon associated with the lot in the Actions column of the results table.

    If you are using location security, the Delete Lot icon and Delete option in the Actions menu are only available if you have delete access to the location associated to the lot in the Location Security Setup page.

    For more information on location security, see Location Security Overview.

    The system displays a message asking if you are sure to want to delete the lot.

  5. Click the Yes button.

    The lot is deleted from the system.

Synchronizing Lots (Lot Interface Table)

Oracle Pedigree and Serialization Manager (OPSM) provides a Lot Interface table that enables external systems to integrate with OPSM for Lot Synchronization. Synchronization of lot data, including lot expiration dates, is essential for accurate serial data management and tracking.

Using the Lot Synchronization page in OPSM you will initiate a process which will perform one of the following synchronization actions:

For more information on the lot definition process, see Understanding the Lot Definition process.

For more information on defining Lot Synchronization scenarios, see Defining Product Synchronization, Lot Synchronization, and Work Order Serialization Scenarios.

For more information on integrating Oracle E-Business Suite with OPSM, see Oracle Serialization and Tracking Process Integration Pack for Oracle Pedigree and Serialization Manager and Oracle E-Business Suite Guide.

Use these procedures to:

Prerequisites

To Extract and Merge Lot Information from an External System

  1. Navigate to the Lot Synchronization page.

    Lot Synchronization page

    the picture is described in the document text

  2. Click the Submit New Instance button in the upper right hand corner of the Lot Synchronization page.

    Lot Synchronization dialog box

    the picture is described in the document text

    The Lot Synchronization dialog box appears.

  3. Enter the following options for the Lot Synchronization process:

    Field Name Description
    Synchronization Action Select Extract Lots and Merge Lots.
    After you select the Synchronization Action, the Extract Scenario Name, Source System, and Purge Interface Table fields become available.
    Extract Scenario Name Select the extract scenario name.
    Extract Scenario Names are user defined using Lookup Type PAS_LOT_EXTRACT.
    Oracle delivers four lookup codes for Lot Synchronization between OPSM and Oracle E-Business Suite for the PAS_LOT_EXTRACT lookup type. They are:

    • EBS_LOT_SYNC_DISCRETE_FULL (EBS Discrete Full)

    • EBS_LOT_SYNC_DISCRETE_INCR (EBS Discrete Incremental)

    • EBS_LOT_SYNC_PROCESS_R11_FULL (EBS R11 Process Full)

    • EBS_LOT_SYNC_PROCESS_R11_INCR (EBS R11 Process Incremental)

    Source System Select the source system where you are going to synchronize lot information from into OPSM.
    Source Systems are user defined using the Lookup Type PAS_SOURCE_SYSTEM.
    Purge Interface Table check box Select this check box if you want to delete existing records in the interface table for the selected source system.

    Lot Synchronization dialog box

    the picture is described in the document text

  4. Click the OK button to initiate the Lot Synchronization process.

    The Lot Synchronization process runs in the background. The system assigns a job instance Id for that specific run of the process. The Lot Synchronization page reappears.

    The Lot Synchronization (Extract Lots) background process will invoke an Oracle Data Integrator (ODI) application to extract lot information from an external system. The lot information that is extracted from the source system will be uploaded into the target OPSM Lot Interface table (PAS_S_LOT_INTERFACE).

    The Lot Synchronization (Merge Lots) background process takes lot information from the PAS_S_LOT_INTERFACE table and validates and inserts the transformed data into the OPSM lot table (PAS_S_LOTS).

  5. Enter the following information in the Search: Job Instances region of the page:

    Field Name Description
    Job Instance ID (Optional) Enter a specific job instance ID.
    Job Status (Optional) Select the job status for the job instances. Job Statuses are:

    • Complete

    • Error(s) Exist

    • In Progress

    • Submitted

    • Abnormal Termination

    • Warning(s) Exist

    Creation Date Select a creation date for the job instance that is equal to the current date.
    Created By Enter the individual that initiated the process.

  6. Click the Search button.

  7. Locate the job instance Id for the process and verify that the Job Instance Id completed successfully or completed with warnings.

    The Job Status associated with job instance Id is at one of these statuses:

    • Complete: Job instance completed successfully with no errors or warnings.

    • Error(s) Exist: Job instance did not complete successfully.

    • In Progress: Job instance is in progress.

    • Submitted: Job instance has been submitted but not started.

    • Abnormal Termination: The job instance did not complete successfully due to a catastrophic failure (for example, the system went down during processing).

    • Warning(s) Exist: Job completed successfully but there are warning messages.

    Scroll to the Job Instance Messages region and view the following:

    • Informational messages (blue circle with the letter "i"): These messages display the parameters used to initiate the process and the results of the process.

    • Warning messages (A yellow triangle with an exclamation point): These messages display the warning messages for the process.

    You can also verify the results of the Lot Synchronization process (Extract and Merge Lots synchronization action) by navigating to the OPSM Maintain Lots page. The Maintain Lots page will display the lot information that was created in OPSM.

    For more information on the job instances functionality, see Using Job Instances functionality.

    For more information on the Maintaining Lots page, see Viewing Lot Detail Information.

To Extract Lot Information from an External System

  1. Navigate to the Lot Synchronization page.

    Lot Synchronization page

    the picture is described in the document text

  2. Click the Submit New Instance button in the upper right hand corner of the Lot Synchronization page.

    Lot Synchronization dialog box

    the picture is described in the document text

    The Lot Synchronization dialog box appears.

  3. Enter the following options for the Lot Synchronization process:

    Field Name Description
    Synchronization Action Select Extract Lots.
    After you select the Synchronization Action, the Extract Scenario Name, Source System, and Purge Interface Table fields become available.
    Extract Scenario Name Select the extract scenario name.
    Extract Scenario Names are user defined using Lookup Type PAS_LOT_EXTRACT.
    Oracle delivers four lookup codes for Lot Synchronization between OPSM and Oracle E-Business Suite for the PAS_LOT_EXTRACT lookup type. They are:

    • EBS_LOT_SYNC_DISCRETE_FULL (EBS Discrete Full)

    • EBS_LOT_SYNC_DISCRETE_INCR (EBS Discrete Incremental)

    • EBS_LOT_SYNC_PROCESS_R11_FULL (EBS R11 Process Full)

    • EBS_LOT_SYNC_PROCESS_R11_INCR (EBS R11 Process Incremental)

    Source System Select the source system where you are going to synchronize lot information from into OPSM.
    Source Systems are user defined using the Lookup Type PAS_SOURCE_SYSTEM.
    Purge Interface Table check box Select this check box if you want to delete existing records in the interface table for the selected source system.

    Lot Synchronization dialog box

    the picture is described in the document text

  4. Click the OK button to initiate the Lot Synchronization process.

    The Lot Synchronization process runs in the background. The system assigns a job instance Id for that specific run of the process. The Lot Synchronization page reappears.

    The Lot Synchronization (Extract Lots) background process will invoke an Oracle Data Integrator (ODI) application to extract lot information from an external system. The lot information that is extracted from the source system will be uploaded into the target OPSM Lot Interface table (PAS_S_LOT_INTERFACE).

  5. Enter the following information in the Search: Job Instances region of the page:

    Field Name Description
    Job Instance ID (Optional) Enter a specific job instance ID.
    Job Status (Optional) Select the job status for the job instances. Job Statuses are:

    • Complete

    • Error(s) Exist

    • In Progress

    • Submitted

    • Abnormal Termination

    • Warning(s) Exist

    Creation Date Select a creation date for the job instance that is equal to the current date.
    Created By Enter the individual that initiated the process.

  6. Click the Search button.

  7. Locate the job instance Id for the process and verify that the Job Instance Id completed successfully or completed with warnings.

    The Job Status associated with job instance Id is at one of these statuses:

    • Complete: Job instance completed successfully with no errors or warnings.

    • Error(s) Exist: Job instance did not complete successfully.

    • In Progress: Job instance is in progress.

    • Submitted: Job instance has been submitted but not started.

    • Abnormal Termination: The job instance did not complete successfully due to a catastrophic failure (for example, the system went down during processing).

    • Warning(s) Exist: Job completed successfully but there are warning messages.

    Scroll to the Job Instance Messages region and view the following:

    • Informational messages (blue circle with the letter "i"): These messages display the parameters used to initiate the process and the results of the process.

    • Warning messages (A yellow triangle with an exclamation point): These messages display the warning messages for the process.

    For more information on the job instances functionality, see Using Job Instances functionality.

To Merge the Extracted Lots into OPSM

  1. Navigate to the Lot Synchronization page.

  2. Click the Submit New Instance button in the upper right hand corner of the Lot Synchronization page.

    The Lot Synchronization dialog box appears.

  3. Enter the following options for the Lot Synchronization process:

    Field Name Description
    Synchronization Action Select Merge Lots.
    After you select the Synchronization Action, the Source System, and Purge Interface Table fields become available.
    Source System Select the source system where you are going to synchronize lot information from into OPSM.
    Source Systems are user defined using the Lookup Type PAS_SOURCE_SYSTEM.
    Purge Interface Table check box Select this check box if you want to delete existing records in the interface table for the selected source system.

    Lot Synchronization dialog box

    the picture is described in the document text

  4. Click the OK button to initiate the Product Synchronization process.

    The Lot Synchronization process runs in the back ground. The system assigns a job instance Id for that specific run of the process. The Lot Synchronization page reappears.

    The Lot Synchronization (Merge Lots) background process takes lot information from the PAS_S_LOT_INTERFACE table and validates and inserts the transformed data into the OPSM Lot table (PAS_S_LOTS).

  5. Enter the following information in the Search: Job Instances region of the page:

    Field Name Description
    Job Instance ID (Optional) Enter a specific job instance ID.
    Job Status (Optional) Select the job status for the job instances. Job Statuses are:

    • Complete

    • Error(s) Exist

    • In Progress

    • Submitted

    • Abnormal Termination

    • Warning(s) Exist

    Creation Date Select a creation date for the job instance that is equal to the current date.
    Created By Enter the individual that initiated the process.

  6. Click the Search button.

  7. Locate the job instance Id for the process and verify that the Job Instance Id completed successfully or completed with warnings.

    The Job Status associated with job instance Id is at one of these statuses:

    • Complete: Job instance completed successfully with no errors or warnings.

    • Error(s) Exist: Job instance did not complete successfully.

    • In Progress: Job instance is in progress.

    • Submitted: Job instance has been submitted but not started.

    • Abnormal Termination: The job instance did not complete successfully due to a catastrophic failure (for example, the system went down during processing).

    • Warning(s) Exist: Job completed successfully but there are warning messages.

    Scroll to the Job Instance Messages region and view the following:

    • Informational messages (blue circle with the letter "i"): These messages display the parameters used to initiate the process and the results of the process.

    • Warning messages (A yellow triangle with an exclamation point): These messages display the warning messages for the process.

    You can also verify the results of the Lot Synchronization process (Merge Lots) by navigating to the OPSM Maintain Lots page. The Maintain Lots page will display the lot information that was created in OPSM.

    For more information on the job instances functionality, see Using Job Instances functionality.

    For more information on the Maintaining Lots page, see Viewing Lot Detail Information.

Merging Lots Using JMS Queue

Oracle Pedigree and Serialization Manager (OPSM) uses a JMS Queue for asynchronous processing of inbound mergeLot messages. When a message is placed into the JMS Queue by the producer, the message is picked up and processed by the OPSM BPEL composite (consumer). The BPEL composite calls the mergeLot Web Service. If the web service call fails or returns an error, a job instance along with a job instance message is created in OPSM. Errors related to mergeLot messages that fail to process successfully can be viewed in the Web Services Exception page.

This diagram illustrates the mergeLot Web Service process flow:

mergeLot Web Service Process Flow

the picture is described in the document text

You will use the Web Service Exceptions page to view exception messages that are generated when messages are processed by the mergeLot, createTransaction, captureEpcisDoc, Edit Serial by Primary Document, Edit Serial by Label, Edit Serial by List, and HTTP Post web services. Exception messages are only created for exceptions or errors that are detected by the web service. If the web service processes successfully during the integration process no message is recorded.

The Web Service Exceptions page is located under the Serials section and the Transactions section of the Task menu. The page is the same in both locations.

Important: If you call the OPSM Web Services directly without using the JMS Queue you are not able to view exception messages using the OPSM Web Service Exceptions page.

Web Service Exceptions Process Flow

An OPSM process continually monitors the integration message queue and then pulls the JMS messages from the queue and dequeues them. It then invokes the appropriate web service. If the web service fails it creates a job instance message. Using the Web Service Exceptions page you can view the job instance messages created by the web service. A web service can fail because the data that is being passed in the message is invalid or the data being passed is incorrect for the message. In addition, you can view the overall system problem errors or web services not running errors using the Web Service Exceptions page.

Use this procedure to view web service exceptions:

Prerequisites

To View Web Service Exceptions

  1. Navigate to the Web Service Exceptions page.

    Web Service Exceptions page

    the picture is described in the document text

    The Web Service Exceptions page appears. You can only view WEBSERVICES job types on this page.

  2. In the Search: Job Instances region, enter the search criteria for the job instances using one or more of these fields:

    Field Name Description
    Job Instance Id (Optional) Enter a specific job instance Id.
    Job Status (Optional) Select the job status for the job instances. Job Statuses are:

    • Complete

    • Error(s) Exist

    • In Progress

    • Submitted

    • Abnormal Termination

    • Warning(s) Exist


    Job statuses are defined using the system Lookup Type PAS_JOB_STATUS.
    Web Service Name (Optional) Select the Web Service name. Web Service names are:

    • captureEpcisDoc

    • createTransaction

    • Edit Serial By Primary Document Web Service

    • Edit Serial By Label Web Service

    • Edit Serial By List Web Service

    • HTTPPost

    • mergeLot


    When merging lots you will want to select mergeLot as the web service name.
    Created By (Optional) Enter the individual that created the job instances (initiated the process).
    Creation Date (Optional) Select the date the job instances were created.

    Otherwise, you can click the Search button without entering any search criteria and all available job instance Ids will appear.

    Web Service Exceptions page

    the picture is described in the document text

    All of the exceptions that match the search criteria appear in the Search Results: Job Instances table of the page.

  3. Select a Job Instance Id that you want to view the messages for in the Search Results: Job Instances table.

    Web Service Exceptions page

    the picture is described in the document text

    The job instance messages for that specific web service job instance appear in the Job Instance Messages region of the page. Three job instance messages appear for each job instance. The messages provide this information:

    • The first job instance message provides details indicating that the web service failed and provides the details (actual fields in the message) where the failure occurred. You can use this information to identify the message to re-send from the transactional system.

    • The second job instance message provides details indicating a partial explanation of the exception that was triggered by the web service. Only a portion of the exception text appears.

    • The third job instance message provides details indicating which composite ID contains more details about the exception. You can view this composite ID within the Oracle Enterprise Manager application to view the entire SOA composite and BPEL flow.

    If the SOA composite produces a fault (runtime fault and so on), the BPEL CatchAll activity grabs the fault and writes a job instance record and corresponding job instance message record. This job instance message provides details indicating which composite ID contains more details about the SOA composite fault. You can view this composite ID within the Oracle Enterprise Manager application to view the entire SOA composite and BPEL flow.

    For more information on the job instances functionality, see Using Job Instances functionality.