Custom Authorisation controlling row filters

Written by Mandy. Posted in Authentication & Authorisation.

I had a requirement recently for a set of users to be managed within the application, assigning them access to certain 'Regions' (Australian States, etc). Based on this access, the data displayed in multiple reports throughout the application should only show the regions they have access to.

The reports mostly contain Projects & Project Financials information.


IR Report with Dynamic Columns

Written by Mandy. Posted in Interactive Reports.

My client has an application where they manage their consulting resources, and assign them to different projects.

The format of the 'Assignment' table is somewhat like:

Consultant Name | Project Name | Start Date | End Date | Utilisation % | Tentative Y/N


They wanted to take this data and display it in a tranposed format, so that it looks more like a calendar. This is so each team leader can view their team's schedule and they can easily see who is available between two given dates.

This is what the report looks like:

schedule report


About Me

I currently specialise in developing bespoke applications using Oracle APEX.I have worked with APEX since it was known as HTMLDB, but have also dabbled with E-Business Suite, Oracle AS Portal, ECM, Webcenter and Website Design.

I enjoy working with new clients and assisting them develop custom applications to enhance and improve internal business processes.

Find Me

mandy nerd2