Transfer Purge Batch Is Failing With Error ORA-01405: Fetched Column Value Is NULL
(Doc ID 3002826.1)
Last updated on FEBRUARY 07, 2024
Applies to:
Oracle Retail Merchandising System - Version 15.0.3 and laterInformation in this document applies to any platform.
Symptoms
While running the TSFPRG (Transfer Purge) Batch is Failing with the following Error .
Steps to recreate:
- Create a manual transfer without specifying to-Location.
- Also click OK button without adding any items to the transfer.
- Open the transfer in edit mode and delete it.
- Run TSFPRG PRE job and check that the transfer was inserted into DOC_PURGE_QUEUE with the TO_LOC value as NULL.
- Run TSFPRG.PC batch and notice the error above
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 |
Cause |
Solution |
References |