OTBI
Discussion List
-
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 395 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 31 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 214 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 102 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… -
Detecting Managers in OBTISummary: We would like to detect new managers within OBTI. We would like to identify the date that an employee becomes a manager. We have two examples: An original emplo… -
How to make bold font in a custom formulaSummary: Using subject area WFM Worker Assignment Real Time, field Worker/Address Line 4. Is there a way to modify this formula to show 'MISSING' in bold red text? CASE … -
BI report does not open in android devicesWe have a third party payroll integration and we have a report so that payroll outputs can be pulled from self service. When this report is opened from the mobile applic…Ömer Vardar 31 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
I was trying to create a report to pull employees, excluding the managersHow to pull employees using OTBI and to exclude managers who are also an employee. please share ideas thanks.Joliver Caangay 21 views 2 comments 0 points Most recent by Joliver Caangay Reporting and Analytics for HCM -
unable to get the assignment details for pending worker from checklist real time subject areaHello Team, while running the report from checklist real time subject area the orgainzation hierarchy levels are showing null and also all the attributes for assignment …Shivam Naugraiya 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Offering Course Not Showing in OTBI If No Learners Are EnrolledGood Day, I have a specific offering course in fusion application where still no learners are enrolled. I can see this in fusion but when creating an analysis using Work… -
Tables/View for Item and Asset Category to PO categoriesSummary: Tables/View for Item and Asset Category to PO categories Content (please ensure you mask any confidential information): Hi Experts, Would like to reach out to y…