BI Publisher
Discussion List
-
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… -
Retrieve “Processed People” count for Generate Total Compensation Statements ESS process in BIPWe need to build a BI Publisher dashboard for Compensation ESS processes. For the ESS process Generate Total Compensation Statements, the Scheduled Processes log display…Ankush Jadhav -Oracle 5 views 0 comments 0 points Started by Ankush Jadhav -Oracle 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 … -
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 14 views 1 comment 0 points Most recent by Carl Bequilla-Oracle Reporting and Analytics for HCM -
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 11 views 2 comments 0 points Most recent by Carl Bequilla-Oracle Reporting and Analytics for HCM
-
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 531 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 5 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 43 views 8 comments 0 points Most recent by Kevin Wong Sing Ting 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 1 view 0 comments 0 points Started by Somnagho_in-Oracle Receivables & Collections
-
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 441 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 395 views 4 comments 1 point Most recent by Rahul_Jadhav02 Reporting and Analytics for HCM -
Can we remove or hide the destination from Scheduling BIP ReportsSummary: We have users who run scheduled reports in BIP but we do not wish for them to be able reports using the email selector or send anywhere else. Is there a way to …Barry Stamp 5 views 1 comment 0 points Most recent by SUSAN SANDIFER 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…
-
Data Model option does not show up in BIPSummary: Data Model option does not show up in BIP Content (please ensure you mask any confidential information): Hi All, Greetings! We have added the needful BI related…Parag Hiremath 28 views 6 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
We need a query to get Payroll Balance group usages mapped to Balance dimensionSummary: Hi. We need a query to get Payroll Balance group usages mapped to Balance dimension. When dimension changes(Quarter, Run, Month… ) then the Balance group usages…Opkey PA 33 views 4 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
How to track email delivery status for the emails (invoice, dunning) sent to customers?Summary: Oracle Fusion Accounts Receivable (AR) sends high volumes of customer emails daily, such as Invoices, Customer Statements, and Dunning Letters. However, there i…soureddy 753 views 79 comments 9 points Most recent by Prashanth Govindarajan Receivables & Collections
-
Query to Pull List of Candidates and Their Supporting DocumentsSummary Query to Pull List of Candidates and Their Supporting DocumentsContent Hi Experts! Looking for some guidance. We need to build a query that lists all candidates …Lindsay Lamont 73 views 8 comments 0 points Most recent by MarkHodges Reporting and Analytics for HCM -
Is there any standard report for document of record audit fields?Hi, After 26A the audit field (Last updated by) of the screen "document of record" are not visible anymore. For audit purposes, HR administrator needs to view this infor…Lynda Ramos 14 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Filter PER_EXT_PAY_EMPLOYEES_V2_UE to get the assignments of employees with payroll results onlySummary: Our custom HCM Extract contains the following UEs (per hierarchy): 1. PAYROLL ACTIONS RANGE UE (Root Data Group) 2. PAYROLL REL ACTIONS RANGE UE (Connected to #…
-
Technical Specialization BI Pub ReportHello everyone, We need to create a BI Publisher report to retrieve the Technical Specialization for each employee. For this, we need to extract all technical specializa…Andriampeno Odilon 53 views 9 comments 0 points Most recent by Andriampeno Odilon Reporting and Analytics for HCM -
How to set static/Dynamic password generation for PO-PDF in Oracle FusionHow to set static/Dynamic password generation for PO-PDF in Oracle Fusion A requester received a Purchase Order (PO) change notification, which included the PO PDF. The …PASALA SATEESH REDDY 17 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
Balance Value for Balance Dimension visible in Fusion UI but not in OTBISummary: We are trying to lookup Payroll Balance Results based on a specific Dimension Name and Balance Name, and the output retrieved from OTBI is not matching to that …