Artikelen
Alerts for Oracle Services Procurement PDF Afdrukken E-mail
Geschreven door Marcel Koolwijk   
maandag, 25 maart 2013 22:06

When implementing Oracle Services Procurement there are a number of steps in the process that can easily be controlled by a number of Alerts. The Alerts will notify you when a certain step in the process is not performed as expected. Examples are:

  1. The Purchase Order for a Contingent Worker is approved but the Purchase Order is not yet assigned to a Contingent Worker Assignment in Oracle HR
  2. Purchase Orders for Contingent Workers that are expiring within the next 14 days
  3. There is a mismatches between the Start date on the Purchase Order and the Start date of the Contingent Worker Assignment in HR
  4. Contingent Workers with an active assignment but without active user
  5. Contingent Worker Requisitions that are not charged to the Clearing Project (CWK Project)
In this article you will find some sample SQL queries for these Alerts. You can use these are basis for your own Alerts. If you just want to run the SQL queries you can of course just exclude the "into" section.
Lees meer...