BI Publisher
Discussion List
-
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 51 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 21 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… -
Report for Missing TimecardsSummary Employees without time card associationContent Hi All, We have a requirement to identify and report those employees that are missing time card association. I am …Sowdha Murugan 326 views 3 comments 0 points Most recent by Pennie Spies Reporting and Analytics for HCM -
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 41 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
Issue in Salary Certificate DORSummary: Issue in Salary Certificate DOR Content (required): Hi All, We are facing the issue in salary certificate DOR. Salary certificate is working fine in draft versi… -
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 11 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.3K 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 11 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 11 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 113 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_… -
How to default logged in user to BI report parameter?Summary: Default logged in user to BI report parameter Content (please ensure you mask any confidential information): Hi, We have a custom BI report, that has a paramete…Elena Tudor 92 views 14 comments 0 points Most recent by Elena Tudor Reporting and Analytics for ERP -
Multiple legal employers records showing in each employeeThere was an error rendering this rich post.AjayKumar Maddipati 21 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 993 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 43 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