RPM_SFR_DATA_CONVERSION_JOB Fails With ORA-12154: "TNS: Could Not Resolve The Connect"
(Doc ID 2889981.1)
Last updated on AUGUST 17, 2022
Applies to:
Oracle Retail Merchandising Foundation Cloud Service - Version 22.1 and laterInformation in this document applies to any platform.
Symptoms
Actual Behavior
-----------------------
The RPM_SFR_DATA_CONVERSION_JOB fails with the ORA-12154 error.
Find that a few items are loaded in version 22 with the below condition.
ITEM_MASTER.SELLABLE_IND='Y'
ITEM_LOC.SELLING_UOM is NULL
Expected Behavior
-----------------------
Ideally, they should be in the below condition as verified in the version 16 data and the load file.
ITEM_MASTER.SELLABLE_IND='N'
ITEM_LOC.SELLING_UOM is NULL
The items are marked in ITEM_MASTER.SELLABLE_IND='Y' should have ITEM_LOC.SELLING_UOM.
Error
-----------------------
"ORA-12154: TNS:could not resolve the connect identifier specified"
Steps to Reproduce
-----------------------
1. Schedule and Run RPM_SFR_DATA_CONVERSION_PROCESS_ADHOC and observe the ORA error.
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 |