Sample Reports
Discussion List
-
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 861 views 10 comments 0 points Most recent by AbinayaRA-Oracle Reporting and Analytics for HCM -
Need sql Query to fetch the Job Applicants in Draft StatusSummary: We have a Requirement to build a BIP Report for fetching the Job Applicants in Draft Status. Can anybody please share the sql query for this requirement. Conten…Milan_Mohanty 17 views 2 comments 0 points Most recent by Milan_Mohanty Reporting and Analytics for HCM -
Probation Confirmation LetterSummary: We have a Requirement to send the Probation Confirmation using Oracle BIP Bursting . Can anybody share the Bursting Logic to call the IN .rtf Template or the US…Milan_Mohanty 31 views 3 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
Cross subject area "Receivables - Transactions Real Time" and "Receivables - Customer Real Time", neSummary: Cross subject area "Receivables - Transactions Real Time" and "Receivables - Customer Real Time", need to join the subject area to fetch data as there is no com…Prasad Tummalapalli 7 views 0 comments 0 points Started by Prasad Tummalapalli Reporting and Analytics for ERP -
Cross Subject Area receivables moduleSummary: Cross subject area "Receivables - Transactions Real Time" and "Receivables - Customer Real Time", need to join the subject area to fetch data as there is no com…Prasad Tummalapalli 8 views 0 comments 0 points Started by Prasad Tummalapalli Reporting and Analytics for HCM
-
List of Seeded Report in Learning ModuleSummary: Hello Experts, By using the excel attached on the CCC post I see there are learning module seeded reports available But when I can at the prescribed path, I did… -
Is there any way to identify the last usage date of a role assigned to a user in Oracle Fusion CloudHi Team, We have a requirement to identify the last usage date of a specific role assigned to a user in Oracle Fusion Cloud SaaS. We are looking for a way to determine: …Vignesh_Rajasekaran-Oracle 10 views 0 comments 0 points Started by Vignesh_Rajasekaran-Oracle Reporting and Analytics for ERP
-
Time Change Request reportSummary: Hi All, Has anyone Developed a BI/OTBI Report on Capturing Details of Time Change Requests? We have a requirement and working on this. Appreciate if anyone can …Abhishek Bhaskar 84 views 4 comments 1 point Most recent by Raj Battiwala Reporting and Analytics for HCM -
how to create custom roles and what are the common privileges need to add to run and publish reportsHi Team, What are the common privileges and roles required or to created a custom role to open reports in BI Publisher and scheduled new process AP Multiperiod Accountin…K Rama Krishna 18 views 1 comment 0 points Most recent by K Rama Krishna Reporting & Analytics for Fusion Service
-
How to get the the latest balance from HCM ExtractHi, I have created a balance group HCM extract to retrieve the custom balance value. I have selected the UE - PAY_INTERFACE_PAYROLL_REL_UE and selected the process type …
-
Call Sub Templates inside Main RTF TemplateSummary: We are facing issue while trying to call the sub Template inside the Main RTF Template. It Returns Blank Page Output for the P_COUNTRY Parameter selected from L…Milan_Mohanty 20 views 2 comments 0 points Most recent by Milan_Mohanty Reporting and Analytics for HCM
-
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… -
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…Joshua K 1 view 1 comment 0 points Most recent by Vignesh_Rajasekaran-Oracle Reporting & Analytics for Fusion Service
-
How to grant access to OTBI without granting access to datamodelSummary: Although a custom reporting role strictly restricts the user from creating or editing Data Models, a security gap allows them to delete existing Data Model obje…Kevin123 51 views 8 comments 0 points Most recent by Kevin Wong Sing Ting Reporting and Analytics for ERP
-
We need a query to get Payroll Balance group usages mapped to Balance dimensionSummary: Hi. We need a query to get Payroll Balance group usages mapped to Balance dimension. When dimension changes(Quarter, Run, Month… ) then the Balance group usages…Opkey PA 40 views 4 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
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…
-
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 387 views 12 comments 0 points Most recent by ParthivAVT Reporting and Analytics for HCM
-
How to set static/Dynamic password generation for PO-PDF in Oracle FusionHow to set static/Dynamic password generation for PO-PDF in Oracle Fusion A requester received a Purchase Order (PO) change notification, which included the PO PDF. The …PASALA SATEESH REDDY 14 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
Query required to fetch the fields - Resident PSD Code, Resident School District, Work PSD Code.Hi, Does anybody have a query that will fetch the fields - Resident PSD Code, Resident School District, Work PSD Code, Work School District. These fields are present in …
-
SQL script for Roles , Privileges, Inherit roles & Data Security PoliciesSummary SQL script for Roles , Privileges, Inherit roles & Data Security PoliciesContent Trying to built a query to fetch Application Roles, Privileges, Data Security & …
-
Table/View for AP Invoice Approval History & Workflow (BPM Flow)We are in the process of creating a customized report to track the complete approval history of AP invoices in Oracle Fusion. The requirement is to fetch details of the …sailesh_cloudare 422 views 4 comments 1 point Most recent by Jayanth Sarma Reporting and Analytics for ERP -
Content Type - Web LinkSummary: What is the correct mapping for content weblink for a web based content type. We are mapping the Web link from table - WLF_LI_CONTENT_F and field - STARTING_URL…
-
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…
-
Standard report for Oracle journeysSummary: Standard report for journeys Content (please ensure you mask any confidential information): Hello experts, does anyone know if there are standard reports delive… -
unable to find the ESS Job while creating Request setSummary: Hello, We are creating a request set for an ESS Job. But while creating the request set the ESS Job name is not able to see. Kindly suggest on this for possible…Chathura kavali 12 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
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 12 views 1 comment 0 points Most recent by Gangadhara S Ariga Reporting and Analytics for ERP
-
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…
-
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 61 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 …