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.
Symptoms
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.
[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.
Changes
Cause
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
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |