BI Publisher
Discussion List
-
Degraded performance when using secured views in BIP reportsSummary: Using a secured view (e.g., PER_PERSON_SECURED_LIST_V) in a BIP report results in a severe increase in the execution time of the query when ran by a user with a…George Chernikov 68 views 3 comments 0 points Most recent by Lohit Kad-Oracle Reporting and Analytics for HCM -
Old value of Seniority Date doesn't appear in the report.Summary: Hi, We are building a BI Publisher report to track changes in different attributes in the system alongside Seniority Dates. So while we perform changes in that … -
Assets - The following segment labels have misspelled BI Object Name setSummary: Hi What are correct spelled BI Object Name set for Assets. I have hit the following error: Regards, Bo Content (please ensure you mask any confidential informat…Bo Tøpgaard 96 views 4 comments 0 points Most recent by Santhosh_Krishnan123 Reporting and Analytics for ERP -
Custom Disbursement Payment File Format Not Appearing in 'Manage Format' SetupDear All, I have successfully customized the Disbursement Payment File Format report: I also added two custom templates: However, nothing appears in the 'Manage Format' …George Mattar 173 views 8 comments 0 points Most recent by Neeraj_Pal Payables, Payments & Cash Management -
Course/Offering Status Code Change Impacting BIP Report Output Across EnvironmentsSummary: We created a BIP report in DEV2 using the status codes ORA_COU_ACTIVE (Course Status) and ORA_CLS_ACTIVE (Offering Status). The report had been working correctl… -
Retrieving learner-submitted attachments through the BI reportSummary: I need to fetch learner-uploaded attachment details via the BI report from the specified path below. UI Path - Edit Assignment > Related Materials > Learning As…Sanduni Pathirathne 28 views 4 comments 6 points Most recent by Kathy F. Reporting and Analytics for HCM -
Oracle BI Report bursting throwing errorHi Team, I created 5 reports and all 5 are scheduled in Prod. Only 1 report is getting failed while bursting. Getting below error. Detail Message: ::JOB_WAIT_TIME_SECOND…VijayRajalbandi 38 views 2 comments 0 points Most recent by Vasanthakumar Ravi Reporting and Analytics for HCM -
Error While Customizing “Global Subledger Detail Journal Report” – Invalid Table Name IssueSummary We are trying to customize the Oracle seeded report “Global Subledger Detail Journal Report” located in: /shared/Financials/Fusion Accounting Hub. We created a c… -
Provide the supplier balance aging report logic from backend.Summary: Hi Team, Could you please help us to provide the supplier balance aging report logic from backend. We were not able to see the logic of supplier balance aging r…Arjunayan 44 views 3 comments 0 points Most recent by Vishnu Kommineni-Oracle Payables, Payments & Cash Management -
Seeded Process/Report/Data Model customizationSummary: Once we did customization of seeded Process/Report/Data Model, after applied any patch/upgrade then the customization changes will override. Content (please ens… -
Invoice Approval Notification: Task details aren't available for this task. (FUN-720809)Summary: Our Invoice approvals are based on mail & one user has been getting "Task details aren't available for this task. (FUN-720809)" & notification is empty without …Sujatha Kumari 24 views 6 comments 0 points Most recent by Sujatha Kumari Payables, Payments & Cash Management -
Organization Calendar Events with Coverage Area Data Extraction QuerySummary: Query to extract Organization Calendar Events with Coverage Area (Geography) Content (please ensure you mask any confidential information): Hi, We have a requir…Vasanthakumar Ravi 4 views 0 comments 0 points Started by Vasanthakumar Ravi Reporting and Analytics for HCM -
How to fetch Burden Cost Burden Cost Code (Oracle Project Costing) — tables/SQL?Hi All, We’re trying to fetch burden cost details along with the burden cost code in Oracle Project Costing. Environment (please confirm) Product: Oracle Fusion Cloud: 2… -
How to use HTTP Connection as Data source with linked parameters in BIP (Fusion)?Summary: Hi, I'm looking for a way to use an HTTP Connection as a Data Source in a Dataset with BIP datamodel. The idea is to call URL with parameters which are linked f… -
unable to open Oracle seeded reportSummary: I do not see option to open the report. Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable…Ramani K 2 views 5 comments 0 points Most recent by Purvi -Oracle Payables, Payments & Cash Management -
Print Receivables Transactions completes with errorSummary: When attempting to run the "Print Receivables Transactions" process for a single invoice, we are getting below error: The bill-to customer email address for tra… -
REST API to run FRS reports in FusionSummary: Need to know REST API details if any to run FRS reports in Fusion Content (required): REST API to run FRS reports in Fusion Version (include the version you are…
-
New FRS report is not visible for the user in the Financial Reporting CenterSummary: New FRS reports is not visible for the user in the Financial Reporting Center Content (please ensure you mask any confidential information): New FRS reports are…Chittibabu Dudala 8 views 2 comments 0 points Most recent by Chittibabu Dudala General Ledger & Intercompany -
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… -
Is there a way to add field in Edit distribution feature on the BPM notificationIs it possible to pull the accounting date field into the BPM notification and make it editable when using the edit distributions feature on an invoice notificationAkanksha Bhardwaj 33 views 6 comments 0 points Most recent by Mohit8799 Payables, Payments & Cash Management -
Extracting Learning data from Oracle EBSSummary: Extracting Learning data from Oracle EBS Content (please ensure you mask any confidential information): Hi Team, Greetings! This question is about extracting Le… -
how to join xcc_budget_accounts to projects,tasks and expenditure typesSummary: i want to know the joins between xcc_budget_accounts and project tables. i have tried to join segment_value1 with project number from pjf_projects_all_b which i… -
I need to review the Invoice Header.Account Coding StatusSummary: Hi Oracle, I need to review the Invoice Header.Account Coding Status when it is not marked as “Complete.” Could you please confirm the exact value that should b…Javier Zakzuk 11 views 2 comments 0 points Most recent by Javier Zakzuk Payables, Payments & Cash Management -
Issues in Prepayment Handling in Custom AP Aging Report (As-of-Date Logic – Oracle Fusion)Summary: Incorrect remaining amount calculation in custom AP Aging Report due to improper handling of multiple prepayment applications (Invoice-Level and Line-Level), in… -
Permission for standard folderSummary: Hello, I'd like to know if we can set permission for Human Capital Management under shared folder(the standard folder) to specific users. I managed to do that i…Mayar Mohamed 7 views 2 comments 0 points Most recent by Mayar Mohamed Reporting and Analytics for ERP -
Report notifies manager when time reported by employee is less than 4.5 hoursSummary: I need to build a report that will have coloumns Emp name, number, manager name, department, and calendar days in recent time card on which date employee report…Vamsi Krishna G 8 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
How to fetch a comma separated string into separate columns in Oracle fusionSummary: We have a column name - "Approvers" from table - "FA_FUSION_SOAINFRA.WFTASK". When we have multiple approvers for a transaction and those will appear in the "Ap… -
How to enable deep link in payment approval notificationSummary: How to enable deep link in payment approval notification? Content (please ensure you mask any confidential information): Hi all, We got a requirement to show in…Venkatesan 42 views 3 comments 0 points Most recent by Stesha Sasidaran Payables, Payments & Cash Management -
Customize Receivables Aging by General Ledger Account ReportSummary: Hi, We want to customize the "Receivables Aging by General Ledger Account Report" for a specific GL Account. We know how to customize/ extend a seeded ESS BIP r…Gireesha Pinnagoda 224 views 6 comments 0 points Most recent by User_3XIID Receivables & Collections