OTBI
Discussion List
-
BIP Local Solutions reports do not print Natural Account descriptions in selected local languageSummary: Predefined Latin America Local Cloud Solution (LALCS) BIP reports do not print Natural Account Descriptions in translated language - Spanish. Content (please en… -
Otbi analysis filter for budget date greater than creation dateSummary: We are looking for advice on the most effective way to set up an analysis that lists all requisitions that have a budget date of more than 30 days from their cr… -
How to schedule an OTBI report to generate monthly with dynamic prompt?Summary: We have an OTBI report that contains a datetime prompt. I'd like to schedule the OTBI report to run each month and have the datetime prompt automatically popula…Steven Woods 273 views 7 comments 1 point Most recent by Steven Woods Reporting and Analytics for ERP -
Cannot Deliver More Than 75K Lines to an OTBI reportSummary: Hi, The customer needs to extract data from an OTBI report with more than 75,000 rows. How can we change this limit, which is already pre-set in the report? Cur…Silas Henrique Silva 342 views 2 comments 0 points Most recent by Silas Henrique Silva Reporting and Analytics for ERP -
OTBI Dashboard Prompt: Year, Quarter,MonthSummary: Need help on OTBI Dashboard Prompt: Year, Quarter, Month with Variable Content (please ensure you mask any confidential information): We are working on a custom…Mohan Murali P-Oracle 61 views 1 comment 0 points Most recent by Mohan Murali P-Oracle Reporting and Analytics for HCM -
24B: BIP - What is the OTBI subject area or tables to get transaction approvers from Learning?Summary: What is the OTBI subject area or tables to get transaction approvers from Learning? Content (please ensure you mask any confidential information): Please share …Nipon 21 views 3 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM -
How to update asset meter fields in all the assets( more than 10,000 assets)https://us.v-cdn.net/6034893/uploads/K84LDAEJNNPA/10-asset-meter-attribute-update.docx Summary: Content (please ensure you mask any confidential information): Version (i… -
OTBI report to fetch goal plan and its goalsHello, I'd like to create an OTBI report to fetch all the goal plans created and goals associated directly to each goal plan - even if goal plans and goals have not been… -
Analysis Close Ratio by Trailing 12 MonthsHello, We are trying to create a dashboard that will show the close ratio - win vs loss - of each month as a trailing 12 total. We are looking to have the months as the …NAndrusick 21 views 3 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
OTBI Column Properties Data format First Name Last NameSummary: The current format is Last Name, First Name - is there a way to switch this with below Data Format? Content (please ensure you mask any confidential information…THawkins_LGI 21 views 8 comments 0 points Most recent by THawkins_LGI Reporting and Analytics for HCM -
New And Old Address ReportSummary New And Old Address ReportContent Hi All, I working on building a report which will populate Address Change ( Old & New) with Assignment & Location Change detail…User_2025-02-07-19-03-14-525 95 views 10 comments 0 points Most recent by Tammy Hemmingson Reporting and Analytics for HCM -
HCM OTBI Report on all absences with a future or missing end dateSummary: Our IT dept are having a hard time identifying logins that are due for auto deletion due to inactivity but that actually need to be kept open (eg those on long …KerryanneLee 21 views 3 comments 0 points Most recent by KerryanneLee Reporting and Analytics for ERP -
Project Number for Payables Invoices in JournalsGood Day, Where can I pull the correct project number field for payables sources? We use 3 subject areas for our report where both Journals Real Time are mainly used: - … -
Where to find Warning limit and Error limit for the fusion tablesSummary: Greetings of the day.. Please share the information where we can find Warning limit and Error limit for the fusion tables Content (please ensure you mask any co… -
HCM Position Hierarchy standard report code file required which is running in backendHi Team, We have a requirement to develop a new report as like "HCM Position Hierarchy" standard report, so please share code file or file path and report name so that w…Suresh Gandla-Oracle 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
PVOs with one to one relationships to base tablesSummary: Hi, We are building a Lakehouse on databricks using PVOs as source. Since PVOs are a combination of base tables together it is some time harder to get the data …Rajat N 21 views 1 comment 0 points Most recent by Deshin Pillay-Oracle Reporting and Analytics for SCM -
Location of Highlighted Information in Oracle BI Publisher (Learning)Summary: Hello, We need to know in which table and column of Oracle BI Publisher the information highlighted in red is located. "Number of mandatory activities in each s… -
Is there a way to give Delegations for Reporting?Summary: We would like a manager to allow an employee to pull reports for her direct reports We tried Role delegation and Approval Delegations but none of them help with…THawkins_LGI 21 views 6 comments 0 points Most recent by THawkins_LGI Reporting and Analytics for HCM -
Learning Calendar reportSummary: Hi Folks, Learning calendar view is blank and does not have the calendar view Please help to fix this All other reports for learning calendar title and learning…Sowmiya Velusamy 131 views 7 comments 0 points Most recent by User_7DF56 Reporting and Analytics for HCM -
Sandbox- AP invoice,If any GL code otherthan “****” is used under multiperiod, user receive popupSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Stephen Sushanth Alexander 11 views 1 comment 0 points Most recent by Elena Vlad-Oracle Payables, Payments & Cash Management -
Unable to join Purchasing and Receipts subject areas in OTBIWe have a requirement where we need to create an OTBI report with Purchasing Order and Purchase Order Receipts information like Purchase Order Number, PO Line Number, PO… -
OTI Query for Fetching Free Text Fields from QuestionnaireDear Community, I am working on an OTBI report and need some help with querying data from a questionnaire called "Student Touchbase". The Questionnaire consists of sever…Ashok Kumar Sharma 61 views 14 comments 0 points Most recent by Ashok Kumar Sharma Reporting and Analytics for HCM -
Fixed Asset Register report is not working when you select a date in the past like OCT 2023.Summary: Fixed Asset Register report is not working when you select a date in the past like OCT 2023. it only returns the current Open period after running depreciation.… -
How to fetch the Covered Levels of a Subscription using querySummary: How to fetch the Covered Levels of a Subscription using query Content (please ensure you mask any confidential information): How to fetch the Covered Levels of …Neelesh Varma 22 views 3 comments 0 points Most recent by Manoj Kumar-Support-Oracle Reporting & Analytics for Sales