Windows Task Scheduler

This article is nowhere related with EBS, but will be useful for any computer users.

 

Requirement – Automated process to be executed on schedule basis in windows.

Wanted to ensure if there exist any specific file in system, I should be alerted with details.

 

Solution – Window provides task scheduler to achieve same. Task scheduler is same as oracle triggers with GUI.

 

How to find - Login to windows >> Start>> Task Scheduler

 

Create Task – Click on create Task action  

 

 

General Tab – Set the task name and description and click on Triggers

 

Triggers – This tab is to set the execution time. It can be set to run on schedule or on demand. Click on New button or edit existing schedule.

Provide scheduling detail and move to Actions

Actions- This is to perform different activity. It can run a program, send email or display messages. Click new button to set a new action.

Action = start a program   Program Name = Path of executable file.

We can give the file name only and place path in Start in (optional) block.

 

Conditions – To set various conditions when task should run and when not.

 

Settings – This is to define different instance scenarios.

 

Press OK and it will pop up the windows login password. Task will run at defined schedule.

 

 
 

 

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.