Reports
Discussion List
-
Absence category and absence types under this category query.I need a SQL query that returns information about the absence category and the absence types connected to this category. I would be grateful for the query you can share …Cansel Karasoy 313 views 11 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM -
Sending Bursting pdf as an e-mail body instead of outputI have a notification work that I have prepared, the report returns table type employee data and absence detail.I can send this tabular report as a pdf output, but I wan…Cansel Karasoy 31 views 3 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM
-
How to write a query to pull FCCS Users through a Non-COnsolidation ReportSummary: Currently we are using "select * from FCM_USERS" query to create the report. But it pulls the entire users from the LDAP. However, we want to confine the users …User_2025-03-07-06-14-34-751 121 views 11 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
AS-OF-DATE on Prompt - CURRENT_DATE_REP_OTBI-Session DateSummary: I am using CURRENT_DATE_REP_OTBI in the calendar prompt # As of date . The date is is not defaulting correctly. The session date defaults to 01-Nov-2021. While …
-
Unable to call BIP report with REST APISummary: Hi Experts I'm trying to use the REST APIs for the BIP report developed in Fusion but I'm getting not found error, please help me if I'm creating a wrong URL Be…Sharmava 272 views 1 comment 1 point Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
Is there any table/way to find the tables used (data set details) in BIP reportSummary: Is there any table/way to find the tables used (data set details) in BIP report Content (required): Hi Team, Greetings! Is there any table/way to find the table…Parag Hiremath 931 views 16 comments 0 points Most recent by HarshithDarla Reporting and Analytics for HCM -
Looking for a Workflow transactional Report where Self Approval is enabled.Hi Team, I'm Looking for a Workflow transactional Report where Self Approval is enabled. Either the report should let me know about on which workflow rule self approval …
-
FR member search does not work for options other than NAMESummary: Content (required): Hi all We are finding few issues with FR today for a client. When we try to seach for a member using default / alias or Alias-form, we get a… -
Connecting Workiva Cloud Service with ERP Cloud for SEC ReportingSummary Would like to know if anybody has done this connection and how worksContent Hello, I'm trying to learn from somebody that already experienced how to connect Work… -
No access privilege for subject area errorSummary: User getting this error No access privilege for subject area when trying to access OTBI Reports using Order Management – Fulfillment Lines Real Time subject are…SakshiA 41 views 4 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP
-
Extract description of lookup in OTBISummary: Content (required): Hi everyone, we are having problems extracting the value of a dff configured for the JOB. Is it possible to extract the description of the r…Gerardo Peluso 1 view 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Getting error in FRS reportSummary: Getting errors in the FRS report Content (required): Hi All, I moved one FRS report from TEST instance to PROD. When I try to run the report in PROD, I am getti…
-
FR: HTML reports preview does not display pop window to define promptSummary: Content (required): Hi all We have an issue with Fr web studio where the pop-up window to define prompt and select members for a specific prompt does not displa…
-
Looking for SQL query for Duty Role to Job Role mappingSummary: We have a couple of job roles and child duty roles and privileges assigned to the same job role. Can someone help me with SQL to fetch the same as we need to co…sailesh_cloudare 477 views 1 comment 2 points Most recent by Gayatri Chappalli-Oracle Reporting and Analytics for ERP -
Need help with querySummary: May I know what is wrong in this query Content (required): SELECT order_key, dfla.source_order_number, dfla.source_line_number, DFLA.ordered_qty using_requireme…kalyan gade 101 views 5 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
OTBI Report is not giving results.Summary: Hi Everyone! Workforce management - Worker Assignment Event Real time I am using above subject area to create a report but when i click results, i am getting " …ShawShankk 2.2K views 9 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Can we schedule a OTBI report by password protecting the output?Summary Can we schedule a OTBI report by password protecting the output?Content Hi, We have a question: Can we schedule a OTBI report by password protecting the output? …User_MC37Q 57 views 8 comments 1 point Most recent by Kimberly Nguyen Reporting and Analytics for HCM -
Is there a way to combine this so that the team shows on one row?Summary: Is there a way to pull the team on one row instead of duplicating per territory role? Content (required): I am trying to create an analysis for sales. The terri…
-
query to get current logged in user_id in BI publisher reportSummary query to get current logged in user_id in BI publisher reportContent Hi Experts, how to get current logged in user_id in BI publisher report. Thanks, PradvinPradvin Prabhakar 5.4K views 7 comments 2 points Most recent by MastekLtd Reporting and Analytics for HCM
-
renaming entity and cost center membersSummary: Content (required): Hi We need to rename entity code and cost center members - first four digits. (Ex: old code is 503010001 and new code is 803010001) We teste…
-
Output Name is incorrect in Report Job HistorySummary: Content (required): We used Bursting to set the file name of the report. It is displayed correctly on the Schedule Report Job History screen inside file name bu…
-
How to change middle name field to just one character?Summary: When the middle name field is more than one character, is there a formula that can be used to only show the first character? For example middle name contains "W…
-
How to fetch learning community access group details?Hi everyone, I have a requirement to fetch the learning community access group details like, Community Access Group Name, Community Access Group Learner Count and Commun…Prashanth Sangram-Oracle 11 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Split Opening Balance of Other Comprehensive Income Balance Sheet AccountSummary: We have detail account of each category of FCCS_Other Comprehensive Income but in FCCS, FCCS_Other Comprehensive Income -> FCCS_ClosingBalance will comes to FCC…
-
How do we find out the date a leave of absence was approved?Summary How do we find out the date a leave of absence was approved?Content We are using the 'Workforce Management - Absence Real Time' subject area and using the 'Assig…
-
How to pull correct Learning Assignment Status valuesSummary: Cannot determine the logic to pull the correct Status value that is displayed in Status column of Learning Assignment Page. The Table has two Status fields and …Vanessa Gepitulan 314 views 6 comments 0 points Most recent by Vanessa Gepitulan Reporting and Analytics for HCM
-
Child account not reflecting under Parent account in Smart ViewSummary Child account not reflecting under Parent account in Smart ViewContent After creating a new account, when refreshing Smartview report I noticed Its not reflectin…
-
Extract the ID of a department (going active on 01 october) from FusionHello, In Fusion we have created a department that will become active on the 1st of October. For our integration with Taleo I need the Department ID of this department a…
-
Absence Headcount - Percentage of Employees on Leave by JobSummary: Divide count of employees by total number of employees Content (required): Hello experts, As the title suggests, I was trying to fetch the percentage of employe…