Ganesh

Latest posts by Ganesh

• Excel - to CI - Compile error - User Defined Type not defined.

  When using ExcelToCI on Windows 10, trying to load template or stage and submit data, it gave a 'Compile error' that reference to Visual Basic code reference to DOMDocument object. Users usually get a "Compile error: User-defined type not defined" error This not an error in the Windows 7 OS, it is a...

  Posted on 16 October 2019 | 11:51 pm

  Read post

• PSQuery Performance issues with Rowlevel Query Security Tables

  PSQuery Performance issues with Query Security Tables We see PSQuery having bad performance due to many Query Security Join tables that the PSQuery tool adds to the PSQuery SQL for security. We have few options to work around to easily improve the performance without much involving tunning from the...

  Posted on 4 October 2019 | 10:26 am

  Read post

• Identify navigation in PeopleSoft by a Process name or a Job name

  Identify navigation in PeopleSoft by a Process name and/or Job name There are many SQL statements in different blogs to identify the navigation for a process. But I have modified that to get the Navigation for a Job. Single SQL works for both Process and Job. SELECT DISTINCT RTRIM( REVERSE ( SYS_CON...

  Posted on 2 October 2019 | 6:12 am

  Read post