Sample Reports
Discussion List
-
OBJECT_ID stores the Period of Service ID instead of the Assignment ID for PER_ALL_ASSIGNMENTS_M ?Usually, for transactions related to the Assignment page: •Object Name → PER_ALL_ASSIGNMENTS_M • Object ID → Employee Assignment ID However, in one particular case invol…Ashish_Goyal_MPC 62 views 8 comments 1 point Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
Is there a filter/prompt/SQL or a report for a daily dashboard for HR Helpdesk for new/close SRis there a dashboard available or report, or any sql/filter/prompt I can use for OTBI in order to get a daily dashboard for HR Helpdesk queries specifically looking for …
-
Tables of ESS/BIP jobs and their parameters in Oracle fusionSummary Please share the tables in which the parameters of the ESS and BIP Jobs submitted are saved.Content Please share the tables in which the ESS and BIP Jobs, and th…Roohi Syed 4.1K views 6 comments 0 points Most recent by SUDERSHAN PRASAD TIWARI Reporting and Analytics for ERP
-
In which table can I find the Proposed Worker Type field in Workrelationship?Hi, I want to add the Proposed Worker Type field on the person screen to my report as in the screenshot below, but this information returns an id in the per_all_assignme…Cansel Karasoy 1.8K views 9 comments 0 points Most recent by Nikhil Dugad Reporting and Analytics for HCM -
Need table name 'Source: Talent Profile’ information displayed in the Candidate Search HCM?Summary: Please provide the table name in Oracle Fusion HCM that corresponds to the under-Degree 'Source: Talent Profile’ field shown on the Candidate Search page. This …Janardhana Kondaveeti 22 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Table name and column for Accounting Period of Project CostSummary Table name and column for Accounting Period of Project CostContent Hi Experts, What could be Table name and column for Accounting Period of Project Cost (under M…
-
Data Extraction for Learning dataSummary: Data Extraction for Learning data Content (please ensure you mask any confidential information): Hi Team, Greetings! We are looking for the data extraction mech… -
Requisition Life-cycle report (OTBI)Summary Simple report showing creation date, approval date, PO creation date etc for purchase requisitionsContent See attached screenshot for details. Unarchive the atta… -
Is there an easy way to pull all the notifications enabled in the systemSummary: Is there an easy way to pull all the notifications enabled in the system. Content (please ensure you mask any confidential information): Is there a way we can p…AnushaGarikipati 21 views 5 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
BIP Vs OTBI What is the practicality of moving BIP reports to OTBI?Summary: I am recommending that my client investigates the possibility of using OTBI in preference to BIP for their reports (including whether this is just for new repor… -
Fetch the BIP report Scheduled output bursting detailsSummary: I need to fetch the details like , Output name, Template, Format. is there a table to fetch this details of the scheduled output ? Thanks for the help in advanc…Vishal Purohit 32 views 6 comments 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP -
Account Holder field not available in OTBISummary: Account Holder field not available in OTBI Content (please ensure you mask any confidential information): Hi experts, we are creating an OTBI report to retrieve…Oriana L. 31 views 6 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
Query to Fetch Tax Calsification Code Value From the Transaction LineSummary: We have a requriement to create a report to fetch Tax Classification Code value from the transaction line Content (please ensure you mask any confidential infor…Mamdouh Ahmed 22 views 4 comments 0 points Most recent by Mamdouh Ahmed Reporting and Analytics for ERP
-
Hierarchical Prompt for dep tree with OTBISummary: Hierarchical Prompt for dep tree with OTBI Content (please ensure you mask any confidential information): Hello experts, we have configured in OTBI a report wit…
-
Issue with Month-wise Active Headcount Count in Workforce Real time Trend Subject Area - OTBI ReportHello All, I am working on a report using the Workforce Trend - Real Time subject area in OTBI. The requirement is to show month-wise new joiners, attrition, and total a…KetanChavan 121 views 7 comments 0 points Most recent by Diana Mitrovski Reporting and Analytics for HCM -
table for address purpose and site related to customer in oracle fusionHi, table for address purpose and site related to customer in oracle fusion Regards C Rao
-
Report to extract initiatives associated to Learning ItemsHello all, We're trying to create a report which should extract for each learning item (specialization, course, offer etc) the initiative(s) created and its status (acti… -
per_personSummary: We could see lot of system users are exists in oracle fusion. We would like to build a report to identify only the actual users in oracle fusion. FUSION_APPS_AM…Alexander W 51 views 10 comments 0 points Most recent by Alexander W Reporting and Analytics for HCM -
How to enable activity sequencing in Oracle learning cloud?Summary: How to enable activity sequencing in Oracle learning cloud? what are all steps are involved. Content (please ensure you mask any confidential information): Vers…
-
OTBI Report for AP Invoice HoldsSummary Sample OTBI Report for ERP Cloud: AP Invoices on HoldContent This is an update on Andy Gough's Topic using the new subject area. I have also enhanced Andy's repo…
-
Report descriptionSummary: I would need a complete list of Out Of the Box Reports for Oracle ERP and SCM. Content (please ensure you mask any confidential information): I would need a com…DamianLopez7 11 views 5 comments 0 points Most recent by Andrew_Schmitz Reporting and Analytics for SCM
-
How to remove special characters in the output of a e-text templatesSummary: We want to send all the open POs to a third party system in .txt format. The item description have a lot of special characters, how to remove it in the output w…
-
GL Analytics dashboard in OTBIHas anyone created a GL analytics dashboard that they are wanting to share? I am trying to create a dashboard that gives our finance department/CFO all the information w…
-
Funnel percentage Graph change to 100%Summary: How I change the Funnel view to have 100% percentage in each phase? As below in the first phase I have 5395, where I've expect o have until 100% percentage Cont…
-
Analysis showing projected absence accrual at year endSummary: Hi We have a periodic accrual scheme for annual leave which accrues monthly at the month end. However we give our employees their entitlement up front (e.g. Mr …HRJon 71 views 4 comments 0 points Most recent by Saptadip Datta - DXB Reporting and Analytics for HCM -
FDI - Custom Security Context LOV returns row-level values instead of value-based valuesHi, We are currently implementing the security configuration in Oracle Fusion Data Intelligence (FDI). In addition to the 5 standard Security Contexts available, we need…
-
How to add an image in customize on email custom with datamodelSummary: Content (required): Hello, We are creating custom notifications for the learning module for a client. In particular, we have created both reports, bursting and …
-
Approver Name of a transaction with OTBISummary: Create an OTBI report with Transaction details, the initiator and approver Content (please ensure you mask any confidential information): Hello experts, is it p…
-
Customisation of Expense Approval Workflow Notification using BIPSummary Issues persist even while following expense config document step by stepContent Hi,We are trying to implement customized expense approval workflow notifications …Mohak Kirtane 153 views 3 comments 1 point Most recent by Matthew - Town of Aurora Reporting and Analytics for ERP
-
Historical Training Reports Missing Former Employees and Showing Incorrect “Withdrawn” StatusSummary: Hi everyone, I’m encountering an issue in Oracle Fusion Cloud while trying to retrack historical training records, and I’m hoping someone here might have come a…