BI Publisher
Discussion List
-
SQL query or link between CE_CP_OPTIONS and CE_CP_OPTION_TIME_DIMSSummary: Hi TTeam, Could you please help us on this below SQL query or link between CE_CP_OPTIONS and CE_CP_OPTION_TIME_DIMS in Specify Cash Positioning and Forecasting …Opkey PA 11 views 1 comment 0 points Most recent by Stephen Westerfield-Oracle Reporting and Analytics for ERP -
What table store approval rules configuration in FusionSummary: We are looking tables name for approval rule configuration. Navigation: Tools>Transaction Console>Approval Rules Content (please ensure you mask any confidentia…
-
BIP Report to list all Custom ReportsSummary BIP Report to list all Custom Reports.Content Ho to fetch list of all custom reports from cloud instance (Oracle Cloud SaaS). I know how to fetch them from BIP A…Amarnath 2.3K views 9 comments 1 point Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
Big performance difference between the query in BIP data model and the pure querySummary: The issue below has been observed Performance of a custom BIP started to be extremly degraded post to the upgrade. The BIP used to run in a second, but it start…Sunghpark 31 views 3 comments 0 points Most recent by Akash Katiyar-Oracle Reporting and Analytics for ERP
-
Extra space at the top of the page : RTF TemplateSummary: Having a strange issue with PDF generated form RTF Template. The RTF template has a header. The PDF output when generated has a blank space at the top of the he…Arun Raj 21 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP -
Procure-to-Pay RT subject area - approver nameSummary Procure-to-Pay RT subject area - approver nameContent I am attempting to update my existing P-to-P reports to leverage the P-to-P RT subject area; this subject a… -
SQL query to create list of values for past 24 monthsSummary: I've been searching and attempting to create a List of Values to be used in a Data Model for a report to make the parameter selection dynamic year over year ins… -
Connect to PaaS db from BIP to create report from custom tables created in PaaSSummary: Connect to PaaS db from BIP to create report from custom tables created in PaaS Content (please ensure you mask any confidential information): We have a require…Jepson Erattuparmbil 24 views 3 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
How to pass system date in subject line of email notification when scheduling an Ess jobSummary: I am scheduling ESS job set, our requirement is to print system date in email notification subject line and attachment name. How to configure dynamic date (Sysd…VasanthaFusion90 15 views 1 comment 0 points Most recent by VasanthaFusion90 Reporting and Analytics for ERP
-
ReportService API appears to be deprecated or marked as obsolete in the April 25B update.Summary: As part of the April 25B Patch activity, we noticed that the ReportService API (/xmlpserver/services/v2/ReportService?wsdl) deprecated or obsolete?. Could you p…Chaitanya2324 75 views 2 comments 1 point Most recent by Sridhar Gupta Yerram-Oracle Reporting and Analytics for ERP
-
Report that can extract information about the user's active tasksIs there a report that can extract information about the user's active tasks, which are displayed in the task area of each module? A report on the privileges assigned to…
-
Could you please help with fusion table details or query to get Supplier Email Address.Summary: Looking for list of all Oracle Suppliers email addresses held in Oracle fusion. Thanks. Content (please ensure you mask any confidential information): Looking f…ManishaPatil 134 views 2 comments 0 points Most recent by Kinjal Patel-Oracle Reporting and Analytics for ERP
-
Is there something similar to srw.abort_program in Fusion ERP bip reportIn Oracle report writer one could abort the report using SRW.ABORT_PROGRAM Built in. Is there similar built in in FUSION ERP BIP Report? -
UCM Bursting not working for Fixed Assets Seeded ReportSummary: Issue in UCM Bursting for Seeded FA report Content (required): Hi, We are trying to create bursting for seeded FA What-If Depreciation Analysis Report to push o…Vaigu_27 52 views 1 comment 1 point Most recent by Dinesh Krishna Mamilla Reporting and Analytics for ERP
-
Include URL in BI Publisher report to allow viewing of invoice attachmentsSummary: I am trying to find a way to include a url link to a scanned invoice images stored as pdf attachments in Oracle from a BI Publisher report. Content (required): …User_2025-02-10-15-12-48-631 277 views 9 comments 1 point Most recent by Ramya_30395 Reporting and Analytics for ERP -
What is the role or data access that allows to visualize the Subject Area.?Summary: What is the role or data access that allows to visualize the Subject Area. When I need to search, it is empty. Please your help Thanks Content (please ensure yo… -
Need to enable GL Date From and To as parameters in Account Analysis ReportSummary: Need to enable GL Date From and To as parameters in Account Analysis Report Content (please ensure you mask any confidential information): Account Analysis Repo…Deepa Lakshminarayanan 13 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
BIP - Change Content Type in Content Server Data SetHi, Is it possible to change the "Content Type" from a content server data set in a data model in order to read PDF / Docx content. Thanks! GuillaumeGuillaume SAVALL 11 views 2 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
BIP SFTP Bursting vs BIP SOAP API calloutSummary: Advantages of BIP API download option (for data reports) Vs BIP report sent to SFTP channel Content (please ensure you mask any confidential information): We us…Abdullah Munaz 42 views 2 comments 0 points Most recent by Akash Katiyar-Oracle Reporting and Analytics for ERP
-
SQL query to display Purchase Category hierarchySummary: SQL query to display Purchase Category hierarchy Content (required): For anyone who might find this useful, I've written a SQL to pull the Purchase Category hie… -
Some of the PDF attachments not appearing on printed AR Invoice in Print Receivables TransactionsHi Team, We are facing an issue where attachments in receivables transactions are not consistently getting attached or sometimes dropped during the printing of the invoi…
-
Report not displaying Barcode when executed from ESS jobSummary: Report not displaying Barcode when executed from ESS job Content (please ensure you mask any confidential information): We have customized the Receipt Traveler …
-
Import Oracle Fusion Data Extensions for Transactional Business Intelligence having an impact.Summary: There's an issue with HCM Reports having said that some columns were not available and the root cause of it was when Import Oracle Fusion Data Extensions for Tr… -
Using rest api in fusion BI publisher data modelSummary: Is there any way to use rest api fusion BI publisher data model, I need to consume external data source and create a report in oracle fusion Content (required):…ShivaShiva 1.5K views 6 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
Joining GL with subledger, description repeatingI have the below SQL query and it runs and amounts are as expected. My issue is that when looking at a project journal the line description is repeating and it's not dis…
-
Asset cost and reserve detail ReportSummary: I am currently working on a custom report where I need to include asset cost, reserve details, and a summary report. However, I am unsure about how to obtain th…Regina_P-Oracle 96 views 2 comments 0 points Most recent by arpit_paliwal Reporting and Analytics for ERP
-
BIP Joining GL with PJF_PROJECTS_ALL_BI'm trying to join PJF_PROJECTS_ALL_B with this query so that I can add segment1 from the table to this GL report. Does anyone have any insight for easiest way to achiev…
-
Required a field name and Table name for Manage Payment MethodsSummary: Hi Team, We need backend tables and a column for the field "Automatically assign payment method to all payees" under Usage rule → Manage Payment Methods. I coul…Opkey PA 34 views 1 comment 0 points Most recent by Krishna Pulicherla-Oracle Payables, Payments & Cash Management
-
Table to get the field of Condiion under Manage Chart of Accounts MappingsSummary: We need a table and column where the Condition field information stored for the setup "Manage Chart of Accounts Mappings". Attached the screenshot with highlite…
-
Table or Query for Condition column for Separate Remittance Advice in Manage Payment Process ProfileSummary: Hi Team, We need a table or query to get Condition fied under the Separate Remittance Advice in the setup Manage Payment Process Profile. We gone through these …Opkey PA 12 views 1 comment 0 points Most recent by Stephen Westerfield-Oracle Payables, Payments & Cash Management