Reports
Discussion List
-
SQL Query for Project Budget InformationSummary: Hi Please help us to answer the table and the column for this project budget information (all project not specific project): Version Status Project Number Task … -
Error In Generating Some Books In Update 26.08.95Summary: For some books we are now getting an error message "An error occurred while processing CascadeElement…". See below screenshot for reference as well. This was wo…
-
Planning Reports Bursting is failing overnightSummary: We have always had Reports bursting overnight without issue, however the last two nights we are getting failure notices where it looks like it is losing connect…
-
How can i suppress report parameter by hardcoding the valueSummary: How can i suppress report parameter by hardcoding the value Content (please ensure you mask any confidential information): How can i suppress report parameter b…Tapas_Sathua 9 views 1 comment 0 points Most recent by James McBride Reporting and Analytics for ERP -
Adding filter to NR reportSummary: I created a report in NR and the business would like to implement a filter on the conditional text in the report - i checked online and i see there is some docu…
-
Calculate formula based on Hidden columns from top level memberWe have a requirement where we for Balance sheet we are calculating a column that says if it is above threshold or not for each row. This calculation takes place on basi…
-
Need SQL to get Element Duration DatesSummary: Need SQL to get Element Duration Date, that is at assignment level. Content (required): Need SQL to get Element Duration Date, These dates are present in 3 leve…Raghavendra M 249 views 2 comments 0 points Most recent by Pooja Sunki Reporting and Analytics for HCM -
Preview Offer didn't show Draft Watermark while previewing the offerSummary: Content (please ensure you mask any confidential information): Dears , I added Draft Watermark to the rtf file and while trying to preview the offer the draft w…Beshoy Hakim-Oracle 12 views 1 comment 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
Draft WaterMark missing while previewingSummary: Content (please ensure you mask any confidential information): Dears , I am working on adding DRAFT watermark on rtf file , it working offline while testing on …Beshoy Hakim-Oracle 14 views 1 comment 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
Is it possible to realize OTBI analysis to extract manager different from line manager data?Summary: Possibility to realize OTBI analysis to extract manager different from line manager data? Content (please ensure you mask any confidential information): Hello, …Caterina Ruggiero 8 views 2 comments 0 points Most recent by Baskaran Sambandam Reporting and Analytics for HCM
-
How to convert English language to Arabic in rtf templateSummary: how to convert below English text into Arabic language and split it into two lines in rtf template. Example input text: "EIGHT HUNDRED FIFTY-SIX BAHRAINI DINARS…SireeshaJaladi 610 views 3 comments 0 points Most recent by User_5IBUB Reporting and Analytics for ERP
-
Query to find fusion user details with their rolesI need to create a BI report which retrieves user information like user_id,username , email of the users along with their role information like role_id,role_common_name,…
-
Canceled report job is still runningSummary: Hi all, We have canceled a report's schedule job but for some reason the report is still being generated and sent to the users. If we check the Manage Report Jo…Maria Dantas 42 views 7 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
“Connection is either null or invalid” Error Only for HR Specialist (Custom Role)Summary: We have a BI Publisher report in the Custom folder. When I run the report using my implementation user, it works correctly and generates output. But when we log…Raghavendra M 23 views 4 comments 0 points Most recent by Abbas Sibai Reporting and Analytics for HCM
-
Lease transaction and balance report for a specific month and Opening Balanc ROU is not reflectingSummary: I tried generate the report "Lease transaction and balances report" for the month of Aug in the prod, but it ended up running with the ROU accounted opening bal…
-
Custom heading in reports issue.We would like the top-row member to stay as a custom heading, while the zoomed-in members use the default headings. We have already tried conditional formatting, but it …DebajyotiRay 19 views 2 comments 0 points Most recent by Ramith Attravanam Financial Consolidation and Close
-
Manage Audit Policies -> AUDIT_CHANGE_BIT_MAP_Content Helo, I have activate the audit of assignment object : Navigator > Setup and Maintenance > All Tasks > Name : Manage Audit Policies> Search > Go To task > Audit …User_2025-01-25-01-33-46-269 621 views 6 comments 0 points Most recent by Rashmi05 Reporting and Analytics for HCM -
How to get Phone number, Email Address, Home Address and Bank details old values using BIP ReportSummary How to get Phone number, Email Address, Home Address and Bank details old values using BIP ReportContent Hi Team, We are creating new HCM BIP Report to Fetch the…User_2025-02-01-06-07-07-886 864 views 9 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
OTBI Dashboard and Reports for ExpensesSummary An OTBI dashboard with a series of drillable reports for ExpensesContent The attached catalog files can be imported into an ERP Cloud instance to create a dashbo…Andy Gough 4.6K views 31 comments 31 points Most recent by Lionel Rajesh Devanbu Reporting and Analytics for ERP -
which duty roles would give access to BI Publisher Report which queries these tablesHello All, We want to give access to a custom role to a BI Publisher Report that queries these tables: per_periods_of_service ppos , per_assignment_secured_list_v paam ,… -
How to enable password for P60 Document with date of birthSummary: We are trying to password protect the Oracle P60 document with employee's Date of Birth. The XML doesn't have the Date of Birth tag. Can we modify the seeded Da…
-
I want to group the date year wis in results file which excelFor one of my extractions in report code I am extracting date with code : Trunc(creation_date) CREATION_DATE and in excel layout I hv made the creadtion_date cell custom…
-
Build BI Pub for Representatives Details InformationHi Everyone, We are currently building a BI Publisher report to retrieve detailed information about Representatives. The report and SQL query work as expected in our Tes…Andriampeno Odilon 6 views 0 comments 0 points Started by Andriampeno Odilon Reporting and Analytics for HCM -
roundingSummary: Sum of rounded numbers issue Content (please ensure you mask any confidential information): So I edit a report and find that a total column references sum of an… -
Oracle BI Report bursting throwing errorHi Team, I created 5 reports and all 5 are scheduled in Prod. Only 1 report is getting failed while bursting. Getting below error. Detail Message: ::JOB_WAIT_TIME_SECOND…VijayRajalbandi 199 views 4 comments 0 points Most recent by User_NAIBF Reporting and Analytics for HCM