Reports
Discussion List
-
Track Fusion user activity in OCISummary: OCI experts, Is there any Report in OCI that will help us track the user activity (last log in time). The Fusion Tables FND_USER_SESSIONS and FND_SESSIONS table…Raksha Kodangal 11 views 2 comments 0 points Most recent by Raksha Kodangal Identity and Access Management -
HCM Tables which store BIP/OTBI Scheduled Report email recipientHi Team - We've requirement to list down all the BIP & OTBI reports which are scheduled along with their email recipient details. (some notification could be dynamic bas…
-
Is there log available in FCCS to identify whether any change was done to audit trail configuration?Summary: Is there log available in the FCCS application to identify whether any changes were done to the audit trail configuration, please advise. Content (please ensure…
-
Help Needed: Retrieving Current Address for a Legal EntityHi Everyone, I'm trying to retrieve the current address for a Legal Entity, but I'm facing challenges in identifying the correct tables and joins. Context: I understand …Saurabh_Mharolkar 41 views 8 comments 0 points Most recent by Saurabh_Mharolkar Reporting and Analytics for HCM
-
Can we run a BIP report with REST API datasource in Payroll Flow pattern?Summary: Dear Folks, I'm trying to call REST API method from BIP report to trigger a method in OIC. So, I created a BIP report with REST API endpoint URL as data source.…User_BRCI5 61 views 5 comments 0 points Most recent by Eknath Kayasri Reporting and Analytics for HCM
-
Average based on number of monthsIf I have YTD(Current month) in one column and in the next column i want to dynamically calculate the average as per the below example For example - If it is YTD (March)…
-
BIP attachment Query not accepting the parameterSummary: Hi, When I try to use attachment query with dynamic parameter(:P_DID) , i am not getting the UCM outputs. If I hardcode any UCM(DID) from revisions table then I…
-
We Need a table for the Default Values Configure Worksheet Display -Detail TableSummary: Hi We need a table for the below fields under Configure Worksheet Display -Detail Table in workforce compensation plan Content (please ensure you mask any confi…Opkey PA 21 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Narrative ReportingSummary: In Narrative reporting, is it possible to display numerical numbers in other language numbers e.g Arabic numbers etc in reports. Content (please ensure you mask…
-
BIP Bursting to Email:Output sent as URL:Ability to Change the Position of the URL in the Email BodySummary: BIP Bursting to Email: Output sent as URL: Ability to Change the Position of the URL within the Email Body Content (please ensure you mask any confidential info…
-
Query Custom Attributes from one of their planning environment to Narrative Reporting?Hey guys, Do anyone here had the experience using the Custom Attributes from one of their planning environment (Hyperion in my case) to Narrative Reporting? I am not sur…
-
Is it possible to display contents of CLOB column in OTBI analysis?Content Is it possible to display contents of CLOB column in OTBI analysis? I am adding a CLOB column to an OTBI analysis but it comes up with blank. When I query the sa…User_2025-02-11-06-57-37-559 173 views 7 comments 0 points Most recent by Alex Cardenas Reporting and Analytics for HCM -
Reports to get Service Usage in fusion HCMWe need reports for below: 1) Anonymized Authorized User Names by Service Details 2) Authorized User Names by Service 3) Authorized User Privileges by Service 4) Authori…
-
Schedule a BI report with incremental dataSummary: Schedule a BI report with incremental data Content (please ensure you mask any confidential information): Hi Experts, I have a requirment, I need to scheduled a…Malak 22 views 4 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
Database Table name for Approval DelegationsSummary: We have a requirement to build a report for approval delegations, thus need the database table name for Approval Delegations. Navigation: Person Management > Se…JainSamyak 52 views 4 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
How to schedule BIP report with increment date and timestamp?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Lalit Sinkar 215 views 5 comments 0 points Most recent by Angela Valcelli Reporting and Analytics for ERP
-
Accessing Usage Metrics Drill Through ReportsWe are using version 22B. I received an email about accessing a usage metrics report showing user license consumption. However, I fail to find how to locate / generate t…
-
Get Service Usage Metrics Drill Through report on demandSummary: Get Service Usage Metrics Drill Through report on demand Content (please ensure you mask any confidential information): Hi We need have the information about me…Jazmin Saldierna 1 view 0 comments 0 points Started by Jazmin Saldierna Reporting and Analytics for ERP -
Matching Report = Account in Rows behaviourSummary: Content (please ensure you mask any confidential information): Hi all I want to know what is the exact behaviour of "Accounts in Rows" within Intercompany Repor… -
Is there a payroll report that compares the current payroll to a previous payroll?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Passing multiple person numbers as input parameters in HCM ExtractSummary: To pass multiple person numbers as input parameter in HCM Extract Content (please ensure you mask any confidential information): Trying to pass multiple person …
-
Unable to add a new field to oracle seeded report "Payable Trial Balance Report"Summary: We have a requirement to add a new field "Vendor_name_alt" to seeded report (Payable Trial Balance Report), after added new field and ran ess job it is throwing…SireeshaJaladi 51 views 4 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Access SmartView from Word and connect Oracle Planning reports , without having Narrative ReportingHello, Is it possible to access SmartView from Word and connect Oracle Planning reports (made with reports and not Financial reporting) without having Narrative Reportin…
-
Create infolets with the use of FDI reportsHello, We have been implementing the new reporting tool of FDI and we have been asked if it is possible to create Infolets for the FDI reports in the home page of Oracle…Ioannis Adamou 11 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Adding additional column to get headcount for each month in OTBISummary: How to add additional column or calculated item to get the head count for every month? Content (required): I am using 'Workforce Trend Real time Subject Area' a…Raghavendra M 376 views 17 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Project to GL Reconciliation ReportCan you confirm if there is an existing Project to GL Reconciliation Report? We are trying to check if there is a counterpart for Projects. Sample is attached screenshot…
-
Which SQL Table store the Activity Information of Time Entry in OTL.Which SQL Table store the Activity Information of Time Entry in OTL. Please share the inputs if you know -
How to Burst Email and FTP Output Delivery from the Same Schedule in BIP Report?I have a data model and a report in BIP, and there is a requirement to distribute the report output both by email to HR representatives and also to store the output on a…JayeshKori-Oracle 72 views 2 comments 4 points Most recent by Ketan Janva-Oracle BI Publisher Learning Center
-
How to find the revenue_category_id from revenue_category_code in PPMI need to filter data using revenue category code in PPM. Revenue category code is kept in PJF_REVENUE_CATEGORY lookup. Now when I use joins in PPM table they are holdin…