OTBI
Discussion List
-
Guidance on Fixed Assets and how to get YTD depreciation figuresSummary: Hi, I am trying to recreate the date from the Asset Inquiry screen (screenshot below) but am struggling where to start. I can see three subject areas related to… -
How to grant access to OTBI without granting access to datamodelSummary: Although a custom reporting role strictly restricts the user from creating or editing Data Models, a security gap allows them to delete existing Data Model obje…Kevin123 54 views 8 comments 0 points Most recent by Kevin Wong Sing Ting Reporting and Analytics for ERP -
Can we assign bulk roles to user accounts ( not employees)Summary: Hello All, Can we bulk assign roles to users those are not employees in fusion? Content (please ensure you mask any confidential information): Version (include … -
Fixed asset depreciationSummary: OTBI Fixed Asset Register – YTD Depreciation Excluding Adjustments vs Asset Inquiry (UI) Hello everyone, I would like to seek advice regarding Oracle Fixed Asse…
-
OTBI Reqs Real Time shows PO as blank-unprocessed for req lines that already have a PO createdSummary: We have an OTBI analysis built on the Procurement - Requisitions Real Time subject area used to track unprocessed/overdue PR lines. Several requisition lines ar… -
Entry Grade Name and Grade NameSummary: We have a custom Vacant Positions reports used for infolets - performance tile and data report. Below are the columns and filter for both reports Right now, the…
-
Anyone had any issues with Self-Paced Learning content completions showing on reports?Summary: We have a few custom-built reports, that show results of completions for Courses and Specializations. While testing Self-Paced Learning, those completions are n… -
How to extract requisition approval rules created in BPM as a report or CSV file.Summary: Requirement is to extract approval rules along with details/settings of the various stages, participants and the rulesets. Content (required): I have referred a…Ananda Bhargav Potluri 2K views 12 comments 3 points Most recent by Anitha_Devarajulu Self Service Procurement
-
Candidate date of birth and gender are not pulled from OTBI reportSummary: Hi, I have used Recruiting-real time subject area ans used "person date of birth", "person gender" columns to fetch the candidate date of birth and gender. Howe…Aruna Aounti -Oracle 362 views 8 comments 0 points Most recent by Tara Samari-237472 Reporting and Analytics for HCM
-
Automatic Closure of Expired Contracts in Oracle CLMSummary: What is the process by Oracle provides a standard functionality, scheduled process, ESS job, or supported automation method to automatically move expired contra…
-
Query for Projects, Subledger and General LedgerSummary: Query for Projects, Subledger and General Ledger Content (required): Hello I was wondering if you can share with me any Query for Projects, Subledger and Genera…
-
Unbale to see Context DFF in OTBI Procurement -Purchasing real time Subject areaSummary: Hi All, We have created below context DFF at PO Line level But we are Unbale to see Context DFF in OTBI Procurement -Purchasing real time Subject area,adter dep…
-
Not able to join 3 subject areasSummary: We would like to build OTBI report but will require to use 3 Subject Areas: Workforce Management- Person Real Time Workforce Learning -Learning Records Real Tim…RodrigoRamirez 21 views 4 comments 0 points Most recent by RodrigoRamirez Reporting and Analytics for HCM
-
Is there any standard report for document of record audit fields?Hi, After 26A the audit field (Last updated by) of the screen "document of record" are not visible anymore. For audit purposes, HR administrator needs to view this infor…Lynda Ramos 13 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Access to Supplier Report without Supplier Admin/Manager role?Summary: We created a simple supplier report for users so they can see the active suppliers (+ address, basic details). The users are not able to run/view the report as … -
Looking for a query for Oracle Fusion HCM Templates on Disciplinary ActionSummary: Templates on Disciplinary Action Content (please ensure you mask any confidential information): I am looking for a query for Oracle Fusion HCM Templates on Disc…
-
OTBI - Return transaction directly before current transactionGood afternon. I searched the Customer Connect portal for an answer to this, but couldn't find one. Seems like it should be easy, but I'm stumped. Can anyone advise on h…
-
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 391 views 12 comments 0 points Most recent by ParthivAVT Reporting and Analytics for HCM
-
How to set static/Dynamic password generation for PO-PDF in Oracle FusionHow to set static/Dynamic password generation for PO-PDF in Oracle Fusion A requester received a Purchase Order (PO) change notification, which included the PO PDF. The …PASALA SATEESH REDDY 23 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
Balance Value for Balance Dimension visible in Fusion UI but not in OTBISummary: We are trying to lookup Payroll Balance Results based on a specific Dimension Name and Balance Name, and the output retrieved from OTBI is not matching to that …
-
INVALID_VENDORSummary Expense report invoices rejected due to reason INVALID_VENDORContent Hi Team, I am unable to create invoices for expense report which are Approved and Audited, s…
-
What subject areafolder can I find details to report on Self Paced Learning-Event details?Summary: What subject area and folder can I find details to pull into an OTBI report on Self Paced Learning - Event details? We have our Events tied to a Course but when… -
Why Does Transaction Cost Details Show Blank Costs for Cost Version Date 1/1/1900?Hi everyone, We're encountering an issue with the standard Transaction Cost Details report. For some transactions, the Cost Element, Unit Cost, and Currency columns are …
-
Is an Organization DFF visible in OTBISummary: I'm trying to build an OTBI Report that will show our Organizations and a DFF that is tied to Organizations. This DFF shows under the Department folder in the W…
-
Is there OTBI report for available credit balanceSummary: How to calculate Customer Available Credit Balance — is there an OOTB OTBI report, or is a custom report required? Content (please ensure you mask any confident…
-
Unable to produce an OTBI report that include Cost Centre DescriptionSummary: Unable to include CostCentre Description in a report in OTBI. I am using Workforce Management - Worker Assignment Real Time subject area as we don't use the fin…Julia Kiszelewska1234 3 views 0 comments 0 points Started by Julia Kiszelewska1234 Reporting and Analytics for ERP
-
Is there any Fusion standard report which gives Onhand & its valuation (in PO Cost) for any INV Org?Summary: Is there any Fusion standard report which gives Onhand and its valuation (in PO Cost) for any INV Org. Please note that the Costing method defined for the Cost …
-
SQL script for Roles , Privileges, Inherit roles & Data Security PoliciesSummary SQL script for Roles , Privileges, Inherit roles & Data Security PoliciesContent Trying to built a query to fetch Application Roles, Privileges, Data Security & …
-
Compliance at scale solution peer-review on gapIs “latest certification” logic fundamentally broken in OLC compliance? Using exclusion model instead. Context: Large NHS implementation (~30k workers) using: Learning O…