BI Publisher
Discussion List
-
Regarding Extract DBI of work-schedule asisgnment when assigned at Enterprise levelSummary: Hi Folks, When I assigned work schedule at assignment level then I got the value in HCM extract of WS and the Pattern as well but if i remove the assnment level… -
Need the mapping of Job Application Names EarHcmEss and FscmSummary Need the mapping of Job Application Names EarHcmEss and FscmContent We have a requirement to create a custom report of the ESS Job Execution details. We want to …Vinay Gharge 60 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP -
BIP Bursting - Zip Multiple text/csv files and burst to Content serverSummary: Hi All, We have a requirement to push zip files (multiple text/zip files) to UCM. This has to be accomplished in Oracle ERP Cloud SAAS tools. Please let me know… -
Table : ap_inv_aprvl_hist_all field "response" possible values meaning?Hi Guys I could not find anything on the web, I would be interested to know what some of the values in the "response" field in table ap_inv_aprvl_hist_all mean please an… -
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 … -
Access to Reports and Analytics section - Roles and privileges requiredSummary: Hi All, We had the requirement to build a custom data role which will give the user the access to Reports and Analytics work area and role should provide access…Sreeram V 6K views 10 comments 0 points Most recent by Jose Aguilera Reporting and Analytics for HCM -
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 54 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 338 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.4K 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 112 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 91 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'…