HCKT Hard Limit Reached Events in Fusion
Purpose of the report is to display project hours and hard-limit amount with interactive mode. with XXANSR_PA_EVENTS_cte as (SELECT evt.ROWID as “ROW_ID”, evt.event_id as “EVENT_ID”,…
Read MoreREVENUE TRANSFER REPORT (FUSION)
Purpose of this report is to derive all projects expenditure and event details with cost information. SELECT revenue_type, TO_CHAR (customer_id) customer_id, customer_name, TO_CHAR (project_id) project_id, project_number,…
Read MoreBuilding Dynamic Regions in Oracle APEX using APEX API
Modifying region queries/source dynamically can be done easily, whereas building regions dynamically can be done only using APEX API. Using the below code, a static region and a chart region…
Read MoreIntegrating With Fusion Application Using Services (APEX)
Fusion Applications provides web services that allow external systems to integrate with Fusion Applications. There are two types of services: ADF services and composite services. ADF services are created for…
Read More