BI Publisher
Discussion List
-
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?Reshma Eldho 22 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP -
How to disable the Open option on Reports & Analytics Catalog?Summary: How to disable the Open option on Reports & Analytics Catalog? Among the various reports offered out-of-the-box by the Oracle Fusion modules, some of them can b…Valter Pilan 695 views 10 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP
-
Access Values in mapping set for reportingI'm working on a BI publisher report that is a crosswalk from a legacy system to their new values in Oracle Fusion. The report is around deliver-to locations and in Fusi…
-
OIC Gen3 Services calling in Fusion by using BIP/ Groovy AuthenticationSummary: We are tying to consume the OIC Gen3 REST/SOAP services by using BIP/Groovy we are unable to call them." Error while processing authentication at Trigger. Faile…
-
My ledger currency and reporting currency is different.Summary: Need a report from Oracle cloud financial module that provides month end FX rates. Content (please ensure you mask any confidential information): My ledger curr…PiyushRathi1234 26 views 3 comments 1 point Most recent by Nathan CCC Reporting and Analytics for ERP
-
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… -
FND_FLEX_VALUE_NORM_HIERARCHY is not available in fusion. Please suggest the replica table in FusionSummary: We have DWH implemented and as part of cloud transformation we are migrating from EBS to Fusion Cloud ERP. Hence, from DWH perspective, we are in process of ana…
-
Supplier bank country field in OTBI reportSummary: Supplier bank country field not found in "Supplier-Supplier Real Time" OTBI Subject area Content (please ensure you mask any confidential information): Version …Sharmava 12 views 2 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Supplier Management
-
Query for Approval DelegationContent Hello, I am looking to build a BIP Report which displays whenever someone has delegated approvals to someone of a lower job level - does anyone know where this i…Elliot Hall-Walker 244 views 3 comments 1 point Most recent by Gopi Krishna Pokuru Reporting and Analytics for ERP
-
SQL script for job roles inherited by data rolesSummary: Trying to build a query to fetch users with their data roles and inherited job roles. I am able to fetch the data roles and job role assigned assigned directly …Vaishnavi Agrawal 22 views 2 comments 0 points Most recent by Vaishnavi Agrawal 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 11 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
RTF XDO_METADATA setup not working despite mirroring other setup that is workingSummary: We have customized an RTF to where the results are broken out into different tabs. We used the same for each loop as the other tabs, but the new tab is putting … -
conditional formatting in RTF for duplicateSummary: Is it possible to format rows so that a value is filled with yellow when the value is present in the data more than once? Content (please ensure you mask any co…
-
Can someone help on how to setup to print directly from Oracle to a network printer?Summary: We want to print some reports directly from Oracle. Is there a way to use a printer in the network to have the output of the report print to a printer? Content …
-
Table : ap_inv_aprvl_hist_all field "response" possible values meaning?Hi Guys I could not find anything on the web, I would be interested to know what some of the values in the "response" field in table ap_inv_aprvl_hist_all mean please an…
-
Payables XML can't perform a substring to a concatenated string inside a for-eachSummary: When creating a payment request, we need to have all invoice numbers concatenated in the same field "Ref" from the XML template. However, the bank only allows l…Emma Fayos García 9 views 0 comments 0 points Started by Emma Fayos García Reporting and Analytics for ERP
-
Is there a way to sort date type columns by default?Summary: Is there a way to sort date type columns by default? We want to sort this column with the DD/MM/YY format but by default we can only sort it by MM/DD/YY, if we …
-
Change Excel Sheet name in BI Publisher TemplateContent Hello, Is it possible to rename the Excel Sheet names of a BI Publisher Template Report [Type xpt] which has default output format as Excel (xlsx) ? I have creat…Nalinee Uppiah 896 views 3 comments 1 point Most recent by Tom John Bontoyan 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 21 views 1 comment 1 point Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
How restrict custom BI report data based on flexfield segment valueSummary: How restrict custom BI report data based on flexfield segment value Content (please ensure you mask any confidential information): Hi All, We want to restrict c…
-
How to create a formatted CSV outputHi, The current CSV output format of any BIP Report Layout support only non-formatted CSV. Is there a possibility to get a formatted CSV as per the template designed, Pl…
-
How to export XML sample file from Purchase Order PDF data modelI am trying to export the XML from the standard Oracle Purchase Order PDF Data Model, so that I can import that XML Sample into the RTF Document (using the BI Publisher …Richard Nagle 11 views 3 comments 0 points Most recent by Richard Nagle Reporting and Analytics for ERP -
Terms & Conditions in PO PDFSummary: Hi Fellow Developers, The requirement is to host Terms and Conditions file in Oracle cloud and it should be printed as hyper link in PO PDF. when ever a Supplie…Dhilip Kumar P. 11 views 4 comments 0 points Most recent by Dhilip Kumar P. Reporting and Analytics for ERP
-
Is there a way to modify the configuration so that the link to its own cell is displayed?Summary: When downloading information from a report, clicking on the link of any of the cells always displays the link to the cell corresponding to the first row. Is the…Manuel_Rioboo 21 views 2 comments 0 points Most recent by Manuel_Rioboo Reporting and Analytics for ERP
-
Getting Null value For Pricelist Name While Extracting CO Item from BIP report in EGUP-TESTSummary: Getting Null value For Pricelist Name While Extracting CO Item from BIP report in EGUP-TEST, what can be the reason behind this issue. Content (please ensure yo…
-
How to concatenate elements with same name in etext templateSummary: How to concatenate elements with same name in etext template Content (please ensure you mask any confidential information): We are working in etext template for…
-
Does anyone know about what X-invoices format? or ZUGFeRD format? how we can adapt with RTF TemplateCurrently we are using RTF Format template for invoices, and we are sending Invoice details in PDF. But recently Germany business users asking the invoices details in ZU…Srikanth Doodapaka 32 views 1 comment 0 points Most recent by MiaM-Oracle Reporting and Analytics for ERP
-
How to create Bursting without linking / upload attachment to a Transaction?Summary: Hello, we are using a customized Datamodel for the Print Receivable Transactions process. We also use our own bursting which creates multiple PDFs for a transac…Frank.Steinjan 2 views 0 comments 0 points Started by Frank.Steinjan Reporting and Analytics for ERP
-
Unable to find the table and column in which "Grouped construction in progress" flag at project ExpContent Hi All, I am able to find the "Grouped Construction in Progress" flag at project expenditure level. please find the navigation attached. I'm unable to find the f…
-
Can someone suggest me with respect to performance tuning of the query?Issue is with a BIP report for optimizing the report query FYI this is AR report for Aging bucket. please find my initial findings below, request you to please provide y…Shahid Qureshi 61 views 7 comments 0 points Most recent by James McBride Reporting and Analytics for ERP