OTBI
Discussion List
-
How to capture Tax Registration Number at Supplier Address level in OTBI reportSummary: Hello Oracle Experts, Currently the OTBI Report is showing only the Tax Registration number in the supplier Profile level under Transaction Tax. But we are capt… -
I need an SQL to extract ONLY the learner who have a completion date equal to Today minus 10 daysSummary: I want to create a BI Analysis for assignment criteria that extract ONLY the learner who completed a specific learning item 10 days ago. Content (please ensure … -
How to have a Batch ID parameter which is present in BIP Report in the Dashboard?Hi , We are creating a dashboard of a BIP Report for our use-case, BIP Report has a parameter called Batch ID with which we will pull the data regarding that batch load.…Sainatha B 21 views 1 comment 0 points Most recent by Ramchander Pothanolla Reporting and Analytics for HCM
-
Are there BI Cloud Connectors for OTM Cloud? If yes, where to find them?Summary: Are there BI Cloud Connectors for OTM Cloud? If yes, where to find them? Content (please ensure you mask any confidential information): Version (include the ver…
-
What is the meaning of the LAST_UPDATED_BY and LAST_UPDATE_DATE in GL_FRC_REPORTS_B?Summary: Our auditors asked us to extract the contents of the table GL_FRC_REPORTS_B for them. While reviewing this data, we noticed that for many of the reports it is s…Chris Mansfield 63 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
Payroll - Element Entries History Real Time Assignment ManagerSummary: Payroll - Element Entries History Real Time assignment manager subject area - what to find assignment manager to class employee as direct or Indirect staff Cont…Keith Dunlop 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI report update historyWe have several OTBI reports being updated that are not deployed by our support team. How is the owner updated to System Account? Is there a way to get the audit history…Angela Grace 11 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
When using smartview for the projects Essbase cluster how to display description instead of IdsWhen using smartview for the projects Essbase cluster how to display Tasks_Dimensions or Resource_Dimensions with their description instead of their IDs There is no clea…Ivan Olivera-Oracle 11 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
Pivot Table in OTBI Not Displaying Response Value DataSummary: Where I need to transform data from a vertical format to a horizontal format using a pivot table. My original data looks like this: Buyer Name Question Name Sup…Warunyu.N34 31 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Configure Prompt acting like a nested query?Summary: How to configure Prompt acting like a nested query? Content (please ensure you mask any confidential information): Hi Experts, Would like to reach out to you to…Liwen Chiu 1 view 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Enter prompt variable in SOAP executeXMLQuery requestSummary: We have a report on which i have added a prompt variable to filter based on the email address. This works in the report itself: But when i try to get the report…Nick H 11 views 1 comment 1 point Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
receivables transactions real time oracleSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…RamaBrahmaReddy K-Oracle 1 view 1 comment 0 points Most recent by Cristian Bilibou-Oracle Receivables & Collections
-
Billing number value not showing in receivables transactions real time oracleSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…RamaBrahmaReddy K-Oracle 1 view 1 comment 0 points Most recent by Cristian Bilibou-Oracle Receivables & Collections
-
unsupported report object's type - [catalog]Currently we are using the following webservice to upload a report into BI Publisher https://fa-exsj-test-saasfaprod1.fa.ocs.oraclecloud.com/xmlpserver/services/External…Sankhya 21 views 1 comment 2 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
where can i get the account number for expense report in OTBI?Summary: we can see the Account is defined for the Expense type and how can i show this in OTBI report? Content (please ensure you mask any confidential information): "E…
-
Anyway to tag courses besides skills?Summary: Is there a way to tag courses that could be used to group courses together without skills? If sills is the only way , where in OTBI can you bring in skills asso…
-
How to show person data at the time of absence submission in OTBI?Summary: We have a requirement to show the person data at the time of submitting their absences. But the OTBI report brings the latest job name, FTE, department, busines…Ridma Karunanathan 11 views 1 comment 0 points Most recent by gclampitt Reporting and Analytics for HCM
-
Determine Account date for PAY_COSTS entriesSummary: I am trying to figure out how to get back to the accounting date from each entry in the pay_costs table. We have a need to get this down to the person for some …Jason Snipes 2 views 3 comments 0 points Most recent by Phani S-Oracle Reporting and Analytics for HCM -
Custom lookups in OTBISummary: We have created a custom look up as common lookups and we want to use it in OTBI reports. Please let me know if it is possible or not. If yes, then please guide…Richa Arora-Oracle 21 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
Specific user cant extract data from xla_transaction_entities .Need to Know role for this XLA tableSummary: Specific user can't extract data from xla_transaction_entities .Need to Know role for this XLA table We have made one report where we are using this table but a…
-
How to retrieve Manage Receipts page's "Receipt Date" from subject area?Summary: How to retrieve Manage Receipts page's "Receipt Date" from subject area? Content (please ensure you mask any confidential information): Hi Experts, Would like t…
-
How to keep search panel available when search result shows?Summary: How to keep search panel available when search result shows? Content (please ensure you mask any confidential information): Hi Experts, May I ask how to have th…
-
Calculating Days in Calendar Year on a Suspended StatusSummary: Part of our annual incentive program, we prorate any worker who has been in a Suspended Assignment Status for greater than 90 days in the Calendar Year. Looking…Kayla Malecki 21 views 4 comments 0 points Most recent by Kayla Malecki Reporting and Analytics for HCM
-
Field in OTBI subject area to differentiate Purchase Order schedules which are FirmedWe are creating an Analysis and need an Identifier in Purchase Order Schedule to get the schedules which are Firmed ( Purchase Order schedule → Details → Actions → Firm)…Jith 2 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
User Should access all Inv Org for the OTBI reports If user is having access for 1 Inventory OrgSummary: Hello We have created an on-hand report for the business, but we need that few user with access with only 1 or few inventory org should also be able to view the…Parth11 13 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Can anyone help with a report to find potential duplicate employeesSummary: We have Contingent Workers who instead of being re hired as Permanent employees against the CWK record, these are being rehired as new employees creating duplic…Laura_Stewart_Sita 11 views 1 comment 0 points Most recent by gclampitt Reporting and Analytics for HCM
-
Which table contains the information from Manage Legal Reporting Unit HCM Information ?Summary: Content (please ensure you mask any confidential information): Which table contains the information from Manage Legal Reporting Unit HCM Information? Version (i…OliveiraRR 43 views 4 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM