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.