Reports
Discussion List
-
Blank page appears end of report in RTF template even though conditional split page is used.We are encountering an issue in a BI Publisher RTF template where an extra blank page is generated at the end of the PDF output. The template uses a conditional page bre…Sai Teja Madishetty 76 views 1 comment 0 points Most recent by Yemi Onigbode Reporting and Analytics for ERP -
Query for Approval DelegationContent Hello, I am looking to build a BIP Report which displays whenever someone has delegated approvals to someone of a lower job level - does anyone know where this i…Elliot Hall-Walker 334 views 4 comments 1 point Most recent by SR_1234 Reporting and Analytics for ERP
-
insert line break inside a conditional statement in rtf letter templateSummary: insert line break inside a conditional statement in rtf letter template bi publisher Content (required): creating an RTF letter template and need to insert a li…Akhil Vutukuri1 2.3K views 3 comments 0 points Most recent by Ashish1Soni Reporting and Analytics for HCM
-
Poor Query Performance of CMP_ASG_SALARY_VSummary: A simple query on this view runs 40+ minutes. We are experiencing poor performance with the CMP_ASG_SALARY_V HCM view. When doing a simple SELECT statement with…
-
Get candidate attachments for BIP Data ModelSummary: Option to get the URL for accessing a candidate's attachment in the Recruiting module Content (please ensure you mask any confidential information): Hello every…
-
NR Chart Legend Label/Text Cuts Off or Not Displaying in fullHi Everyone, Anyone know if there's a way to get this label text to display in full? The legend doesn't seem to be adjusting for the longer member alias. I found a KB ar… -
Project Class Category Causes Duplicate Rows for Project Financial Information in OTBI and BI PUBSummary: When we want to report on the Project Classifications class categories for a project number there is no clean way to do it. The current solution we are doing re…
-
HCM alerts real time Subject Area - data not returningSummary: HCM alerts real time Subject Area - data not returning Content (please ensure you mask any confidential information): Hello I am trying to write an Analysis usi…
-
Machine learning files - CausalityAnalysisPromptTemplateSummary: what is the best way to update this machine learning files to show my data without %. Do I take a copy of an existing example, or do I write my response based o…
-
How to report on journey task expiration configuration?Summary: Is it possible to report on journey task expiration configuration (i.e. Task 1 expires 10 days after assigned date, Task 2 expires 10 days after due date, etc.)…
-
Lease details report showing values in adjustment column for ROU but not for lease liabilityWhen a lease is amended, the lease details report is updated with the adjustment amount for both ROU and lease liability balances. However, upon amending the same lease …
-
Can we filter the data in reports based on smart list member?Summary: I am preparing one report where i am using smart list. I have smart list member created like - Bank Overdraft,Term Loan, Lease Liabilities and i am recording va…Chakresh 51 views 4 comments 0 points Most recent by Dave Roberts_-Oracle Financial Consolidation and Close
-
How to fetch the survey section from Performance DocumentHello Experts, Does anyone know where in the tables to fetch the Survey section from performance document? Please Help! TIA
-
Query to get Scheduled BIP Jobs in Oracle Fusion HCMHi All, Is there a way to retrieve the schedule details of BIP reports like job name, report name, schedule start date, schedule end date, frequency etc. using a sql que…Dhanuka Chamal 1.7K views 4 comments 5 points Most recent by gclampitt Reporting and Analytics for HCM -
OTBI Report coming up with blank dataSummary: We created an OTBI analysis in Recruiting in Real Time and data is coming up blank. Content (please ensure you mask any confidential information): Summary: We c… -
How can I retrieve the full details of each exception?Hi everyone, I’m working on a report that returns schedule exceptions using the following query: SELECT 1 KEY, pse.SCHEDULE_EXCEPTION_ID, pse.SCHEDULE_ID, pse.SCHEDULE_A…Andriampeno Odilon 32 views 4 comments 0 points Most recent by Andriampeno Odilon Reporting and Analytics for HCM -
Is there a reporting function to return the first child of the current POV member?I am trying to figure out a way to return the first child of the current POV member in a report. For example, if the outline below was a dimension hierarchy and the user… -
Syntax for referencing a user privilege in an EL ExpressionSummary: Content (please ensure you mask any confidential information): Hi, I am trying to build a custom menu to access OTBI reports from the Navigator / springboard . …NeenaS25 13 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
Datedifference formulae function in FCCS ReportsI want to calculate a days difference between 2 dates in fccs reports by the datedifference function available in FCCS reports, I have already used the multiple combinat…Chakresh 61 views 8 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Issue with Views in HCM cloud Learning Management (WLF_LRNR_COMPLETION_DETAILS_V) in SpecializationSummary Joins are missing in the Specialization item type part in the Views WLF_LRNR_COMPLETION_DETAILS_V and WLF_LRNR_COMPLETION_SUMMARY_VContent In the code of the vie…Rajesh Ravikumar 56 views 3 comments 1 point Most recent by R Ravichandran Reporting and Analytics for HCM
-
Import Oracle Fusion Data Extensions for Transactional Business Intelligence having an impact.Summary: There's an issue with HCM Reports having said that some columns were not available and the root cause of it was when Import Oracle Fusion Data Extensions for Tr…Franz Marcelo 1.3K views 8 comments 1 point Most recent by Rich Merkel Reporting and Analytics for ERP -
Table/View for AP Invoice Approval History & Workflow (BPM Flow)We are in the process of creating a customized report to track the complete approval history of AP invoices in Oracle Fusion. The requirement is to fetch details of the …sailesh_cloudare 328 views 3 comments 1 point Most recent by NikhilYadav Reporting and Analytics for ERP -
Headerless csv output in oracle fusion BI reportingSummary: Hi Team, We have a requirement to get the extract in CSV format without header fields in the Oracle BI report. Content (please ensure you mask any confidential …