Pages

Recently Viewed

Sunday, November 25, 2012

DOA assignment using Data Loader

Data loader is a tool, used for data entry during EBS setups. This can be leveraged to do any manual data entry in various applications.
This post is to have data loader script for assigning DOA (delegation of Authority) to oracle positions in procurement.
 
 
First DOA Assignments Update DOA Value Add additional DOA value
\{TAB} \{TAB} \{TAB}
POSITION POSITION POSITION
\{TAB} \{TAB} \{TAB}
Purchase Requisitions \{F11} \{F7}
\{TAB} Purchase Requisitions Purchase Requisitions
10M \^{F11} \{TAB}
\{TAB} \{TAB} 200K
\{TAB} \{TAB} \{TAB}
\^s \{TAB} \{TAB}
\{F4} SYSDATE \^s
\{ENTER}  \{TAB} \{F4}
  \^s \{ENTER}
  \{F4}  
  \{ENTER}  
 
First DOA Assignment - Position does not have any existing active/inactive assignment
Update DOA Value - Given sample is to end date existing assignment. Incase there is a change in value,give new value at second TAB.
Add additional DOA Value - assignment for a position having already some assignments. 

No comments:

Post a Comment