BI Publisher
Discussion List
-
OTBI Graph: Maintain Same Color for Multiple Measures of the Same SupplierHi, I'm working on an OTBI Analysis in Oracle Fusion and have a requirement to display both Invoiced Quantity and % of Quantity in a stacked vertical bar chart. Currentl…sakthi.paramasivam 5 views 1 comment 0 points Most recent by Abbas Sibai Reporting and Analytics for SCM -
“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 18 views 4 comments 0 points Most recent by Abbas Sibai Reporting and Analytics for HCM -
How to track email delivery status for the emails (invoice, dunning) sent to customers?Summary: Oracle Fusion Accounts Receivable (AR) sends high volumes of customer emails daily, such as Invoices, Customer Statements, and Dunning Letters. However, there i…
-
How retrieve a list of BIP report names and paths that use a specific table name?Summary: How to retrieve a list of BIP report names and paths that use a specific table name? I wanted to know the list of BIP Data models used below benefit tables. Tab… -
Unable to find “Enterprise Scheduler Job Application Identity for HCM” user/Application RoleSummary: Unable to find or assign “Enterprise Scheduler Job Application Identity for HCM” user after recent Oracle release Content (please ensure you mask any confidenti… -
per_person_secured_list_v view problemSummary: per_person_secured_list_v view is ignoring past events Content (please ensure you mask any confidential information): Hi, we have an admin user and she should h…Stefano_Mazzocca 100 views 4 comments 0 points Most recent by Stefano_Mazzocca Reporting and Analytics for HCM -
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 616 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 859 views 9 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
Global and Local Learning Specialist not able to see correct data in Learning History BI ReportSummary: We are currently implementing the Learning Module, which involves distinct HR roles with different levels of access: 1. Global Learning Specialist: Has View All…
-
Way to fetch Value By Criteria Definitions in custom payroll fast formulaSummary: Way to fetch Value By Criteria Definitions in custom payroll fast formula select * from PAY_VBC_VALUE_IDENTS? I'm not seeing my records in HCM BI query Thank yo…jtwhit_hcm 83 views 2 comments 0 points Most recent by Balamurugan.N-Oracle Payroll and Global Payroll Interface (GPI)
-
ACA Eligibility Process caused duplicate Action Codes to appear with differing datesWe found that the ACA Eligibility Process is duplicating action codes on employees' assignment histories and it's not clear how we would easily query assignment records …
-
Duplicate of Print Receivables Transactions Report fails to reach parameter selectionSummary: I have created a duplicate of the Print Receivables Transactions Report to be able to add an additional parameter to the report. Upon duplication the process sh…
-
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 ,… -
Unable to search employee on Assign Learn?Summary: Unable to search employee on Assign Learn? I have followed below steps , didn't resolved the issue. Add the PER_ENABLE_WORKER_SEARCHES_USING_EFFECTIVE_DATES_PRI…
-
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 3 views 0 comments 0 points Started by Andriampeno Odilon Reporting and Analytics for HCM -
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 189 views 4 comments 0 points Most recent by User_NAIBF Reporting and Analytics for HCM
-
Unable to deliver the file to SFTP serverHi Team, We have created SFTP server and while clicking on "Test Connection" the connection is showing as successful. But while we are scheduling the extract to the resp…MaheshRayudu7 94 views 3 comments 0 points Most recent by Zohaib-Oracle Reporting and Analytics for HCM
-
What is the retention period for BIP reports & ESS Jobs in Oracle fusion applicationSummary: We wish to know the retention period of BIP reports & ESS Jobs in Oracle fusion application. Also needed any Oracle documentation that helps in understanding th…Shabharish.Pasupula 52 views 3 comments 0 points Most recent by Shabharish.Pasupula Reporting and Analytics for ERP
-
Table to get special purpose field of input valueHello, I'd like to know if anyone has an idea on where I can find the field of ''Special Purpose' and its value, whether it's a table or a query would be very helpful. I…Mayar Mohamed 2 views 2 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
Dynamic column generation - Reporting with BIP (RTF/Excel Template)Summary Need to dynamically generate columns based on the number of elements currently present in the ApplicationContent Hi, We are currently on Release 13 Oracle Cloud …Brendon Charles-24581 310 views 5 comments 2 points Most recent by DebashishDeka Reporting and Analytics for HCM -
Query to fetch Approvals Groups Across Workflow ModulesSummary: We need to update a workflow approval group. I’d like a query that shows, by module, every workflow rule that will be affected by this change. Exemple: Approval…
-
User Login Activity QuerySummary: We have a contractor and would like to measure his level of effort within our company. Is there an existing query or report that shows how many times a specific…
-
PER_EXTRACT_UTILITY performance in reportingSummary: Hi experts, quick question, is PER_EXTRACT_UTILITY faster than querying the actual table in BIP? e.g. we can use get_decoded_lookup to get the Meaning of the lo…
-
Customizing Separate Remittance Advice Subject with dynamic valueSummary: Customizing Separate Remittance Advice Subject Content (please ensure you mask any confidential information): Hi Team we should customize the subject with PAYEE…Luca Nobili PWC 294 views 7 comments 2 points Most recent by Kara Hart Payables, Payments & Cash Management
-
Where does the payment acknowledgement email come from and how to customize it?Summary: We recently set up a payment acknowledgment with the bank and have the payment file register with document detail email once the disbursement and acknowledgment…Nikki Reich 1 view 4 comments 0 points Most recent by Nikki Reich Payables, Payments & Cash Management
-
Unable to skip resending the Bursting Notifications to HR/Team for Positions whose incumbent is ZeroSummary: Unable to skip resending the Bursting Notifications to HR/Team for Positions whose incumbent is Zero , and notification was already sent in previous bursting ru…
-
Unable to skip resending the Bursting Notifications to HR/Team for Positions whose incumbent is ZeroSummary :- Unable to skip resending the Bursting Notifications to HR/Team for Positions whose incumbent is Zero , and notification was already sent in previous bursting …