OTBI
Discussion List
-
Update of Invoice Landing Page to add custom infolet/infotileHello, The requirement is to update the Invoice Landing Page to add custom infolet/infotile. We would like to verify if this is feasible. Navigation: Payables > Invoice …Mark Llasos 31 views 5 comments 0 points Most recent by User_YBLTT Payables, Payments & Cash Management -
Report for getting shift overlap or shift with open end dateSummary: Report for getting shift overlap or shift with open end date Content (please ensure you mask any confidential information): Hi Team, Greetings! If anyone has an… -
How to avoid duplicate invoice number while performing the PO receivingWe have observed a scenario where a PO receiving was created twice using the same invoice number. Currently, the system allows entry of duplicate invoice numbers without…
-
How to join Procurement - Procure To Pay Real Time and Enterprise Contracts - Contracts Real TimeHi Team, I am currently working on joining the below two OTBI subject areas, but I am unable to establish a proper join between them: Procurement - Procure To Pay Real T…
-
Reference number in system transactionsSummary: Could we change the reference in system transactions for bank reconcilliation? The reference column and transaction number is populating same data. Could this b…
-
I Cant find the Flexfield AR_CASH_RECEIPTS in OTBIContent Hi All, I did add Descriptive Flexfield to account receivable - Receipt Screen - under Additional Information ( global segment - Descriptive Flexfield name ( AR_…User_2025-01-29-22-38-36-974 80 views 5 comments 0 points Most recent by Gangadhara S Ariga Reporting and Analytics for ERP -
PER_PERSON_EIT_EFF flex fields are not appearing in OTBI Subject AreaSummary: Some PER_PERSON_EIT_EFF flex fields are not appearing in OTBI Subject Area Content (please ensure you mask any confidential information): See screen shots of Fl…Al Darabaris 22 views 2 comments 0 points Most recent by Al Darabaris Reporting and Analytics for HCM
-
Audit Report - On Folder Permissions ChangesSummary: Content (required): We have a requirement on Auditing folder Permissions Changes on any OTBI folders This report in theory needs to show us When and Who and Wha…Clifford Trett 322 views 15 comments 4 points Most recent by Namrata_20 Reporting and Analytics for HCM -
I need to create an analytic in OTBI To identify what work schedule is assigned to employeesI am trying to create a simple analytic in OTBI to show all employee names, their assignment numbers and the names of the assigned Work Schedule for each assignment. It …
-
Scheduling of Assignment Profile based on analysis criteriaSummary: Scheduling of Assignment Profile based on analysis criteria Scenario: Whenever a new employee joins the organization, We have few courses to be assigned to them…
-
Get list of all BI Publisher reports that use a specific data modelSummary: Is there a way in BI Publisher to get a list of all BI reports that are using xyz data model as the DM, in order to understand the impact of making changes to a…Shant_Sarkissian_WJG 702 views 8 comments 0 points Most recent by Surya_TejaS Reporting and Analytics for HCM -
Transactions Tables are not storing Data for few TransactionsSummary: Hi Team, I am trying to fetch the transaction details for Time Change Request Approval. But I have encountered that there two tables that were not storing any d…Dasari Dileep 352 views 9 comments 0 points Most recent by Converse_with_OraEnthu Reporting and Analytics for HCM
-
how to get supplier tax country in OTBI reportwe would like to create an OTBI report to get supplier tax country and tax registration number, where can we find the supplier tax country?
-
Need SQL Query or OTBI report to display OTL Calculated HoursContent Hi All, Pls share Subject area or SQL query to get the OTL calculated hours. For Ex: In a week employee entered 42 hours under Regular. When we click on NEXT but…Visu 1K views 2 comments 0 points Most recent by Janhavi Kulkarni-Oracle Reporting and Analytics for HCM
-
How to pass multiple values in a single parameter in OTBI agent?I have a requirement to prompt user while running an OTBI agent. But I don't see that option. Is there a way we can pass multiple values in a single parameter by using O… -
OTBI report has increased massively since 26BHi, A report that was taking 9 seconds to run is now taking 706. This is since 26B came in on Monday. I will attach the report xml, and I have run a Performance check us…
-
Requisition Life-cycle report (OTBI)Summary Simple report showing creation date, approval date, PO creation date etc for purchase requisitionsContent See attached screenshot for details. Unarchive the atta… -
Unable to Get Cost & Bid Details Agent Output in Design to Source WorkspaceI am currently testing the Agentic AI capabilities in the Design to Source Workspace and facing a few issues. When we provide a prompt such as: “Shift focus to Item ABC … -
Unable to get OTBI column value for 'Request to Resubmit' Approval actionSummary: We are unable to fetch OTBI column value for 'Request to Resubmit' Approval action on Supplier Registration Request page which is impacting us to develop one ne…AnuragGandhi 11 views 4 comments 0 points Most recent by Sai Krishna Reddy Gurram-Oracle Reporting and Analytics for ERP
-
BIP Vs OTBI What is the practicality of moving BIP reports to OTBI?Summary: I am recommending that my client investigates the possibility of using OTBI in preference to BIP for their reports (including whether this is just for new repor… -
Front-Loaded Accrual BalanceContent I've been trying to create an Absence Balance OTBI Report that reports both the Incremental and Front-Loaded Balances (for the Incremental Accrual Balance, I use…
-
Account Holder field not available in OTBISummary: Account Holder field not available in OTBI Content (please ensure you mask any confidential information): Hi experts, we are creating an OTBI report to retrieve…Oriana L. 31 views 6 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
CST_TRANSACTION_COSTS pvoSummary: What is the PVO for CST_TRANSACTION_COSTS Content (please ensure you mask any confidential information): Version (include the version you are using, if applicab…
-
Joint Venture Setup and Contributions AnalysisSummary: It seems there is only an OTBI subject area for the Joint Venture module Transactions and Distributions details. There does not seem to be a way to report on an… -
Cannot commit OTBI report on Purchase Orders (Redwood) pageSummary: OTBI report added on Purchase Orders (Redwood) page 'vanishes' after 'Exit Edit Mode' view. Content (please ensure you mask any confidential information): I am … -
SQL query or table for Project Cost Transaction AccountingSummary: Hello, Please help to have query or table to get the accounting details from Project Cost Transaction where we know the transaction number. Content (please ensu…
-
AR Transaction Register Report erroring as too many records. how have people got round thisSummary: AR Transaction Register Report erroring as too many records (trying to run for full quarter as needed for external audit). how have people got round this? Conte…Jill Stanton 31 views 8 comments 0 points Most recent by Rinku Gautam Reporting and Analytics for ERP
-
Missing time cardWe would like to see missing time cards. We have specified Compliance also and existing report related to compliance OTBI gives time entry is missing if anyone creates a…Priti Davda 11 views 2 comments 0 points Most recent by NaveenGM_CCC Reporting and Analytics for ERP