BI Publisher
Discussion List
-
BI Fields used at Header in RTF template do not show input parameters value when there is no data.Summary: Hi All, In custom report, BI Fields are used at Header level in RTF template to display selected input parameters values. User use PDF extract and it works fine… -
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 10 views 1 comment 0 points Most recent by Stephen Westerfield-Oracle Payables, Payments & Cash Management
-
Is there any table which stores last email notification sent date for Requisition approvalwe need to display Last email notification date in our report so we wanted to check is there any workflow table which stores the details. we trayed to query this below t…
-
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 …
-
Automating AGIS Invoices creation processHi Team We are trying to automate AGIS Invoices creation.OIC triggers the Transfer Intercompany Transactions to receivables.And after its trigerred we have created the B…
-
What reports are available for agent level productivity metrics?Summary: We are looking at agent level productivity metrics. What seeded reports are available in Oracle? Or are these custom created reports? This ask is across all the…
-
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…
-
How to Fix Height of table In An RTF TemplateSummary: Hi Team ,Can anyone tell me how to Fix Height of table In An RTF Template. Example: If table has 1 or 10 invoice the height of table should be same. I have chec…Nidhi Chhajed 207 views 3 comments 0 points Most recent by Leeni Samuel Reporting and Analytics for ERP
-
How to add Hyperlink to BI Excel template fieldSummary: We have a requirement to show Oracle AR Invoice Page and when click on Invoice Number in BI Excel template. Excel template has list of Invoice Numbers and its d…SireeshaJaladi 247 views 5 comments 0 points Most recent by SatheeshSamy-Oracle Reporting and Analytics for ERP
-
Which Table Stores Final Shipment Forecast Amount per Item in Manage Demand?Summary: I’m currently developing a report and struggling to find the table that contains the Final Shipment Forecast amount from Manage Demand. Has anyone encountered a…User_VJWD5 25 views 3 comments 0 points Most recent by NinaLyubenova-Oracle Supply Chain Planning and Collaboration
-
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):…
-
Scheduling "report" based on column with user emailSummary: I developed an SQL report on OTBI and an EXCEL output should be delivered to corresponding users. There is a column containing email address of the user and use…Rojhat Sinan Balka 6 views 1 comment 0 points Most recent by James McBride Reporting and Analytics for ERP
-
How to use job schedule as a parameter in an SQL report?Summary: I need a method to get recurrence rules from a job to use it in an SQL report. So if I change the job, related SQL should have the same effect. Content (please …Rojhat Sinan Balka 4 views 0 comments 0 points Started by Rojhat Sinan Balka Reporting and Analytics for ERP
-
Request Read Receipt while scheduling BI ReportsContent I have scheduled a BI report and enabled Request Delivery Status Notification and Request Read Receipt Option. But I havent received any email or notification af…Sabarish Reddy Ganda 119 views 1 comment 1 point Most recent by Usman Ali2025 Reporting and Analytics for ERP
-
Tables to get Multiperiod Accounting Invoices With Amortization ScheduleSummary: Tables to get Multiperiod Accounting Invoices With Amortization Schedule Content (please ensure you mask any confidential information): Hi All, Is there any tab…Venkatesan 14 views 1 comment 0 points Most recent by Daniela Petria-Oracle Subledger Accounting & Accounting Hub
-
Searching in Reports and Analytics using the magnifying glass icon giving internal server errorSummary: In reports and Analytics, users wanted to search for some related reports and so by using the search option(magnifying glass icon), they entered some options an…P.S.Nikhitha Muduliar 12 views 1 comment 0 points Most recent by P.S.Nikhitha Muduliar Reporting and Analytics for ERP
-
Query/tables to find payment approved by final approver approved PPRSummary: Query/tables to find payment approved by final approver approved PPR Content (please ensure you mask any confidential information): Hi All, We got a requirement…
-
Seeking Innovative Solutions for Stale Dated Check Letter Report in Oracle Fusion ERP CloudSummary: Hi Team, We're developing a report to identify stale dated checks, specifically those exceeding 180 days from their issue date. Our goal is to automate the dail…Abhilash K - Deloitte USI 3 views 0 comments 0 points Started by Abhilash K - Deloitte USI 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… -
Creating a Headerless CSV File Using eText TemplateSummary: We are planning to develop a report in BI Publisher that generates a CSV file without column headers. Our understanding is that in order to exclude the header, …Jimin Park 17 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
How to use number format of process options of ess job in the BI publisher concerned ?Hi, how to format amounts of my custom BI Publisher depending on Number Format of my custom ESS job (defined for this custom report), submitted to Scheduled Processes ?LaurentDup 4 views 1 comment 1 point Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
error using data mode property: Optimize Query ExecutionSummary: Hello everyone, a few days ago I experienced a new situation. I have a report that extracts a large amount of data (over 100,000). I tried to optimize the execu…Ayala01 14 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
Query to Find Privillages under Role and its Inherited RolesSummary: Need query to get privileges assigned under Role and its inherited Roles. Content (please ensure you mask any confidential information): Tried Below query but l…Nishanth B Jain 21 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
I want to restrict last line of any receipt line to be printed in EDI Etext template for the clientWe have 2 new BIP report enhancement requirement To restrict every receipt's last line to be restricted in the query, please see screenshot below for your reference the …Shahid Qureshi 14 views 2 comments 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Can i restrict edit access to BI reports to those who creates itSummary: Hi Team, We have a requirement to restrict edit access to BI reports that a certain user has created it. i.e , The one who creates can only be allowed to edit i…
-
How to check Memory Used Information for ReportSummary: We would do an enhancement for reducing the 'Memory Used' and 'Memory Read' for one BI report. However, we do not khow how to get 'Memory Used' and 'Memory Read…Abby Chen522 14 views 1 comment 1 point Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Output when using a procedure callHello, I created a procedure call within OTBI. It is a complex PL/SQL that retrieve data from several tables. Each data pushed into a local table of records. All is fine…AA 20 views 1 comment 1 point Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Line breaks in RTF template with Excel outputSummary: I have a report with two datasets. The first dataset is joined to the second dataset in the data model designer. The report used is an RTF template, and when ex…Ayala01 14 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle 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 a table for Payment Document Category in Manage Bank account setupSummary: Hi Team, We need a table where the information of "Payment Document Category" meaning stored. There is a column PAYMENT_DOC_CATEGORY in CE_PAYMENT_DOCUMENTS but…