Pedigree Serial (OPSM) Error: ORA-01001: Invalid Cursor On VALIDATE_SERIALS_SHIPMENT (Doc ID 2201382.1)

Last updated on NOVEMBER 07, 2016

Applies to:

Oracle Pedigree and Serialization Manager - Version 1.2.0.18.0 and later
Information in this document applies to any platform.
Pedigree Serial (OPSM) Error: ORA-01001: Invalid Cursor On VALIDATE_SERIALS_SHIPMENT:

Symptoms

Oracle Pedigree Serialization Management (OPSM) raises an error when we try to import some shipments in OPSM database.

What is working
This worked fine on OPSM 1.2.0.17 but not on OPSM 1.2.0.18.

Error


Steps
1. Import a 1st batch of serials in OPSM on : LocationCreation 1 | Product 1 | Lot 1 | serial #1 to #100

2. Import a 2nd batch of serials in OPSM on : LocationCreation 1 | Product 2 | Lot 1 | serial #1 to #100

* Note: Only products are different. Serials, location and lot numbers are the same.

3. Ship Product 1 | Lot 1 | serial #1 to #100 to another location

4. The error is raised.

-or-

Same issue with another business case :

1. Import a 1st batch of serials in OPSM on : LocationCreation A | Product A | Lot A | serial #1 to #100

2. Import a 2nd batch of serials in OPSM on : LocationCreation A | Product B | Lot B | serial #1 to #100

* Note: Products and Lots are different. Serials and location are the same

3. Ship Product A | Lot A | serial #1 to #100 to another location

4. The error is raised.

Changes

Upgrade from OPSM 1.2.0.17 to OPSM 1.2.0.18.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms