Reports
Discussion List
-
How to restrict the data in OTBI report based on AOR (Area of Responsibility)We have created HCM reports from the Absence module, Goals and performance, etc. and we need to restrict the data based on AOR. Is it possible to restrict the data in th…Vikas V. Kamat 202 views 7 comments 0 points Most recent by GPOtimization Reporting and Analytics for HCM -
OTBI Worker Attributes Changed After Redwood EnablementSummary: Our reports stopped working in Production after migrating to Core HR Redwood. We’ve observed changes in OTBI column attributes when comparing Redwood and non-Re…Josel Pleyto 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Can you help me add the assignment status (Active/Inactive/Suspended,etc) to this SQL query?Summary: Hello team! I have this code, but I don't know how to add the assignment status (Active/Inactive/Suspended, etc). Could you please help me with that? Thank you …Claudia Linares L 103 views 13 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
The extract chunking task does not generate the default XML(at least parameter data) file.Hi Team, We observed that when there is no data to chunk, the extract chunking task completes successfully after 25C; however, it does not generate the default XML file …
-
Where are project asset details (and additional details) stored?Summary: Looks like the central project asset table is pjc_prj_assets_all. In the UI there's additional details areas that I'm not seeing a corresponding table. I'm spec…Jason Parker 1 view 1 comment 0 points Most recent by Clara Azoitei-Support-Oracle Project Management -
Absence calendar seeded report does not show any dataSummary: Absence calendar report does not show any data Content (please ensure you mask any confidential information): Could someone advise why does the data does not po…
-
Create an alert or mail delivery system for a sequence in OACI have a sequence in OAC. The sequence has multiple data flows present. I need to setup some sort of alert so that I get an alert in case a data flow fails. How to get t…
-
Migrate Reports from one instance to otherSummary: Need help to migrate Report from 1 instance to other Content (please ensure you mask any confidential information): I exported the report using Snapshots. But w…
-
How to setup global POV name as Alias in Report PBCS?Summary: Hi, I am having trouble finding the setting for the global POV bar on the report display name. My client wants it to display as an alias, but I cannot find the …
-
Failed to select any new views or all views that you requested to built exist alreadySummary: We are using Optimize Aggregation schedule job on a ASO cube, received below error Failed to select any new views or all views that you requested to built exist…
-
Cross Reference Grid Oracle EPM ReportI created a cross reference grid. I can view both grids (Grid 1-Actual Report Referencing to Grid 2-Data). I can view both grids but a user all of a sudden cannot view t…
-
Assistance Required: Identifying Primary Keys and Table Relationships in Oracle ERP BackendHi Team, We require information on the primary keys and relationships between Oracle ERP backend tables. We are currently retrieving primary key details from the "FND_PR… -
Need Table Storing Bank's "Active" Flag from Personal payment Methods ScreenHello, I'm trying to locate the backend table that stores the "Active" flag status displayed on the Personal Payment Methods > Bank Information screen in Oracle HCM (Sel…Jahnvee Sharma 32 views 1 comment 0 points Most recent by Carl Bequilla-Oracle Reporting and Analytics for HCM
-
Can't inquire into Invoices in the system using Action Link in OTBISummary: Hi. I'm trying to create OTBI Report that will show outstanding Invoices (Unpaid after Due Date is already Due). I'd like to add Action Link, so user will be ab…Yftach Paschur-Oracle 2 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP -
convert period to a number and use in formulaI need to convert the period to a number (e.g. Oct = 1, Nov = 2, etc…) and then use that number in a formula to divide one of the amounts by that number. I was able to c… -
In which table does the Candidate Job Application Fields are storedSummary: Hi Everyone I have loaded the Candidate Job Application into the system using HDL. So I'm trying to fetch those loaded fields using SQL for verification. Conten…Sujeeth Chinta 718 views 4 comments 0 points Most recent by Emerson Oliveira Reporting and Analytics for HCM -
Data Extract from EPBCSOracle Team: I know that we have the ability to create visibility into Oracle Fusion ERP by creating data models to extract data from the base tables in Oracle Fusion ER…
-
convert period to a number and use in formulaI need to convert the period to a number (e.g. Oct = 1, Nov = 2, etc…) and then use that number in a formula to divide one of the amounts by that number. I was able to c…
-
Labels placement on Bar chart in narrative reportingHi, We are looking for labels outside the bar chart as the width of the graph is less, numbers are not showing on the graph due to small value of the data. e.g. In image…
-
OTBI Report with Payments Disbursements and Invoices with Invoice distributionSummary OTBI Report with Payments Disbursements and Invoices with Invoice distributionContent I am trying to create a report that shows only the invoice expense account …User_2025-02-06-00-15-19-515 761 views 3 comments 0 points Most recent by J Dimond Reporting and Analytics for ERP -
BI Report access issueSummary: Hi, One of the users is unable to access the BI report. When he tries to access it, he getting the error shown below. But, he is able to access the report from …DHILNA P 1 view 2 comments 0 points Most recent by Yves_Guyon-Oracle Reporting and Analytics for HCM
-
OTBI output is different for 2 different usersSummary: Hi, We have a custom OTBI report which is scheduled to send report to the Business Users. This report shows that 100 employees have missing family contact infor…Sailajad 21 views 8 comments 0 points Most recent by Yves_Guyon-Oracle Reporting and Analytics for HCM -
Issue: Unable to expand Calculation Components Detail folder in Payroll - Calculation Cards Real TimSummary Users building reports on Calculation Cards Subject Area when try to expand Calculation Components Detail folder, the folder doesn't expand. Solution is provided…Tanvi Jain-Oracle 161 views 1 comment 2 points Most recent by Al Darabaris Reporting and Analytics for HCM
-
View Reports and AnalysisSummary: View Reporting and Analysis on the Cloud Help Center Content (please ensure you mask any confidential information): There used to be a link for Reporting and An…AVorster-Oracle 22 views 4 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
Qualified Member Name from Reports output cannot be recognized when perform ad hoc analysisSummary: We move Financial Report to Reports then the output for member qualified name display only with dot and without bracket. This display cause error when perform a…
-
[FTPProcessor]Delivery to SFTP completed with failure oracle.xdo.delivery.ssh2.SshException: TimeoutSummary: [FTPProcessor]Delivery to SFTP completed with failure oracle.xdo.delivery.ssh2.SshException: Timeout waiting for response from server. Content (please ensure yo…
-
Add Business Unit as an additional parameter in the Run Gross-to-Net ReportWe have a requirement to include Business Unit as an additional parameter in the Run Gross-to-Net Report (Gross to Net Summary Archive) so that the report can be generat…
-
Report to say if employee has any direct reportsContent Hi, have a simple report that says something like PERSON NUMBER | Name | Department. I need to add an additional column that returns yes/no for if that employee …Mike Borghoff 128 views 7 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM