BI Publisher
Discussion List
-
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 7 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 8 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 7 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 10 views 0 comments 0 points 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 1 view 1 comment 0 points Most recent by devesh.tyagi Receivables & Collections -
JPMC H2H key renewal schedule for SSH certificates every 6 monthsWe received an email from JPMC stating that the H2H key renewal schedule is changing and the SSH keys and SSL certificates they own will renew every six months instead o…Stephanie Turner 11 views 0 comments 0 points Started by Stephanie Turner Payables, Payments & Cash Management -
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 11 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 543 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 51 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 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 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… -
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 21 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 40 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 757 views 79 comments 9 points Most recent by Prashanth Govindarajan Receivables & Collections