Category 81
Discussion List
-
Accounts Payable Trial Balance Report - no detailsSummary: Why do I only see a summarized amount, when running Accounts Payable Trial Balance Report? How do I get details per supplier? Content (required): Version (inclu…Bo Tøpgaard 92 views 2 comments 1 point Most recent by Bo Tøpgaard Payables, Payments & Cash Management -
AZA: Consecutive Absence ReportSummary: Hi team, We have a requirement to build an absence report for a specific absence type, report should pull the data if the duration of the absence is greater tha…Ahmed AZA 31 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Login In, Login Out and Login Duration of a user in an OTBI analysis.Summary Login In, Login Out and Login Duration of a user in an OTBI analysis.Content Hi, We need to find a subject area that gives the login time of the user into fusion…User_MC37Q 302 views 3 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Trouble in arranging grids and charts in EPRCS Word report packageHi guys! There is a trouble being faced in arranging grids and charts which are referred from a report in Microsoft word report package and your ideas are much helpful. … -
Table name and column for Projects To ProcurementSummary Table name and column for Projects To ProcurementContent Hi Champs, what could be possible Table name and column for Projects To Procurement and payables or any … -
BIP report Excel output is formatting large numbers as General/scientificSummary: We created a BIP report for Fixed Assets. Any numerical values in the tens of millions or higher export to Excel as scientific. For example, an asset Cost of 42…Brad Kirschner 815 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP -
Unallocated AORI've got sql to extract those who have an AOR allocated to them but im looking to do a cleanse on active AOR where a colleague isn't allocated. Does anybody have any tho… -
How to get the Excel option in FCCS Reports - Report Format?Summary: Get the Excel option in FCCS Reports - Report Format? Content (required): Is there any way to get the Excel option under Report Format along with HTML and PDF? …ApOK 31 views 4 comments 0 points Most recent by Dave Roberts_-Oracle Financial Consolidation and Close -
To pull direct and indirect managers list from Compensation Worksheet pageSummary: Hello Team, We have a requirement to pull all the indirect and direct managers in a single column along with their direct line manager from Compensation Workshe…Geej 91 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Total sum of three custom calculated columns is not calculating data correctlySummary I am working on learning report where I need to sum three custom calculated columns to get the total completion of 3 set of courses. I am performing sum of all t…Kamini Kaushik-Oracle 22 views 0 comments 0 points Started by Kamini Kaushik-Oracle Reporting and Analytics for HCM -
BI Publisher - Can you FULL outer join?Summary: Full outer join in a BI Publisher is not behaving how I expect a full outer join should. Content (required): I need to do a full outer join on two sets of data … -
Customize the CourseCompletion Certificate in LearningSummary: Looking for steps to customize the CourseCompletion Certificate report. Content (required): I have a requirement to customize the CourseCompletion Certificate r… -
OTBI report Timing outSummary: Content (required): I am pulling some payroll data using an OTBI but it keeps timing out- How do I increase the time? I can't schedule since I created a DM usin…Riti Malhotra 31 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Manage Audit Policies enabled but output shows 'There are no records to display'Summary: We have enabled 'Manage Audit Policies' for Payables >Invoices (attributes also SELECTED and added) last week. 1) However when we run the "Generate Audit Report…Joel Dsilva 611 views 3 comments 1 point Most recent by Donna Curtis Reporting and Analytics for ERP -
"Benefits - Enrollment Real Time" Subject Area Not Populating Plan Name without Payroll Element NameHello all, I have a requirement in which I need to display benefits plan and corresponding payroll element name in OTBI Report. I am using "Benefits - Enrollment Real Ti…Khush Tiwari 64 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Dashboard PromptSummary: Content (required): Version (include the version you are using, if applicable): Oracle HCM 21D Code Snippet (add any code snippets that support your topic, if a… -
Bursting - Multiple Templates - Multiple DestinationsSummary: Bursting Query for sending email notifications to an employee and line manager, each with their own template. Content (required): Hello, We have a requirement w… -
22B: Asset Additions Report with custom template not producing data.Summary: After upgrading to 22B, Asset Additions Report with custom template (data module is same) is not showing any data. Content (required): PROD is working fine but … -
where we see all Scheduled jobsHi Team, where we find the all scheduled BI jobs In instance and previously I checked through Administration>Manage Jobs . But In 22A I unable to to find out that sectio…AjayKumar Maddipati 11 views 4 comments 0 points Most recent by AjayKumar Maddipati BI Publisher Learning Center -
BIP Query to pull unapproved/pending absences from last 10 daysHi Team, Could you please help me with the BIP Query to pull unapproved/pending absences from the last 10 days? It would be great if you can share DM or query for the sa… -
Plan to Produce Infolets are not appearing on Home PageSummary Plan to Produce Infolets are not appearing on Home PageContent Hi All, We are not able to see any infolets on Plan to Produce Infolets section. Please let us kno…Siva Kumar-Oracle 36 views 1 comment 1 point Most recent by CumminssCP Reporting and Analytics for SCM -
Getting the Period Start Active Headcount to equal the previous months Period End Active HeadcountSummary: Getting the Period Start Active Headcount to equal the previous months Period End Active Headcount Content (required): We need to get the Period Start Active He…Rebekah Gilday 72 views 6 comments 0 points Most recent by Rebekah Gilday Reporting and Analytics for HCM