DataLoad Community Forum Index DataLoad Community

 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

How to enter data on COA Flexfield form?

 
Post new topic   Reply to topic    DataLoad Community Forum Index -> Macro Load Support (.dld files)
View previous topic :: View next topic  
Author Message
masai_chadi



Joined: 17 Oct 2006
Posts: 2

PostPosted: Wed Nov 08, 2006 8:36 am    Post subject: How to enter data on COA Flexfield form? Reply with quote

Under Oracle Purchasing Approval Groups, when Account Ranges are specified the the application brings up a form with each of the COA Segment fields to enter low and high value. How best to enter this data in DataLoad Spreadsheet?
Back to top
View user's profile Send private message
David



Joined: 15 Nov 2005
Posts: 97
Location: Near Heathrow Airport, London

PostPosted: Tue Nov 14, 2006 6:26 pm    Post subject: Entering accounting flexfield segment values Reply with quote

This is best done using "keystrokes". To achieve this, prefix each value with a \ (backslash) character.

Suppose that your Accounting Flexfield contains three segments, Company, Department and Account, and that the values you want to allow for each segment are 22 only, 100 to 149 and 3000 to 4999 respectively, then the appropriate section of your DataLoad spreadsheet would look like this:-
Code:

\22     \22     \100    \149    \3000  \4999

Since you are filling each segment completely, you should be able to send all of the characters together, using this alternative:-
Code:

\222210014930004999

but you might find that your system cannot keep up with data being sent so quickly, and you may need to add an *SL or maybe *SL3 afterwards.

Cool HTH

David.
_________________
When my time comes,
I want to die like my grandfather did:
quietly and in his sleep.
Not kicking and screaming like the passengers in his car.

David K. Dickson
DataLoad Forum Moderator
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    DataLoad Community Forum Index -> Macro Load Support (.dld files) All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group