OTBI
Discussion List
-
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,… -
Information: Query to get last P2T/T2T Refresh DateSummary: In order to get last refresh date from backend, below SQL can be used: select * from ask_deployed_provision_configs last_update_date column in this table gives … -
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 384 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 1 view 1 comment 0 points Most recent by Dhilipkumaar-Oracle Reporting and Analytics for SCM
-
Access to Reports and Analytics section - Roles and privileges requiredSummary: Hi All, We had the requirement to build a custom data role which will give the user the access to Reports and Analytics work area and role should provide access…Sreeram V 6.4K views 11 comments 0 points Most recent by Nazir Hossain Reporting and Analytics for HCM
-
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 13 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 11 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… -
Unable to save XML in BI Publisher.Summary Unable to save XML in BI Publisher.Content Unable to save XML in BI Publisher. We are getting an error: Upload file size exceeds the maximum size limit defined b…Aloka Bhattacharya 78 views 14 comments 0 points Most recent by Milan_Chandra Reporting and Analytics for HCM -
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…AjayKumar Maddipati 171 views 6 comments 0 points Most recent by User_IHDYF 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.1K views 19 comments 22 points Most recent by Gaurav Kumar-100036 Reporting and Analytics for ERP -
OTBI Dashboard and Reports for ExpensesSummary An OTBI dashboard with a series of drillable reports for ExpensesContent The attached catalog files can be imported into an ERP Cloud instance to create a dashbo…Andy Gough 4.4K views 30 comments 31 points Most recent by Farooq Syed, CPA, PMP, CISA, TOGAF 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…
-
Zip File for 'Identifying Authorized Hosted Named Users' no longer available?Summary: Hi, I used to be the primary person managing Oracle Licenses and would utilize the 'Identifying Authorized Hosted Named Users' reports which provided the follow…Rebecca_Edwards 1 view 0 comments 0 points Started by Rebecca_Edwards Reporting and Analytics for HCM -
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 13 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 32 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 252 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 53 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 25 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…
-
Unable to load content into a self-paced activity via HDL .Summary: We are trying to load a self-paced activity using content that was previously created through the front end. However, an error occurs when we pass the content n…