| Loading Positions [message #547489] |
Wed, 14 March 2012 07:53  |
hany_marawan
Messages: 198
Registered: April 2005
Location: Cairo - Egypt
|
Senior Member |
|
|
Hello,
I have a customer his position flexfields contain 8 segments, also it must depend on each other.
i.e segment2 depend on segment1 and segment3 depend on segment2 ....
So I created 8 tables (my tables) have the data which the customer want and created the segments depend on 8 LOVs each LOV depend on one table of the 8 tables.
All these data is text.
I tried to load the positions in HR using HR_POSITION_API.CREATE_POSITION API but it gave me this error "ORA-20001: FLEX-DSQL EXCEPTION".
I tried to insert these data manual from the position form, it inserted.
I checkd the spelling of the data.
When I replaced the text by numbers, i.e HC----> 1, Bardi--> 2
It was loaded!!!!.
What's the error???.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
