OTBI
Discussion List
-
Error using 'Upload Customers' FBDI, using OIC processthe error is: Processing Data File: ArUploadCustomers.csv Data files cannot be processed due to incorrect file name prefix. You must provide the Data Files having valid … -
Payables Trial Balance Report ESS Job Template changeSummary: Hi, User requested to create a template change for Payables Trial Balance Report, the ESS job. As this is an oracle developed report you cant make a template ch…aireyevan 53 views 3 comments 0 points Most recent by Shouryadeep12-Oracle Payables, Payments & Cash Management -
How to use ASCII Values in OTBISummary: We are using this statement REPLACE(REPLACE("Document and Rating Details"."Rating Comments", CHAR(13), ''), CHAR(10), '') in BIP Report.How can i use the same s…Narendar-Oracle 1 view 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Missing Fields in SaaS Table ZMM_NOTES Data Sources.Hi All, As Per Oracle Documentation We are able to see the NOTE_TXT field for the Data Source FscmTopModelAM.NoteAM.ExpenseReportHistoryNotePVO but not able to see the s… -
Grade Legislative Information not available in OTBISummary: Grade Legislative Information not available in OTBI Content (please ensure you mask any confidential information): Hi All, We want to pull out the Grade Legisla…Arther Bu 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to schedule an agent to run only if new / upcoming terminations are enteredSummary: Hello, I'm working on a push report for our security operations team who wants to be notified of upcoming terminations entered into the system. Unsure how to pr…CGardner01 11 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Global Transfer and Learning InitiativeHi Team, We’re encountering an issue with our Learning Dashboard reporting due to complications arising from the Global Transfer scenario. Here’s a summary of the proble… -
scheduled report not getting data in output filewe have scheduled a report on daily basis to the SFTP folder using the destination while scheduling reports. Reports are scheduling but not showing data in the output ge…Dara Nagasai 103 views 1 comment 1 point Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
ESS Job to default the output to Email address when submitting the job on demandSummary: Hello ! We have a BI report as an ESS Job, the requirement is to default the email address and the subject and the BI report output (XLS) in this case needs to …vivek.clement 45 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
CUPS Server Printer Setup in ERP BIPSummary: Hi Team, we have below requirement and need to understand. Can some one please help on this. The print server has been installed in Azure with the CUPS service …Nagendra Prasad Gangu 12 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
When passing a parameter to OTBI analysis in Page Composer it is not filtering as expectedDescription: I am trying to do page customization using the page composer for the "BPA Change Order Approval Notification” where I want to add one BI Analysis Dashboard …Dawn Ramos 12 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
How to migrate user folder from one user to other having OTBI and BI reportsSummary: We are changing username for some of the users and we need a way to migrate there reports from old name folder to ne username folder Reports and Analytics Conte…Aakanksha0395 22 views 3 comments 0 points Most recent by Rich Merkel Reporting and Analytics for ERP -
Report for active State Withholding ID for W2Summary: Report for active State Withholding ID for W2 Content (please ensure you mask any confidential information): Hi All, Greetings! We need to get the list of the a…Parag Hiremath 1 view 0 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Annual salary not equal across different subject areasWe are having a problem with annual salary not being equal in Compensation - Salary Details Real Time and Compensation - Workforce Assignment Salary Real Time. It appear… -
OTBI -Costing Receipt Accounting Real Time - Cost Source ReferenceSummary: OTBI -Costing Receipt Accounting Real Time - Cost Source Reference We would like to have the information as per the attached print screen Which is the cost elem… -
How to calculate Learning Assignment Creation Date + 7 Days in OTBISummary: First, I apologize, as I am not a reporting guru like you all so this question may seem rudimentary! I am the main administrator for our HCM Learning app. I oft…Angie Elliott 41 views 4 comments 0 points Most recent by theachiever_07 Reporting and Analytics for HCM -
Report showing working days per person for a period based on work schedule assignedSummary: Trying to report on working days for people based on Work schedule. Content (please ensure you mask any confidential information): I am trying to create an OTBI… -
Extracting the absence durationSummary: Hi, I need to extract the absence duration of employees for a report need. I thought I could use the GET_PAY_AVAILABILITY function for this, but it didn't work.…Barış Ergün 92 views 2 comments 0 points Most recent by Omnia-Oracle Reporting and Analytics for HCM -
Our requirement is to create an OTBI report for local catalogsSummary: We want to find out the below:- Which BPA lines are not assigned to a local catalog? Which CPA/BPA are not assigned to a local catalog? Can we achieve this requ… -
Assigning HR AOR Roles Changed ReportingSummary: We are moving our HR Specialists to AOR Roles, based on Location. And in testing this in our lower instances, everything on the screens is working as expected. …Melissa Gettman 1 view 2 comments 0 points Most recent by Melissa Gettman Reporting and Analytics for HCM -
Employee job levelsSummary: Adding job level to employee report Content (please ensure you mask any confidential information): We have a requirement to show the employee job levels. When I…Ridma Karunanathan 81 views 4 comments 0 points Most recent by Ridma Karunanathan Reporting and Analytics for HCM -
removeposted to the wrong place!Monique 12 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
Access to Project Budget vs Actual and Project Capital Costs reportIs there a specific privilege or data policy to access Project Budget vs Actual and Project Capital Costs report? Project Accountant gives us access however it has too m…dennisepanopio 12 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
Support Incremental is not enabling for BICC extractSummary: Hi Team, we are using application composer custom objects and looks like supports incremental is not getting enabled to this like it happen for seeded ones. Can…Nagendra Prasad Gangu 52 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
How to update Data Time Zone offset in the Data Format tab of Column PropertiesSummary: OTBI report using Posting Date can be displayed in Sydney timezone but when it is used in a calculation in Edit Column Formula, it reverts back to UTC timezone.…Jennifer-Leung 13 views 1 comment 1 point Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
We are trying to access OTBI Reports on Screen Cloud using RSS Feed optionSummary: Not able to access the OTBI reports in the screencloud or any RSS platform. Content (please ensure you mask any confidential information): RSS Feed Version (inc…Adithya Koushik 22 views 2 comments 0 points Most recent by Adithya Koushik Reporting and Analytics for ERP -
Error in OTBI report while using 2 Procuement subject areasSummary: I am trying to create a OTBI report to understand Non catalog Requisitions which are not created from Smart forms. For this i am combining 2 subject areas namel…Shameek 3 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP