OTBI
Discussion List
-
Case Management Reports / DashboardsSummary: Hello All, We would appreciate the community’s support in sharing or pointing us to any existing or delivered case management or HelpDesk reports or dashboards …Chandramouli Yangareddy 43 views 6 comments 0 points Most recent by Shelleyyo Reporting & Analytics for Fusion Service -
Is there a list of tables where the "Manage Geographies" setup is stored?Summary Looking for SQL Tables for the Manage Geographies setupContent Someone has setup some Geography data in the Manage Geographies setup pages which include some hie… -
issues with buyer pdf template for negotiation using the BIPHi team, I have customized the buyer pdf view template for negotiation. Followed all the required steps/ways to achieve it. The new layout does not show u on the configu…
-
What tables to use to pull Learning Class Training Supplier?Summary: Need to find which database tables to use to pull 'Training Supplier' found in Oracle HCM Learning Classes Content (please ensure you mask any confidential info…marcfromhawaii 363 views 5 comments 0 points Most recent by Habiba KAYAAKAY Reporting and Analytics for HCM
-
Users are not able to see custom ESS jobsSummary: The custom ESS job has the permission for BI author role and assigned BI author role to the users still users are not able to see/run the Custom ESS jobs Conten…Chandana.palaparthi 36 views 2 comments 0 points Most recent by NikhilYadav General Ledger & Intercompany
-
How to Sort the data in Resource AlertSummary: We've developed an alert which will notify line managers and listing the employee's (reporting to the line manager) who are all overdue in completing their lear… -
Is any currently using NACHA File Format with more than one addenda record?I am trying to implement a NACHA CTX Format for my eText bank file using the US NACHA CCDP template. I have tried other templates as well. The closest I have come is to …Keith Doucet 31 views 2 comments 0 points Most recent by User_04LIM Payables, Payments & Cash Management
-
Impact of Redwood Changes on backend Tables (OTBI/BIP/FRS Reports)Summary: Any changes to database/table structure for Fusion Financials? Any guide/pointers on what's needed to be checked before/after migrating to Redwood for our exist…
-
Is it possible to track how many employees clicked on a particular tile in the HCM Open Page - Eg: PSummary Is it possible to track how many employees clicked on a particular tile in the HCM Open Page - Eg: Person ManagementContent Hi Team, Is it possible to track how … -
Difference in report outputs in PIMI have a custom report built using SQL based data model, no UI or report level filters. However when I run the report an excel is downloaded with inconsistent report out…
-
Reporting on withdrawn absencesSummary Is it possible to report approved and withdrawn absence bookings in OTBI?Content We have a requirement to start reporting on absences which have been withdrawn b…Elizabeth Docherty 330 views 26 comments 0 points Most recent by Brent_Beardsley Reporting and Analytics for HCM -
How to get Sales Order Return Quantity against the Sales OrderSummary: How to get the Return Sales Order Quantity against a sales order using sql. Content (please ensure you mask any confidential information): Version (include the …
-
Is there any way to track Tile clicks by Users in HCM ?Hello Experts, Has anyone implemented or come across a supported method in Oracle Fusion HCM to track how often Home page tiles (e.g. Team Activity center) are accessed …
-
How to change the week start daySummary: Hello Experts, I created an Analysis and i see the Calendar Week Start Date is Sunday, but the customer need set to Monday. And this impact on the number of wee…
-
OTBI Analysis - Create Action Link for Workspace Activity SubtabSummary: Hi All, In Oracle Sales Cloud we have a workspace tab and we have a Activities subtab. I have an analysis report from OTBI where there is an Activity Title fiel…
-
Why I am not able to see prompts when I navigate through Reports & AnalysisI created an OTBI report in Accounts Receivable with prompts. When I access the report through Browse Catalog, the prompts appear as expected. However, when I navigate v…Sejal Mehta 41 views 5 comments 0 points Most recent by CA Nirmal Choudhary Reporting and Analytics for ERP
-
HCM Position HierarchySummary: Hi Team, We have a requirement to develop a new report as like "HCM Position Hierarchy" standard report, so please share code file or file path and report name …
-
How to keep searching panel available on the screen?Summary: How to keep searching panel available on the screen? Content (please ensure you mask any confidential information): Hi Experts, Would like to reach out to you o…
-
How can I design an OTBI inventory analysis report that displays item serial numbers and lot numbersSummary: How can I design an OTBI inventory analysis report that displays item serial numbers and lot numbers as report columns with subinventory, Qty and Unit cost in O…
-
LMS Utilization ReportSummary: I need to build a report in OBTI that shows our LMS Utilization Rates for our Executive Team. Does anyone have any examples or files that they would be willing …
-
How can I populate longitude and Latitude in OTBI report?Summary: Hello, I am here to inquire about 25B new feature by the name: New Address Attributes Added to Worker and Location Dimensions. I am trying to create an OTBI rep…Vaishnavi Katiyar 21 views 5 comments 0 points Most recent by Melanie Ramirez Reporting and Analytics for HCM
-
Unable to access the certs/attachments on Transcripts for termed employees in oracle fusionSummary: Hello All, we cannot access the certs/attachments on Transcripts for termed employees in oracle fusion. This is an issue anytime we need to pull any type of att… -
Report image only visible in pdf not in wordSummary: Hi all, We noticed that when downloading a custom report in word we cannot see the image/enterprise logo attached. Whereas, when downloading the same report in …Silvia Stangarone CAI 1 view 0 comments 0 points Started by Silvia Stangarone CAI Reporting and Analytics for ERP
-
OTBI Analysis Error: Subquery contains too many values for the IN predicate.Summary State: HY000. Code: 42029. [nQSError: 42029] Subquery contains too many values for the IN predicate. (HY000)Content Hi, I have a OTBI report which needs to pull … -
Facing issue while using OTBI Analysis payroll - calculation card entriesSummary: While using OTBI Analysis, payroll - calculation card real time for a person I am getting 2 rows for a person having LGPS ESCC Scholl employee. After adding ass…User_102WR 1 view 2 comments 0 points Most recent by User_102WR Payables, Payments & Cash Management
-
How to add a new page for the inforletSummary: I was able to add a few report to an existing page. but I want to be able to crete a new page and add all my reports. I added my report using the page Composer …diego m schenquerman 1 view 3 comments 1 point Most recent by diego m schenquerman Reporting and Analytics for SCM
-
How to Automatically Send OTBI Reports to an FTP ServerHello, Has anyone managed to automatically deliver an OTBI report to an FTP server? Is there an Agent that can handle this automatically? If so, could you please share t…
-
How to combine multiple max formula criteria in OTBISummary: I'm having trouble pulling in all employees latest Seniority Dates. It seems I need to pull in 2 criteria: 1. LATEST Seniority Change Start Date & LATEST Senior…CGardner01 31 views 4 comments 0 points Most recent by Manasa Madishetty Reporting and Analytics for HCM