OTBI
Discussion List
-
Issue Using Two Subject Areas in a Single OTBI Analysis to Bring Budget and End Of The Day Balance.We are trying to build an OTBI analysis that contains Ending balances and End Of The Balance(EOD) related transactions within a period. To achieve this, we are using two…Sri Sai Kiran Tekumudi 21 views 0 comments 0 points Most recent by Sri Sai Kiran Tekumudi General Ledger & Intercompany -
OTBI Report with SQL query filterSummary: Hi Team, We have a custom reporting requirement that involves applying complex, SQL-based filters. We are planning to implement this logic within an OTBI report…
-
Why cant we change the credit card charges notification templateSummary: When out visa upload takes place we have activated the automatic notification to be triggered and sent to the credit card holder to tell them they have new tran…
-
I am looking for the tables which stores IExpense item dispute date and dispute commentsSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Volume of email notifications by typeSummary: I have a stakeholder who has requested the volume of emails by template sent by HCM to workers by Month. We have BI Burst, Alert Composer, and Seeded Notificati…SusanJ 11 views 2 comments 0 points Most recent by Andre Brown-Support-Oracle Reporting and Analytics for HCM
-
Getting errors UPDATING an Item in a Price List in Bulk using Import Price Lists Batch FBDIWhile trying to UPDATE an existing Price Lists' Items and Charges, getting the following errors: primary_pricing_uom_flag - Only one price list item record can be the pr…
-
Impact of import oracle fusion data extensions for transactional business intelligenceSummary: Hi, Please help us to understand if the program - Import oracle fusion data extensions for transactional business intelligence will impact in any of the current…SwapnilSurange1 52 views 1 comment 0 points Most recent by Rich Merkel Reporting and Analytics for ERP
-
Is there an API in Oracle that can extract the OTBI Analysis Criteria XMLSummary: We have lot of OTBI analysis which are being used for Learning initiatives/recommendations. These reports have filters on Organizational levels/Names. Whenever …
-
OTBI Analysis Report – Duplicate Rows Issue Even After Enabling DISTINCTSummary: I am working on an OTBI analysis where I am seeing duplicate rows in the output. For example, the same Person Number and Person Name (e.g., "101 – Ben") is repe…Manoj Muddineni 72 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Need to Extract Termination Transaction Approval DetailsSummary: Need to Extract Termination Transaction Approval Details Content (please ensure you mask any confidential information): Hello Experts, We have a requirement to …Vasanthakumar Ravi 21 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Check-Ins ReportContent We are considering implementing the Check-Ins feature in our 2021 performance reviews. We will need to be able to track completion rates. Perhaps I am overlookin…User_2025-10-31-00-57-47-193 79 views 7 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
BI report to extract GL Daily Rates table data for a range of corporate ratesSummary: Is there a report that can be schedules to export the GL Daily Rates table data out of Oracle Fusion? Content (please ensure you mask any confidential informati…
-
Want to fetch row values based on another column's value.I want to print mid salary values which are highlighted in screenshot, based on columns "overtime" and "grade rate name".Raja Subramanian-Oracle 11 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
how to fetch top 10 otbi reports that users access frequentlySummary: The request is to fetch the top 10 OTBI reports that users access frequently on their dashboard Content (please ensure you mask any confidential information): R…SivaNallagatla 41 views 7 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Functionality to print a label or report once the receiving is completedSummary: Business user is looking for the functionality to print a label or report once the receiving is completed against to the PO in Oracle. Is there a way to print i…Valencia Jonathan 21 views 1 comment 1 point Most recent by Adnan Siddiqui-Oracle Inventory Management
-
SQL query to get Bank Account Details at Supplier Header/ profile levelHello experts, I need SQL query to fetch supplier bank accounts details created at header/ profile level as below to check which bank account does not contain IBAN, Bank… -
Adding Count in OTBI which Uses Custom Logical SQL QuerySummary: I have created OTBI Report using Logical SQL Query using multiple table Subject areas and Outer Joins , Need to add Report Data Count in the report . Is there a…
-
OTBI Redwood Receiving CommentsWe have a requirement from users that they be able to see comments on RSSP Redwood Receipts (formerly before 24D in Notes). We are attempting to create am OTBI report wh…
-
Trouble Querying For PO Delegation DetailsI am trying to query for delegation details of a PO. Currently only able to query for the approver name for each PO, but cant seem to join delegations table to properly …
-
Join XCC_BALANCES with PO tablesContent Hi all, I need to retrieve the budget available amount (see screenshot below) I found the amounts in the table XCC_BALANCES. But I can't find a way to join it wi…
-
we don't have access to OTBI report subject areaSummary: We don't have access to otbi report subject role with custom role, we unable find the exact privilege was missing. kindly help us on this. Thank you.
-
ESS JOB SHWOING DIFFRENT OUTPUTHi Experts! Greetings! Recently I Came across an issue in ESS JOB FOR BIP REPORT. When I run the ESS JOB then in the attachment (pdf) one part of the report is missing ,…Mainur-Oracle 51 views 2 comments 0 points Most recent by Crescentia David Reporting & Analytics for Fusion Service
-
I need to return the latest component subinventory and locator in a work definition in an OTBI queryI'm looking to extract out the the latest version of a work definitions, the components within a work definition and the subinventory and locators. I curently have an OT…
-
BIP: For Year Parameter, Set Default Value as Current Year and attach LOV (SQL Query LOV) to the YeaSummary BIP: For Year Parameter, Set Default Value as Current Year and attach LOV (SQL Query LOV) to the Year ParameterContent Hi, This is related to earlier post: https…User_MC37Q 1.1K views 5 comments 1 point Most recent by NIRMAL KUMAR L Reporting and Analytics for HCM -
Report or SQL Query to Identify Unused Departments in Department TreeHi Team, We’re looking to generate a report that identifies unused departments within our department tree. Specifically, we’d like to find departments that: Have no asso…Mahendra Y 2 views 1 comment 0 points Most recent by Carl Bequilla-Oracle Reporting and Analytics for HCM
-
Reporting/Managing on Goal Plan EligibilitySummary Can goal plan eligibility be managed like Performance documents can?Content I've been searching the forums but haven't found a clear answer. I have a lot of ques… -
Generate Employment Letter from Employee Self ServiceSummary: Hello Experts, We have a requirement to develop the Employment Letter from the system from the employee self service. We have checked in the delivered Document …Jaydeep.More 21 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
HR Action / Termination Action in Manage Work RelationshipSummary HR Action / Termination Action in Manage Work RelationshipContent Hi - We are trying to move all of our BI Publisher reports to Analysis and encountered an issue…Roy Paolo Paunlagui 198 views 13 comments 1 point Most recent by Anjaneyulu Reporting and Analytics for HCM
-
Unable to proceed to create Dataset using webservice in Oracle BIP ReportSummary: Unable to create dataset with Webservice while creating custom BIP report Content (please ensure you mask any confidential information): below are the steps to …SireeshaJaladi 129 views 6 comments 1 point Most recent by Sri Prasanth Reporting and Analytics for ERP
-
Unable to see the DFF attribute which are based on Table type value set in the OTBI subject areaHi All, We have created a few custom DFF attributes under Manage Customer Account Descriptive Flexfields. Few are based on independent value sets, and few use table-type…Gurujothi D 244 views 10 comments 0 points Most recent by Malleswara_Rao_P Reporting and Analytics for ERP