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 & Analytics for Fusion Service
Discussion List
-
BIP Output delivery Details to SAAS and UCM detailsHello All, Could you please help us with details on following points if you have any inputs regarding BI reports delivery: 1. BIP output shown in report history is hoste… -
Watermark in PDF reportsHow do we edit a watermark from a PDF report in Oracle, now it only shows "Draft" but with some conditions (not all of them). Is it done through the query database? Or i… -
Financial Reporting Web Studio Save button not saving changesThroughout Web Studio Workspace. For example, I originally had a text box in a header which contains the "" function on the first line and a "" function on the second. T…
-
Fetch all report catalog objects - GL_FRC_REPORTS_BSummary: Fetch all report catalog objects - GL_FRC_REPORTS_B Content (please ensure you mask any confidential information): We are looking for a way to query all the cus…
-
Refer HR Organization hirarchy on "Expenses - Expense Transactions Real Time"How to get HR Organization Hierarchy details on "Expenses - Expense Transactions Real Time"
-
Display attachment content in Work Order Traveler Extensible reportHi All, We customized Work Order Traveler Extensible report and we have a requirement to retrieve content of the attachments in the report output. We have tried accessin… -
Cannot find table in Oracle BIP that stores the Organization (Department) of usersHi all, In order to complete a movement Request report, I am required to include the Department of the user that created the movement request. I have not yet been able t…
-
labels and reportsSummary: look for labels in reporting Content (please ensure you mask any confidential information): Hello, is it possible to visualize reports and analytics about label…
-
How to use phone numbers (Work phone, Mobile phone and home phone) in OTBIHi Oracle Community, The customer needs to report the Contact (Person) phone numbers (Work phone, Mobile phone and home phone) in OTBI, but these atributtes are not avai…
-
Enable Data Stores in BICC OfferingsWe observed that there are some oracle delivered data Stores which are not enabled for extraction e.g Customer for given offering like Financials or Customer Data manage…
-
Norwegian number format displaying as text in BI publisher excel outputHi, I have a report which displays Amount, Rate and QTY columns (In Norwegian number format i.e., Decimal separator as ',' and thousands separator as '.') as part of the…
-
where to find the comments (Transaction Console Page) in backend?Please help me to find the tables for above snapshot
-
GL Drill Down to Work OrderNeed a query to drill down from GL to Work Order. We need details of PO, Work Order Number, Quantity, Amount when starting from Journals. We are using Source = 'Cost Acc…
-
Calling an external image in bursting.While calling an external image in bip Busting its throws an error on the image. Error: The linked image cannot be displayed. The file might have been remove/renamed or …
-
Deep Link/table for each task notification?Hi all, I need an SQL query or a deep link to get the link for the tasks in the BPM worklist like this: thanks.
-
Payables UI Creation Date is different from the QueryHi everyone, Does anyone know why is the Creation Date on UI (Payables) shows different from the Query? Here is the sample. And here's the query. SELECT INVOICE_NUM , CR…Christian Nicole Cristobal 11 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle
-
How to define a custom field which its LOV is dependent on another field in the formSummary: Custom field added to form should hold LOV based on a query dependent on another field in the form Content (please ensure you mask any confidential information)… -
Dynamic LOGO in BIP report Oracle fusion is not workingWe are trying to achieve dynamic logo in BIP report according to BU. We have around 25 BU and each of them has its own logo. Approaches tried:- 1) Using subtemplate Whil…
-
Is there way we can get the "Import Asset and Assignments Process" import errors detailswhen we run the "Import Asset and Assignments Process" to import the Capital assets the load interface file import success and errored at import job and we are trying to…
-
Can I dynamically mention the columns in PIVOT clause in a SQL query?This query is to be used in a BIP report. For Example: SELECT MONTH, AMOUNT, COLUMN_NAME FROM TABLE PIVOT(SUM(AMOUNT) FORM COLUMN_NAME IN ('COL_NAME1','COL_NAME2','COL_N…
-
How to map interfaces and database tablesSummary: How can I find which database tables (in BIP) are used in Fusion Web Interface Content (please ensure you mask any confidential information): Version (include t…
-
OTBI Report - Effective Start Date UnionI am creating an OTBI report to extract Union member, Union of the employees and the date from which the employee joined the union. I am using the following subject area…
-
How to print an embedded dashboard pageSummary: When opening a dashboard through directly in the catalog, there is a gear in the top right that gives the ability to print out a dashboard page. When a dashboar…
-
EBS to Oracle cloud mapping for below mentioned columns.Summary: Could you please help us to find the correct EBS to Oracle cloud mapping for below mentioned columns. Content (please ensure you mask any confidential informati…
-
EBS to Oracle cloud mapping for below mentioned columns.Summary: Could you please help us to find the correct EBS to Oracle cloud mapping for below mentioned columns. Content (please ensure you mask any confidential informati…
-
Please let us know, can we use excel template with xlsx extension for getting outputs in BIPPlease let us know, can we use excel template with xlsx extension for getting outputs in BIP
-
BI Publisher Report Issue -"Failed to load servlet/dmvalidate?_sTkn=dea4afb718b89c1d4df."Dear experts, In some of the Data Model (Fusion SaaS) , I am below error when I open the datamodel. "Failed to load servlet/dmvalidate?_sTkn=dea4afb718b89c1d4df." Also I… -
DFF values not appearing in OTBIHow do you get a DFF LOV results values to appear in OTBI reports and analytics? Seems as though I am able to return every value and DFF results value field into the rep…
-
recruiting events analyticsHello, I would like to have some analytics or dashboards for metrics regarding recruiting events and campaigns in Recruiting. Is there any predefined dashboard, or a way…
-
Report Analysis adding multiple subject areas (more than 2) errorHi there, we have a scenario where we have added a new subject area to an existing report that is already set up with the Dimensionality flag, so one would assume adding…