OTBI
Discussion List
-
Are the running records kept in the OIC environment like the scheduled reports?Hi, Is it possible to take the last runtime of the service I prepared in OIC and add a condition in this direction to my sql report?I s such information available? For e…Cansel Karasoy 11 views 0 comments 0 points Started by Cansel Karasoy Reporting and Analytics for HCM -
Unable to get the Calculation card Federal Start Date valueSummary: Unable to get the Calculation card Federal Start Date value in OTBI/BIP query Content (required): I am unable to get the Federal Start Date value in OTBI/BIP qu… -
Current performance calibration and overall target OTBISummary: Content (required): Hello everyone, We are having issues with an OTBI related to the performance dashboard for the Manager. In particular, the otbi "Current per…Gerardo Peluso 51 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Examples of Termination reportsSummary: Content (required): Hello experts, please, could you share some examples of Worker Termination reports? Thanks in advance for your time! Kind Regards, Valerio V…Valerio Curzi 41 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Report for getting list of all Customized objectsIS there a report which can list out all the objects on which either Page Customization or Customization via Designer Studio was done? -
Payroll Deductions by Benefit PlansSummary: Looking to report on employee benefit deductions and their respective plan by pay period. Content (required): We have been tasked to report on employee pre-tax … -
Options for removing receipts and partially invoiced items from the Period End Accrual ReportSummary: What are Options for removing receipts and partially invoiced items from the Period End Accrual Report Content (required): What are Options for removing receipt… -
Working deeplinks/OTBI drill down for CollectionsSummary: Has anyone managed to get the following collections deeplinks to work: Collections (AR_TRANSACTION,PAY) Collections (AR_TRANSACTION,PROMISE) Collections (IEX_CU… -
Formatting a date to appear as APR-22Summary: I am expecting that the period column should present itself as APR-22 for example, but it is presenting the result of 04-22 Content (required): I have a simple … -
How to translate the "Account Analysis Report" in a different currency that the ledger one?Summary: I need to translate the "Account Analysis Report"/"Generate Financial Reports and Account Groups" into a different currency than the ledger one. Content (requir…Teodora Bulancea 51 views 4 comments 0 points Most recent by Teodora Bulancea General Ledger & Intercompany -
Which Role is required for column AsgRepresentativePEO.WORKER_ASSIGNMENT_ID?Summary: I have Created an OTBI report in which AsgRepresentativePEO.WORKER_ASSIGNMENT_ID is cloumn is there I am not bale to access the report , So I am assuming may be…Rajib_Samanta 31 views 7 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
How to adjust a query to return only work email address and add Person NumberSummary: Hi, I'm looking for some help to adjust the below query to only return work email address (W1) and if possible add in Person Number Content (required): select E…Sharon Ferguson 766 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Need formula for Date Paid is in last calendar monthSummary: I have a report using Subject Area Payroll - Payroll Balances Real Time. The report will run on the first day of every month and will capture the number of hour… -
OTBI Report - Phone logicHi Team, I have one report have couple of assignment details, Now I have to add one column phone number. Criteria to fetch phone number is, If the work mobile number is … -
Favourites window only fills half of screenSummary: In OTBI the favourites window only fills half of the screen Content (required): When entering OTBI the favourites window only fills half of the screen, bottom h…DennisOliver 31 views 4 comments 0 points Most recent by DennisOliver Reporting and Analytics for HCM -
How to view specific subject areasSummary: I can't seem to figure out how to access the vacancy numbers under Workforce Management - Vacancy Real Time Content (required): I'm attempting to view the vacan…RyanPE 32 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Available Methods to search for a keyword in ReportsSummary: Available Methods to search for a keyword in Reports Content (required): Hi Team, Greetings! We are planning to modify the payroll balance related setup and tha… -
Error with Next 90 Day SyntaxSummary: I'm getting an error when I use the below formula to get the next 90 days form a specific date field in my filter. Content (required): The error I'm getting bel… -
Dear Experts I want to check do we able to get the translated report in OTBI ScenerioSummary: We have built questionnaires with a translation of the language and prepared the report to see who attended the evaluation and their responses. Currently, we ca…Mohammed Tariq 31 views 2 comments 0 points Most recent by Rajeshkumar_Sekar06 Reporting and Analytics for HCM -
Change Dashboard Icon ColourSummary: Content (required): Recently, our client decided to change the background color of the application, and overall it looks fine but on the dashboard, the icon col…