OTBI
Discussion List
-
Deep Link to view the Purcahse Order details from OTBI report is not workingSummary: Deep Link to view the Purcahse Order details from OTBI report is opening a PO Web page but the page is blank Content (please ensure you mask any confidential in… -
Extract the transaction console comment in OTBIHello, I have a requirement where I need to report (in OTBI) on the comments visible in the Transaction Console. Specifically for the termination quick action, in which …Sara Suleiman 21 views 3 comments 0 points Most recent by Sara Suleiman Reporting and Analytics for HCM -
DFF created in EXM_CASH_ADVANCES are not shown in OTBISummary: I created a Date DFF in Global Segments of Manage Descriptive Flexfields for Expense Reports , Flexfields=EXM_CASH_ADVANCES. I deployed the Flexfields and ran t… -
OTBI - values turning to blank after more columns are addedSummary: I have built a report that combines two subject areas: Compensation - Salary Details Real Time and Payroll - Element Entries History Real Time The report is sho…Julia Kiszelewska1234 74 views 7 comments 0 points Most recent by Peeyush Chandel Reporting and Analytics for HCM -
OTBI AP Invoice real time is not bringing information when it is the second subject areaSummary: I tried to merge 2 subject areas (Fixed asset and Payables transaction real time). The Fixed Asset information is bringing the right data, but when added the se…Pablo Schenquerman 23 views 3 comments 0 points Most recent by User_Q63UG Payables, Payments & Cash Management -
Clicked metric is not available for reporting or data extraction in ORC CampaignsSummary of the Issue In Oracle Recruiting Cloud, the “Clicked” metric is visible and functions correctly at the campaign level in the user interface. However, this metri…alfredreyes1809 31 views 4 comments 2 points Most recent by alfredreyes1809 Reporting and Analytics for HCM -
Reporting on Roles and PrivilegesSummary: I want to report which employees have two custom roles in OTBI. When I report person number, name and role name column it reports out the correct data. However,… -
Report for Missing TimecardsSummary Employees without time card associationContent Hi All, We have a requirement to identify and report those employees that are missing time card association. I am …Sowdha Murugan 450 views 6 comments 0 points Most recent by Neha Thakre 2023 Reporting and Analytics for HCM -
cant show HR Representative in Otbi reportHello , I want to create a otbi report where i want to see my subordinates which is i am HR representative. I am the line manager of some employee and HR Representative …Mirza_Adeel 31 views 9 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
How to Fetch the PO Revised Amount in oracle fusionSummary: Hi Kindly Suggest the tables or provide any sample query to fetch the PO Revised Amount in Oracle Fusion Content (please ensure you mask any confidential inform… -
Does Oracle Fusion Maintenance Cloud support offline mobile functionality for technicians?Summary: Does Oracle Fusion Maintenance Cloud provides any native mobile application with offline capability for technicians. Specifically: Is there any mobile app avail… -
Payable Invoice lifecycleSummary: looking for any OTBI Analysis which provides AP Invoice lifecycle view. Content (please ensure you mask any confidential information): Version (include the vers…Anirban.sensarma 1 view 0 comments 0 points Started by Anirban.sensarma Reporting and Analytics for ERP -
Tools>>Reports and Analytics Page is still not available in RedwoodSummary: Reports and Analytics Page is still not available in Redwood . By when this page will available in redwood ? Content (please ensure you mask any confidential in…NaveenBellam 24 views 1 comment 0 points Most recent by Dhilipkumaar-Oracle Reporting and Analytics for SCM -
What table store approval rules configuration in FusionSummary: We are looking tables name for approval rule configuration. Navigation: Tools>Transaction Console>Approval Rules Content (please ensure you mask any confidentia… -
Pick slip status and quantity exception reasonSummary: Hi CCC, I was trying to identify the Pick slip status - Open / Confirmed and quantity exception reason in case of short pick from the backend tables. I couldn't…VishnupriyaSelvakumar 31 views 3 comments 0 points Most recent by Joseba Urrutia Inventory Management -
Incorrect drill-down results (action link to BI content) when using UNION in OTBI AnalysisI've written an analysis against the Workforce Goals - Goal Status Overview Real Time subject area. I had to use a UNION to accommodate some complex criteria and breakou…Shawn Gertler 36 views 7 comments 0 points Most recent by Shawn Gertler Reporting and Analytics for HCM -
Employee with Bank Account but no Payment Method ReportSummary: I have a report that picks up all employees that do not have a bank account and a payment method active, but how do I pick up employees that have a bank account… -
Issue with BICC TASK PVO extractHello Community, I am trying to extract Task details from fusion using BICC. This is the PVO "FscmTopModelAM.PjfProjectDefinitionAM.TaskPVO" we found, but there is some … -
Highest Education level not showing in OTBI person profile subject areaSummary: Hi Team, we have need to extract the report of each employee of highest education level but not coming in workforce profile - person profile real time . ANy one…Maddipati Ajay Kumar 182 views 6 comments 0 points Most recent by CMcConnell Reporting and Analytics for HCM -
OTBI Report for AP Invoice HoldsSummary Sample OTBI report for ERP Cloud providing a list of AP Invoices on HoldContent Sample OTBI Report for ERP Cloud: AP Invoices on Hold This report provides a list…Andy Gough 2.2K views 19 comments 22 points Most recent by Gaurav Kumar-100036 Reporting and Analytics for ERP -
Underlying reports for the graphs/charts on OM pageSummary: Do we have the underlying reports available on Fusion Reports & Analytics, for the Graphs/Charts that are visible on the Classic Order management page?? If yes,… -
Requistion Approval email data model does not retrive details using (Requistion ID) parameterSummary: I want to customize requistion approval email notification, data model does not retrieve the requistion details in case to export sample data Content (please en… -
Limiting Sandbox infolet / table by business unitSummary: We have a dashboard/table that we are looking to add to the Purchase Orders page and we are looking to limit the security by business unit. Specifically using: … -
ORA-00920: invalid relational operator at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.jaSummary: Hello Team, we have an sql report with multiple parameters and each parameter is a multi selelct pick list. we are trying following SQL for this and it is faili…Sudheer V SB 68 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
OTBI Dashboard Prompt Not Filtering Correctly When Mixing Person and Assignment Subject AreasSummary: OTBI Dashboard Prompt Not Filtering Correctly When Mixing Person and Assignment Subject Areas Content (please ensure you mask any confidential information): We …Jeeva - Cloud Vantage 31 views 1 comment 0 points Most recent by Iulian Brinzoi-Nuta - HCM-Oracle Human Capital Management -
How to display OTBI report in Journey task "report"Summary: Hi Team, I have a OTBI report and I want to display in journeys where employee can see the data and esign. I am using advanced task and but report is not coming…AvinashP 261 views 16 comments 0 points Most recent by Archana Prasad Reporting and Analytics for HCM -
How do I source: profile item id for spreadsheet loaderI'm trying to build a spreadsheet loader to load license and certifications specifically Responsible Manager which sits in Responsible Person Region in Skills and Qualif…Tina T 63 views 3 comments 0 points Most recent by Aditya Jena Reporting & Analytics for Fusion Service -
Link between WLF_ASSIGNMENT_RECORDS_F and HRC_TXN_HEADER tablesSummary: Link between WLF_ASSIGNMENT_RECORDS_F and HRC_TXN_HEADER tables. Content (please ensure you mask any confidential information): We have established a link betwe…ViswanadhK 43 views 3 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
Top Employee Missing from HierarchySummary: Our top employee is not appearing in reporting when the organisation hierarchy is included in a report. Content (required): The head of our organisation current… -
OTBI - how to get the payables invoice details from General Ledger Journals Real Time Subject areaSummary: I am creating an OTBI using General Ledger Journals Real Time Subject area but I want to show payables invoice line description. I tried to add Payables Invoice…