BI Publisher
Discussion List
-
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 10 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 42 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 5 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 45 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 3 views 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 2 views 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 6 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 13 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…
-
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 4 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 82 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 19 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 … -
Is there any way to get all BI folder level permission details via report?Hi Team, I have a requirement to fetch details of folder level permissions set on each folder in BI catalog. I see different roles/users have different level of access o…Narula Shray 558 views 6 comments 0 points Most recent by Matt Van Asten Reporting and Analytics for HCM -
Changes to custom report, replicates in seeded reportHi all, I have encountered a problem while customising reports. -When I create a copy of a custom report ("customise it" using XMLP server) then the seeded object disapp…Shruthi Arun Krithika 2 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
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 … -
How to grant access to OTBI without granting access to datamodelSummary: Although a custom reporting role strictly restricts the user from creating or editing Data Models, a security gap allows them to delete existing Data Model obje…Kevin123 52 views 8 comments 0 points Most recent by Kevin Wong Sing Ting Reporting and Analytics for ERP
-
Can we assign bulk roles to user accounts ( not employees)Summary: Hello All, Can we bulk assign roles to users those are not employees in fusion? Content (please ensure you mask any confidential information): Version (include … -
Option 5 Enabled Flag for Document Delivery PreferenceSummary: What are the equivalent HDL attributes in DocumentDeliveryPreference.dat for the following source fields from hr_document_delivery_prefs: OPTION1_ENABLED OPTION…
-
Restrict Quick Payment and Allow only Manual PaymentIssue: There ate no apporvals for Payments created via create payments tab. So, Business wants to restrict the users only to make manual payments from Create Payments Ta…Jagjit Singh Arora 451 views 9 comments 0 points Most recent by Srividya V Payables, Payments & Cash Management
-
Report to get Original Date Earned of element entrySummary: Report to get Original Date Earned of element entry Content (please ensure you mask any confidential information): Hi Team, Greetings! Does anyone have the repo…Parag Hiremath 391 views 4 comments 1 point Most recent by Rahul_Jadhav02 Reporting and Analytics for HCM -
Need sql query to join between subledger and fixed asset and asset invoicesSummary: We are pulling the general and sub-ledgers for fixed assets and asset invoices in order to create a custom BI report for fixed asset reconciliation. Since we ar…
-
Why created Global access groups are not showing for communities Membership?Summary: Why created Global access groups are not showing for communities? we have created three Global access groups, we want to reuse the same access groups. And let u…