Sample Reports
Discussion List
-
Scheduled OTBI Report to provide output as on previous dateSummary: Want to schedule OTBI report which triggers output as on previous date as effective date Content (required): When OTBI report is scheduled, we have a requiremen… -
How to calculate cost of sickness in UKSummary: Calculate the cost of sickness using salary from element entry Content (required): I have been asked to calculate the quarterly cost of sickness. I was wonderin…Isabela Radivoi 21 views 2 comments 0 points Most recent by Isabela Radivoi Reporting and Analytics for HCM -
Articulate 360 users, What settings do you use for Learning for SCORM reportsSummary: We use Articulate Rise 360 to create our learning content. We need to report out scores and overall attempts (not individuals, there are over 6000 employees) fo…
-
Need source of PO Charge account for OTBI reportSummary: what is the database source field for the PO charge account - would like to include in an OTBI report Content (required): PO charge account on the page - what d…Bernadette Dorris 41 views 6 comments 0 points Most recent by Bernadette Dorris Reporting and Analytics for SCM
-
OTBI-Expense-Expense Transactions - SQL to Link Expense and PPM ?Summary: OTBI-Expense - Expense Transactions - SQL to Link Expense and PPM Content (required): Hello I have an OTBI report with the subject area Expense-Expense Transact…Cesar Saveedra 41 views 1 comment 0 points Most recent by Vinodhini Vobhilineni-Oracle Project Management
-
Hiding Out of The Box Reports - (Human Capital Management)Is it at all possible to hide the folder that contains the out of the box reports (Human Capital Management)? I can see we can remove the 'BI Consumer Role' from our rep…MikeW 51 views 3 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
We have Multipul records in UI for each employee but we need only latest one that is top one?Summary: HI Team, We have Multipul records in UI for each employee but we need only latest one that is top one in below screen short? Could you please help me on . Thank…AjayKumar Maddipati 41 views 8 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
Report that shows what OBTI is attached to an InitiativeSummary: We need to run a report that shows what OBTI Analysis is attached to an initiative, so we know which are currently in use. Content (required): Learning Initiati…
-
Pull current assignment only from Workforce Profiles - Person Profiles Real Time subject area?Summary: Subject Area: Workforce Profiles - Person Profiles Real Time Pull only most recent, current assignment - NOT past assignment data Content (required): Hi All, *R…William_Johnson 61 views 7 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
How to make a custom report available in supply planning work area?Summary How to make a custom report available in supply planning work area?Content Created a custom report. Users want it to be able to open from the supply planning wor…
-
We need to fetch the latest record only in OTBI how can we achieve this requirement ?Summary: Hi Team, in below attachment filled by Hr team for employee in multiple times of records creating and report also fetching three records, but Business wants to …AjayKumar Maddipati 471 views 2 comments 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM
-
ORC-OTBI Report we have used two subject areas but report still searching modeSummary: Hi Team, I have developed OTBI report by using recurting real time and recurting real time we used but no out after long time also. Please find attachement of i…AjayKumar Maddipati 21 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM
-
We have new requirement in my workforce page how find which subject area available ?Summary: HI Team, we have new requirement in my workforce page > additional person info group. which subject area available . Any one help me on . Thanks. Ajay Content (…AjayKumar Maddipati 51 views 9 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
Risk/Impact columns pulls in one value and one blank value causing duplicate rows in OTBI?Summary: Subject Area: Workforce Profiles - Person Profile Real Time Columns: "- Risk of Loss"."Impact of Loss", "- Risk of Loss"."Risk of Loss" Content (required): Hi A…William_Johnson 51 views 1 comment 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
HR self-service reporting in Oracle HCMSummary: Content (required): Hello everyone, I wanted to ask about the possibility to have HR self-service reporting in Oracle HCM, i.e. the possibility for HR users to …Maria Xydopoulou 61 views 10 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Bursting Report outputSummary: Bursting Email Contains the Sql Query output in the Message Body. How to Remove the Sql Query Output line from the Message Body Content (required): Version (inc…MilanMohanty 81 views 9 comments 0 points Most recent by Rajdeep Chavda Reporting and Analytics for HCM -
Calculate revenue % distribution for each project with in Business unitSummary: We have the below requirement Project1 Revenue amount-20 project2 Revenue amount-30 project3 revenue amount-16 Total BU revenue amount 66 (this is achieved by e…
-
Can we extract import project errors using custom BIP report?Hi, We are using FBDI to import projects in Oracle PPM Cloud. As per our observation, projects interface table PJF_PROJECTS_ALL_XFACE is getting purged automatically onc… -
OTBI:Market Data: No data in report when columns from Global HR dimensions are usedSummary: Guidance to ensure that Market Data reports return data when Global HR dimensions are used. Content (required): 1- Subject Area: "Compensation - Market Data Rea…Abhishek Dixit-Oracle 61 views 3 comments 1 point Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM -
how to change columns as rows in below requireimentSummary: Hi Team, In OTBI how change annual accrual and carry over coulmn into row we need . Any one help me on ? Content (required): Version (include the version you ar…AjayKumar Maddipati 81 views 20 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
We need Work Schedule Name, Work schedule start date, Work schedule End date on OTBISummary: Hi Team, we looking below columns in OTBI subject areas May i know which subject area available? Thanks, Ajay Content (required): UI: Version (include the versi…AjayKumar Maddipati 32 views 2 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
In BI Report we getting dupilcate records as per ui but we need only one recordSummary: HI Team, We have exist interview survey status report but we getting dupliacte reocrds nearly 700plus. due to report takes as per ui but in ui some of employees…AjayKumar Maddipati 31 views 3 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
Unable to join Invoice and Procurement Subject Area in OTBI AnalysisSummary I have a requirement to fetch the Purchase order details with corresponding invoice details. Therefore i need to connect two subject areas to fetch the required …Santosh V-228136 647 views 8 comments 0 points Most recent by Khassham Khan Reporting and Analytics for ERP
-
Best subject area for pulling "Worker"."Work Email" into OTBI?Summary: Current Subject Area Used: Workforce Management - Worker Assignment Real Time Columns: "Worker"."Work Email" OR "Worker"."Employee Email Address" Content (requi…William_Johnson 41 views 3 comments 0 points Most recent by William_Johnson Reporting and Analytics for HCM
-
Different filename based on a parameter value of report using ESS jobHi All, How to achieve custom filename using report parameter value as part of filename Example: ABC_XYZ_Timestamp.xml or ABC_XYZ_Timestamp.csv ABC is part of the file, …Swapnil Kashid 1 view 1 comment 0 points Most recent by Swapnil Kashid Reporting and Analytics for SCM -
Need help on calculating Hash Total for National Bank of Kuwait EFT templateSummary: is there any ready to use code to calculate hash total logic in oracle etext template to make a payment to National Bank of Kuwait Content (required): Hash tota…SireeshaJaladi 31 views 1 comment 0 points Most recent by SireeshaJaladi Reporting and Analytics for ERP
-
Post Conversion validation reports for Core HR moduleHi Team, Could you please help us with the Post Conversion validation reports for the Core HR module? We need the following reports. Please share with us if you have eit…
-
we have OTBI Report skills and certfications but it showing unparallely ?Summary: HI Team, We have report facing this is how can sorted Content (required): Version (include the version you are using, if applicable): How it looks in the report…AjayKumar Maddipati 21 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Prepare Review Content example reportsSummary: Prepare Review Content Subject Area: Workforce Talent Review - Talent Review Meeting Real Time Content (required): Hi All, We are looking to better engage our e…William_Johnson 21 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Workforce Talent Review - Talent Review Tasks Real Time reporting bug?Summary: How can we pull a report using this subject area to provide an administrative overview of all existing tasks in a Talent Reviews within the system? Content (req…William_Johnson 21 views 2 comments 0 points Most recent by William_Johnson Reporting and Analytics for HCM