BI Publisher
Discussion List
-
Tables to get the Project Budget by monthSummary: Can anyone help me with the details of the tables that have Project budget in PPM. I am looking for the budget data by month. Building a custom BIP report. Cont… -
Reports and Analytics - Catalog - usage numbersSummary: Need to identify usage nubmers of reports in the ERP Tools and Analytics catalog Content (required): We are trying to identify the frequency and usage of report…Marko Puskac 41 views 4 comments 0 points Most recent by Marko Puskac Reporting and Analytics for ERP -
Need PVO details for PER_ROLES_DN? Not able to find one in BICC mapping to Finance/HCM listSummary: I am looking BICC Tag for PER_USER, PER_USER_ROLES , PER_ROLES_DN HAve found following for PER_USER and PER_USER_ROLES and not for PER_ROLES_DN HcmTopModelAnaly…Antony P Patrick -Oracle 103 views 6 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Is there a function to get lookup meaningsSummary: I am creating a report and the users require the displayed values for the lookups, I know I can do multiple links to the fnd_lookup_values_vl view (see code sni…
-
Print Receivable Transaction not generating output for Intercompany invoicesSummary: Print Receivable Transaction not generating output for Intercompany invoices Content (please ensure you mask any confidential information): Hi All, Why Print Re…Venkatesan 21 views 2 comments 1 point Most recent by Eain Cathcart-Oracle Receivables & Collections
-
Creating BIP Reports via SOAP WebserviceSummary: Creating BIP Reports via SOAP Webservice Content (please ensure you mask any confidential information): 1)Can we create a BIP data model and report dynamically …Kishore S-Oracle 497 views 6 comments 3 points Most recent by Sudhan Reporting and Analytics for ERP -
Ability to restrict access to specific FAH Subledger tables for creating new data modelSummary: Ability to restrict access to specific FAH Subledger tables for creating new data model. This is needed to restrict personal information which is coming from so…
-
Required Tables that stores min-max values for Replenishment planningSummary: As part of report development, we required min-max values for Replenishment planning. Please provide the details of tables that has to be used to derive the val…
-
How to add a deep link to items ?I have attempted to use the Deep Link SCM document to create a deep link for Items, but unfortunately, it didn’t work as expected. Could you kindly assist me with a step…
-
PO PDF error printing attachments "Could not get data source connection for: FA_UCM_PROVISIONED"Summary: Getting error in PO PDF customization " "No such data source found in the data source config. Or you do not have access permission. Could not get data source co…Lucky Sharma 32 views 7 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…
-
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 21 views 3 comments 1 point Most recent by Nathan CCC Reporting and Analytics for ERP
-
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 21 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 267 views 3 comments 1 point Most recent by Gopi Krishna Pokuru 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 65 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. 33 views 4 comments 0 points Most recent by Dhilip Kumar P. Reporting and Analytics for ERP
-
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…Nidhi Chhajed 133 views 1 comment 1 point Most recent by MiaM-Oracle Reporting and Analytics for ERP
-
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 41 views 1 comment 0 points Most recent by MiaM-Oracle 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
-
sql query to fetch item number detailsSummary: We need a SQL query to fetch the item number, business unit, inventory item id, unit cost, total cost, sub inventory code, organization name. Kindly let us know…Dilip.Murugan-Oracle 2K views 11 comments 0 points Most recent by User_2Y0JM Reporting and Analytics for ERP
-
cashflow statement report querySummary: Hi All, Does any one have 'Cashflow Statement Report' query?? if you have could you please share. Thanks in Advance. Content (please ensure you mask any confide…Amarnath Podaralla 11 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
How to join INV_TRANSFER_ORDER_HEADERS with GL_JE_LINES to get period name?Summary: I am using INV_TRANSFER_ORDER_HEADERS,INV_TRANSFER_ORDER_lines table in my report to get transfer data but i want to run this report for particular month and ad…
-
Fixed Assets To and From Period range parameterSummary: I'm editing a DM for a fixed assets report. My task is to create a "To Period" and "From Period", the issue is in the SQL no matter how I've written it in to be…
-
Extra blank page in the output from BI Publisher RTF template due to using page break to get multiBI Publisher - RTF Template Report Output - Extra Blank Page is getting generated at the end of the Output.Srini_Venkat 83 views 1 comment 1 point Most recent by Shankar-Oracle Reporting and Analytics for ERP
-
How to stop/disable email bursting from BIP reports after P2T refreshSummary: Hi All, We have multiple custom BIP reports with email-bursting queries. When the P2T happens, we want to disable the email bursting from the custom reports. Si…
-
ERP BI Publisher - HTTP Data SourceWe are planning to use an external API as a data source in BIP within Oracle ERP Cloud. Can anyone confirm if "HTTP" as a data source will be de-supported in a future re…Rohit Varma - Architect 21 views 1 comment 1 point Most recent by MiaM-Oracle Reporting and Analytics for ERP