BI Publisher
Discussion List
-
How to pull in correct payroll number of employees in BI Publisher reporting?Summary: I have put together a query where my joins for payroll number are bringing some duplicate lines into my record. On investigation, the joins are not bringing the… -
How to attached Invoices to Payments Remittance Advice Notification via EmailSummary: The accounting team is requesting to attach the invoices to the Payments Remittance Advice Notifications sent via Email Content (required): We have a custom pay…Patricia Gonzalez 71 views 3 comments 0 points Most recent by Patricia Gonzalez Payables, Payments & Cash Management -
BIP Data format on group-sumSummary: Content (required): I'm trying to create a report in BIP (in a RTF file). So I have used table wizard to create a for each on the values I need. In the actuals …Nicolas Vahman 45 views 4 comments 0 points Most recent by Nicolas Vahman Reporting and Analytics for ERP
-
Inability to view the National ID information in the report by the employee,how should we proceed?I have an excel report that I prepared with BI publisher, and this report contains the National ID information I got from the PER_NATIONAL_IDENTIFIERS table. But the use…Cansel Karasoy 391 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Error after adding another subject area to an analysisSummary: I built an analysis based on Workforce Management - Worker Assignment Real Time. Now I need to add a column from Worker Management - Person Real time. When I di…
-
Getting an error while running a report.Summary: Hi Team, I am getting an error while running a report, please see the attached screenshot. Could you please let me know the rout causes. Thank you Content (requ…
-
how to report on job offers that are pending for approvals using workflow tablesSummary: we need to cover and track all job offers that are pending for approvals and who is the next approvers! I need to create a report covering this topic.. for the …Ayoub AFRASS 101 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Need the query to get the data on the Review Budgetary Control Balances UISummary: We need a query for a report, which happens to be the details of the Review Budgetary Control Balances UI. Please assist. Please assign this SR to the relevant …Sushan Peiris 324 views 3 comments 0 points Most recent by Catherine Myrand Reporting and Analytics for ERP -
Error: Report data size exceeds the maximum limit under the free memory threshold**This post was created as part of a How to Service Request (SR) Release: 23A Summary: There are Bi jobs to export data from CX Sales to an external server, every two ho…Dragos Deak-Support-Oracle 553 views 1 comment 0 points Most recent by Dragos Deak-Support-Oracle Reporting & Analytics for Sales
-
Table details which stores Payment System Account name in Payment Process Profile setupSummary: We need table details which stores Payment System Account name in Payment Process Profile setup task Content (required): Version (include the version you are us…Nishanth B Jain 91 views 5 comments 0 points Most recent by Nishanth B Jain Payables, Payments & Cash Management -
Localization Report for TurkeySummary: Need E-Ledger Report for Turkey Content (required): Hi All, We have Turkey localization and below reports are required: Quarterly Advance Tax Declaration (Incom…Jakeeagarwal 161 views 2 comments 0 points Most recent by Jakeeagarwal General Ledger & Intercompany
-
Need help on arrears balance ReportSummary: Content (required): Hello, We are trying build a custom arrears balance for both active and terminated employees. We do not have anything available for terminat…Ganesh G 212 views 3 comments 0 points Most recent by Catherine Chan Reporting and Analytics for HCM -
table to pull the error details from transaction console.Summary: Hi All, I'm trying to build a report and looking to pull the error details from transaction console. I tried searching tables but I'm not getting the info, can …vamshi krishna-283622 471 views 8 comments 0 points Most recent by Arun Menon Reporting and Analytics for HCM
-
Report to get the list of employees with multiple active relationshipsSummary: Report to get the list of employees with multiple active relationships Content (required): Hi Team, Greetings! With Global Transfer- there are some cases observ…Parag Hiremath 360 views 4 comments 0 points Most recent by Volodymyr Faranosov Reporting and Analytics for HCM -
Is there a way to encrypt the scheduled reports?Summary: Is there a way to encrypt the scheduled reports Content (required): We are looking into scheduling reports but we need to make sure there is an encryption in pl…Balazs Grajczar 82 views 6 comments 0 points Most recent by teresa.marciano Reporting and Analytics for HCM -
Payroll Element and Related Elements InformationSummary: Payroll Element and Related Elements Information Content (required): In the Payroll Element screen we have Related Elements. We need to know in which table/subj…
-
Multiple Bank Accounts in Smartview Cash ForecastSummary Multiple Bank Accounts in Smartview Cash ForecastContent Hi I would just like to inquire if there is a way to do a multiple bank account view at the same time in…User_2025-02-11-12-30-38-982 37 views 3 comments 1 point Most recent by CA Nirmal Choudhary Payables, Payments & Cash Management -
Is there an option to update Oracle or Vision logo once to reflect in all seeded reports?Summary: Client is asking for one single update of oracle or vision logo so the users doesnt see Oracle /vision logo in out of the box report when run. Client requests t…Abhilash K - Deloitte USI 172 views 5 comments 1 point Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
Bursting Query table from the reportsSummary: Bursting Query table from the reports Content (required): Hi Team, Greetings! Is there any table(s) which holds the queries included in the bursting query in th…Parag Hiremath 432 views 3 comments 1 point Most recent by Prateek Parasar - GTUK, ACE Pro Reporting and Analytics for HCM
-
Extract information about the Job Board eQuest in ORCSummary: Content (required): Hello everyone, We are having problems extracting information regarding the publication of a job requisition. In particular, in addition to …Gerardo Peluso 12 views 0 comments 0 points Started by Gerardo Peluso Reporting and Analytics for HCM
-
CAGR(Compound Annual Growth Rate) Calculation in OTBISummary: Creating an OTBI analysis to calculate CAGR of the joiners in my org in last 3 years. Content (required): I am trying to calculate CAGR of the joiners in my org…Dinky Dudeja 51 views 2 comments 0 points Most recent by Dinky Dudeja Reporting and Analytics for HCM
-
ORA-01722 Invalid NumberSummary: Content (required): A report that used to work is now giving us an error ORA-01722: invalid number. Version (include the version you are using, if applicable): …Ratha Sun 377 views 7 comments 0 points Most recent by Jahnavi-Oracle Reporting and Analytics for HCM
-
BI Tables for compensation planSummary: Content (required): Hello experts, do you know which BI tables allows me to extract workforce compensation plan data? Thanks in advance for your time! Kind Rega…Valerio Curzi 51 views 6 comments 0 points Most recent by Valerio Curzi Reporting and Analytics for HCM -
Is it possible to retrieve compensation component amounts entered in closed compensation campaigns?Summary: Content (required): Hello experts, our customer wants to add in compensation plan some columns retrieving compensation amounts entered in past campaigns. Is it …Valerio Curzi 1 view 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How to generate employee listing report in Oracle fusion?Summary: Content (required): Employee Listing report Version (include the version you are using, if applicable): Oracle Fusion Cloud Applications 23A (11.13.23.01.0) Cod…Radha, Rangu 658 views 7 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
How to send HTML content email using OTBI agentSummary: Not able to send an email which include html tags and image contents to be scheduled and sent over agents in OTBI Content (required): Version (include the versi…Kostare 101 views 1 comment 0 points Most recent by Syed Misbauddin-Support-Oracle Reporting & Analytics for Sales -
Function to convert accented characters to their plain ascii equivalents in BI reportSummary: Function to convert accented characters to their plain ascii equivalents in BI report Content (required): Function to convert accented characters to their plain…