BI Publisher
Discussion List
-
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 61 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 31 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 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 31 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 51 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 11 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 121 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 44 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 … -
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 81 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 511 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 421 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… -
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 71 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 113 views 4 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
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 70 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 11 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
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 71 views 9 comments 0 points Most recent by Andriampeno Odilon Reporting and Analytics for HCM