BI Publisher
Discussion List
-
Get Journal Entries Details For An EmployeeSummary: Team We would need to fetch Accounting Date & Transaction Number From Journal Entries. (Payroll-> Review Journal Entries) For An Employee Columns are: Accountin…Manoharan 51 views 1 comment 0 points Most recent by Nalsoft Pvt Ltd Reporting and Analytics for HCM -
Withholding tax base on rateSummary: withholding tax report, invoice with withholding base particular rate Content (required): transaction date, withholding rate and amount, invoice number Version …
-
Employee Missing PPM detailsSummary: Hi everyone, I need a query for those employees whose bank details are missing(PPM), If anyone has this query. Please share with me. Thank you.Saher 11 views 3 comments 0 points Most recent by Karla Dixon-Proactive Support SPA-Oracle Reporting and Analytics for HCM
-
Employee Audit ReportSummary: Are there any delivered reports or custom BIP reports someone could share to help with an Employee Audit Report? I have already included the required Employee i…
-
Template for large BIP reportHi Which template is it recommended to use if we need to generate reports which require layouts with many columns. Using the wizard for creating .xpt reports, it is diff…
-
LISTAGG Function Not workingSummary: Hi Team, Please help me debugging or optimize the below query. Content (required): The result: The result I want: Version (include the version you are using, if…Robinson Ng 31 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
AR Cash ReceiptsSummary Which Role gives us the access to print AR Cash Receipt Print report?Content Which Role gives us the access to print AR Cash Receipt Print report? Version 21BKanika Mahajan 46 views 2 comments 0 points Most recent by Srivatsav PR-Oracle Receivables & Collections
-
OTBI create/edit/view accesshi, We have a requirement to give OTBI access to business users. business user should be able to create/edit/view report for all the subject areas Should not have access…Nivya Mathire 51 views 3 comments 0 points Most recent by Skolli-Oracle Reporting and Analytics for HCM -
Archive/Unarchive buttons missing in Catalog ReportsSummary Archive/Unarchive buttons missing in Catalog ReportsContent Hi All, Archive/Unarchive buttons missing in Catalog Reports Thanks, Dev Thota. Version 21BDevendra Thota 475 views 3 comments 3 points Most recent by Skolli-Oracle Reporting and Analytics for ERP
-
eText RTF error on Open "XML-20211: (Fatal Error) '--' is not allowed in comments."Summary: Hello I've attached my eText RTF template (in Docx extension per forum rules) and XML (as .txt) I have gone over the template and my Data Model SQL data sets bu… -
Long Running Custom BI Report OptimizationSummary: We have created custom BI Report which is running for long almost 4.5 hours and wanted to improve the performance of the report. we have used sub query in the s…
-
Add Days to day_start_timeTeam, How to add days to datetimestamp. We have a requirement to add one week to the date timestamp and display. day_start_time in hwm_tm_rpt_entry_v. If the date is 25-…Manoharan 21 views 2 comments 0 points Most recent by Rajdeep Chavda Reporting and Analytics for HCM
-
How to use Custom fonts i.e., Open Type Fonts (.otf) in BI ?Summary: How to use Custom fonts i.e., Open Type Fonts (.otf) in BI ? Content (required): Version (include the version you are using, if applicable): Oracle Fusion Cloud…
-
Viewing USD AmountSummary Viewing USD AmountContent Hi, We have many companies in different countries that have different currency. We designed an pivot table using OTBI for Purchase Orde…User_2025-02-05-02-38-04-251 39 views 6 comments 0 points Most recent by Zehra M Reporting and Analytics for ERP -
Increase font for Dashboard Link objectSummary: Increase font for Dashboard Link object Content (required): We are developing the report landing page using a dashboard page where we want to link all reports. …Ajit Dani-Oracle 31 views 3 comments 1 point Most recent by Ajit Dani-Oracle Reporting and Analytics for HCM
-
Tables available for ConnectionsHi, What are the tables available for "Connections" reporting. Regards, NivyaNivya Mathire 51 views 5 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Catalog objects not visible while creating Data model using Oracle BI analysisSummary Catalog objects not visible while creating Data model using Oracle BI analysisContent I am creating a new Data Set using Oracle BI Analysis, when I click on Orac…User_2025-02-03-21-28-21-735 53 views 3 comments 0 points Most recent by David Wright - More4apps Reporting and Analytics for HCM
-
Need to display Employee Image in the BIP report outputSummary Requirement to display Employee Image along with employee details in the BIP report outputContent Hi All, We have a requirement to display Employee Image and wit…
-
Report to show OTBI filters/parametersSummary Report to show OTBI filters/parametersContent Is there a report available, or a way, to pull report filters/parameters out of OTBI analyses to view? I have a lar…User_2025-02-08-04-25-10-086 55 views 4 comments 0 points Most recent by Caroline.E.B. Reporting and Analytics for HCM
-
To capture Personal Payment method changesSummary: To capture Personal Payment method changes Content (required): Planning to develop a extract to capture personal payment method changes . My question is , how t…
-
AOR Query Performance IssueSummary: Hi Everyone, Currently, I'm working on a report. The purpose of this report is to retrieve pending records. The main query works fine. I'm facing an issue with …
-
The report cannot be rendered because of an error, please contact the administrator.Summary: We have a custom report and when business user is trying to run the report below error is displayed Content (required): The report cannot be rendered because of…Kaushik Pola 381 views 6 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
Tables to find leave approval detailsSummary: Tables to find leave approval details Content (required): Hi All, We got a report requirement to show leave details with who approved the leave. From which tabl…
-
Checkbox value not getting fetched in backendSummary: Content (required): A checkbox dff has been created in such a way that if it is checked then Yes value from the value set will be picked and if not checked then…Pranjal Mohla 11 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
when we run the RTF template report we getting below errorSummary: HI Team, we have RTF developed template but now we have enchement on statement of text so we changed the matter but we getting below error. please assitance on …AjayKumar Maddipati 31 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
How to identify process id of data load triggerred using HCm extractSummary: Need to know logic to find process id of a HDL load carried out using "inbound integration" delivery type option within a HCM extract using a BIP query Content …
-
Which table has data for 'Manage Data Access for Users' where security context is 'Legal Entity'Summary: We have created a BI Publisher report which is restricted to role - 'Cash Manager' via permission option. From task 'Manage Data Access for Users' we can restri…Sudip Kumar Mishra 610 views 0 comments 1 point Started by Sudip Kumar Mishra Payables, Payments & Cash Management
-
How to wrap BI ParametersHi, I would like to have two lines for parameters instead of a single line when reports have more than 4 parameters. Is there any way to wrap or split BI report paramete…
-
How to make MICR bold in AP checks?Summary: Couldn't make MICR bolder using the AP checks in RTF Template. Content (required): i I have tried changing the MICR tag bold in RTF template ii I have tried add…Krishna Kumar v 11 views 0 comments 0 points Started by Krishna Kumar v Reporting and Analytics for ERP