Sample Reports
Discussion List
-
OTBI Subledger Reconciliation Report with GL - ReportSummary: OTBI Subledger Reconciliation Report with GL - Report Content (please ensure you mask any confidential information): Hello The Company have the below subledgers…martingabriel Kinovisques 6 views 1 comment 0 points Most recent by Gangadhara S Ariga Reporting and Analytics for ERP -
Oracle hcm cloud seeded reports what is the list of reports and their locationHello, I would like to know please, what is the list of Oracle hcm cloud seeded reports ? and where they are located ? for example : employee contact ,employee address ,…Revital Mefano 825 views 9 comments 0 points Most recent by User_P172L Reporting and Analytics for HCM -
Which table has the information for Rule Builder for Checklist Template redwood taskSummary: Hi team, Which table has the information for Rule Builder for Checklist Template redwood task. Need the table where Rule builder name stores for the checklist c…
-
Time Change Request Type TableSummary: Hello, does anyone know which table stores the values of Request Type column in Time Change Request page? We are currently building a BIP report and was able to…
-
BI Publisher Excel Template Pivot Table Not Refreshing Automatically in OutputHi Everyone, I have developed an Excel-based BI Publisher template (.xls) in Oracle Fusion. The workbook contains two sheets: Detailed GL Transactions: This sheet is pop…
-
Query for Projects, Subledger and General LedgerSummary: Query for Projects, Subledger and General Ledger Content (required): Hello I was wondering if you can share with me any Query for Projects, Subledger and Genera…
-
display logo in excel format in Oracle Fusion BI reportI want to diplay the logo in Orcale Fusion RTF template in excel output When fetching output in pdf its showing the logo but not in excel fromat What is the sloution to …Abdur Rehman 67 views 5 comments 0 points Most recent by Pratiksha Sawandkar Reporting and Analytics for SCM -
Budgetary Control Balances OTBI with Deep Link Sample ReportSummary: Content (required): The Budget Balances OTBI with Deep Link Sample Report Kit contains a sample report embedded with a deep link to Review Budgetary Control Tra…Anne Wong -Oracle 1.3K views 18 comments 5 points Most recent by Anne Wong -Oracle Reporting and Analytics for ERP -
How to send attachment from content server to email through BI bursting in fusionSummary: Let’s say we have uploaded a PDF attachment in the contract, and the uploaded attachment gets saved in the content server. Now, we want to send this attachment …
-
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 59 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…
-
Alert composer : All team Overdue Assignments - Group By ManagerSummary: I would like to customize the notification "All team Overdue Assignments - Group by manager" This notification will target all required learning assignments whi… -
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… -
Transactions Tables are not storing Data for few TransactionsSummary: Hi Team, I am trying to fetch the transaction details for Time Change Request Approval. But I have encountered that there two tables that were not storing any d…Dasari Dileep 372 views 9 comments 0 points Most recent by Converse_with_OraEnthu Reporting and Analytics for HCM
-
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 22 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 31 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 124 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 53 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…