OTBI
Discussion List
-
How to display Active employees count month wiseSummary How to display Active employees count month wiseContent Is there any way on calculating employee count by month in OAC. The starting point is an Employees table …Saptadip 421 views 6 comments 1 point Most recent by Lakshmi Devi Bathala Reporting and Analytics for HCM -
Supplier account balance confirmationHi Team, We need to confirm open balances with suppliers per specific date. Is there any standard report available that shows all outstanding/unpaid invoices per supplie…
-
Position Grade Code and Position Grade Name not being populated in OTBIHi all, We have an issue that the Position Grade Code and Position Grade Name is not being populated in OTBI. The only field that is populated is "Valid Grades" and this…
-
How to get Header Columns in a BIP Report Export in Camel case?Summary: When creating a BIP Report, the header columns specified in our data model are in camel case. However, when we export the report in CSV format, these header col…
-
Can you share Expense Reports OTBI including Approver information ?Summary: Can you share Expense Reports OTBI including Approver information ? Thank you Content (please ensure you mask any confidential information): Version (include th…
-
User and Report Access ReportBusiness is requesting a report that have the following columns details: User username Report Name Period Inventory Valuation Report Source Of Report Scheduled Process o…
-
How to change the default Location flexfield Segment Label "State segment"?Summary: Hi, For the location key flexfield structure, we have 3 segments: Campus, Building and Room as segment1, segment2 and segment3 respectively. To assign the segme… -
Is it possible in one report Bursting and ad hoc running possibleIs it possible to create one report where Bursting setup will ensure that the report is distributed to the correct recipients as specified, whenever it is run on an ad h…Sangeetarani Padhi 31 views 1 comment 0 points Most recent by Angel Jimenez-Support-Oracle Reporting & Analytics for Fusion Service
-
locator name and lot number in costingunable to find the locator name filed in OTBI subject area "Costing - Cost Accounting Real Time", we are able to see locator id and locator description etc, we need loca…
-
How to identify new lines in a PO through tables?Hello community, We are customizing the purchase order PDF, and in a requirement my client asks to show the new lines that have been included in a change order after the… -
How to get items list along with Inventory organization associationSummary: How to get items list along with Inventory organization association Content (please ensure you mask any confidential information): We need list of items along w…
-
Busting OTBI Myths - Reporting current and previous values side by sideContent Myth: You can't report current and previous values side by side One common example is reporting the current assignment values and the previous ones after an assi…Julian Challenger-Oracle 396 views 11 comments 5 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Time Lag when changes in Procurement appear in OTBIChanges made to PO's, Requisition do not appear immediately in OTBI but after a number of Hours? Is there a process that pushes through the Changes to OTBI?
-
How can we get the Posted Revaluation amount calulation on Daily basis not period?Summary: Bank customer and daily running the revaluation and wants to see the posted revaluation amounts for each foreign currency and revaluation rate. Content (please …Eswarvoona-Oracle 11 views 1 comment 0 points Most recent by veerendranath pulivarthi-Oracle General Ledger & Intercompany
-
Regarding the security role required to access OTBIDespite assigning the AP role to the user, the AP OTBI is not displayed. It is likely related to security roles. Could you please tell me the security role required to a…yuyano-Oracle 32 views 3 comments 0 points Most recent by Swapnil Kashid Payables, Payments & Cash Management
-
Access to OTBI from the subject area Security - Roles and Privileges to resolve access issuesSummary Need to to provide more broadly access to the OTBI from the subject area Security - Roles and Privileges subject area to help resolve access question more quickl…amy hardtke 1.5K views 4 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
Copying OTBI reports in bulkSummary: Copying OTBI reports in bulk Content (please ensure you mask any confidential information): Hi Team, Greetings! There is a requirement to copy multiple OTBI Rep…Parag Hiremath 11 views 5 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Subject Area for Personal Payment Method DetailsSummary Subject Area for Personal Payment Method DetailsContent Hi All, Can any one please help me to find OTBI Subject area for personal payment method details. I have …nitin Sharma 217 views 13 comments 1 point Most recent by GopiKAutomus Reporting and Analytics for HCM
-
Oracle EBS BOM equivalent query in oracleSummary: Hello Team, I am researching on fining the equivalent query we are using EBS in Oracle Cloud. SELECT al2.organization_code, al1.item_number, al1.operation_seq_n…Jignesh_HAE 31 views 7 comments 0 points Most recent by Thierry Lamote Supply Chain Planning and Collaboration
-
Issue with missing value list in Receivables to Ledger Reconciliation ReportSummary: Hello, I’m trying to run the Receivables to Ledger Reconciliation Report, but I can’t see the value list. I currently have the standard roles assigned. Does any…Teresa Martinez-Oracle 1 view 1 comment 0 points Most recent by Deepak Singal Receivables & Collections
-
OTBI Analysis, Payroll - Calculation Cards Real Time - PAE - How do I show each linked assignment?Summary: I'm trying to create an analysis to report on employee Calculation Cards using Payroll - Calculation Cards Real Time and in the case of employees with multiple …Julie Searles 91 views 1 comment 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM -
Is there a way we can use embedded reports for custom error messagesWe have a requirement to have an error message to validate entries in a standard field in Learning module. As far as we have checked, there are no autocomplete rules ava…
-
where to find the course publish start date in OTBISummary: I need to publish a report of all active courses. Till now we're using the publish start and end date to "unpublish" courses in our catalogue. However, whatever…
-
Opportunity Marketplace Out of the Box ReportingSummary: Opportunity Marketplace Out of the Box Reporting Content (please ensure you mask any confidential information): Are there any out of the box reporting for Oppor…