OTBI
Discussion List
-
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 78 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…
-
What is the subject area of Project Definition DFF on OTBI on Projects module?Summary: We cannot find Project Definition DFF on OTBI. What is the subject area of this attribute on Projects module. DFF is BI enabled, we run "Import Oracle Fusion Da…
-
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 1 view 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 11 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 197 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 121 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 234 views 10 comments 0 points Most recent by Malleswara_Rao_P Reporting and Analytics for ERP -
How to schedule an OTBI report using agent with effective date prompt?I have OTBI analysis where I have added 'Effective date' prompt. I want to schedule this analysis via agent. However, wants to select date in prompt under 'condition' se…
-
How to Reprice the Sales Orders after Pick ReleaseSummary: How to Reprice the Sales Orders after Pick Release Content (please ensure you mask any confidential information): We have a requirement to reprice the Sales Ord…
-
OTBI/BIP catalog/folder last update date differenceHI Team, After a refresh/upgrade/patch getting applied does the folder last modified date change for each folder. We could see some folders have different last modified … -
How to add page break in etext template (Fixed position based) in BIP reportHow to add page break in etext template (Fixed position based) in BIP report? Need to add page break after every 50 rows.Harshitha S Motagi 31 views 3 comments 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP
-
Hi All can anyone help me to print these columns item and description in my transaction report.Summary: Please help me to print these columns in my transaction detail report please provide sql or tables where i can find these columns data. These are present under …
-
Any OTBI Report/table to get Multiperiod Accounting Transactions AHCSDo we have any tables or oracle Reports BI or OTBI to get the list of Multiperiod transactions posted and future transactions other than table XLA_MPA_DISTRIBUTIONS.Chetan007 1 view 1 comment 0 points Most recent by Anca A-Oracle Subledger Accounting & Accounting Hub
-
OTBI Report (Dashboard) Security Not Mirroring FusionContent My understanding of the OTBI security is that security applied in Fusion will also be applied when running reports. You'll see the same data. However, if additio…Rebecca L Smith 63 views 13 comments 0 points Most recent by GPOtimization Reporting and Analytics for HCM
-
Need to get the OTBI Schedule Agent Information Report Jobs.Summary: Content (please ensure you mask any confidential information): We need to the details of OTBI agent schedule report jobs when the report was run details, who ra…VishnuVardhan Raju 31 views 3 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM