OTBI
Discussion List
-
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 21 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 321 views 15 comments 4 points Most recent by Namrata_20 Reporting and Analytics for HCM -
Work Schedules for non-primary assignments in Person Real Time Subject AreaSummary: I'm trying to report on the work schedules for employees with multiple assignments. However the OTBI Person Real Time Subject Area / Person Schedule Assignment …Richard Kemp-Eyre 64 views 3 comments 0 points Most recent by User_IHDYF Reporting and Analytics for HCM -
Getting an error when trying to view standard Cost Management ReportSummary: Hi Team, While trying to view the Standard GRNI, Good Received Not Invoiced Report under the Navigation:- Shared Folder>Supply Chain Management>Cost Management>…
-
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 701 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 351 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?
-
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…
-
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… -
Work Order Operation Transaction Import FBDI fileSummary: We are trying to leverage 'WorkOrderOperationTransactionTemplate.xlsm' FBDI for an integration and we would like to use DFFs to capture few fields. We do not wa…
-
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…Andy Gough 939 views 11 comments 9 points Most recent by Shiladitya Roy Reporting and Analytics for ERP -
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 17 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… -
Unable to View "Not Started" Course Status for Assigned LearnersSummary: In the Specialization view, the course status is displayed as “Not Started” for learners who have already been assigned to the specialization. However, when an …
-
How can we view the approval pending receiving transactions?Summary: 26B: Receiving approval workflow After submitting for approval on self-service receiving page, how can we check the pending approval RCV transactions? I cannot …Tomoyuki Hyakutake-Oracle 11 views 2 comments 0 points Most recent by Tomoyuki Hyakutake-Oracle Inventory Management
-
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. 33 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…
-
Journal approval and rejection reportSummary: Do we a report in Oracle that provide information on journals which were submitted for approval and have been rejected. If not can anyone share any queries wher…