| Ora-20001: Flex-dsql Exception [message #425300] |
Thu, 08 October 2009 09:09  |
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 #425452 is a reply to message #425300] |
Fri, 09 October 2009 03:38  |
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 #426093 is a reply to message #425300] |
Wed, 14 October 2009 01:33 |
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 |
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
