Scheduling nVision through AE

For obvious reasons, I cannot possible document the entire AE in this blogpost so I'll just give a quick rundown.

nVision is scheduled through a series of setup pages under this navigation
Main Menu > Reporting Tools > PS/nVision

Behind the curtains, PeopleSoft is inserting data to the following tables

• PSNVSBOOK
• NVS_SCOPE
• NVS_SCOPE_FIELD
• NVS_SCOPE_VALUE
• NVS_REPORT
• PTNVSQRYPROMPTS
• PSNVSBOOKREQUST

Which means, in order to successfully schedule an nVision instance, you just need to discover the values to insert to said records.

All you have to do is schedule a sample nVision instance, monitor these tables and then code the insert statements in your AE.

After that is done, go ahead and schedule the instance:

&RQST = CreateProcessRequest();
&RQST.RunControlID = "YourRandomReportIDHere";
&RQST.ProcessName = "YourProcessNameHere";
&RQST.ProcessType = "nVision-ReportBook";
&RQST.OutDestType = "Web";
&RQST.OutDestFormat = "XLS";
&RQST.RunLocation = "PSNT";
&RQST.Schedule();

Bonus Tip

If you want the report to show up only for a specific person, add this line before you call Schedule().

&RQST.OutDest = "U:" | ThatOtherGuy;

The guy who ran the AE won't see it in his Report Manager, but ThatOtherGuy will.