BI Publisher
Discussion List
-
SQL Query for timecard approval to BPM workflowObjective : SQL Query to get Approver Name, Approval Date and Status of Timecards Imported in Project Cost Issue : I am unable to find a link between HWM_TM_REC and Work…Palash Kumar Singh 452 views 5 comments 0 points Most recent by Raj Battiwala Reporting and Analytics for HCM -
difference between legal employer hire date and enterprise hire dateSummary difference between legal employer hire date and enterprise hire dateContent Hi, Please find attached screenshot of Manage Work Relationships for a person: 63060.… -
How can we print different Logo based on LE name in EXCEL BIP TemplateSummary: For the Excel template, we have a requirement to print the logo based on the Legal Employer selected in the parameter while running the report. This requirement… -
How to report on job subfamily?Hi, Is there a way to run a report with the job code, job name, associated job family and associated job subfamily in BI publisher?Jacqueline Mellonas 34 views 3 comments 0 points Most recent by Melissa Robinson Reporting and Analytics for HCM
-
Reliable way to identify negative gross / net pay employees without error message text?Hi all, We maintain a custom BI Publisher report that flags employees with negative gross or negative net payments during payroll processing. The report is provided to o…Chandrika Yatham 37 views 0 comments 0 points Started by Chandrika Yatham Reporting and Analytics for HCM
-
Which table stores Receivables Specialist Assignment Rules?Summary: Which table stores Receivables Specialist Assignment Rules? Is there any Subject area to create OTBI report? Content (please ensure you mask any confidential in…Bhanu Prakash Sharma 14 views 3 comments 0 points Most recent by Bhanu Prakash Sharma Receivables & Collections -
Unable to save XML in BI Publisher.Summary Unable to save XML in BI Publisher.Content Unable to save XML in BI Publisher. We are getting an error: Upload file size exceeds the maximum size limit defined b…Aloka Bhattacharya 121 views 20 comments 0 points Most recent by Milan_Chandra Reporting and Analytics for HCM -
DeletedThis post has been deleted. Regards,
-
Need a query that identifies run results or balances where taxes are not being withheldNeed a query that identifies run results or balances where taxes are not being withheld, even though tax withholding is configured on the Calculation Card. There are sev…
-
External bank transactions cannot be voided in Oracle Fusion. However, the Bank Transfer canceled.Summary: External bank transactions cannot be voided in Oracle Fusion. However, the Bank Transfer canceled. Could you please clarify what is the recommended process for …Esraa Yousef 15 views 2 comments 0 points Most recent by Venkatesh Padamwar Payables, Payments & Cash Management
-
Bank account is not being populated in Payment file register and payment fileSummary: I am trying to create a Payment file using PPR however all bank details are populated in Payment register and payment file except Bank account number. I can see…BhargavV 34 views 2 comments 0 points Most recent by Venkatesh Padamwar Payables, Payments & Cash Management
-
A Functional Guide for customizing Disbursement Payment File Format in Oracle Cloud ERPHi All, Please find below detailed steps on how an Oracle Finance Functional Consultant should approach the customization of any payment file (Disbursement Payment File)…CA Nirmal Choudhary 1.1K views 7 comments 6 points Most recent by Malleswara_Rao_P Payables, Payments & Cash Management -
ExternalReportWSSService and runReportHas anyone gotten ExternalReportWSSService working successfully to run a custom BI Publisher report in Fusion Service Cloud? Trying to confirm whether this is a known-wo…RadhaThati 52 views 3 comments 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP
-
Exception: oracle.xdo.servlet.CreateException: java.lang.SecurityException: Security violationSummary: Failure: Due to oracle.xdo.server.ReportException: oracle.xdo.servlet.CreateException: java.lang.SecurityException: Security violation Content (please ensure yo…Parag Hiremath 1.2K views 13 comments 0 points Most recent by Siva_1722 Reporting and Analytics for HCM -
on Redwood page using Guided Journey- BI report bind parametersSummary: To show/embed BI report link on the redwood page and pass the assignment id of the logged in employee as a bind parameter to the path , tried using below &_xmod…
-
Report on Auto-Provisioned RolesSummary: We are looking for a way to report on which of our security roles are auto-provisioned vs. manually provisioned. Does anyone know of a subject area that has thi… -
Dynamic Hyperlink in BIP RTF templateContent Hi Team, I am looking for a dynamic hyperlink for my rtf template. The requirement is such that for recruiting we need to send email to employees with a link for…Shikha Agarwal 1.8K views 9 comments 0 points Most recent by Kevin Wong Sing Ting Reporting and Analytics for HCM -
BIP Report is missing the schedule - How to find the reason for the miss?Summary: We have a BIP report which is scheduled to run daily with scheduled end date in 2024. However, the report hasn't run since 15th Sep. It is not failing either. H…MandeepGupta 28 views 3 comments 0 points Most recent by priyanka_kumbhar2 Reporting and Analytics for HCM -
Does the person with delegated role get access to the additional data via reportingContent (please ensure you mask any confidential information): If a Manager has delegated (say) their Line Manager role to their Exec. Assistant (EA), then does the EA s…SameerJain 37 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Load HMRC XML File Fails When P6 P9 Audit Report Output Format Is Changed to CSVSummary: We are using the UK Payroll flow pattern "Load HMRC XML File". The flow generates the "Inbound Data Audit Report", which uses the layout "P6 P9 Audit Report". W…
-
OTM/GTM - what is the size limitation for oracle BI Publisher rtf template?Summary: OTM/GTM - what is the size limitation for oracle BI Publisher rtf template? Content (please ensure you mask any confidential information): OTM/GTM Product is cu…Nilesh Kumar Mal-Oracle 40 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for SCM -
Applied Receipts Register Report Showing Only Consolidated Values Instead of Parameter-Level DetaileWe are facing an issue with the Applied Receipts Register Report in Oracle Fusion Receivables. The report completes successfully and returns data; however, regardless of…
-
How can I get the original column header in the CSV output of a BI report without underscoreSummary: How can I get the original column header in the CSV output of a BI report without underscore Content (please ensure you mask any confidential information): How …MohanaPriya 32 views 1 comment 0 points Most recent by Raj Battiwala Reporting and Analytics for HCM
-
using HCM extract in need to upload the profile image into document recordsusing HCM extract in need to upload the profile image into document records post approval. Once the image is approved it will be enabled. Same image can we upload in DOR…
-
Sql query required to identify time card approver and assignee detailsSql query required to identify time card approver and assignee details. We tried to join hrc_txn_header, hrc_txn_data and fa_fusion_soainfra.wftask to get the details. B…Abhishek Jois 547 views 4 comments 0 points Most recent by Raj Battiwala Reporting and Analytics for HCM
-
Get Time Card Period (Employee Time Card Details)Summary: We have a requirement to get employee's timecard (timeentry details) ... daywise. We have got the measure (days) from the table hwm_tm_rec using the resource_id…Manoharan 943 views 8 comments 0 points Most recent by Raj Battiwala Reporting and Analytics for HCM
-
Careers of Interest - ReportHi, Anyone has sample report for "Careers of Interest" which comes under development goals? Or can anyone help me with the tables? Regards, NivyaNivya Mathire 41 views 4 comments 0 points Most recent by Jenny Scognamgilio Reporting and Analytics for HCM