-
Hide or make null a value in pivot table
Hi all, I am building a pivot table as per the above and as you can see the total shows a value of less than 10 which is contrary to our policies. How do I make the row and total show null or have 'Less Than 10' instead please? Any ideas would be greatly appreciated please.
-
What occurred when FUSION_APPS_HCM_ESS_APPID was the last update user, a month after termination?
We are using the Subject Area User System Usage to show our Auditors when a User last accessed the system. We were hoping to use this subject area to also show when the account was locked. There is a field called Last Update Date and the content is showing that a mass update occurred by FUSION_APPS_HCM_ESS_APPID one month…
-
Printable PDF of our Dashboard is distorted, It's not the same as it looks on dashboard/ portal page
Hi all, When we click on Printable PDF of our dashboard, it doesn't give out exactly a neat format (as shown in attached file) . On the Dashboard it looks fine. But when the PDF is generated the charts are all here and there with misalignments and charts up and down. Dashboard PDF Screenshots (1).pdf
-
Checking audit for the saved customization report
Several users are experiencing deletion of saved customization report in OTBI. As for their experience, it happens once or twice a year. Is there a way to check the logs of the deleted saved customization besides from the audit report? For this year, it occurred last February to march 2024.
-
derive FTP output parameters - Remote Filename and Remote Directory automatically
HI, We have created BIP reports with pl/sql type and when we try to schedule them with output option → FTP, it requires to input Remote Directory and Remote Filename. Is there any option to get those values from lookup or any other way to avoid human errors ?
-
How to filter Scheduled Ship Date based on Pacific Time Zone (PST/PDT) in OTBI Reports.
I have an OTBI report that retrieves a list of orders with missed scheduled ship dates. The filtering criteria for the report is set as "Fulfillment Lines - Scheduling Details"."Schedule Ship Date Fline" < (current_date), and it's filtering based on the UTC timezone. Is there a way to modify this report to filter results…
-
New Headcount Planning in Workforce Job level Granularity
We are looking for a solution of updating Start Date and adding new Headcount/Hire for a new/existing jobs in the middle of Plan/Forecast Year. Since the compensation calculation is based on Start date, we cant update start date for a new/existing jobs while adding new headcount/Hire. it will impact the existing…
-
Unique privilege or grant identifies the primary user- Security Console
A user with the "Application Implementation Consultant" role has permission to view all Business Unit information. This role (ORA_ASM_APPLICATION_IMPLEMENTATION_CONSULTANT_JOB) can be copied and assigned to other users (secondary users). Question: What unique privilege or grant identifies the primary user (with the…
-
Need to display the custom error message on OTBI reports. Please provide the workaround
Need to display the custom error message in OTBI report , wherein error message is displayed basis the report column value whether the same is in correct format or not . We are not looking for error message that can be derived from Criteria tab
-
Subject Area: Project Billing- Invoices Real Time
When using the Fusion OTBI subject area; - Project Billing- Invoices Real Time; the field 'Invoice Number' does not return any data for ALL records. Can anyone confirm if this field works (produces output and if so from exactly where, is this AP / AR Invoice Numbers?) and if not if there is any work around for this? thanks…
-
Conections reports oti bi
Hi, I need to create a report about the last conections and the fisrt one when the user enter in tha plataform HCM Cloud Thanks
-
Oracle Incentive - OTBI - Participant Position
I am looking for Participant Details along with his/ her POSITION from OTBI. Any pointers on which subject Area to be used. I can see Participant Details in few Incentive Related Subject Area but not POSITION of Participant. Please confirm
-
Excel compatibility with Oracle BI?
We are using the version of Excel 1997, which is too old and is only capable of threat with 65,000 lines. Which other versions of Excel are compatible with Oracle BI Cloud in order to extract higher data documents? Thanks.
-
Estimated End Date associated with an Absence - OTBI
I am having trouble getting the Estimated End Date associated with the absence to pull into an OTBI report. Is there a way to pull in this value?
-
Advice needed. Got a request to create a new role for OTBI access only; no access to BIP.
The role will need the following access in OTBI: Ability to create, edit, delete, archive and unarchive reports in the My Folder No Ability to create, copy, modify or delete reports in Shared Folders of OTBI. No Access to BIP reporting
-
Filter results of an OTBI report based on logged in user
I am creating a data model for approval transactions. Is there a way to filter the results of the approvals based on the logged in user (Approver)
-
Duplicate element entry report with entry details
I have a requirement where I need to report on more than one element entry for a person where the input values differ. Attached is the OTBI analysis details on how I have developed but I need to correct in a way that it gives me only two rows with the input values and displayed value as columns to the element entry. In the…
-
How do I get the performance tiles to aggregate properly when using multiple subject areas?
Hello Experts, I've run into an issue when creating performance tiles from joined subject areas. The tile (using a simple count measure) I'm using seems to aggregate properly when in the compound view, but when the tile is in edit view or on another dashboard, it only displays a one. Is there a better way to set up the…
-
Report Job History defaults
Hello, When searching for the reports I recently ran, by navigating to Report Job History, it defaults to 1 week ago date, slowing down the search itself. How can we change this default to 1 day?
-
How to move BIP report extraction output file from UCM to object storage
Request is to move the BIP report output file from UCM to object storage . Please advice if there is any configuration to be done at HCM side so that BIP output files can be sent to object storage
-
Line Manager Email notification with their Employees Due and OverDue Trainings
We have the OTBI report that sends an email to line managers with their direct reports due and overdue trainings via agents. And, we have recently found that, there is a line manager who has 64 direct reports and the report is failing to send the email to this specific line manager. Has anyone experienced this issue and…
-
Audit Related: Last Logon Session
Summary Last LogOn Session: Looking for a audit related report that shows last time accessing Oracle Content I am able to query HCM related tables (such as per_users) to find data necessary for audit - which provides information when a new user was created, termed and if the user is Enabled/Disabled - along with roles.…
-
Security and users access to Oracle
Hi Gurus, can you please assist in what best practices available to control the below points in Oracle fusion, and is there any report from Oracle that show last activity for any user for monitoring purpose. Point 1 Administrators users changes to the system full report Point 2 Monitoring user access rights and the…
-
Fixed Asset Register report returns current period date instead of selected past dates
Fixed Asset Register report is not working when you select a date in the past like OCT 2023. it only returns the current Open period after running depreciation. How will resolve this issue, even after changing the parameter to Data type from text to Date parameter.
-
How can two different teams can use a single PVO with different set of columns
Hi, We have a scenario where AP team can extract ledger PVO with different column set and similarly AR team also need to extract the same PVO with different column set. how can we implement this solution.? FYI : ODI will be used to Extract the data from PVO's Thanks, Anil.
-
Budget Distribution Data in OTBI Fusion
Is there any subject area in Fusion OTBI that contains data from the following budget distribution tables: xcc_budget_dist_lines xcc_budget_dist_headers Currently, I can only see subject areas for budget balances and transactions.
-
How can I join the DOO_HEADERS_ALL table with PO tables like PO_LINES_ALL in Oracle Fusion ?
I’m working on a BI report for order and item details like order number and item number and description in Oracle Fusion, and I need to join the DOO_HEADERS_ALL table with other PO tables like PO_LINES_ALL. However, there’s no direct common column between them. How can I effectively link these tables to retrieve relevant…
-
IBAN for OTBI analysis
Hello experts, we want to create an OTBI analysis with the IBAN info of the employees, does anyone know which subject area and which column we need to use? Thanks a lot Regards.
-
query find history candidate pools in its different phases
Hello. In which tables or subject area we can find the status history in its different phases of candidate pools. Thanks and regards.
-
Get current and future termination EE records in OTBI
Hi, We are trying to build a demographic file that should pull the data of EEs as of system date and also future terminations in next 7 days. I have tried using the prefix but I could fetch current date+7 or current date but not both. I am using Workforce Management - Person Real Time, Workforce Management - Worker…
