Home » Applications » Oracle Fusion Apps & E-Business Suite » Loading Positions
Loading Positions [message #547489] Wed, 14 March 2012 07:53 Go to next message
hany_marawan
Messages: 180
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???.
Re: Loading Positions [message #547511 is a reply to message #547489] Wed, 14 March 2012 09:31 Go to previous messageGo to next message
hany_marawan
Messages: 180
Registered: April 2005
Location: Cairo - Egypt
Senior Member
no one can help me.
Re: Loading Positions [message #547624 is a reply to message #547511] Thu, 15 March 2012 03:37 Go to previous message
hany_marawan
Messages: 180
Registered: April 2005
Location: Cairo - Egypt
Senior Member
Thanks every body
I found a solution for it.
Previous Topic: Acccessing EBS 12.1.3 through port forwarding
Next Topic: Workflow Query - How to define Processes
Goto Forum:
  


Current Time: Tue Sep 16 11:12:17 CDT 2014

Total time taken to generate the page: 0.29411 seconds