BI Publisher
Discussion List
-
Need sql Query to fetch the Job Applicants in Draft StatusSummary: We have a Requirement to build a BIP Report for fetching the Job Applicants in Draft Status. Can anybody please share the sql query for this requirement. Conten…Milan_Mohanty 41 views 2 comments 0 points Most recent by Milan_Mohanty Reporting and Analytics for HCM -
Query or report to print approver hierercy once the Invoice approval initiatedSummary: We need to know a report name or query so that we can run this report or build a report from the query which will provide al approvers name list which we genera…Sam Samaddar 1 view 2 comments 0 points Most recent by Sam Samaddar Payables, Payments & Cash Management -
Workflow Approval Report for Journal Approval is now showing result for all participantsSummary: We ran the Journal Approval Workflow approval report. We have two participants in our approval rules and workflow report is successfully printing for first part…
-
How to enable deep link in payment approval notificationSummary: How to enable deep link in payment approval notification? Content (please ensure you mask any confidential information): Hi all, We got a requirement to show in…Venkatesan 61 views 4 comments 0 points Most recent by Venkata Rajesh A Payables, Payments & Cash Management
-
Facing performance issue with a query on gl_periods and per_calendar_events tables.On Fusion ERP I have a BIP report with complex query which involvers among others GL_PERIODS and PER_CALENDAR_EVENTS tables. Report parameters are GL Period From and GL …N.V. Mehta 13 views 4 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP -
Print Receivables Transactions email by customerSummary: We are using the standard Print Receivables Transactions job in Oracle Cloud ERP to generate and burst invoice PDFs to customers via email. Is it technically po…
-
R13 20A - How to fetch the error messages from HRC_TXN_ERROR tableSummary Unable to get the failed error message reportContent We are creating a report to pull all the transactions that failed on a given day based on the issue date. We…Suganthi Srinivasan 41 views 2 comments 1 point Most recent by ViswanadhK Reporting and Analytics for HCM
-
BPM Worklist ReportSummary Help on creating BPM Worklist ReportContent Hi, We currently have several requests regarding the BPM Worklist Report in Fusion HCM. Do you have any idea on how t…User_2025-01-29-01-38-21-058 262 views 9 comments 0 points Most recent by ViswanadhK Reporting and Analytics for HCM -
Learning incident custom notification report is appearing blankSummary: We modified a custom report workflow notification but the notification appears blank in production. In backend the template shows all the changes The FYI notifi…
-
Oracle Fusion AP - How to correctly pair Debit and Credit XLA lines for AP Invoice accounting reporthi We are building a custom BI Publisher report in Oracle Fusion Cloud (Oracle ERP Cloud) that shows AP invoice journal accounting details with debit and credit account …User_Q43IX 34 views 3 comments 0 points Most recent by VeerendraChava Subledger Accounting & Accounting Hub
-
Probation Confirmation LetterSummary: We have a Requirement to send the Probation Confirmation using Oracle BIP Bursting . Can anybody share the Bursting Logic to call the IN .rtf Template or the US…Milan_Mohanty 45 views 3 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
OTBI Graph: Maintain Same Color for Multiple Measures of the Same SupplierHi, I'm working on an OTBI Analysis in Oracle Fusion and have a requirement to display both Invoiced Quantity and % of Quantity in a stacked vertical bar chart. Currentl…sakthi.paramasivam 3 views 0 comments 0 points Started by sakthi.paramasivam Reporting and Analytics for SCM
-
How to know who delete some reports in OTBIA folder containing reports has disappeared from my environment, and we want to know if it was accidentally deleted by a user or where the folder is located.Roy1823 41 views 3 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
Cross subject area "Receivables - Transactions Real Time" and "Receivables - Customer Real Time", neSummary: Cross subject area "Receivables - Transactions Real Time" and "Receivables - Customer Real Time", need to join the subject area to fetch data as there is no com…Prasad Tummalapalli 1 view 0 comments 0 points Started by Prasad Tummalapalli Reporting and Analytics for ERP
-
Cross Subject Area receivables moduleSummary: Cross subject area "Receivables - Transactions Real Time" and "Receivables - Customer Real Time", need to join the subject area to fetch data as there is no com…Prasad Tummalapalli 1 view 0 comments 0 points Started by Prasad Tummalapalli Reporting and Analytics for HCM
-
Guidance Required – Executing Dynamic SQL in Oracle BI Publisher ReportSummary: We have a requirement where business users will maintain extract configurations through a custom Oracle VBCS screen. For each vendor, the users will configure d…Sanin Antony T 11 views 0 comments 0 points Started by Sanin Antony T Reporting and Analytics for ERP -
In fusion expense, I need to send a different email notiication to submitter vs. approver.Summary: The ask is to send email notification to submitter of a claim when there is personal expense spent on corporate card. The challenge is we have been able to cust…
-
Is there any way to identify the last usage date of a role assigned to a user in Oracle Fusion CloudHi Team, We have a requirement to identify the last usage date of a specific role assigned to a user in Oracle Fusion Cloud SaaS. We are looking for a way to determine: …Vignesh_Rajasekaran-Oracle 25 views 0 comments 1 point Started by Vignesh_Rajasekaran-Oracle Reporting and Analytics for ERP
-
How can we automate multiple credit memos to one invoice and one credit memo to multiple invoices?We’re trying to build a logic where credit memos will be applied to invoices automatically. We have built a logic where one credit memo can be applied to one invoice. Bu…Somnagho_in-Oracle 10 views 1 comment 0 points Most recent by Devesh Tyagi Receivables & Collections
-
how many transactions can be process in a single run of Print receivables transactionSummary: how many transactions can be process in a single run of Print receivables transaction Content (please ensure you mask any confidential information): how many tr…Nagarjuna Nudurupati 12 views 1 comment 0 points Most recent by Devesh Tyagi Receivables & Collections
-
Time Change Request reportSummary: Hi All, Has anyone Developed a BI/OTBI Report on Capturing Details of Time Change Requests? We have a requirement and working on this. Appreciate if anyone can …Abhishek Bhaskar 81 views 4 comments 1 point Most recent by Raj Battiwala Reporting and Analytics for HCM -
How to map new custom data model and Separate Remittance Advice template to PPR process.Summary: I have created new custom data model & template and added it in Disbursement Separate Remittance Advice Formats report. But when run the payrun, still output is…
-
Call Sub Templates inside Main RTF TemplateSummary: We are facing issue while trying to call the sub Template inside the Main RTF Template. It Returns Blank Page Output for the P_COUNTRY Parameter selected from L…Milan_Mohanty 28 views 2 comments 0 points Most recent by Milan_Mohanty Reporting and Analytics for HCM
-
Budget Transfer Comments Not Traceable in Backend Tables (Data/Setup)Summary: We allow users to enter free-text comments/justification while performing a Budget Transfer between control budget accounts (Manage Budgets / Budgetary Control … -
what is the deep link for manage customers details?Summary: We need the deep link of manage customers page Content (please ensure you mask any confidential information): we made a dashboard with customers and we want to …
-
How to embed logo or image in email body using email bursting querySummary: Need info on Parameter5 of email bursting query can be included with image file or Logo in it. We want company logo to be added along with email body .Please gu…
-
What is the efficient way to get balance value in BIP report?Summary: Currenly we are using below subqueries to get the balance values for any payroll_rel_action_id. But our report has many columns to get the balance value and it …