OTBI
Discussion List
-
SQL Query to Retrieve based on Customer ShipTo Site NumberSummary: Hi, I need SQL Query to Retrieve below data from Ship to Site Number OrigSysShipPartyId OrigSysShipPartySiteId Original System Ship-to Customer Reference Origin…Mahmoud9308 843 views 3 comments 0 points Most recent by Karun Jain-Oracle Receivables & Collections -
need a payroll element costing reportSummary: Need to write a payroll element costing report that includes highlighted information from picture below Content (required): need a report that shows all the inf…Bernadette Dorris 164 views 6 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
How to convert bip report out format into JSON format by using e-Text templateDear Experts, I need to convert Bip report out format into JSON format by using e-Text template. Please send me the e-Text template and how to use that template with XML…Ravindr-Oracle 513 views 1 comment 0 points Most recent by Volodymyr Faranosov Reporting and Analytics for HCM
-
Supplier AgingSummary: We want to develop a custom report basis on the payables aging as on date Content (please ensure you mask any confidential information): Is there any specific t…V.Bharath 42 views 1 comment 0 points Most recent by Vinay Galithoti-Oracle Payables, Payments & Cash Management
-
OOTB Subject Area Partner does not OOTB field Preferred Contact NameSummary: Hi Experts, I am trying to create a simple OTBI Analysis report within Oracle Sales Cloud (CX Sales) SaaS. The OTBI Analysis report should show all Partner Orga…AparajitMalliJawaharBapu 11 views 2 comments 0 points Most recent by AparajitMalliJawaharBapu Reporting & Analytics for Sales
-
Inventory Reservations Query/ReportSummary: Need a report of the information seen in Manage Reservations and Picks (Item, Reserved Quantity, Document Number, Document Line Number) Content (please ensure y…
-
segregation of access within BI Reporting (Reports and Analytics)Summary: Requirement to segregate the access in Reports and Analytics such that user who can deploy the reports to PROD, user who can manage the reports (edit/delete) an…
-
Condtional formating not working for standard fieldsSummary: Adding a conditional formating criteria does not work on standard fields but works fine for flex fields Content (please ensure you mask any confidential informa… -
Where can you find the meaning for the ASSIGNMENT_STATUS_TYPE_ID number?Hi, When running the below query, the table contains ASSIGNMENT_STATUS_TYPE_ID. This is a NUMBER value. Does anyone know where I could find the meaning of the value retu…
-
Unable to get the Payroll Balance Value through Payroll - Payroll Balances Real Time subject areaSummary: Unable to get the Payroll Balance Value through Payroll - Payroll Balances Real Time subject area Content (required): We have payroll balance data for an employ…
-
AOR Areas of Responsibilities in OTBIContent Hi All, Can someone help, which Subject area I can find Assigned Areas of Responsibility details in OTBI? Thanks, VijayUser_2025-02-07-19-03-14-525 1.2K views 11 comments 0 points Most recent by Natalie A. Reporting and Analytics for HCM -
How to pass Business Unit for Customer Site while creating Customers using Customer FBDI UploadSummary: We are trying to load Customers using FBDI (CustomerImportTemplate.xlsm) Content (please ensure you mask any confidential information): We are not able to find …Abhishek Sinha 135 views 3 comments 0 points Most recent by Sairam Surampalli-Support-Oracle Receivables & Collections
-
Permission - BI ReportSummary: We need an audit report with information about which user made the changes to the report's permissions in analytics.Mayara Fulquim 22 views 1 comment 2 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Is there any documentation available on using AND, OR, and groups in OTBI report filters?Summary: I am trying to set up filters in an OTBI report to pull a subset of employees for an assignment in Oracle Learn. I need to select a group of employees and then … -
OTBI does not show attributes standar that were created in Oracle CxSummary: Hello community! When creating an analyst in OTBI, and located in the object "Lead" missing the field "ExpirationDate", this field is standard, however, does no…XUM TECHNOLOGIES 42 views 3 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
Filter to get the earliest date in the OTBI Analysis.Summary: Content (please ensure you mask any confidential information): Hi, kindly asking for your help. I am trying to get the earliest date per account/activity within…Ivony Ann Paula Salango 32 views 3 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
Report to find employees without any presentative (AoR HRBP)Summary: Hi, I'd like to create a report to find if any employees haven't been assigned to any HR Business Partner with an AoR. Do you know if this is feasible and how t…Alberto Americi 61 views 5 comments 0 points Most recent by Alberto Americi Reporting and Analytics for HCM
-
Need query to get who submitted resignation in last 24hourswe have a requirement to get the report of employees who submitted resignation. Can anyone share me the query to get employees data or atleast how can we get data of emp…Dara Nagasai 31 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Mutiple conditions applied at the same time in conditional formatSummary: I am trying to use color code for one column, where two conditions need to apply for the conditional format, meaning that both conditions have to be met at the …JohanneAM 21 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
OTBI Goal Plan ReportSummary Cannot get individuals to show 0 goalsContent Hello all, I am at an interesting place. Using OTBI I am attempting to create a report that shows me how many goals…Nicolas Trojack-24006 301 views 33 comments 2 points Most recent by Nikhila Reporting and Analytics for HCM -
Customer requires a quantity based blanket purchase agreement at header (commodity centric business)Summary: Looking for a solution to track BPAs where the deliverable is gross weight is spread (not-equally/not known) across multiple items. Need to be able to track the…
-
How to report on Owner Person Email in Workforce Management - Checklist Real Time subject areaSummary: Content (please ensure you mask any confidential information): We are building an OTBI report to display Journey tasks metrics using the Workforce Management - …Giuseppe Cannova 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Created new Measure with conditions incorrect result, Workforce Management - Workforce Assignment RTSummary: Hello all, I have created a new measure - Count of Female Managers - FILTER("Worker Assignment"."Assignment Count" USING ((DESCRIPTOR_IDOF("Workforce Management…Ian.Gooderham 11 views 2 comments 0 points Most recent by Ian.Gooderham Reporting and Analytics for HCM
-
Is it possible to give OTBI analysis access to Department Managers without any job role?Summary: Hello, We have a requirement to see PR-related analysis by department managers. These managers are not having roles or data access related to SSP module. Simila…
-
OTBI get name from Person Number in an analysisSummary: Hello, is there a way to get an employee's name from a field that stores their person number? For instance, "Feedback Response"."Created By" in the Workforce Pe…CClark30 72 views 1 comment 2 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
List of standards reports and infolets in Oracle HCMHello, Is there a list of standard infolets and reports in Oracle HCM that companies can use please ? Thank youHiba Ghoualmia 344 views 4 comments 0 points Most recent by Hiba Ghoualmia Reporting and Analytics for HCM -
Account Analysis ReportSummary: Account Analysis Report Content (required): Does any of the GL Analysis report contains supplier name, address and withholding Tax Code? If not which can be mod…
-
financial categoriesSummary: ERP Financial Categories and Fusion Analytic Warehouse Content (please ensure you mask any confidential information): Customer is implementing Fusion Analytic W…VALENTE CORTES-Oracle 41 views 3 comments 0 points Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP