BI Publisher
Discussion List
-
How can we query the error message in BI Server's Report Job History?Summary: Error Log Report that will display the error message like in the Report Job History Content (required): Hi, We wanted to create a custom report that will output…Kristelle 444 views 17 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP -
How to find the difference between two date attributes in eText templateSummary: We need to find out the difference between two dates and add 1 to the result in eText template. Content (required): We need to find out the difference between t…Meenakshi K 1.3K views 9 comments 0 points Most recent by Ruma Bhatnagar-Oracle Reporting and Analytics for HCM
-
Receivable Module : Print Attachment without Invoice Print BI reportOrganization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Description (Required): Hi team, We h… -
Could not establish connection. java.net.ConnectException: Connection timed outSummary: Could not establish connection. java.net.ConnectException: Connection timed out Content (please ensure you mask any confidential information): We are trying to …Sai Krisna 83 views 5 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
per_pos_tree_node_rf and PER_POS_TREE_NODE_RF tables empty, though it is visible from frontendSummary: I am developing an HCM Extract to send Position Structure data external source. One of the required fields is the Parent Position Code for each position. When n…Vishal Purohit 19 views 0 comments 0 points Started by Vishal Purohit Reporting and Analytics for HCM -
OTBI Dashboard Reverted to Old UISummary: Hi team, We have a dashboard that has reverted to an older UI in both Test and Production environments. However, the same dashboard in DEV looks fine and retain…Josel Pleyto 137 views 4 comments 0 points Most recent by Nicolas-Vahman Reporting and Analytics for HCM -
How To Edit Payroll flow report as it is seeded Gross to Net ReportThe data model and report are both seeded for Gross to Net Report. Can you please let us know if the Payroll Flow can be altered to call custom reports as we would like …Srujanya Dodda 61 views 4 comments 0 points Most recent by CSINGH_KCC Reporting and Analytics for HCM
-
Table name of language Level in skill and qualification sectionSummary: Does anyone know the table name of the language Level table name in the skill and qualification section? Currently, I'm using attached BI query to fetch the oth…Saher 104 views 3 comments 0 points Most recent by YashaswaniSrivastava Reporting and Analytics for HCM
-
BIP report for Accrual BalanceSummary: Hi All, We have a requirement to create a BIP report for accrual balances for liabilty account with PO details. The query we are using is not giving us the corr…
-
Is it possible to report on Workforce Compensation Change Statement Volumes executed by managers?Summary: We have our Compensation Change statements configured to Printed and delivered by managers, we would like to monitor and report on how many managers are accessi…Adam_Cantwell 22 views 3 comments 0 points Most recent by Adam_Cantwell Reporting and Analytics for HCM
-
It is possible to track compensation change statements line manager have already downloaded?Summary: Content (required): Hello experts, in the compensation change statements system page (please, see the attached screen) our customer want to create a checkbox wh…Valerio Curzi 4 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Information: Query to get last P2T/T2T Refresh DateSummary: In order to get last refresh date from backend, below SQL can be used: select * from ask_deployed_provision_configs last_update_date column in this table gives …MandeepGupta 491 views 5 comments 15 points Most recent by Sudeep Doke Reporting and Analytics for HCM -
Select query to fetch the PO header detailsSummary: We have a requirement to create a report to show the PO header details Content (please ensure you mask any confidential information): We have a requirement were…Mamdouh Ahmed 49 views 2 comments 0 points Most recent by Mamdouh Ahmed Reporting and Analytics for SCM
-
When attempting to print expense report with pdf receipt, the page goes to error messageSummary: Certain users are unable to print their expense reports from expenses application because when they do, the page spins for a while trying to load and then goes …
-
Changes to expense approval template does not reflect after 24hoursHi all, We have a requirement to modify expense approval template to add the account number to show up on the email notifications. To achieve this, I have modified the '…
-
Combining Oracle HCM Source and data from Microsoft Excel file sourceSummary: Combining Oracle HCM Source and data from Microsoft Excel file source Content (required): We have created a report where we have defined a data model with a joi…Vasanthakumar Ravi 155 views 8 comments 1 point Most recent by ViswanadhK Reporting and Analytics for HCM -
Does anyone know the Oracle BI Publisher Notification can be customized or notDear all, We would like to teach the user to schedule the report, however, does anyone know if this "Job was successfully processed" notification can be customized or no…
-
how to pass dynamically the flow name and instance Id from HCM Extract to SFP FileSummary: In an HCM EXTRACT, We enabled SFTP bursting need to save the file name with flow instance name and flow instance Id dynamically in SFTP server when we ran the e…
-
View PDF Option is not working for some Cancelled PO in fusion.Hi Experts! Recently we are facing an issue with view pdf option in fusion. Case: It is working for PO s which are not cancelled. Its working for some Cancelled POs. But…
-
Only access seeded reports and subject areas in OTBISummary: Client wants a role to allow them to access seeded reports and OTBI subject areas but not any fusion tasks. Is it possible? Can you please guide us?Amit Dey 11 views 2 comments 0 points Most recent by Jehosheba Amruthaluri Reporting and Analytics for ERP
-
Respond To Questionnaire Notification Report template is coming blank. 0kb file is downloading.I have to customize 'Respond To Questionnaire Notification Report' but unable to do so as report template is coming blank. When i am downloading rtf, 0 kb file is gettin…
-
Working report stopped and throwing an error ORA-01722: invalid numberSummary: I was able to use a custom BI Report a week ago. But it stopped working and throwing an error "ORA-01722: invalid number" when running. I am not sure what is ca…Ankurzen 484 views 7 comments 0 points Most recent by Ashok Pavithran Reporting and Analytics for ERP
-
Use of dynamic URL to run the report on Home page linkWe have created a BIP report and used that URL to create a page link on the Fusion Home page. At present, configured using Static URL on the link and it works fine. The …Vijay Ramani VJ 2.3K views 12 comments 0 points Most recent by Lisa Carter Reporting and Analytics for HCM -
How to remove the USD from the Email notification report in Expense module?Hello, We require your support regarding an issue with the Expense Report approval email notification in Oracle Fusion Expenses. Currently, when an expense report is sub… -
SQL query for item master and functional catalog assignmentsSummary: We have a requirement to develop a report to fetch a list of items with catalog and category values. Content (please ensure you mask any confidential informatio…Mamdouh Ahmed 81 views 2 comments 0 points Most recent by Mamdouh Ahmed Reporting and Analytics for SCM
-
Bursting Customer Statement Report on basis of legal entity of the Business UnitSummary: We want to generate customer statement reports on basis of legal entity of the Business Unit. We are making change in the statement data set by adding the legal…Akankshya Jena 115 views 3 comments 0 points Most recent by Gangadhara S Ariga Receivables & Collections
-
Invoking the runReport operation of the ExternalReportWSSService with reportData supported in FusionSummary: Is invoking the runReport operation of the ExternalReportWSSService with reportData as input a supported approach in Oracle Fusion? Content (please ensure you m…Aseef Babujan-Oracle 25 views 5 comments 0 points Most recent by Rohit Mali - API Wizard Reporting and Analytics for ERP
-
Need a query to pickout the balances details in Oracle HCM fusionHi All, Our requirement is to get the balance details of the following balances based on the employee details for a pay period. can you please share the code for that. '…
-
Excel report is not printing the parameter when used with burstingSummary: Excel report is not printing the parameter when used with bursting Content (please ensure you mask any confidential information): Hello All, I have an Excel tem…Pritam Das 23 views 5 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
How to give access to Learning reports onlyHello, Do you know if there are any privileges/ duties for Learning reports? We have couple of users (HRBPs) who need to see how many employees completed a specific cour…