OTBI
Discussion List
-
Help with Query optimization - Sum of Payroll Balance DimensionSummary: Only months into our post-implementation and our pension report query is consistently timing out. I believe I have narrowed down the offending portion of the da… -
Process Electronic Bank Statements - How to change SFTP passwordContent Our "Process Electronic Bank Statements" scheduled process stopped working in March when the SFTP password was changed and our Finance department just noticed. O…John-SCC 46 views 6 comments 2 points Most recent by Norman Jee Payables, Payments & Cash Management -
Pull birthdays in the next 90 days in OTBI.Summary: Hello all, How to pull birthdays in the next 90 days in OTBI. The logic I currently use is to pull birthdays that fall between WEEK OF YEAR ( CURRENT_DATE) and … -
Multiple join in Procurement - Purchasing Real Time subject area - Need helpSummary: I am trying to create a very simple analysis from the start. But when I add colums from other folders, the rows multiply and the data is convoluted. Content (pl…
-
What are the native reivables dashboards and what is the execution path?Summary: I need to know what the native bashboards of the accounts receivable module are so that the client can use them Content (please ensure you mask any confidential…MARCO GARCIA TOVAR 31 views 1 comment 0 points Most recent by Helle Hennings-Oracle Revenue Management
-
How to find and use a specific kind of configuration/typology of "Event Types" in OTBI ?Summary: There is a specific kind of configuration/typology of "Event Types". It is included in the "Manage Project Billing Value Sets" configuration form You can get th…
-
How to calculate Age with Person Date of Birth and Effective Date variableSummary: Calculating Age using Person Date of Birth and the Effective Date variable based on a date entered in the prompt. Content (required): I need to calculate Age us…GJ79 641 views 7 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
Remove Year from Date in OTBI ReportSummary: I need to set up a scheduled report to go out and not reflect the year of the birth dates. I know how to change the format in the Column Format, but once the re…Jessica D 81 views 6 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
Scheduled report to pull employees with birthdays per monthSummary: I need a scheduled report to pull the employees with birthdays per month. For example on Feb 10, It should pull the list of employees who have the birthdays in … -
Do you have an assessment results report created with OTBI?Summary: I created an assessment using the questionnaire tools in Oracle. Does anyone have a report they can share to get the results of an assessment using the new subj… -
Report for Disabled GL account code combinations with balancesSummary: HI Team, Is there any report in Fusion GL which can list the disabled/invalid account code combinations along with their balances. Thanks Content (please ensure…Mayank Sapra 131 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
is there a way to get data from tables?Apologies for the basic question but is there a way to get data from the Geog Trees, calendar events, work patterns and work schedules please? This is from the backgroun… -
there is a way to check access for the report who have ?Summary: Hi Team, we have placed the BI reports in shared folder and some of have given the access the reports based on request but now we need to track the report who h…AjayKumar Maddipati 31 views 4 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Import Oracle Taleo Recruiting to HCM Fusion.Summary: Hi Team, Could you please let us know, Candidate Imported form Taleo to fusion through "Import Oracle Taleo Recruiting Cloud Service Data" process, in which tab…
-
How to use phone numbers (Work phone, Mobile phone and home phone) in OTBIHi Oracle Community, The customer needs to report the Contact (Person) phone numbers (Work phone, Mobile phone and home phone) in OTBI, but these atributtes are not avai…Daniel Pérez Acevedo 174 views 1 comment 0 points Most recent by Syed Misbauddin-Support-Oracle Reporting & Analytics for Fusion Service
-
Adding 'Trading Partner Type' filtering data "Product Management - Trading Partner Item Real Time"Summary: Filtering Trading Partner details alone by Trading Partner Type is not working as expected with "Product Management - Trading Partner Item Real Time" SA. Issue:…Santhi Vakacharla-Oracle 21 views 1 comment 0 points Most recent by Hari Kurra-Oracle Product Master Data Management
-
How to create a trial Balance either in OTBI or FRC ?Summary: How to create a trial Balance either OTBI or FRC ? Content (please ensure you mask any confidential information): Hello The company would like to have a trial b…Cesar Saveedra 51 views 1 comment 0 points Most recent by Lakshmi Alagappan-Oracle General Ledger & Intercompany
-
Ability to Drill down from OTBI to edit journal passing data access set on general accountingSummary: Deeplink on a column in order to edit the journal , also if the user is set on general accounting on a ledger different from the report row ledger Content (plea…GNCC33 271 views 3 comments 0 points Most recent by CA Nirmal Choudhary General Ledger & Intercompany -
Date Paid is Current Date (the date the report runs)Summary: I have an OTBI report using the Payroll Balances Real Time subject area. The report is scheduled to run every 14 days which is also the Date Paid. How can I set…
-
Requirement to have a report that provides details of changes made to UDTSummary: We have a requirement to have a report that provides details of changes made to User defined tables. can anyone please help us on this requirement? Content (ple…Jagadesh S 21 views 2 comments 0 points Most recent by Satyabrata Nanda Reporting and Analytics for HCM
-
Actual Goal Names are not reflecting in the Analysis ReportSummary: We are trying to build OTBI Analysis Report with the following attributes from Two Subject areas: Person Number, Name, Position Name, Unit, Department Name, Man…sayeed_ahmed 41 views 10 comments 0 points Most recent by sayeed_ahmed Reporting and Analytics for HCM -
ARGENTINA - SICORE. REPORTING OF WITHHOLDINGS IN ACCOUNTS PAYABLESummary: what is the structure that this report should handle according to your country reg Content (required): Argentina SICORE, what is the structure that this report …
-
deletedelete -
Bringing the latest record of the person instead of all records in the OTBI reportHi, I have an Analysis report that contains employee background information, and an employee may log in and leave work more than once, and all records of this person com…Cansel Karasoy 41 views 10 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM -
Payroll run exclusion GroupSummary Identifies employees who are in an exclusion group and will not be included in the payroll run.Content Hi, Can you please suggest if Payroll exclusion group is a…User_2025-01-30-20-59-13-989 42 views 4 comments 0 points Most recent by Nitin.Goswami Reporting and Analytics for HCM -
Calculations with Sum Distinct for Pivot TableSummary: Hi! I am hoping for some guidance regarding a report I am making to predict retirement in my company. I built a formula to estimate the likelihood of retirement…