My Oracle Support Banner

When Running the Packing Slip Report (INS6500) on a SQL Server Database the Report Abends With an Error [Microsoft] SQL Server Native Client 11.0 [SQL Server] Invalid Object Name ‘ps_LOT_CONTROL_INV’ (Doc ID 2982615.1)

Last updated on NOVEMBER 24, 2023

Applies to:

PeopleSoft Enterprise SCM Inventory - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.


When running the Packing Slip report on a SQL Server database, it is abending with the an Invalid Object Name error.

The issue can be reproduced at will with the following steps:
1. Navigate to Packing Slip Report (Inventory-->FulFill Stock Orders-->Shipping Reports-->Packing Slip)
2. Enter Criteria. Make sure to select the Print Lot Information flag.
3. Click Run
4. From within the Packing Slip Run Control click on Process Monitor
5. Process goes to No Success.
6. Click on Details
7. Click on the link INS6500_<process instance #>.out
8. Get the below error.

(SQR 5528) ODBC SQL dbdesc: SQLNumResultCols error 208 in cursor 57:
   [Microsoft] SQL Server Native Client 11.0 [SQL Server] Invalid object name 'ps_LOT_CONTROL_INV'
(SQR 5528) ODBC SQL dbdesc: SQLNumResultCols error 11529 in cursor 57:
   [Microsoft] [SQL Server Native Client 11.0][SQL Server]The metadata could not be determined because every code path results in an error; see previous errors for some of these.

Error on line 4037:
   (SQR 3716) Error in SQL statement.

Errors were found in the program file.




To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.