BI Publisher
Discussion List
-
How to Enable EFF on AR Invoice not DFFSummary: How to Enable EFF on AR Invoices not DFF Content (please ensure you mask any confidential information): Due to limitation of DFF attributes list on AR Invoice, … -
Rejection reason message need to be printed in the Reversal Status ReportHi Oracle community, I hope this message finds you well. We have encountered a scenario where different levels of rejection reason message need to be printed in the Reve…
-
To update the "Send statement" box, we use the REST API for Customer profile.Summary: to update the "Send Statement" checkbox for a customer in Oracle Fusion do we have the rest api and If yes what it is Content (please ensure you mask any confid…
-
Purge older data more than 90 days in fnd_session_user_activityAfter activating FND_TRACK_USER_ACTIVITY profile option, is it possible to delete data older than 90 days in fnd_session_user_activity table
-
How to get XML extract "Funds Capture Payer Notification" ReportIs there any way or SQL query to get XML extract for Funds Capture Payer Notification https://docs.oracle.com/en/cloud/saas/financials/24d/faofc/funds-capture-payer-noti…CA Nirmal Choudhary 12 views 1 comment 0 points Most recent by CA Nirmal Choudhary Receivables & Collections -
How to get XML extract "Funds Capture Payer Notification" ReportHow to get XML extract "Funds Capture Payer Notification" Report https://docs.oracle.com/en/cloud/saas/financials/24d/faofc/funds-capture-payer-notification-reports.html…CA Nirmal Choudhary 31 views 1 comment 0 points Most recent by CA Nirmal Choudhary Receivables & Collections
-
Payroll register dynamic BI reportI have a requirement to get the below records in payroll register report(dynamically). Person Number|| 1|earning element run result values| deduction…
-
how to populate rejection reason for expense auto rejected by WorkflowSummary: Whenever an expense report is auto rejected due to workflow the user wants to see a descriptive reason for teh rejection but currently in expense report only th…User_PZTF9 31 views 4 comments 0 points Most recent by Yahya Khan Payables, Payments & Cash Management
-
Mapping Payment Format - Replace decimal with commaSummary: Mapping Payment Format - Replace decimal point with comma Content (please ensure you mask any confidential information): EText RTF Template - Fixed position tem…Amit Patnaik 11 views 1 comment 0 points Most recent by Amit Patnaik Payables, Payments & Cash Management
-
SQL Query to get calendar attached to employee .Summary: Dear Team: We need to get the calendar details for an employee. Navigation is Login as an employee→Time and absences→Calendar Content (please ensure you mask an…
-
Does exist a BIP table/view with both Person Number and Employee Name?Summary: Building a valueset Content (please ensure you mask any confidential information): I need to create a value extracting person name, person number and person id.…Stefano_Mazzocca 21 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Issue and Resolutions from the Transaction ConsoleSummary: Hello, I was able to find the issue description and resolution information from the table "HRC_CONSOLE_FAULT_DETAILS_VL". However, I'm unable to connect the act…
-
Table to view Project Expenses Mass Adjustment Reason and TypeSummary: Which table can I use to get the "Adjustment type" and "Adjustment Reason" for mass adjustments made against Project Expenses. I found the table PJC_TXN_MASS_AD… -
Restrict the compensation information in reports and analytics.Hi Team, We have a requirement that some set of employees can able to access/view the compensation data in BI and OTBI Analysis reports. E.g: If a user queries the compe… -
Bold Style is missing for Arabic text in PDF output of rtf templateSummary: We have a check template (.rtf) developed with Payment Date, Payee Name, Payment Amount and Payment Amount in Words . In these fields, Payee name and Payment Am…SireeshaJaladi 1.1K views 18 comments 1 point Most recent by Lohit Kad-Oracle Reporting and Analytics for ERP
-
Verification of User Login Status in ERP CloudSummary: I would like to know if there is a report in ERP Cloud that shows which users logged in and when. Content (please ensure you mask any confidential information):…
-
which tables store information about data access set for user?I need to a query to read for each user which BU have access to
-
AR Print Receivables should send invoice pdf file and attachments seperately to SFTPOrganization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Deloitte USI Description (Required): …
-
Query for Assignment Action and Action reasonSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…TestUser35 1.1K views 4 comments 0 points Most recent by L.G.M Manikanta Reporting and Analytics for HCM
-
Roles required for PER_AVAILABILITY_DETAILS.GET_AVAILABILITY_DETAILSSummary: Hi, We have created a report to get employee calendar, and we are using PER_AVAILABILITY_DETAILS.GET_AVAILABILITY_DETAILS in our query. This is working for us a…
-
How do we split the invoice and supporting attachments into separate files in Print ReceivablesCurrent State : Invoice and supporting attachments are sent as one file to the customer from the client when they run the Print Receivables Job in Oracle Fusion Requirem…
-
How to creat data set with standard SQL link to PLSQLI need to build a BIP report using RTF as layout The report has header and detail level To generate XML with header / detail , I need to write header and detail SQL in t…
-
Add parameter to Seeded report- Statement Generation data modelSummary: Hi, I have a requirement to add the parameter to Receivables-Statement Generation data model, its giving me error saying Parameter is not declared in the packag…
-
Use of custom objects created using application composer for building BIP reportsSummary: We have built couple of reports referencing custom objects created using application composer. We wanted to check if Oracle has any plans in near future to depr…Jepson Erattuparmbil 3 views 0 comments 0 points Started by Jepson Erattuparmbil Reporting and Analytics for ERP
-
Performance Issue - per_availability_details.Get_availability_detailsWe've developed a BI Publisher Report, but it's experiencing performance issues. When run ad-hoc, the report times out (Timeout Error), and when scheduled, it takes over…
-
what is the relevant table for ap_batches_all table in oracle fusionwe have AP_BATCHES_ALL table in oracle fusion, but we don't see any data in table . Is there any relevant table for ap batchesHarshitha S Motagi 11 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
Hi, It is possible to send Attachment from AR Invoice Level Using BI Bursting Report from AttachmentHi, It is possible to send Attachment from AR Invoice Level Using BI Bursting Report from Attachment
-
How to Import a signature and logo in UCM Server and Export a signature and logo in RTF TemplateSummary A requirement is to upload logo in UCM server and access that logo in RTF Template by using Payment Format(Check printing))Content A requirement is to upload log…Arpita Saha-137995 728 views 10 comments 1 point Most recent by User_P8MK7 Reporting and Analytics for ERP
-
Equivalent FUNCTION (per_bipntf_utility) for XPATH QuerySummary In Fusion Cloud Applications Update 21C, Oracle will deprecate a column in a table in the BIP Data Models (HRC_TXN_DATA.DATA_CACHE) and advised to replace XPATH …Sandeep19rm 1.5K views 3 comments 0 points Most recent by Aditya Jena Reporting and Analytics for HCM