Category 385
Discussion List
-
Edit incoming email filter - Add Rule NameSummary: Id like to see the name of the Workflow Rule that rejected the email. Content (please ensure you mask any confidential information): I currently use the incomin…Marissa Gonzales 4 views 0 comments 0 points Started by Marissa Gonzales Reporting & Analytics for Fusion Service -
In which Fusion DB tables SaaS usage details are stored?We are trying to build an custom report similar to SaaS Service Usage Metrics Report for our Fusion instance. The report will need to display region wise/country wise li…Antony Davidraj 4 views 0 comments 0 points Started by Antony Davidraj Reporting & Analytics for Fusion Service -
We are following a white paper to upload the Employee Letter to DORHi, We are following a white paper PER_HCM_Extracts_DocumentRecords_WP where DOR is not uploaded. Can you please help/Suggest. Regards, Shanmukhi
-
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…Ambika Priya Dokku 4 views 0 comments 0 points Started by Ambika Priya Dokku Reporting & Analytics for Fusion Service -
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…Mariyam129 1 view 0 comments 0 points Started by Mariyam129 Reporting & Analytics for Fusion Service
-
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…Daniel Pérez Acevedo 3 views 0 comments 0 points Started by Daniel Pérez Acevedo Reporting & Analytics for Fusion Service
-
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…Oracletechnofunctional 11 views 0 comments 0 points Started by Oracletechnofunctional Reporting & Analytics for Fusion Service
-
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…Palak Jain 1 view 0 comments 0 points Started by Palak Jain Reporting & Analytics for Fusion Service
-
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 …Shanmukhi 21 views 1 comment 0 points Most recent by Shanmukhi Reporting & Analytics for Fusion Service
-
where to find the comments (Transaction Console Page) in backend?Please help me to find the tables for above snapshotSATHISH REDDY 11 views 0 comments 0 points Started by SATHISH REDDY Reporting & Analytics for Fusion Service
-
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…
-
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.Mohammad Borghol 11 views 0 comments 0 points Started by Mohammad Borghol Reporting & Analytics for Fusion Service
-
Need to schedule the ESS Job set in fusion to run on 1st business day of the month.We have a scenario where we need to run the ess job set on 1st business day of each month . is there any way apart from user schedule where we need to manually update th…
-
How to create custom PVO and add it in BICCSummary: How to create custom PVO and add it in BICC Content (required): How to create custom PVO and add it in BICC Version (include the version you are using, if appli…Vivek Gautam 1.5K views 4 comments 1 point Most recent by Bhavani Rikkula Reporting & Analytics for Fusion Service -
View object cannot be found for HCM table PER_POSITION_EXTRA_INFO_FWe were using the oracle mapping document "Rel13_23D_BICC_HCM_Database_Mapping_with_ViewObjects.xlsx". Looking for the corresponding VO for table PER_POSITION_EXTRA_INFO…Ian Cosinas 11 views 0 comments 0 points Started by Ian Cosinas Reporting & Analytics for Fusion Service
-
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 0 comments 0 points Started by Christian Nicole Cristobal Reporting & Analytics for Fusion Service
-
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)…Michal Shaked 1 view 0 comments 0 points Started by Michal Shaked Reporting & Analytics for Fusion Service
-
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…Sateesh Kumar 11 views 0 comments 0 points Started by Sateesh Kumar Reporting & Analytics for Fusion Service
-
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…Aaron Paul 1 view 0 comments 0 points Started by Aaron Paul Reporting & Analytics for Fusion Service
-
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…NicolaosDerr 1 view 0 comments 0 points Started by NicolaosDerr Reporting & Analytics for Fusion Service
-
Open-source fonts to replace licensed Monotype fonts in BIP and OTBI in 24AIn 24A, open-source fonts will replace the Monotype fonts currently available in Oracle Transactional Business Intelligence. You can use the open-source fonts available …Noelle Bartlam-Oracle 41 views 1 comment 0 points Most recent by K Hart13 Reporting & Analytics for Fusion Service
-
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…Krutika Narayankar 11 views 0 comments 0 points Started by Krutika Narayankar Reporting & Analytics for Fusion Service
-
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…Krutika Narayankar 1 view 0 comments 0 points Started by Krutika Narayankar Reporting & Analytics for Fusion Service
-
sql functionsLooking for sql function to use inside BIP report which does the following: We have a table column that stores: -AE,BH,BR,CA,CH,CN,GB,HK,IE,KW,MX,NL,OM,QA,SA,SG,US we wo…Rafatullah BS 11 views 1 comment 0 points Most recent by Rafatullah BS Reporting & Analytics for Fusion Service -
SQL to get employees and their dependents enrolled in a benefit planLooking for "SQL to get employees and their dependents enrolled in a benefit plan" to build BIP Report.Rafatullah BS 21 views 2 comments 0 points Most recent by Rafatullah BS Reporting & Analytics for Fusion Service
-
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 BIPNagendra Chitra-Oracle 1 view 0 comments 0 points Started by Nagendra Chitra-Oracle Reporting & Analytics for Fusion Service
-
what are the seeded Reports/Analytics and infolets in Oracle Help Desk?**This post was created as part of a How to Service Request (SR) Release: 11.13.22.07.0 Summary of the question: What are the seeded Reports/Analytics and infolets and d…Priscila Terazawa - Support-Oracle 61 views 4 comments 0 points Most recent by Rizwan Basha Reporting & Analytics for Fusion Service -
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…