BI Publisher
Discussion List
-
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 532 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 211 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 465 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 341 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 81 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 171 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 414 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 11 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 371 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 52 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 652 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 102 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… -
Subject Area for Override LocationSummary: We have a requirement to query 4 different types of address for employees. HOME, US Resident Tax, Work Location and Override Location addresses. I am able to qu… -
can we create report on the missing candidates (unconfirmed candidates).There are some candidates who were not able to submit there job applications because of issues with being able to access the assessment. I need to check if we can create…Chetana Pawar 62 views 3 comments 0 points Most recent by Dawn C-Support-Oracle Reporting and Analytics for HCM -
What is the best way to implement ECC200 data matrix in oracle reports?Summary: Need to add a 2d data matrix to report letters that will store a string of numbers. The ECC200 data matrix does not seem to be currently supported by Oracle so …KevinCochran 42 views 1 comment 1 point Most recent by Adam Gates-Oracle Reporting and Analytics for HCM -
sFTP connection is failing with 503 error after whitelisting Oracle given IPsSummary: sFTP connection is failing with 503 error after whitelisting Oracle given IPs Content (required): Our system was upgraded with 23A over the weekend and after th… -
How do you enable My Report tab for employees?Summary: How do you enable My Report tab for employees? Content (required): What is the privilige that you need to use in order to enable My Report tab for employees? Ve…
-
Is there a query for fetching LinkedIn profile details in BIP report? Which is the table for that?Summary: To fetch linkedin profile details in BIP SQL report. Which table needs to used to achieve this requirement? Content (required): Version (include the version you…Hemanth Kumar Muthyala 31 views 1 comment 1 point Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
How to get the termination action/reason for the report with benefit details?Summary: I have an OTBI report built with benefit details. I need to add employee's termination reason/action for that report. Content (required): I cannot find a benefi…Ayesha Iroshani 376 views 1 comment 0 points Most recent by Adam Gates-Oracle Reporting and Analytics for HCM