Reports
Discussion List
-
Explanation / Description of values in STATUS column in pjc_expend_item_adj_acts TableSummary: Looking for help identifying the description / explanation of various statuses in the pjc_expend_item_adj_acts.status table. These are the values we see in that… -
FA Asset Addition and FA Asset Register reports lexical parameter and Temporary tableHi , Both of these reports use lexical parameter &l_fa_whatif_rep_t. We want to understand how this parameter value is derived. We tried to use fa_whatif_rep_t table, to… -
Reporting on Payment ApprovalsSummary BI Publisher or OTBI Report to extract Payment ApprovalsContent Hi Community Are there are any BI Publisher or OTBI Reports available to report on Payment Approv…Kunal Daya-175386 201 views 5 comments 0 points Most recent by Marko Puskac Reporting and Analytics for ERP
-
Project Costing - Unprocessed Transactions Real Time Cannot see people namesI have one user who has all seeded Project roles and the proper access defined and is not able to see people names in the analysis: Project Costing - Unprocessed Transac…erpexpert03 11 views 1 comment 0 points Most recent by Clara Azoitei-Support-Oracle Project Management -
Need Cleared check report in Oracle fusion without reconciliation processSummary: Hi, The business is using check payment method and issuing checks and they are using cash account when they issue payments. So there is no reconciliation proces…
-
Report Data is incorrect because Time zoneHello, we just recently faced an issue related to BI report on absence related data. It will give last one hour updated records of employees absences. (submitted/awaitin…Dara Nagasai 11 views 4 comments 0 points Most recent by Vanitha Kundaram Reporting and Analytics for HCM -
Purge User RequestsSummary: Purge User Requests Content (please ensure you mask any confidential information): There is a way to purge a specific request? I'd like to purge some requests f…Luca Nobili PWC 34 views 3 comments 0 points Most recent by Luca Nobili PWC Reporting and Analytics for ERP
-
Unable to find audit logs for archive or unarchive activity on BIP data model/report in ERP FusionOur client has a requirement to build a BIP report for audit purposes that can fetch information, such as when a user archives or unarchives the BIP data model or report…
-
Control report-level permissions during migrationSummary: We have a custom folder ("Folder A") with 4 roles assigned: Role A, Role B, Role C, and Role D. When a new report is migrated into this folder, it automatically…
-
Does anyone know what table does the Absence Management Type time attribute belong to?Summary: We currently have Payroll Time Type and Absence Management Type configured for the Time Entry Layout Components in our system. We already found that the HWM_TM_…
-
Send reminders to the employee based bip report burstingSummary: Send reminders to the employee based bip report bursting Content (please ensure you mask any confidential information): Hi Team, I have a requirement. I need to…
-
Conditional formatting issue in ReportsSummary: I have a basic grid with a couple of formula rows and then a second reference grid which I pull the results of the main grid formulas into, using the CellValue(…
-
Is the 75000 row limit for OTBI reports just a limit on the output?For an OTBI report, the SQL automatically adds "FETCH FIRST 75001 ROWS ONLY." Is this only referring to the output of the report? Or is it also referring to the total po…
-
How to delete page entry which are created using structure toolSummary: How to delete page entry which are created using structure tool Content (please ensure you mask any confidential information): Hi All, We created page entry(Rep…
-
Justify Alignment in Text BoxSummary: We have created an 83-page reporting package in Narrative Reporting with FCCS as the data source. The Reporting Package is an external audit financial reporting…
-
-
Report listing active users with current and past assigned roles (with start and end date)Summary: Report listing active users with current and past assigned roles (with start and end date). Content (please ensure you mask any confidential information): Clien…
-
Question Mark is appearing after each row in etext outputContent Hi, Question Mark is appearing after each row in etext output. How to remove? Thanks in advance. Regards, NivyaNivya Mathire 121 views 6 comments 2 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Custom Budget Report - Hierarchy LevelHi, We're creating a custom budget report to convert the currency values according to the user preference. But when capturing the Hierarchy Level column with a manager t…Khel 11 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Can we format the Out Of The Box Journal reports and ICP reports like font or color?I would like to know the flexibility of editing format of the OOTB Journal reports , ICP report? can we get that option if we raise the enhancement request?MeghaC 11 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Unable to fetch retro time card adjustments from the HCM backendHi All, We have a requirement to pull retro time card adjustments through the Changes Only HCM Extract. However, we are unable to fetch these adjustments from the HCM ba…
-
Values not populating in 'Recruiting - Recruiting real time' subject areaHi Oracle community, When we create an analysis using the 'Recruiting - Recruiting Real Time' subject area, filter the results to show only the Recruiting Type 'Offshore…Alyssa T. 63 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
What particular role or privilege needed to gain access to Manage Report Jobs page?Summary: What particular role or privilege needed to gain access to Manage Report Jobs page as well as the list of scheduled report jobs? Here's the example:Welsey 94 views 9 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
Replace/Remove the Slash Symbol (/) in Folder Names - upcoming considerationSummary: Replace/Remove the Slash Symbol (/) in Folder Names - can someone confirm if this relates only to folders created in the application (like in Data forms, Report…Anne-Marie M 12 views 0 comments 0 points Most recent by Anne-Marie M Profitability and Cost Management
-
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 13 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…
-
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…