-
Export to Excel in OTBI Dashboard
Summary: How to export all pages in a table analysis within a dashboard Content (required): We have developed a OTBI dashboard which contains a table based analysis. User wants to export all the rows in the analysis but whenever we do "export to excel" --> "export entire dashboard". it only exports the current display page…
-
How to extract the details of the Employee and there Line Manager / Supervisor details ?
Hello All, We are trying to extract the details of the Employee and there Line Manager / Supervisor details for all the employees. Is there any Standard report available or do we need to write custom OTBI reports ?
-
Need Employee Human resources Representative and HR Business Partner
Dear Expert, Can someone help me to get the query or subject area where i can get employee Human resources Representative and HR Business Partner. Example- Employee is John and i wanted to know who is Human resources Representative and HR Business Partner for john. Thank you!
-
How to get the last incumbent date for vacant positions
Hi Experts, Looking for a sample report to get whether the position ever had an incumbent and if so what the last date the position was filled. I have been able to get which positions are vacant, but not able to find when the position got vacant Regards, Nivya
-
Organization Hierarchy: using the value of one field as the heading for another.
If the content of the field "Organization Hierarchy"."Level 01 Organization Classification" is "Division", how can I use this content to be the column heading for "Organization Hierarchy"."Level 01 Organization Name"?
-
Need Table mapping between oracle EBS and Fusion
We have found that below tables are accountable for W_PRODUCT_LOT_XACT_FS in Oracle 11g . Can you provide corresponding Oracle fusion table names?…
-
add invoice life cycle details to OTBI analysis?
Is it possible to add the Order Life Cycle details to an OTBI analysis? We have created OTBI analysis using subject area "Procurement - Purchasing Real Time". Now we want to add data to this analysis that shows the details of the Order Life Cycle. How much was Ordered, Shipped, Received, Delivered, Invoiced. (Invoiced is…
-
SQL query to get Budgetary control Transactions in oracle fusion financials
-
How to use attachment tab in datamodel ?
Hi Experts, How can I attach FAQ document to the bursting query? I could see a attachment tab next to busting query. Can anyone share sample query to get document from content server? Ref:…
-
How can i do Join in this two suject areas Human Capital Mgmt – Transaction X Document of Records
We need the report to documents of records and datas about approvals in Console Transaction. We are using this subjects areas: Human Capital Management – Transaction Administration Real Time Workforce Management - Documents of Record Real Time We cant identify the common attribute to join this subject areas Regards
-
Report to see who opens and closes an accounting period
Looking to create a report that shows what user opened and closed an accounting period. Including username, date, time, ledger name, etc. I've been looking at a subject area under general ledger -period status real time but I'm not seeing the info I need there. Is there another subject area that I could use to make this…
-
What table houses data related to user login times?
-
OTBI - Education reporting
Hello, I was going to create a OTBI report in order to map the employee education level, major, school etc but I'm not able to look for specific items to be added to the report such as MAJOR, SCHOOL etc; Where i can find them and how to add to the report in OTBI? Thank you in advance for your time. Best, Asia
-
Can you please share any OTBI seeded AP Dashboard's ?
Hello I was wondering if you could please share with me any OTBI Dashboard that include any AP's KPI's Thanks
-
Create Data Model option
Hi, I have all the Application Admin and BI Admin/Author roles but in Reports and Analytics > Create > there is no Data Model option ? What role do i need to get this option ?
-
Pass oracle fusion fscmui url components to dashboard prompts as parameters
Hi All, We have a requirement from a customer to create a Dashboard for the Goals Center Page (Navigation: Me > Career and Performance > Goals Center). This dashboard needs to receive its parameter values directly from the URL components. Could you please confirm if this requirement is technically feasible within the…
-
Workforce Performance - Performance Check-In Real Time - issue with table prompts
Hello, I have following OTBI analysis : SET VARIABLE PREFERRED_CURRENCY='User Preferred Currency 1';SELECT0 s_0,"Workforce Performance - Performance Check-In Real Time"."Business Unit"."Business Unit Name" s_1,"Workforce Performance - Performance Check-In Real Time"."Check-In Details"."Check-In ID" s_2,"Workforce…
-
How do I show 1 row per employee based on ranked address type
Some employees have multiple address types on file. I am trying to show 1 row per employee based on address type. I want it show home address (address rank 1) but if none exist then show Mailing Address (Address rank 2). I created a case statement to assign address rank. thanks…
-
How can I get default results in a graph under a manager when the manager is the logged-in user?
I am using OTBI-analysis in creating curtailment report. It will be shown as infolet in Oracle Sales Cloud. I need 2 subject area because I need the default result of the graph to be the counts of curtailment under the manager. The result is incorrect because the managers username is not correct per account. This should be…
-
Seeded Learning Dashboard designs
Hi Team, We have a new requirement to develop a new learn dashboard. However, we would like to understand what oracle offered for customers. Can someone share seeded path for learning dashboard. Also, do we have any oracle document related to this? Thanks, Manisha
-
HCM Performance Check-in Status
Hello, We're using Workforce Performance - Performance Check-In Real Time SA to report on check)in meetings for performance but we don't seem to find in OTBI is the Check-in Status field (Draft, In-Progress, Closed). Any idea if this field is exposed in any SA in OTBI? (the only thing I could find related to check-in…
-
In Prod only after 25D GL Journals Real Time Analysis fails to work when a key FF values is selected
In Prod after 25D was applied recently. Create a new Analysis for GL Journals Real Time analysis. Simple columns - Journal Name, Period, Line Number, DR and CR This works fine. But add Balancing Segment Value to the output and no data is returned. On TEST which also has 25D applied this is not the case and the Bal Seg…
-
Status field for Employment Contracts (Oracle HCM)
Hello experts, we are creating an OTBI report with the Employment Contracts Real Time subject area and we have seen that it is available the fields Status and Status code, but what do they refer to exactly in the application? Because, if we look at the Employment Contracts page there is no Status field available, even from…
-
What privilege grants access to data in the Purchase Order Measures folder columns?
I have a user who is trying to use columns from the Purchase Order Measures folder in the Procurement - Procure to Pay Real Time subject area. I've created a custom role so that the user can report on Purchase Order data in OTBI and so far all the other columns are working as expected. I'm not sure what area (e.g.…
-
Supplier Registration Analysis?
Hello, Has anyone ever used OTBI to create an analysis showing info on suppliers, specifically which have access through the iSupplier Portal, and which are able to create invoices through the portal? I am attempting to create something that would show the top ten suppliers who don't have access to the portal, those who…
-
Report retrive data well by user who developed
Hi We have A Report RTF template work fine and retrive data when opened by user who developed the report while not working by any other user
-
Access procurement approval workflows in OTBI
Hello, Is it possible to access the requisition/order approval workflows to add into an OTBI analysis, the people that a requisition/order is pending to be approved? Thanks
-
SQL query for retrieving information from Work Definitions Table
We are having issues identifying the relevant table for work definitions and their associated operations/resources. Can anyone provide a query (or give some direction) on how we can retrieve the following: Work Definition Code, Work Definition Name, Work Definition Description, Start Date, Operation Seq Number, Operation…
-
PER_SHARE_INFORMATION table not returning any data
I came across the following code in one of the seeded query, but it isn't returning any data when executed. Could anyone help me understand what information is supposed to be stored in this table? Additionally, what settings or configurations need to be in place for the data to be populated in this table? SELECT 1 FROM…
-
Displaying the Receipt Date for the Purchase Order in PO Details Report
Summary Displaying the Receipt Date for the Purchase Order in PO Details Report Content Hi , I have PO Details Report with the following fields. PO Number, PO Date, PO Status PO Line Number PO Line Description Order Quantity Unit Price PO Line Value PO Line Received Quantity Total Receipt Amount Total Match Amount I am…
