OTBI
Discussion List
-
How do i access "Procurement Audit Details Report" in Oracle Fusion?Summary: How do i access "Procurement Audit Details Report" in Oracle Fusion? Content (required): How do i access "Procurement Audit Details Report" in Oracle Fusion? Is…AkashAgarwal 41 views 2 comments 1 point Most recent by SrikrishnaKarnatapu Payables, Payments & Cash Management -
Enable to get the output from the "Person Profile Real Time” subject areaSummary: Enable to get the output from the "Person Profile Real Time” subject area Content (please ensure you mask any confidential information): Hi experts, we want to … -
Is it possible to show/identify the job family for the Line Manager in OTBI Analysis ReportAs per business requirement I am creating a OTBI Analysis report to identify/highlight job family (Thru Conditional Formatting) for direct manager. For example, if a Dir… -
Payment Status: Pending action to address payment validation errors.Summary Payment Status: Pending action to address payment validation errors.Content Hi All, Payment Status: Pending action to address payment validation errors. Thanks, …Devendra Thota 272 views 2 comments 3 points Most recent by Senthil Mohanraj Payables, Payments & Cash Management
-
Overdue count for 'Not Passed' courses is '0' in OTBISummary: Hi, The overdue count for Not passed courses is 0 in OTBI. When selecting learners that have an overdue date for course completion and have not passed the cours…
-
Restricting BI Publisher folder not workingSummary: We are trying to restrict folders in BIPublisher using the roles. However it seems , this is not working. like Folder /shared/Custom/Human Capital Management/Be…
-
Employee Job HistoryHi I am looking for a data mart/query I can use that provide employee job history. For context, here is what I am looking to do. If we hire an employee into a specific r… -
Multiple assignment abseSummary: Hi, I am trying to create a report for absences that are assigned at assignment level. As you can see from the image attached the moment a column is added from …
-
Unable to view job history of custom reports in Oracle FusionSummary: I have BI Author, BI Consumber, and BI Administrator Roles assigned to my profile. I'm trying to view Report Job History for a Customized version of the Receipt… -
Working of CreditCheckingService SOAP WebserviceSummary: Working of CreditCheckingService SOAP Webservice Content (please ensure you mask any confidential information): Hello Team, We would like to know how the Availa…
-
Reports in Case ManagementSummary: Case Management has been introduced as part of Next Gen Help Desk. Could anyone please share your inputs if there are any subject areas available to build repor…
-
We have OTBI report but need to convert to Dasboard how can I develop ?Summary: Hi Team, We have OTBI report but need to convert to Dasboard how can I develop . Any one help me on I'm new to dashboards ? Thanks, Ajay Content (please ensure …AjayKumar Maddipati 41 views 7 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Level 02 Organization Name (Business Area) Not Showing UpSummary: We are currently in the process of implementing ORC and we are trying to create some dashboards that we can use for requisition/candidate data. When we run the …Kyle Norris 131 views 20 comments 1 point Most recent by Kyle Norris Reporting and Analytics for HCM
-
Milestone date showing as Hire Date in Long service Employees Report ?Summary: Hi Team We have long service employees report on who completed the 5, 10, 15 years like and we applied filter on as below. TIMESTAMPDIFF(SQL_TSI_YEAR, "Worker".…AjayKumar Maddipati 21 views 6 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
how do I modify the General Ledger and Subledger Account Analysis Report to add address and tax idSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
OTBI Agent to send to HR Business Partner via Username in the agent not sendingSummary: I am setting up a new agent to send via email to users. it is being created by conditional analysis. Get Recipients from the Analysis Used in the Agent Conditio…
-
Need inputs to get the YTD, QTD, MTD balance values using Pay_run_balances tableSummary: Need inputs to get the YTD, QTD, MTD balance values using Pay_run_balances table Content (required): In the Pay_run_balances table able to see "RUN" related bal…
-
We have performance rating report How to fetch latest rating record in OTBI Report ?Summary: Hi Team, We have performance rating report for inactive employees but we need only last rating but in my report showing all years rating. how will get ? Thanks,…AjayKumar Maddipati 71 views 8 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
Combing Two Rows into One Based on Person NumberHello everyone, We're working on the earnings report and there are some employees have two assignments for one year. We are looking for the solution to combine them into…Yiming Xiong 21 views 10 comments 0 points Most recent by Yiming Xiong Reporting and Analytics for HCM
-
Unable to retrieve the data from OTBI Analysis when two subject areas are addedSummary: In BI Publisher application, the requirement is need to add the contract number(Subscription Number) and known as columns to the customer contact information OT…Chandana Priya-Oracle 63 views 2 comments 0 points Most recent by Chandana Priya-Oracle Reporting and Analytics for SCM
-
Payables Module: Specific tables and fields where the employee banking information is stored?Summary: I've been asked by one of our internal auditors the following 2 questions specific to the Oracle Accounts Payable module: List the specific tables and fields wh…K Hart13 229 views 5 comments 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
OTBI Link between Negotiation and Outcome Document (AG/PO)Summary: When Purchasing document is created thru a Negotiation, there is no reference number of either AG/PO in any of the OTBI Subject areas Content (please ensure you…
-
how to add months 24 to a date field in the OTBI Report FilterSummary: I would like to add 24 months to length of service date field using case when. Please provide the code how to write in OTBI Content (please ensure you mask any …Anjan Polimera 81 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
Custom Report - It is possible to translate Layout name i an RTF type reportHello, We have a OTBI report created with a RTF template. In the report, we have by example an Layout name call Approval_RTF. When we attach this report to a dashbord an…Patrick Turcotte 31 views 2 comments 0 points Most recent by Patrick Turcotte Reporting and Analytics for HCM
-
Rcount sort orderSummary: I need to know what controls the sort order for the RCount function. I have a requirement to select one assignment per person from worker assignment real time S…
-
Issue while adding prompts to a pivot view of an OTBISummary: Not able to add and apply prompts to pivot view of an OTBI analysis Content (please ensure you mask any confidential information): The requirement I have is to …Vibha Pandey - Oracle 11 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Payroll Relationship - Element Duration Dates - Final Close DateContent Hello, We're keen to build a report that shows the final close date using OTBIEE Answers (subject areas), however when included this appears to be on the relatio…Kevin M Storrie 197 views 12 comments 0 points Most recent by Sharon Harper Reporting and Analytics for HCM -
Unable to acheive trend analysis using prompt for accounting year in OTBISummary: Unable to use Time series formulae in OTBI to fetch YTD data for past 5 years/ for 5 years based on prompt Content (please ensure you mask any confidential info…Madhuri Kovuri 1 view 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Expenses Module: Specific tables and fields where the employee banking information is stored?Summary: I've been asked the following 2 questions by one of our internal auditors, specific to the Expenses Module: List the specific tables and fields where the employ…