BI Publisher
Discussion List
-
How to disable user login whenever the user is deactivatedSummary: Content (required): Hi All, The requirement that when users leave the company and when email get deactivate in the company, then fusion application login also s… -
Time Entry report to get updates and deletion of time entrySummary: Need a report for time entry to pull all new creation, updated and deleted records. Content (required): We have a requirement for integration where we need to g…Raghavendra M 74 views 9 comments 0 points Most recent by John Finnegan-Oracle Reporting and Analytics for HCM -
Need query for notes created on transaction level and customer level at collections dashboardSummary: Need query for notes created on transaction level and customer level at collections dashboard Content (required): following query only return notes at transacti…
-
Legal report for Portugal to communicate the inventories once every year - Portugal localizationsSummary: Portuguese companies are required to communicate to the Tax Authority the inventory relating to the last day of the tax period, through a file with defined char…Siddharth JSS 81 views 6 comments 0 points Most recent by Bogdan Pana-Oracle Reporting and Analytics for ERP
-
Need query for notes created on transaction level and customer level at collections dashboardSummary: Need query for notes created on transaction level and customer level at collections dashboard Content (required): following query only return notes at transacti…Nikatfusion 41 views 1 comment 0 points Most recent by Mohamed Sadik -Oracle Payables, Payments & Cash Management
-
Unable to Deploy to BIP using Oracle SOAP ServicesSummary: Unable to use /analystics-ws SOAP Service to deploy a BIP Report (catalog file). Content (required): We use pasteItem2 operation of https:///analytics-ws/saw.dl…Shrujal Patel 62 views 2 comments 0 points Most recent by Shrujal Patel Reporting and Analytics for ERP
-
Can someone help me with the query for customizing the trial balance report.Summary: Currently i am trying to customize the oracle standard trial balance report for fetching the YTD,PTD and QTD balances. Need someone who can help with the logic …Rudraksha Vishnu 171 views 1 comment 0 points Most recent by MariCostache-Oracle General Ledger & Intercompany -
Access to restricted data in BI reportSummary: We have a BIP report in /Custom/Human Capital Management/Reports, which is used by certain users. On May 31st one user reported that he/she is able to view data…
-
Getting Absence Reason in BIPSummary: I need to get the absence reason for a large number of absence in a BIP report. However, when trying to link the Absence Entry Reason ID to the Reason ID using …
-
Need help in DataModelInSession SOAP ServiceSummary: Can someone share working payload of DataModel In Session SOAP Service to call Data model dynamically in Fusion? Content (required): Version (include the versio…sailesh_cloudare 41 views 0 comments 0 points Started by sailesh_cloudare Reporting and Analytics for ERP -
BI Publisher report with cashing multi-million records query and staggered upload to FTPSummary BIP Maximum Rows for CSV output limit is 2 million. need elegant solution to query database only once for bigger record count and then have staggered upload of r…Roman Havrylyak 491 views 4 comments 1 point Most recent by Roman Havrylyak Reporting and Analytics for ERP -
How to create actual vs budget and variance report?Summary: Hi, We have loaded our budget on budgetary control. We are now trying to build a report with budget vs actual amounts and variance between the two. However, ora…ShailenS 1.1K views 4 comments 0 points Most recent by Linda Wong-Oracle Reporting and Analytics for ERP
-
Payment format file is producing output in Text format instead of PDFSummary: Payment format file is producing output in Text format instead of PDF Content (required): Version (include the version you are using, if applicable): Code Snipp…User_2025-03-10-22-49-33-989 131 views 2 comments 0 points Most recent by Sandeep Nayak-Oracle Payables, Payments & Cash Management
-
Restrict the access for creating data model and create analysisSummary: Hi All, How to find the roles which are giving create and edit access of analysis and BIP report? is anyone have any SQL for to find out these in any custom rol…Amit_Ekbote 41 views 2 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
While running whole population in OTBI we are facing issue.Summary: Content (required): we are using Pivot table output in the OTBI report for 1 or 2 employee it's working fine when we are running whole population, we are gettin…challa praveen 22 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
User wants to use BI PublisherSummary: Hi, There are 2 users in Oracle Application Cloud- kalam and rtokar. kalam can access and see data in OBIEE my folder where as rtokar can't do the same. The use…
-
Report to extract LRU Calculation cards configuration detailsSummary: Report to extract LRU Calculation cards configuration details Content (required): Hi Team, Greetings! Does anyone have the report or the query to extract LRU Ca…Parag Hiremath 61 views 0 comments 0 points Started by Parag Hiremath Reporting and Analytics for HCM -
Is there a way to report which report is used how frequently for BI/OTBI/BICC/FRS?Summary: Hi Team, We are looking for providing a metrics on usage of reports and wanted a way to report which report is used how frequently for BI/OTBI/BICC/FRS? Content…Abhilash K - Deloitte USI 71 views 3 comments 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
Payment Amount Text in eText template for check printingSummary: We have a requirement to print check amount in below format ONE THOUSAND FIVE HUNDRED USD AND 00/100 DOLLARS Currently xml generated from PPR is having format l…
-
What are the prerequisites/setups for tax reporting in Fusion?Summary: Hi, Could someone please point me towards the prerequisites/setups need to make the "Finally Reported" column work? Thanks in anticipation, Shailen Content (req…
-
Customization of Collections Aging by Collector 7 Bucket ReportSummary:- I am customizing Oracle fusion seeded report "Collections Aging by Collector 7 Bucket Report" In which I Need to add Invoice_date in this report as one column.…Shraddhha Namde 282 views 1 comment 0 points Most recent by Daniel S.-Oracle Receivables & Collections
-
Mass Update messagesSummary: Content (required): What table stores the messages from Mass Update transactions? Version (include the version you are using, if applicable): Code Snippet (add …Scott Paulin 41 views 2 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Need the 8 seeded Receivables Bill Presentment Templates in Reports and AnalyticsSummary: How can I get the seeded Receivables Bill Presentment Templates? They were overwritten with customized versions in our environment so I cannot get them from Rep…Carol Fergusson 51 views 4 comments 0 points Most recent by Carol Fergusson Receivables & Collections
-
Invalid Number Error in fetching Basic Salary ComponentSummary: We are writing an oracle sql query to fetch different components in the salary for inactive employees. But it keeps showing below error on runtime. ORA-01722: i…Rohankumar Patel 61 views 2 comments 0 points Most recent by Sudheer Patel Reporting and Analytics for HCM
-
How can we limit access to reports residing in delivered (out of the box) folders?Summary: How can we limit access to reports residing in delivered folders? Most of the users have access to BI roles (Consumer/Author/Admin) inherited through other role…Dibyanshu_Shekhar 41 views 2 comments 0 points Most recent by Dibyanshu_Shekhar Reporting and Analytics for ERP
-
Can we hide a specific sheet in the excel output for some users?Content (required): We have an excel report which contains 2 tabs where 1st sheet contains the data dump and 2nd sheet is the actual report which is based on the 1st she…Sujeeth Chinta 41 views 2 comments 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM -
Automatic parameter binding for contextual reportsSummary How to configure R13 functionality "Application Context Passing to Embedded Reports"Content We are trying to configure the solution "Application Context Passing …Gabrielle Ungaro 69 views 2 comments 1 point Most recent by Satheesh Nesamani Reporting and Analytics for HCM -
Reporting on OTBI and its Subject areas in UseSummary: There is requirement to check if there are any existing OTBIs that uses fields identified as sensitive. Is there a way to achieve this? Content (required): refe…Girish_Kulkarni_123 32 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
BIP reports emailed securely from HCM (by default)?Summary: BIP reports emailed securely from HCM (by default)? Content (required): We are scheduling a new BIP report to go to internal users and external (outside the com…Rich R 61 views 4 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM