BI Publisher
Discussion List
-
Ability to get the Payment Approval Rule details defined on BPM by queries in Reports and AnalyticsIdea Number: 707234…Thomas De Leeuw 11 views 2 comments 0 points Most recent by Thomas De Leeuw Reporting and Analytics for ERP -
I need to find Frieght amount for purchase order line BI publihser sql,Summary: i am looking to figure out where freight amounrt for purchase order line is stored, can any one help me ? Content (please ensure you mask any confidential infor…
-
24C regression - scheduled reports are completing successfully for invalid email addressesSummary: Content (please ensure you mask any confidential information): If an invalid email address is provided as xyz@abc, Till 24B, the delivery was failing and delive…
-
BIP Data Source: Secure HTTP ConnectionSummary: While setting up an HTTP connection in the Data Sources section, I noticed that the only authentication method available is basic authentication. I’m reaching o…Pradeep Moganti 21 views 1 comment 1 point Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
1Required The bank account suffix from Supplier site bank account Subject area OTBISummary: Required The bank account suffix from Supplier site bank account to enhance from exist supplier bank account subject area.. We have raised SR 3-38474138291 : CC…
-
History Limit in ESS_REQUEST_HISTORY Table?Is there a limit to the history stored in the ESS_REQUEST_HISTORY table? I can see transactions in the view PAYROLL_FLOW that trigger a BIP report, but I'm unable to fin…
-
Need a query to get total of Current Cost, Accumulated Depreciation, Impairment for asset categoriesContent Hi all, Can someone give me a query that gives a total of : * Current Cost * Accumulated Depreciation * Impairment per asset categories in Fixed Assets Module. R…Sushan Peiris 1.1K views 2 comments 1 point Most recent by Soumya Prakash Parhi Reporting and Analytics for ERP -
Is there a way to custom the buckets of Aging 7 Buckets?Summary: I need to change the period of the buckets. Content (please ensure you mask any confidential information): Is there a way to create a customized report based on… -
Need the SQL query used in SaaS Service Usage Metrics ReportNeed the SQL query used in SaaS Service Usage Metrics Report (the one with PDF format extracted from MyServices) as we need to use it in a bursting program under BI Publ…
-
Insufficient space to include full field value in add help textSummary: For the BIP template trying to add a field to print the masked bank account number as below but it prints only upto…
-
Is there a mapping document from eBS to Fusion CloudSummary: We are moving one of existing eBS customer to Cloud and while moving existing reports for customer, we are facing many challenges to map eBS fields to Fusion Cl…Sanjaykuamar Varma-Oracle 1.2K views 8 comments 0 points Most recent by MangalThorat Reporting and Analytics for ERP -
Oracle will update BI Publisher-based notifications to Redwood-based BI Publisher.Summary: We have received the notification that in Oracle Fusion Cloud Update 25A, Oracle will update the few BI Publisher-based notifications to Redwood-based BI Publis…
-
How to Bind List of Values together so when either parameter is select the other auto populatesSummary: Wondering how to bind list of values together so that when a user selects one parameter, then the other is auto populated and then vice versa. So far all I can …
-
SQL Query for bypass Approval transactions of the BPM workflowSummary: The Client is asking to build a report based on the bypass Approval transactions of the BPM workflow. (without Approval). Content (required): we need to build t… -
How to restrict schedule process page based on usersSummary: How to restrict schedule process page based on users Content (please ensure you mask any confidential information): Hi All, As of now who ever has access to sch…Venkatesan 31 views 2 comments 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP
-
In what subject area can i find the details of a Return Lines (Return to Supplier)Summary: Hi In what subject area can i find the details of a Return Lines (Return to Supplier), specifically the details of the receipt number, RMA, Document Number (PO)…Johann Christian 33 views 5 comments 1 point Most recent by Becca Edwards Reporting and Analytics for ERP
-
How to get IP address of Fusion SaaS BI server that sends out email via burstingSummary: How to get IP address of Fusion SaaS BI server that sends out email via bursting. This is needed for white listing the From address to allow email to reach corp…Nirmal Ignatius 31 views 1 comment 1 point Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP -
How to create a parent schedule for multiple schedule of one BI Publisher reportClient has created multiple schedule of one one BI Publisher report using different parameters ex-cost centres and different recipient in each schedule. Is it possible t…Saikat1 21 views 2 comments 1 point Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
oracle.xdo.XDOException: Template type 'etext' is not yet supported.Summary: DataException:[INSTANCE_JOB_ID=1343928] oracle.xdo.XDOException: Template type 'etext' is not yet supported. oracle.xdo.servlet.data.DataException: oracle.xdo.X…Toka Halawa-Oracle 163 views 3 comments 1 point Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
Table or SQL queries for getting Project number along witht Expense report number ?Summary: Hi Team, Can anyone please let us know the table or SQL queries for getting Project number along witht Expense report number ?. Need to connect table PJF_PROJEC…
-
Oracle Fusion BI Publisher Custom Physical SQL SecuritySummary Oracle Fusion BI Publisher Custom SQL - Security ConsiderationsContent Hi, When you create a Business Intelligence Publisher data model with physical SQL, you ha…User_2025-02-05-04-43-06-903 128 views 6 comments 3 points Most recent by Carlos Benassi Reporting and Analytics for ERP -
BIP Schedule Data Parameters for the Previous MonthSummary: BIP Schedule Data Parameters for the Previous Month Content (please ensure you mask any confidential information): I am looking to use date parameters on a BIP …KDR 174 views 6 comments 0 points Most recent by Neil Wanags Livingstone Reporting and Analytics for ERP
-
Need an help for SQL query.Hello experts, I need some quick help in for my Bi Report which is for Receivables Module - I have query in which it has three corelated subqueries. I want to use the ou…
-
How to output html stored in database as formattedI have a table column zmm_notes specifically where a column for the note text can be stored as formatted text, so the html tags to format are stored in the database. Wha… -
Unable to select Manage Formats from the Report LayoutI need to be able to format a column on a custom BIP to HTML but in the report layout in edit mode, I am unable to select the Manage Formats. What could be the issue?
-
How to restrict users from using direct base tables in Data ModelWe have to provide certain users with Create Data Model access in BIP, but need to restrict them to usage of only certain tables or certain data in the tables. Do we hav…
-
Restricting Data retrieved by BIP report queryHi, We have requirement to restrict the data returned by BIP query based on Data Access Security setup on ERP Cloud. We find that we have concept of Secured List Views (…AbdulBasith 31 views 3 comments 1 point Most recent by James McBride Reporting and Analytics for ERP
-
How to add a header to the e-text outputSummary: By default the e-text layout output doesn't have column headers. We have a requirement to add the headers as well for the integration file with the third party.…SuniChacko 306 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
BIP internal bank account table?Hi Guys When I search online I get told to use view CE_INTERNAL_BANK_ACCOUNTS_V to lookup field INTERNAL_BANK_ACCOUNT_ID out of table iby_pay_service_requests. However w…