OTBI
Discussion List
-
OTBI Subject Area: "Payroll - Personal Payment Details Real Time" --> Target Bank --> Selected AccoSummary OTBI Subject Area: "Payroll - Personal Payment Details Real Time" --> Target Bank --> Selected Account FlagContent HI, I am looking to identify a field in the OT… -
I would like a way to report that includes the following information in one report:Approval Status: Details of the goals. Pending approvals indicating whether they are with the HR manager or department. Goal details before HR approval: To allow review … -
BI Publisher is limited in Storage?Summary: Does anyone know, What is the maximum volume of gigabytes that can be stored in different file formats? Regards, Content (please ensure you mask any confidentia…Hernan Modlin-Oracle 1 view 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Need to add Adjustments and Absences in two different columns. Please hep me with the querySummary: Hi Folks, I need to add Adjustments in one column and Absences in one column in the report in Absence Management. Please help me with the query. Content (please…Raj_540 1 view 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Employees on Leave - Retrieving Assignment Dates for Old Reason CodesSummary: We are trying to create a report that has all employees who are on leave with the date they went out on leave. However, in OTBI if a change is made to an employ…joshvanlaan 3 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
How to get Month name as abbrevation concat with year in OTBIHi Experts, Can someone please help me how can we get Month name Concat with year in the same column in OTBI. We have a requirement to show the date's in the below scree…Dinesh Jaini 91 views 2 comments 0 points Most recent by Dinesh Jaini Reporting and Analytics for HCM
-
How to get the Top-Down Manager Hierarchy in OTBI expect CEO,remining Top down 3 Manager hierarchy.Summary: Currently we are looking to fetch top down manager hierarchy in one of our OTBI reports like from CEO to employee Top level manager hierarchy to fetch in to the…challa praveen 1.1K views 29 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Recruiting - Recruiting Real Time not showing jobs with 0 applicationsSummary: Content (please ensure you mask any confidential information): Hi all, I am trying to build an analysis using the subject area "Recruiting - Recruiting Real Tim… -
# of Specialization Activities Completed - Dimension in OTBISummary: I am trying to build an OTBI analysis that will allow an administrator to pull the progress of team members who have been enrolled in a number of specialization… -
UOM conversion rate attribute in OTBI for Procurement Purchase Agreement Subject AreaSummary: I am looking for UOM conversion rate attribute in OTBI for Procurement Purchase Agreement Subject Area. Any idea if this attribute is available can't seems to f…
-
OTBI Analysis: only select worker records if primary assignment in hierarchySummary: I’m developing a performance document status report for managers, to be ran on self-service basis. I don’t want any records retrieved for a manager unless worke…
-
Duplicate rows in Fixed Assets Depreciation OTBI reportWe've created a custom dashboard to view our Fixed Assets Depreciation, based on the 'Fixed Assets - Asset Depreciation Real Time' subject area. We've found that some as… -
Is there a column "Ship Lines Together" in the "Fullfilment Lines Real Time" subject area?Summary: Is there a column "Ship Lines Together" in the "Fullfilment Lines Real Time" subject area? Content (please ensure you mask any confidential information): Wareho…
-
Invoice Lines DFFSummary: Invoice Lines DFF Content (please ensure you mask any confidential information): Can invoice lines DFF that are displayed under "Details" be shown on the invoic…
-
Reporting duplicate supplier bank accountsSummary: We need to identify the suppliers that happen to have the same bank branch and bank account numbers. I plan to build a data model and a BI report to list the su… -
Duplicate rows in Fixed Assets Depreciation OTBI reportSummary: We've created a custom dashboard to view our Fixed Assets Depreciation, based on the 'Fixed Assets - Asset Depreciation Real Time' subject area. We've found tha…
-
Allow International payments not visible in OTBISummary: Hi, I am working on the Supplier OTBI report, there I have a requirement of the Allow International Payment field, Which is not available in Suppliers - Supplie…Abu Hussain 31 views 1 comment 0 points Most recent by Stephen Westerfield-Oracle Payables, Payments & Cash Management
-
Global Talent Community Pool data not visible in OTBISummary: Hi Team, We are using OTBI to fetch data from the candidate data belonging to "Global Talent Community Pool". However, we are getting only one record having sta…
-
Certification: Retrive attachments information with OTBI or BI PublisherHello, our customer asks to retrive the information associated to the attachments section of certifications (URL and PDF), is it possible? if so, how? Any advice? Thank … -
Procurement BU missing in Top 10 Spend by CategorySummary: Procurement BU missing in Top 10 Spend by Category Content (please ensure you mask any confidential information): Hi Experts, Would like to reach out to you on …
-
SQL to Get Grade and Grade and Grade Step details on a assignmentSummary: Hello Everyone, I'm new to SQL query building. Just getting hands on it. I am trying to create a Data model that will return salary detail including Grade and G…PRABHA_DEV 4.7K views 16 comments 0 points Most recent by Mohamed M. Faramawy-Oracle Reporting and Analytics for HCM
-
Some of reports when we try to download the report we are getting processing errorThere was an error rendering this rich post.AjayKumar Maddipati 22 views 4 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
OTBI error - Error during query processingSummary: We have an OTBI report, pulling from 2 subject areas — Workforce Management - Work Relationship Real Time and Workforce Management - Person Real Time. Our HR us…
-
How to remove the restriction preventing a user from accessing data within an OTBI report.Summary: I have a dashboard containing multiple reports. While the user can access some of these reports, others display errors such as "view error" or "error getting dr…Omran Zeaiter 61 views 4 comments 0 points Most recent by RyanPasca1 Reporting and Analytics for SCM
-
What is the link between Sales order and Discount list through SQL in oracle fusion?Hi All, In my project we have done a customization on Discount lists setup which will apply on the sales order based on Attribute Matrix rules. Ex: so we have added a co…
-
How to disable Export -> Data in selected OTBI reports?Summary: Hello, Do you know how to disable Export -> Data in selected OTBI reports? When user clicks Export -> Formatted -> Excel, the report contains only columns that …