Category 385
Discussion List
-
Additional Information for Leave PlansDear All, Unable to find table/column value of "Additional Information" field regards absence accrual details Kindly let us know/share the table or column details which …Uma Jegadeesan 11 views 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service -
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 41 views 1 comment 0 points Most recent by mai fukumura-support-Oracle Reporting & Analytics for B2C Service -
How do I source: profile item id for spreadsheet loaderI'm trying to build a spreadsheet loader to load license and certifications specifically Responsible Manager which sits in Responsible Person Region in Skills and Qualif…
-
How to print space between currency symbol and priceHi, I have added the below formula in the rtf template to display the price along with the price currency code. Formula: Output $50 UNIT_PRICE & INVOICE_CURRENCY_CODE d…AVN 11 views 1 comment 0 points Most recent by mai fukumura-support-Oracle Reporting & Analytics for Fusion Service
-
How to integrate the analytics between Oracle Digital Assistant's skill and Oracle FusionSummary: So we have beautiful data in Oracle Digital Assistant and Oracle Fusion Service. We want to put them in the same dashboard. Content (please ensure you mask any …Calin Pavel 36 views 2 comments 0 points Most recent by Calin Pavel Reporting & Analytics for Fusion Service -
Bursting report in procedure call data setSummary: Content (please ensure you mask any confidential information): I have a requirement to insert/update the lookup code and print and deliver the PDF through email…Mayur_Gidwani 21 views 1 comment 0 points Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Fusion Service -
How to add new table extract in BICCSummary: Hi Experts, We noticed some tables are missing in BICC console and below table is an example. May i know if there is a way to extract the missing tables using B…Sudheer YN 41 views 7 comments 1 point Most recent by Sudheer YN Reporting & Analytics for Fusion Service
-
Can we hold the Oracle SFTP for the scheduled BI report jobsWe have few integrations directly using Oracle SFTP to send the file to various vendors. Wanted to check is there a way to hold the Oracle SFTP delivery alone for the sc…Karthik Soundarapandian1 31 views 5 comments 0 points Most recent by Sandeep19rm Reporting & Analytics for Fusion Service
-
What table holds partial time entries from the Web Clock?In summary, if a web clock entry is incomplete AND it has no time type attached, then where is that stored on the backend tables. You're welcome to read more for details…ElijahHopkin 21 views 1 comment 0 points Most recent by ASHOKKUMARFUSION-Oracle Workforce Management
-
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 11 views 1 comment 0 points Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Fusion Service
-
E-stamp & signature for Standard Reportshello, I need a solution to put E-stamp and Signature on standard and customized reports , for example Payslip reportmshehab 11 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle 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 101 views 2 comments 1 point Most recent by Praveen Kumar Akkala-Oracle 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…Sharmava 81 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle 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 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle 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…Greta S 11 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle 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…Tina T 173 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service
-
Looking for sql to find day/timestamp of employee's policy acknowledgmentI am looking for the table(s) to find the signature day/timestamp for a policy that was 'signed' during an onboarding journey. I started in PER_ALLOCATED_TASKS - is that…Wendy G 31 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service
-
Organization name need to be replaced with department name.Summary: Hi All, Can some one help me on changing the Organization name instead of Department name in below query Content (required): In the query its is fetching old or…RamkumarKadhiravan 31 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service -
Barchart in EPM Reports cannot be displayed properlyWe have a FR Report "Barchart_Report" which contains a Barchart and a Grid. This FR report can be generated with data in html & pdf. After migrate this FR Report to Repo…Kenneth Kwok 11 views 2 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service
-
Checklist LetterWe have configured a letter through checklist task and same will be store in DOR after acknowledging, employee has to generate the letter then acknowledge it then the le…Satyam Roy 21 views 1 comment 1 point Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service -
Table containing Candidate personal informationHello! I am looking for the table which contains the candidate personal information data- Gender, Ethnicity, Veteran Status and Disability. We have a requirement to crea…Maitra 14 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service
-
SQL to get both po with requisition and without requisition in a single queryHi All , I need a query to get SQL to get both PO with requisition and without requisition in a single query and the columns I am trying to fetch are below mentioned que…AKV27 803 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service
-
BI Report for Receipt Accounting BU, Commodit Code as input parameter an get PR,PO,Receipt detailsHi Experts, Can someone please help in below requirement. I am looking for sample query and relevant table information where I need to pass date range,BU,LE and Commodit…Revathi I 1 view 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service
-
Query to get the element entries and the pay period datesHello, Requesting your help to get the sql query to fecth element entry details and the associated pay period start dates and end dates. The elements are recurring eleme…Regunanthan 1.2K views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service
-
SQL Reporting TransactionsHi I need to check a Approved documents of records transactions. But I couldnt Get The Transaction Id which matches with my Document_Code from Hrc_Txn_Header and Hrc_Txn…Kaan Can Calkan 121 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service -
How to convert primary ledger currency balances to USD currency balance in Oracle FRS reports?Need to get the primary ledger currency balances to USD currency balance, based on 'Period Average Rate.'Fredrick Ignatius 21 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service
-
Report to identify terminated employees in BPM workflowSummary: Content (please ensure you mask any confidential information): Hi Team, We are looking for two reports: 1.) Report to identify terminated employees in Oracle wo…Nidhi Chhajed 11 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle 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 11 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle 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…Saadiq 21 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle 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 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service