BI Publisher
Discussion List
-
Standard report to provide Cost, YTD and Depreciation Reserve before running Depreciation programIs there any standard report which will provide the Cost, YTD depreciation and Depreciation reserve of assets after mass additions/mass copy in tax book before running t… -
default List of values based on login user in BI ReportSummary: I am trying to Default Division in List of values based on user login, is it possible?? If I login as someone from Operations, I want only Operations Division t…SAI KOMATIREDDY 5 views 0 comments 0 points Started by SAI KOMATIREDDY Reporting and Analytics for HCM -
BI Report in payroll flowSummary: I’m trying to add a BI report in a payroll flow. I’ve done everything, and when I run the flow, the payroll gets calculated successfully. But when it reaches th… -
Extra blank line in Excel output from BI Publisher RTF template due to using page break to get multiSummary Extra blank line in Excel output from BI Publisher RTF template due to using page break to get multiple tabsContent Hi Experts, I have a problem. There is a BI R…Aloka Bhattacharya 2.1K views 28 comments 1 point Most recent by Veeru S M-Oracle 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… -
Restrict BI Author Role to only create OTBI Reports, they should not have ability to edit BI ReportsHow to restrict the user having BI Author Role to only create & access OTBI ORC Subject areas reports only. Not having access & edit BI Reports for other work area like …Twinkle Dudani 62 views 8 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
Join Course and Offering assignment tableSummary: Hi, I'm trying to create a Datamodel (basically a query) to join Course Assignment and Offering Assignment. Both uses the same table WLF_ASSIGNMENT_RECORDS_F, j… -
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 69 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 174 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 28 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 -
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