Sample Reports
Discussion List
-
ESS-01035 Unable to determine a logical application name for new request running new jobset in UII am defining a jobset for the first time, to work in financials for Advanced Collections. I have identified how to create the jobset under Manage Enterprise Scheduler J…Susan Hathaway 34 views 1 comment 0 points Most recent by Narendar Rao Naineni Reporting and Analytics for ERP -
Report dashboard prompt showing error - ACIOA5LNSummary: Report dashboard prompt showing error - ACIOA5LN Content (required): One of the working BI report which uses dashboard prompt, suddenly stopped working and show…Swati U 3.7K views 22 comments 1 point Most recent by Mitali Meshram Reporting and Analytics for HCM
-
Skill Validation Reset - Question on Reporting FeasibilityWe've been continuing our research on the Skill Validation Reset concept and have shifted our focus from the future state solution to whether there's an interim process …Career and Skills Product Manager 1 view 0 comments 0 points Started by Career and Skills Product Manager Learning
-
BIP query to retrieve the details of loaded Self-Paced Learning items and Physical Events.Summary: Hi All, Could someone please help me by sharing the BIP query to retrieve the details of the loaded Self-Paced Learning items and Physical Events? Thank you in …
-
How to Create a Data Set Using a Web Service in Oracle FusionHi Experts, I tried to create a data set in BI Publisher using a web service that returns valid XML data. I referred to this document: Creating a Data Set Using a Web Se…Krishan_Palihakkara 62 views 2 comments 0 points Most recent by Yeung Shing Keith Reporting & Analytics for Fusion Service -
Advanced CollectionsContent Hello All, Do we have any OTBI subject area which gives data related to Collections. Ex: Collector wise collections. Thanks, NishanthNishanth B Jain 119 views 9 comments 0 points Most recent by Alan S. Reporting and Analytics for ERP -
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 2 comments 0 points Most recent by Bhaskar Konar 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 864 views 11 comments 0 points Most recent by Raj Battiwala 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 31 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 49 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 2 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 1 view 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 12 views 0 comments 1 point 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 86 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 26 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 22 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 19 views 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 52 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 52 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 392 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 20 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 467 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…