And to list out all the active employees, their usernames and whether they have an entry in WF_ROLES:
select ppf.employee_number, ppf.full_name, fu.user_name, wr.status
from per_people_f ppf,
where ppf.person_id =fu.employee_id (+)
and ppf.person_id =wr.orig_system_id (+)
Run this to check everyone in the approval hierarchy is set up correctly if you are having any problems with testing transactions in Approval Manager and get the dreaded...
Another trick I keep forgetting the name of so I'm storing it here....
Express setup tools in iProcurement is the thing that lets you upload employees from a spreadsheet. As of 11.5.10 it got moved to a concurrent program, as per Metalink Note 303087.1. Today the doco is on page 5-19 of the iProc user guide, but tomorrow it could be anywhere.
Once upon a time a management accountant (thankyou Amanda) showed me how to do this and I keep forgetting what it's called so I figure I should blog it so I don't forget and everyone else can add it to their bag of tricks ...
1) Select the range of cells that contains the text values. The range can be any number of rows tall, but no more than one column wide.
Note: There must be one or more blank columns to the right of the selected column or the data to the right of the selected column will be overwritten.
2) On the Data menu, click Text to Columns.
Okay - I confess - I forgot to update this blog thingie ... again.... :)
My latest craze - iProcurement on 11.5.10, haven't done this one since 11.5.8 so it's a bit sexier and yet again the screens have changed - woohoo!
New things I like:
- Non-Catalog templates
- Using AME for Requisition Approval
New things I dislike:
- The new homepage isn't as easy as the 11.5.8 one
- Personalization just gets more complicated every release
Old things they still haven't fixed: