BI Publisher
Discussion List
-
How to create View Image in AP invoice pageSummary: How to create View Image in AP invoice page Content (please ensure you mask any confidential information): Hi All, We got a requirement to create one button and…Venkatesan 12 views 1 comment 1 point Most recent by Venkatesan Payables, Payments & Cash Management -
can we hide a WF Notification hyperlink with BIP and RTF template based on a security roleSummary: HI Reporting and Analytics forum esp BI Publisher gurus: Is there is an easy way to hide a URL hyperlink on a Notification page (RTF BI Report -side) also based…
-
The report output isn't available. You must schedule the report to run.Summary: Hello, I am trying to create a BI Publisher report for users under the custom folder so that they can run it from FRC. I am able to run it but when uesrs are ru…
-
How to print page number only in last page in rtf templateHow to print page number only in last page in rtf templateLakshmiVanarasi 14 views 1 comment 0 points Most recent by Razvan Paduraru-Oracle Reporting and Analytics for ERP
-
Cannot find GL_JE_LINE table when trying to create Data Model for BIP. "SELECT * FROM GL_JE_LINE"When I try to run this sql in a data model it says the record does not exist, but I'm positive it does. Any ideas why we can't select from it? SELECT * FROM GL_JE_LINEWilliam Jordan 11 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
can we restrict/hide viewing few columns based on rolesIn custom reports, i want to hide few columns based on the roles. I want to restrict the access of columns to few employees only. Is it possible to achieve?
-
Getting error while bursting BIP report output to sFTP serverSummary: Getting below error while bursting BIP report output to sFTP server- Below is my SFTP bursting query- *with hash_q as query* select distinct HASH "KEY", 'MicroS…Neha Aishwarya 85 views 1 comment 1 point Most recent by Lucy Garding Reporting and Analytics for ERP
-
Run large BIP reports using ScheduleReportWSSServiceSummary: In the following document Oracle advises using the ScheduleReportWSSService for executing BIP reports with substantial data volumes. Fusion Application BI Publi…Pradeep Moganti 305 views 2 comments 1 point Most recent by User_0P0CT Reporting and Analytics for ERP
-
Use the ESS web service to schedule a job for running the BI cloud extractsSummary: We have been attempting to run a BICC based job from a SOAP\API call using something similar to the ErpIntegrationService submitESSJobRequest SOAP function but …AaronBaltimore 141 views 5 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Can we restrict jobs based upon roles?Summary: Hi Team, We are looking for a possible solution which might help us to satisfy the below requirement Step 1: A Custom roles to be created and assigned to a user…Dileep Varanasi 36 views 3 comments 0 points Most recent by Toyesh Patra Reporting and Analytics for ERP
-
How to use the or in if clause together in RTF correctly?In RTF template How to use OR in the IF condition ?MayuriMMote 13 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
SQL tables that store invoice and journal approval data like tasks & related rules etc.?Summary: What are the SQL tables with invoice and journal approval data like tasks and related rules like we have for procurement where we have the table POR_AMX_TASKS, …Gurvinder Singh Gill 812 views 3 comments 0 points Most recent by Sravani Budde Reporting and Analytics for ERP
-
Query to get hash codes in case of Fusion APISummary: In max of the REST API for Fusion, we need to pass hash keys like for example in case of Invoice attachment (https://docs.oracle.com/en/cloud/saas/financials/23…sailesh_cloudare 1.2K views 6 comments 1 point Most recent by RKSharma Reporting and Analytics for ERP -
How to display sysdate in an excel template. I am using an HCM Extract.Summary: I want to display the sysdate in one of the columns of an excel output. I am using an excel template. Content (please ensure you mask any confidential informati…
-
Which table has Journal Transaction details?Hi, Does anyone know where the details below can be found in the Oracle Fusion? This is inside of a Journal Transaction
-
Budgetary Control Carry Forward Sample BIP ReportsSummary Sample reports to identify transactions that impact budget account balances, and also facilitate the identification of transactions and balances that need to be …Anne Wong -Oracle 947 views 7 comments 7 points Most recent by Marwa Reporting and Analytics for ERP -
Error when performing a multiplication on a calculated measure in OTBISummary: Hello, When trying to perform multiplication on a calculated measurement of the items in the image, An error occurs that I have not been able to resolve. Conten…Kauan_Bohn 42 views 16 comments 0 points Most recent by mathew060581 Reporting and Analytics for ERP -
Extract XML or output from ESS jobSummary: Is there a way to extract XML or output from ESS job through SOAP webservice, or REST to outside of Oracle fusion Content (please ensure you mask any confidenti…Sunil Pradhan 57 views 4 comments 0 points Most recent by Razvan Paduraru-Oracle Reporting and Analytics for ERP -
Table to find instance name/Environment NameHi Team, Could you please share a table or SQL to find the instance name, when values would be DEV1, DEV2, or PROD. I have already checked the ASK_DEPLOYED_DOMAINS table…Swapnil Kashid 310 views 6 comments 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP -
actual vs budget bi publisher based on COASummary: Hi, is there a BIP report where we can extract initial budget and adjusted amount for chart of accounts 1-3. Content (please ensure you mask any confidential in…
-
There is requirement on BIP for learningSummary: when the learner course is due date past 7 days email notification should go to manager 's manager. How can we write BIP report to generate notification Content…
-
What does the following code in an RTF table cell actually do (if@cell:position()...)?Summary: Hi, I wondering if someone can explain to me what the following code might do. I found it in an BIP RTF report within a table cell. The code was introduced besi…Frank.Steinjan 51 views 8 comments 1 point Most recent by Frank.Steinjan Reporting and Analytics for ERP
-
OTBI - Read Only ModeSummary: I have a service account that is set to Read Only Mode within Fusion, however when navigating into OTBI the account is no longer in read only mode and can edit,…
-
Query to get the final approver of AP InvoiceSummary: Hello, We have a requirement to fetch only final approver details along with Invoice/Requisition in a Invoice and requisition workflow report. Current report is…Sushmitha G 89 views 1 comment 0 points Most recent by James McBride Reporting and Analytics for ERP
-
How to format date column in Excel Template without adding another columnSummary: I am able to format date column in excel by adding another column and using =DATEVALUE function as suggested in below link, but I want to format date in current…Meer Muzafar Ali 21 views 1 comment 0 points Most recent by Razvan Paduraru-Oracle Reporting and Analytics for ERP
-
Why BU is a mandatory parameter in ESS job of Uninvoiced Receipts Accrual ReportWe have a business requirement to run Uninvoiced Receipts Accrual Report for all the BUs. But using the ESS job we can select only one BU at a time. Tried to execute or …DebasmitaDas123 11 views 3 comments 0 points Most recent by DebasmitaDas123 Reporting and Analytics for ERP
-
Bursting Email attachment with a constant attachment.Summary: Is there is any possible way to add an extra constant attachment (pdf) to send an email bursting along with report attachment? If it is Possible please help me …Goutam5555 11 views 1 comment 1 point Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
Can we schedule a BI Report run and place the generated file in an SFTP location?Summary: Can we schedule a BI Report run and place the generated file in an SFTP location? How can we do this?
-
How to call an Integration in OIC from ESS Job in Oracle Fusion SaaSSummary: How to call an Integration in OIC from ESS Job in Oracle Fusion SaaS Content (required): I have an Integration in OIC and I want it to be triggered by submittin… -
Report on inception to date activity on the Revenue aspect/Invoice aspect Development SOW projectsHello, We have a required to build a BIP report on inception to date activity on the Revenue aspect/Invoice aspect Development SOW projects. We need to fetch the financi…