OTBI
Discussion List
-
Help in Query to get Variable Rate for a Benefit of an EmployeeSummary: Hello, Customer Connect! I am in need of developing to get these scenario: If the employee John is enrolled in the Benefit A with the option B, it have a rate v… -
Impact Assessment of Redwood on the Core HR reports and dashboardsHello experts, we are now planning to implement Redwood for Core HR. Can you advise what we should watch out in the Reporting side? Like Changes in the Subject Areas, or…Maria Cristina L. San Jose 37 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
What is table of Supplier Address Transaction Tax?Content Hi all. I need to know what is name of table that stores datas of Supplier Address Transaction Tax. Manage Supplier - Address Details - Transaction Tax. See atta… -
drill down journal general ledger with specific valuewe need to use the drill down function to extract entries in the general ledger with specific values in debit and credit; is there a condition that we can use?for exam…Francesca1 11 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
Using OTBI to report on Specialization Activity Type (Required/Optional)Summary: Has anyone had any luck using OTBI to report on your Specializations and the Activity Types (ie Required vs Optional)? We have a need to build this report, and …
-
Query to get tax registration from supplier address levelSummary Tax Registration from Supplier AddressContent Hello I was wondering if you can share with me any SQL to get the Tax Registration at the address Level. I have the…gabriel kinovisques-163562 4.3K views 6 comments 1 point Most recent by Ch M Prasad-Oracle Payables, Payments & Cash Management
-
Cumulative Salary ReportSummary: Financial report of cumulative salaries per reporting period Content (please ensure you mask any confidential information): Hi experts I have a request to provi… -
OTBI Report - Need Query Transaction Console Approver Name for Job Requisition & Job OfferSummary: Need Query Transaction Console Approver Name for Job Requisition & Job Offer i have tried this query select htce.object_name, htce.task_id task_id_hdr, htce.con…Herman Fersendy 43 views 0 comments 0 points Started by Herman Fersendy Reporting and Analytics for HCM
-
Subject Area to get details related to Maintenance Work definitionSummary: We try to create an analysis in Maintenance module to capture the Maintenance program with Work definition and operations and materials required for the Work or…Kasthuri.S 11 views 2 comments 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for SCM
-
how to derive last day of month in OIC mapper to pass as parameterSummary: Hi All, Could someone please help me in deriving Last day of month based on system date? Content (please ensure you mask any confidential information): I have I…VasanthaFusion90 222 views 10 comments 1 point Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
Report on Duplicate Contacts in BenefitsSummary: I'm looking to see if anyone has come up with a clean way to report on duplicate contacts in Benefits. I have read a few other posts about this issue, so I know…Jessica D 11 views 2 comments 0 points Most recent by Adam Gates-Oracle Reporting and Analytics for HCM
-
How to resolve time out error in running a Fusion BI report specific to an user account?Summary: A specific user is getting time out error after running a report with specific parameter. But the same report with same parameter is working for another user. P…
-
Learning self-servcie setting reportingSummary: Would like to do a OTBI analysis on the Self-service setting and see in which training is seating with which "self-service view" details view // summary view //…
-
How can I pull a terminated employee's last annual salary into an OTBI report?Summary: Terminated Employees salary is not returning the expected amount. Content (required): I'm trying to create an OTBI report to use for balancing my payroll. One o…Sheri Curtis 471 views 8 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
OTBI report available for employeesSummary: OTBI report available for employees Content (please ensure you mask any confidential information): Hello, we have configured a guided journey which is visible i… -
SQL Query for Data Model objects from OTBISummary: I am looking to perform a SQL query of Data Models from within OTBI and need to know which table to query. Content (please ensure you mask any confidential info…Alexinmn 363 views 3 comments 0 points Most recent by marcfromhawaii Reporting & Analytics for Fusion Service
-
Recreating Workforce Goals Reports using BI PublisherHello, For a number of reasons we've had to use BI Publisher to build a report on performance Goals and Goal Plan Eligibility. We've tried to use HRG_PERF_GOALS_SECURED_… -
Is it possible to download a BI report PDF through API from a CRM Groovy script?Hello, We have a requirement to download a PDF from a CRM Service Request screen, when a button is clicked, so we'd like to know if it's possible to run and download a B…Eduardo Ortiz 21 views 2 comments 0 points Most recent by Eduardo Ortiz Reporting & Analytics for Fusion Service
-
How to pass multiple values in one parameter in OIC mapper?Summary: Pass multiple values into a parameter with delimiter in OIC mapper to invoke OTBI Content (please ensure you mask any confidential information): Hi All, I have …VasanthaFusion90 221 views 9 comments 1 point Most recent by VasanthaFusion90 Reporting and Analytics for ERP
-
Payroll Element Entries History excluding terminated employeesSummary Payroll - Element Entries History Real Time subject area is excluding terminated employeesContent I have created a report to pull Annual Salary and Annual Bonus …
-
Employee previous and current locations reportSummary: Looking for a way to report employees and their locations (Current and all previous locations). Content (required): Looking for a way to report employees and th…Scott Conaway 92 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Can I query the values of a fixed list field created in OTM?Hello, We have a user-generated fixed list field in OTM's Order Releases, and I'd like to know if it's possible to query the values in that fixed list field, be it throu…