BI Publisher
Discussion List
-
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 493 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 135 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 21 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 63 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 -
What permissions do I need to run BI Publisher Web ServicesSummary: Getting this error when trying to run the runReport request for the BI Publisher ReportService: PublicReportService::generateReport failed: user: [XXXXX] does n…SeanWesche 1.1K views 5 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
Need table name for Additional Person InfoSummary: Need table name for Additional Person Info.Please refer the attachment for the screenshot.minati_behera-Oracle 482 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Restrict schedule access to users when scheduling BI jobs and OTBI agents.HI Team, We would like to know how to limit scheduling capabilities to users when scheduling BI jobs and OTBI agents. This access should be limited to certain users. Cou…MadhanMH 94 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
GL_PERIOD_STATUSES in BIP not up to date?Hi Guys I must be doing something wrong because I am not seeing the same values in the oracle backend database via BIP that I am seeing in the Oracle Front End. In the f…
-
Financial Tax Register contains confused informationSummary: Could you please provide someone related to Financial Tax Register Report Document. Need to understand on this report usage and its limitations. Content (requir…
-
Data security on BIP reportHi friends, We have developed a BIP data model/report using the below tables which touches across payables, supplier and hcm. Some of payroll users having the Payroll Ma…Vijay Ramani VJ 343 views 5 comments 0 points Most recent by manish sharma Reporting and Analytics for HCM