BI Publisher
Discussion List
-
how to create subtotals in excell template for bipI had a requirement to create subtotals for each individual invoice_numbers , when i try to do sum function or subtotal selection it is not giving subtotal for each indi…Voladri Saikiran 34 views 0 comments 0 points Started by Voladri Saikiran Reporting and Analytics for ERP -
How to get current timezone as of date in server variable CURRENT_DATE_REP_OTBISummary: How to get current time zone as of date in server variable CURRENT_DATE_REP_OTBI. I am trying to get the correct metrics on the headcount dashboard and what i o…Revanth.Rondla 21 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
SQL query or Table for Dynamic Columns data under Configure Assignment Segments in CompensationSummary: Hi, We could not find the tables name or query for Dynamic Columns data under Configure Assignment Segments in Worforce Compensation plan What is the table name…Opkey PA 21 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Feasibility of Daily Trial Balance ReportOrganization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): ADCORP Description (Required): We hav…Muralidhar.Gandrakota-Oracle 11 views 0 comments 1 point Started by Muralidhar.Gandrakota-Oracle Receivables & Collections
-
fbdi "CustomerImport" for adding sites to an existing customerWe need to use the FBDI to add some sites to an existing customer, how can we use the CustomerImport for that requirement?
-
How to suppress credit memo for print email but Invoices should be allowed?Summary: Content (please ensure you mask any confidential information): We need an ability where Credit memo should be suppressed/restricted for print email to the custo…
-
What table contains the AP invoice source distribution transaction line number details?I'm trying to build a BIP report that contains the AP invoice source distribution transaction line number details, as shown in the screenshot below. What BIP table conta…
-
After 25A, customers whose profile is set to XML invoice delivery method are not searchableSince 25A, we can’t search for customers in the From/To Customer fields of custom ESS jobs, even though we use the same CustomerAccountVO and CustomerVVO LOVs as the see…
-
Reporting on Payment ApprovalsSummary BI Publisher or OTBI Report to extract Payment ApprovalsContent Hi Community Are there are any BI Publisher or OTBI Reports available to report on Payment Approv…Kunal Daya-175386 201 views 5 comments 0 points Most recent by Marko Puskac Reporting and Analytics for ERP
-
BIP検索条件についてSummary: Could you please tell me how to specify multiple search conditions for BIP? Content (please ensure you mask any confidential information): In the search screen …
-
BI Publisher Service UnavailableWe are getting the message 'Service Unavailable' when attempting to access BI Publisher. All our automated reports are also impacted by this. They are not being sent.
-
Report Data is incorrect because Time zoneHello, we just recently faced an issue related to BI report on absence related data. It will give last one hour updated records of employees absences. (submitted/awaitin…Dara Nagasai 12 views 4 comments 0 points Most recent by Vanitha Kundaram Reporting and Analytics for HCM -
Invoice Payments querySummary: Create New Invoice Payments Reports Content (please ensure you mask any confidential information):I would like to create a new report in Oracle Fusion ERP to qu…RAJAGANAPATHI 131 views 0 comments 0 points Started by RAJAGANAPATHI Payables, Payments & Cash Management
-
Create customer statements to fetch open and closed statementsSummary: Hi, The Create Customer Statements (ESS) job currently returns both open and closed statements. Is there a supported way to run it so that it outputs only open …
-
Completion of course notification with link to completion certificate of the courseSummary: Completion of course notification with link to completion certificate of the course Content (please ensure you mask any confidential information): Hello, We hav…
-
Control report-level permissions during migrationSummary: We have a custom folder ("Folder A") with 4 roles assigned: Role A, Role B, Role C, and Role D. When a new report is migrated into this folder, it automatically…
-
Does anyone know what table does the Absence Management Type time attribute belong to?Summary: We currently have Payroll Time Type and Absence Management Type configured for the Time Entry Layout Components in our system. We already found that the HWM_TM_…
-
Send reminders to the employee based bip report burstingSummary: Send reminders to the employee based bip report bursting Content (please ensure you mask any confidential information): Hi Team, I have a requirement. I need to…
-
How to display Success Criteria Text without HTML tags from Transaction tablesSummary: How to display Success Criteria Text without HTML tags from Transaction tables We have a requirement to display the Success Criteria Text in the report as plain…
-
Guidance Needed: BI Report with After Data Event Trigger in Oracle Fusion HCMSummary: BI Report with After Data Event Trigger in Oracle Fusion HCM Content (please ensure you mask any confidential information): Hello All, We have a requirement to …Vasanthakumar Ravi 34 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
How increase limit of rows in otbi analysisSummary: How increase limit of rows in otbi analysis Content (required): Customer have some Analysis created and he want to know if there are some possibility to export …Adriana Martins 1.5K views 8 comments 1 point Most recent by SureshRamanujam Receivables & Collections
-
How to sum at highest level of grouping on rtfSummary: I need to sum at the highest level of grouping in my rtf Content (please ensure you mask any confidential information): I am building a rtf template for a repor…
-
Question Mark is appearing after each row in etext outputContent Hi, Question Mark is appearing after each row in etext output. How to remove? Thanks in advance. Regards, NivyaNivya Mathire 121 views 6 comments 2 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
What particular role or privilege needed to gain access to Manage Report Jobs page?Summary: What particular role or privilege needed to gain access to Manage Report Jobs page as well as the list of scheduled report jobs? Here's the example:Welsey 91 views 9 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM -
I want joins for ap_terms_tl and FND_SETID_SETS tabSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Sushmita Nagaraj Doddamani 11 views 2 comments 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
BIP Bursting to object StorageSummary: We have a requirement where we want to schedule BIP report output and store it to object storage . Is it possible burst BIP report to object storage. Also,We do…Mandar -Oracle 601 views 3 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
How do we pass multiple input values for a parameter from Payroll flow to a Bi report.Summary: We have a requirement where in we want to pass multiple input values for a parameter from payroll flow to a bi report. How do we achieve it. We have created a B…User_ANH3E 101 views 9 comments 0 points Most recent by Eknath Kayasri Reporting and Analytics for HCM
-
Learning Communities - Database SchemaCan anyone confirm how I would go about reviewing the Database schema for Oracle? I have some basic SQL knowledge that I have been able to leverage in OTBI/Data Models b…