Presentation variables like F_Date can sometimes be stored as text instead of a proper date format, causing issues when filtering or comparing with the Effective Start Date. Convert the Presentation Variable to a Date Format: Use the CAST or TO_DATE function to ensure F_Date is treated as a date: sql…

Hey mark, Check this out:

Thanks for the info!!!

Hey Diego, It looks like to be a permission issue. Verify User Permissions: The user running the report might lack access to required data. Confirm role-based security settings and ensure the user has read access. Please schedule the report directly from BIP application by enabling the diagnostics log option for both…

Hey Mark, OTBI Subject Areas that can help to track candidate responses, use: Recruiting – Job Applications Real Time Provides details on candidate applications, prescreening responses, and statuses. Includes free-text and predefined answer questions. 2. Recruiting – Candidate Job Applications Real Time Tracks candidate…

Hey Peter, OTBI Subject Areas which can he helpful: Workforce Management – Worker Assignment Real Time Provides details on employee assignments, job roles, and departments. Includes contractual hours if configured in the assignment attributes. 2. Workforce Management – Worker Time Entry Real Time Tracks actual working…

Great work!!!!!

Thanks for the info.

Check This:

@drudd, ASE* tables should NOT be used for any kind of reporting (BIP etc.). Security console features are primarily stored in ASE_* tables and these are not available to customers from 20B onwards. ASE* tables are for internal processing, and tables related to ASE_* should NOT be used for reporting. Customers should not…

Ensure you are using an AOR-related real-time subject area, such as: Workforce Management – Worker Assignment Real Time Human Capital Management – Areas of Responsibility Real Time

Please review the below link as it might be helpful: Per_user_roles or ase_user_role_mbr to be used for Reporting ? — Cloud Customer Connect ASE table reference — Cloud Customer Connect

@Pbrown.Nz-Oracle : Please mark this thread as answered in case your issue is resolved as it might help other customers.

Since Email B’s buttons were created directly in the email without defined campaign goals, the challenge is mapping URL_IDs to their corresponding button labels for reporting clarity. Try below steps to resolve this: Manually Create a Mapping Table: Since the reporting table only contains numeric URL_IDs, you’ll need a…

Here are some Oracle documentation links related to Talent Review Meeting Real Time in OTBI: Workforce Talent Review - Talent Review Tasks Real Time Workforce Talent Review - Talent Review Meeting Real Time Add Analyses to the Talent Review Dashboard

Please check the below docs as it might be helpful: How do you export a list of custom reports from OTBI? — Cloud Customer Connect How To Query Details Of ALL BIP, OTBI and FRC Reports (Doc ID 2722120.1)

The 'Custom' folder under 'Shared Folders' is a key location for storing user-defined reports and configurations. While you can manage its contents, deleting and recreating the folder itself is not recommended due to system dependencies. Check the below: Manage OTBI Folders Restrict Access to the Custom Folder in Shared…

Check the below:Validate Subject Area Selection The Transaction Administration Real-Time subject area may not contain direct mappings for Region or Country. If country data is stored under Assignment subject areas, it might require joining related datasets. 2. Check if the Country Field is Aggregating Instead of Displaying…

Please check this as it might be helpful: OTBI Performance Real Time Fusion Applications OTBI: How To Configure And Use Audit For Usage and Performance In OTBI For Fusion SaaS Cloud Customers (Doc ID 2731495.1)

Check the below: Check PDF Rendering Mode in Adobe Acrobat Open Adobe Acrobat and go to Edit > Preferences > Page Display. Enable "Use Overprint Preview" and set "Rendering Mode" to High Quality". 2. Verify Compression Settings If the scheduled report applies high compression, some elements may not display properly in…