To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting and Analytics for ERP
Discussion List
-
reports dont appear when emailing a dashboardSummary: We have a dashboard that includes multiple analysis and one report (created from a data model). This dashboard is scheduled to be deliverd by email (not attachm… -
What subject areas and query should I use to get AR Aging report based on BICC Extractts?Summary: I know the AR Aging report is complex with joins to XLA tables, hz tables, ar_payment_schedules, and other ra/ar tables. We are trying to generate the AR Aging …
-
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… -
How do I add the FDI link onto our oracle cloud homepageI am looking for the steps to add a link to FDI from our Oracle Cloud Homepage as shown in the screenshot below:
-
Custom Job Set not showing for one userSummary: We have created job sets in a lower environment and the users that need to access it are able to with the exception of our Director of Projects. She is still no…
-
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 …
-
Generating Sheet name dynamically in excel from xml tag in rtf word with PublisherSummary: in publisher while creating an rtf in word for a multi tab excel is it possible to generate sheet name dynamically from source After loading xml, should be able…
-
How to extract attachments for Journals and Payables Invoices for a given period of timeOur company is being sold and we need an extract of journal and payables invoice attachments for a given period of time for audit purposes. We would like the attachment …
-
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 Reset the BICC Extract To last run Date via APISummary: Hi Team, we have requirement to reset to the BICC extract to last run date based on any failures. Can some one please let me know if this is possible via any AP…
-
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…
-
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)…
-
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… -
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…
-
Unable to access Usage Metrics Drill-Through ReportSummary: Dear Concern, We have purchased cloud services through a resell/partner model (i.e. partner users) and now when searching found that some users are getting an e…
-
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…
-
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…
-
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 …
-
Beginning and Ending balance in Subject Area "Fixed Assets - Asset Balances Real Time" not showing cContent Hi all I'm trying to build a Fixed assets balance, based on the Subject Area "Fixed Assets - Asset Balances Real Time". For some reason it shows the wrong deprec… -
how to join pjf_projects_all_b and PAY_COST_ALLOCATION_KEYFLEX in fusionIn EBS we used the below query and later it needs to be linked with AP Invoices details…. SELECT hou.name, pcak.segment2 cost_center, from pjf_projects_all_b ppa, hr_all…
-
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…
-
IBY_AMOUNT_IN_WORDS.GET_AMOUNT_IN_WORDS roundingSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
sql to use in custom BIP report to restrict data dynamically based on the users data security&accessWe are trying to build an custom BIP report/sql script to restrict data dynamically based on the users roles and their data access in fusion (for example, to query AP in…
-
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?
-
Email Both PDF and XML Format with Bursting QueryI have a custom packing slip report that is triggered off a customized scheduled process and the bursting query in the data model of my report handles the email output. …
-
Customizing the Accrual Reconciliation report to a more usable excel sheetSummary: Business is using the Accrual reconciliation report to reconcile the accrual account with the PO details. Currently business has huge data in this report for ce…
-
Using a parameter & variable to represent POD name for deeplinksSummary: It is great we can use deeplinks in OTBI but it would be helpful if a variable could be used to populate the current pod name. Otherwise we need to hard code it…