BI Publisher
Discussion List
-
How to handle & symbol in payment file xsl templateSummary: Need to replace '&' symbol with 'and' in payee name and address fields. We have triedsrziffdavis 21 views 1 comment 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management -
Issue with the Custom Data roleHi, We are using a custom role titled "Hub Data Role - Hub Driver Services". Users assigned this role should be able to view all information related to that specfic job …
-
On Etext template, is it possible to create LOV for reference within the template?Hello, We have a requirement to create a payment file format on Etext template. We have a field that needs to display a 3 character string that will serve as a code equi…Kristelle 11 views 1 comment 0 points Most recent by Lakshmish Rao-Oracle Payables, Payments & Cash Management
-
Address information for SingaporeSummary: HI All Could anyone advice what is the correct navigation for StreetName and Building number in case of Syngapore? I'm trying to create xsl payment file Content…Aleksandra Bykhan 11 views 1 comment 0 points Most recent by Lakshmish Rao-Oracle Payables, Payments & Cash Management -
Unable to find the Purge interface table import process nameHi Team, One user scheduled Purge Interface table ess program on weekly basis and the user was left the customer organization (User end dated) . Due to this the schedule…Somasekhar Basetty -Oracle 52 views 2 comments 0 points Most recent by Gianni Carrero General Ledger & Intercompany
-
how to remove blank line appearing at the top of manager and worker comments for employee objectivesWe have a custom BIP report for fetching the employee objectives and values details under performance module. The output of the report is in excel and while exporting th…Shikha Singh 22 views 2 comments 0 points Most recent by Shikha Singh Reporting and Analytics for HCM
-
User who executed or modified a report in Publisher ?Summary: Is it possible to know which user executed and/or modified a report in Oracle Analytics (Publisher) ? Content (please ensure you mask any confidential informati… -
Help in Query to get Variable Rate for a Benefit of an EmployeeSummary: Hello, Customer Connect! I am in need of developing to get these scenario: If the employee John is enrolled in the Benefit A with the option B, it have a rate v… -
Impact Assessment of Redwood on the Core HR reports and dashboardsHello experts, we are now planning to implement Redwood for Core HR. Can you advise what we should watch out in the Reporting side? Like Changes in the Subject Areas, or…Maria Cristina L. San Jose 45 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
How to download the files that are uploaded in DOR against employeehi i have a query which shows al the files uploaded in DOR of emplyee . select fad.DOCUMENT_ID , fdv.DM_DOCUMENT_ID CONTENT_ID, fdv.datatype_code , fdv.FILE_NAME , fdv.T…Shanmukhi 12 views 3 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
GL Account Analysis ReportSummary: Can you please share the values to be passed for the table name parameters of the GL Account Analysis Report Content (please ensure you mask any confidential in…Aishwarya Penchala-Oracle 1 view 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
Query to get tax registration from supplier address levelSummary Tax Registration from Supplier AddressContent Hello I was wondering if you can share with me any SQL to get the Tax Registration at the address Level. I have the…gabriel kinovisques-163562 4.5K views 6 comments 1 point Most recent by Ch M Prasad-Oracle Payables, Payments & Cash Management
-
Approvers not able to see customized data in approval notificationSummary: Approvers not able to see customized data in approval notification. Content (please ensure you mask any confidential information): We have added few DFF from po…
-
Report on Duplicate Contacts in BenefitsSummary: I'm looking to see if anyone has come up with a clean way to report on duplicate contacts in Benefits. I have read a few other posts about this issue, so I know…Jessica D 12 views 2 comments 0 points Most recent by Adam Gates-Oracle Reporting and Analytics for HCM
-
Report on Extract Definitions / Object Name / AttributesHello, I would like to create a report (Bi Publisher or OTBI). About Extract Definitions. I need following information Extract Definition Name Object Name Attributes Exc…Michael Schweizer 13 views 1 comment 0 points Most recent by Stephane Cote-Oracle Reporting and Analytics for HCM -
Run bip reports via payroll flow or ess jobsSummary: We are planning to create BIP reports, which will run in changes only mode. As a best practise should we be running the report leveraging the last run ESS job o…
-
What is the column for enrollment date in the WLF_LEARNING_ITEMS_F table?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…ClaudiaManea 11 views 3 comments 0 points Most recent by Ramchander Pothanolla Reporting and Analytics for HCM
-
Time to Fill Measure using Requisition Open Date in Recruiting - Recruiting Real Time Subject AreaContent I'm trying to create a Time to Fill measure using data in the Recruiting - Recruiting Real Time Subject Area. My calculation works but the Requisition Open Date …User_2025-02-10-14-03-41-548 114 views 5 comments 0 points Most recent by AshleyM Reporting and Analytics for HCM -
Recreating Workforce Goals Reports using BI PublisherHello, For a number of reasons we've had to use BI Publisher to build a report on performance Goals and Goal Plan Eligibility. We've tried to use HRG_PERF_GOALS_SECURED_… -
Multiple legal employers records showing in each employeeSummary: Hi Team, we have BI query but it Multiple legal employers records showing in each employee. example one employee have x legal employer but it also showing secon…AjayKumar Maddipati 23 views 4 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
Employee Expense AttachmentI need to get the attachment from the header in the Expense Report. I am only getting the attachments from the Expense Items. Am I missing a table or join on this? here'…
-
Employee previous and current locations reportSummary: Looking for a way to report employees and their locations (Current and all previous locations). Content (required): Looking for a way to report employees and th…Scott Conaway 91 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
add 2 columns in ExcelSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…ScottSpivey 11 views 1 comment 0 points Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP
-
Issue with Sheet Naming in BIP Report Excel TemplateHi All, We are developing a report using excel layout and enabled Scalable Mode = True under Report Properties. When the number of records exceeds 65531 the records are …
-
List of all Custom ReportsSummary: Can we get a list of all reports (Custom + Standard) using a query? Also, users who are all having access to these reports? Content (required): Version (include…
-
How to see the list of ESS Jobs scheduledHello All, we had a requirement to get the list of ess jobs scheduled and what frequency they have been and what is the current status of that ESS Job. for BIP Report we…Koteswararao Yenikepalli 1.2K views 8 comments 1 point Most recent by Ranju kumari Reporting and Analytics for ERP -
ESS Job > Schedule Report > Enabling of Request Delivery Status Notification and Read ReceiptSummary: Hi, We are having some issues with sending Invoice PDF to our customer from an ESS Job. The name of the ESS Job is Print Receivable Program. We were told that s…marc.joed.de.guzman 42 views 3 comments 1 point Most recent by Maricel Ortega Receivables & Collections
-
Deleted contacts in AR Customer still appearing in TableSummary: Hi, I have created AR Customer and Customer Account, Site and Contact. When checking in Table using below query, it is working as expected. select * from HZ_REL…Sathyamoorthy Ramakrishnan-Oracle 21 views 1 comment 0 points Most recent by Shyam Patel Reporting and Analytics for SCM
-
How to get legal employer legislation code with SQLSummary: How to get the legal employer legislation code with SQL Content (please ensure you mask any confidential information): Hi experts, I need to get the legal emplo…Volodymyr Faranosov 205 views 2 comments 0 points Most recent by Volodymyr Faranosov Reporting and Analytics for HCM