Home » Applications » Oracle Fusion Apps & E-Business Suite » Ora-20001: Flex-dsql Exception
Ora-20001: Flex-dsql Exception [message #425300] Thu, 08 October 2009 09:09 Go to next message
Corbon262
Messages: 6
Registered: February 2007
Location: Leeds
Junior Member
I'm trying to use the HR_POSITION_API.create_position API to mass load a number of new positions. I've created a custom wrapper to do look ups for a number of fields and got this working.

The problem comes when I try to add a value to one of the key flex segments in PER_POSITION_DEFINITIONS, I get the following error
ORA-20001: FLEX-DSQL EXCEPTION:
ORA-06512: at "APPS.HR_POSITION_API", line 2978
ORA-06512: at "APPS.CCC_WEB_ADI", line 315

I'm asuming this is because the segment has a value set validation of 'Table', where as the other segments which are working have 'Independant'

Does anybody know how I resolve this issue? I've checked oracle's metalink and been searching forums for hours but can not find anything.

Help please
Re: Ora-20001: Flex-dsql Exception [message #425308 is a reply to message #425300] Thu, 08 October 2009 09:57 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Error 20001 is custom error, that is error programmed in YOUR code.
It is NOT an Oracle error.
You have to search for source code to know the reason of this error.

Regards
Michel
Re: Ora-20001: Flex-dsql Exception [message #425452 is a reply to message #425300] Fri, 09 October 2009 03:38 Go to previous messageGo to next message
Corbon262
Messages: 6
Registered: February 2007
Location: Leeds
Junior Member
The error is returned from the oracle supplied API, it's not one I've handled. I've searched the API and all sub packages it calls but there is no mention of this error.

I hoped someone may have come across it before
Re: Ora-20001: Flex-dsql Exception [message #425458 is a reply to message #425452] Fri, 09 October 2009 03:49 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
As I said, this is NOT an Oracle error, it is an error that you have implemented in your program with
raise_application_error (-20001, 'FLEX-DSQL EXCEPTION:');
Search for the module that has this in its code.

Regards
Michel
Re: Ora-20001: Flex-dsql Exception [message #426093 is a reply to message #425300] Wed, 14 October 2009 01:33 Go to previous messageGo to next message
Corbon262
Messages: 6
Registered: February 2007
Location: Leeds
Junior Member
Ok, I'll try a different qustion.

I'm trying to use the create position API. One of the fields I need to enter is part of a Key flexfield, which has a value set with a table look up.

When trying to enter a value for this field I get an error as the values are not held in the value set but looked up.

I found this old post which explains the problem better than I have.
"We have a situation where we desire to use Data Pump to load element entries. All fine and dandy except: these days one has the option to configure an input value to be validated via a Valueset. Not only that but said valueset may be of the table-based persuasion. This is actually very bad news for us here at the well-known paymasters of our nation's armed services. . .Because these wretched valuesets contain references to the FND_SESSIONS table and in a couple of instances also refer to $PROFILES$.PER_BUSINESS_GROUP_ID the Data Pump process fails as: .1. It can't set itself a row in FND_SESSIONS .2. It can't interpret the context of $PROFILES$" (would have linked it but you carn't until you have 5 or more post on this site)
Unfortuneately the post ended as the raiser had a TAR/SR open with oracle

Does anybody know of a way around the table validation using the API??
Re: Ora-20001: Flex-dsql Exception [message #452181 is a reply to message #425300] Tue, 20 April 2010 08:22 Go to previous messageGo to next message
Desai_su
Messages: 1
Registered: April 2010
Location: Greenville
Junior Member
Hi Michelle,

The question about ORA-20001: FLEX-DSQL EXCEPTION: is true, I am trying to create SIT entries using HR_SIT_API's create sit procedure, I understand that oracle provides ORA 20001 till ORA 20999 error code for users and oracle is not suppose to use this range, but in this case this is surprise, because I haven't used this code any where in my program which is hardly 700 lines.Rest be assured that it's coming from API.

Hope you understand.

Thanks Suhas
Re: Ora-20001: Flex-dsql Exception [message #452192 is a reply to message #425300] Tue, 20 April 2010 09:52 Go to previous message
Corbon262
Messages: 6
Registered: February 2007
Location: Leeds
Junior Member
If it's the same issue I had someone on a helpful forum http://www.hcmaces.com/forums/ubbthreads7/ helped point me in the right direction using

FND_GLOBAL.APPS_INITIALIZE
Previous Topic: Hold Comment
Next Topic: AR - wanted to list down "On Account" Receipts
Goto Forum:
  


Current Time: Sun Dec 11 08:11:27 CST 2016

Total time taken to generate the page: 0.08648 seconds