My Oracle Support Banner

MSCOSCWB MSCBALWB form fails with ORA-12154: TNS:could not resolve the connect identifier specified (Doc ID 2694692.1)

Last updated on JULY 27, 2020

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.2.5 and later
Information in this document applies to any platform.

Symptoms


patch being applied 

Cloned the system

Decentralized sytem

 

form fails with 


FRM-30064: Unable to parse statement select mtl.organization_code, hr.organization_name, hr.organization_id from org_organization_definitions hr, mtl_parameters mtl where hr.organization_id = mtl.organization_id order by mtl.organization_code.
ORA-12154: TNS:could not resolve the connect identifier specified
Record Group ORG_RG
Form: MSCOSCWB

FRM-30085: Unable to adjust form for output.

 

Manual compilation also does not works

Same sql when executed from sql developer as apps user also fails with the same ora-12154

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


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