OTBI
Discussion List
-
Active Bank Accounts with different Display NamesSummary: I have a request to create an OTBI report which shows the active banks accounts with different Display Names against them, these names are likely to be spouses … -
showing a historical assignment as latest for some employeesSummary: We have an issue where the top (or Max) row is not returning the correct row! Instead of returning the current assignment, it is returning an old assignment for…
-
Workflow Transactions/Transaction Console Reporting (Rel 13)Content Hello, Just checking if anyone managed to create any Transaction Console related reports out of these two subject areas: 1) Human Capital Management - Transactio…SantoshKumarBhairi 910 views 11 comments 4 points Most recent by Samarpan Reporting and Analytics for HCM -
Project Control - Budgets Real TimeUsing Project Control - Budgets Real Time subject area need to showcase Budget Cost in Project currency as well as in Ledger currency but unable to identify the dimensio…Kalyani-Oracle 21 views 3 comments 0 points Most recent by Kalyani-Oracle Reporting and Analytics for ERP
-
How can we replicate the Budget Analysis from Administration report in CompensationHi, We want to replicate as a OTBI Analysis the Budget Analysis from Administration report in Compensation in order to have information about the Overall Budget amount f…Crisenese 21 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Joining two subject related to project and project program.Summary: I want fetch project customer name based on project name for which program is assigned for this project program performance reporting real time, in this subject…
-
Cost Center details in Purchasing- Requisitions Real Time Subject AreaSummary: Cost Center details such as Cost Center code and Cost Center description in 'Purchasing- Requisitions Real Time' Subject Area Content (please ensure you mask an…Srinivas Reddy 21 views 4 comments 1 point Most recent by Srinivas Reddy Reporting and Analytics for ERP -
How to return only the max ID grouped by selected column (SQL)?Summary: Content (please ensure you mask any confidential information): I am working on an OTBI report that uses Advanced SQL to create the analysis. The reason for usin…Giuseppe Cannova 21 views 4 comments 0 points Most recent by Giuseppe Cannova Reporting and Analytics for HCM -
Oracle hcm cloud seeded reports what is the list of reports and their locationHello, I would like to know please, what is the list of Oracle hcm cloud seeded reports ? and where they are located ? for example : employee contact ,employee address ,…Revital Mefano 667 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
How to capture Tax Registration Number at Supplier Address level in OTBI reportSummary: Requirement is to populate Tax Registration Number from Supplier Address level in OTBI report Content (required): I have created an OTBI report for Supplier Mas… -
Default the accounting period parameter to adjusting period when running create income statement cloOur client is looking for an official response from SR Engineer, so please reply and do not tag it as CCC. Is there a standard functionality in the system to default the…Butch Melvin 1 view 1 comment 0 points Most recent by Lakshmi Alagappan-Oracle General Ledger & Intercompany
-
OTBI IssueHi There is an existing OTBI report which attached below. Now the customer requirement is to add the below condition. But on adding this, the count is reducing. Please s…Dona Das-Oracle 31 views 5 comments 0 points Most recent by Bharat Agrawal Reporting and Analytics for ERP
-
Payment infotile on the Invoices landing pageSummary: Starting Update 22C, the Payment infotile on the Invoices landing page is no longer be available. Has anyone recreated the Infotile, and can share? Content (req…AVorster-Oracle 31 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management -
OTBI Data Missing After Excel ExportThere are two instances with OTBI reports where I have gotten the message below that have impacted reports. In one report, hyperlinks are not working, and in another, ro…Alexander George Demczak III 24 views 2 comments 0 points Most recent by Sarma Yeddanapudy-Oracle Reporting and Analytics for HCM
-
Can anyone suggest some tips to optimize SQL queries for slow running BI reportsSummary: Can anyone suggest some tips to optimize SQL queries for slow running BI reports. Please share your thoughts. Content (please ensure you mask any confidential i…Lucky Sharma 31 views 3 comments 0 points Most recent by Lucky Sharma Reporting and Analytics for ERP -
We have BI report but need to send custom schedule like 1st monday, 3rd monday in a monthSummary: Hi Team, We have BI report but need to send custom schedule like 1st monday, 3rd monday like this in a month how will send if through burshting how can we send …AjayKumar Maddipati 21 views 6 comments 0 points Most recent by Dhilip Kumar P. Reporting and Analytics for HCM -
Sales Order EFFs not showing up in OTBISummary Sales Order EFFs not showing up in OTBIContent Hi Experts, We have created few EFF in the Sales Order Header (with BI enabled), those EFF are not showing up in t…Sunil Dabekar 231 views 3 comments 0 points Most recent by Viswanath-Oracle Reporting and Analytics for SCM -
Where can I find the Payment Number for Payables on OTBISummary: I'm trying to pull together a report listing payments made to suppliers and need to include the the Payment Reference Number (i.e. the cheque, payable order (PO…
-
Sample SOAP request payload for OTBI Analysis extractSummary Sample SOAP request payload for OTBI Analysis extract using variables or filter criteriaContent I have an OTBI analysis based on the "Procurement - Purchasing Re…
-
Unable to join Product management OTBI subject areasSummary: Hello Community, I have a requirement where I need to pull the Royalty data from the "Where Used" part of PIM. As part of that we are trying to join below subje…Sai Revanth 11 views 3 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM
-
which table can store the information about user's parent & child relationship roles in fusion hcmHi All, Thanks for looking into this issue. I am looking for table, which can store the current logged user parent -child roles(for Ex: One big role have more number of …Ravindr-Oracle 101 views 10 comments 0 points Most recent by Rajesh.Vadlamani Reporting and Analytics for HCM
-
24B FTP server errorSummary: We have certain BIP Reports setup in various environment and most of them have no issue except Dev1 environment, which was updated on 24B and when reports jobs …
-
How to download a detail report containing all fixed assetsSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t… -
When manager run the BI report only need to get the details of direct or indirect reportiesSummary: HI Team, When manager run the BI report only need to get the details of direct or indirect reporties how can we develop this requirement? Thanks, Ajay Content (…AjayKumar Maddipati 11 views 1 comment 0 points Most recent by Ellen Manthei Reporting and Analytics for HCM
-
Talent Pools - Succession Plan KPI reportSummary: Need to build report using below fields - either OTBI or BIP. Kindly help please. Content (please ensure you mask any confidential information): Column Name Des…Pradnya_Pampatwar 21 views 1 comment 0 points Most recent by Pradnya_Pampatwar Reporting and Analytics for HCM
-
What is the diffrence between Date start and Orginal_Date_of_hire in PER_PERIODS_OF_SERVICESummary: Hi Team, we have to two columns for Hire_Date in PER_PERIODS_OF_SERVICE table what is difference between. if not why two columns given. Thanks, Ajay Content (pl…AjayKumar Maddipati 54 views 2 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
Expense report with attachment informationHello All There is an option in BI to inform that the expense report was created with an attachment, we need to create a report with this information. Has anyone had thi…