OTBI
Discussion List
-
Create Report to Include Sign On Bonus from Offer LetterSummary: I have an analysis report that list candidates that we had hired. However, I need to add Sign On Bonus amount into the report. I found the "Other Compensation" … -
OTBI Analysis for Remote Workers and Onsite Associate Work Location State and Postal CodeSummary: We currently have a large population of workers who work remote or their "Work Location" is classified as their home office. Our population of around 18,000 wor…Kayla Malecki 11 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Download AR attachment from OTBIIs it possible to download the attachments from and AR invoice directly from OTBI? These are attachments that are uploaded directly into each invoice and the user wants …
-
Is there a way to pull out job offer comments in OTBI?Summary: Is there a way to pull out job offer comments in OTBI? Content (please ensure you mask any confidential information): Hello Experts, We are challenged to pull o…Volodymyr Faranosov 21 views 1 comment 0 points Most recent by Volodymyr Faranosov Reporting and Analytics for HCM -
Enhanced subject areas - Oracle Fusion ERP Analytics (24D)In the whats'new 24D note we have an enhancement in these subject areas: Encumbrance Accounting is available as an additional opt-in Generally Available pipeline feature…Rocha, Diego Rodrigo 41 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
Why are users with my custom role for OTBI not able to see data in OTBI reports?Summary: I created a custom role with copying "Project Administrator" role. Remove all "Function Security Policies" and do not touch "Data Security Policies". Remove all…
-
OTBI report returning Lookup codes, how to fetch meaning instead of codesSummary Few Talent profile attributes in OTBI report returning lookup codes.Content Hi, In the Person profile>License and certifications section few fields are lookup ty…Challa Vidyasagar 283 views 3 comments 0 points Most recent by ShivaBildikarMGS Reporting and Analytics for HCM -
RTF file ConfigurationSummary: Dynamically Present non null column in table Content (please ensure you mask any confidential information): I am creating an RTF file using Word table with 3 fi… -
Optimizing Infolet Loading Time on the SpringboardHello Community, We’ve designed and implemented multiple infolets for employees, line managers, and HR, placing them on the springboard to provide quick access to releva…HarishVummidi 11 views 1 comment 1 point Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
OTBI Data Discrepancy for "Performed Action" Approve in Procurement - Requisitions Real TimeSummary: Hi Community, I'm encountering an issue in OTBI (Oracle Transactional Business Intelligence) when retrieving data from the Subject Area: Procurement - Requisiti…
-
Request for Infolet Samples to Enhance User Experience in Core HR, Absence, ORC, OTL, and PayrollHello Community, I’m currently exploring ways to enhance the user experience for employees, line managers, and HR teams in Oracle Cloud by leveraging infolets effectivel…
-
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