Analytics
Discussion List
-
Foreign key Column & Foreign Table for GL_JE_ACTION_LOG table using HISTORY_IDWe are not able to find the join for GL_JE_ACTION_LOG using HISTORY_ID field. I can able to see in Oracle Docs that HISTORY_ID is the Unique Identifier assigned to user …SumeetVerma 15 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany -
Oracle BIP Report Job ends in error: ORA-56733: logical I/O limit exceededWe have a customized report that when is scheduled ends in error: ORA-56733: logical I/O limit exceeded. What's weird is that when we run the report via the catalog with…User_APIIU 22 views 3 comments 0 points Most recent by Angel Jimenez-Support-Oracle Reporting & Analytics for Fusion Service
-
Is it possible in one report Bursting and ad hoc running possibleIs it possible to create one report where Bursting setup will ensure that the report is distributed to the correct recipients as specified, whenever it is run on an ad h…Sangeetarani Padhi 15 views 1 comment 0 points Most recent by Angel Jimenez-Support-Oracle Reporting & Analytics for Fusion Service
-
RTF Template output alignment issue with Outlook appHi Team, We have recently created a welcome letter using an RTF template, which includes a logo at the top followed by the details in the email body. When we check the o…Rakesh Bahadur Thapa 22 views 2 comments 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
-
What is the impact of not Assign Financial Categories to the Natural AccountsOne of the prerequisites for implenting a reporting tool such as OTBI and FDI , is to assign financail categories to the natural accounts. What is the impact on not doin…
-
Can we display the count in the graph while creating dashboard?Hi Team, I was trying to create a dashboard so what happening is if u out the cursor in the graph the counts are coming. So is it possible to display the counts in the t…Abhisek Kanungo 11 views 0 comments 0 points Started by Abhisek Kanungo Reporting and Analytics for HCM
-
We need to update the #average headcount, #leavers, period start and period end headcount with OTBIWe need to Modify headcount columns in an Annual Turnover dashboard page. We need to update/review the #average headcount, #leavers, period start headcount, and period e…
-
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 2.4K views 7 comments 1 point Most recent by Surendra Majeti Reporting & Analytics for Fusion Service -
sql to fetch organizations or departments based on business unitHi Team, We are trying to write sql to fetch all organization or departments for a business unit. But we dont know how to link organizations to business unit. To tell yo…RamNarayan-Oracle 31 views 1 comment 0 points Most recent by IpsitaGhosh-Oracle Human Capital Management
-
We need a query to retrieve the AR remittance batch approver's name and approval date.Hi All, We need to retrieve the batch approver name and approval date for a remittance batch. Is there an existing table, column, or query that can provide these details…
-
BIP RTF template need Freestyle Script fontHi Everyone, I have a requirement to create an PDF document with employee name like signature. (who signed electronically) We want to use different font which will look …Naveen Jayaraman 15 views 1 comment 0 points Most recent by Angel Jimenez-Support-Oracle Reporting & Analytics for Fusion Service
-
sql query to get the Legislative Info and Associated Profiles associated with job in oracle fusionI need to fetch job code, job name ,Overtime Status under Legislative Info and details of Associated Profiles associated with job in BIP reportAnjali_Kumari4121 87 views 1 comment 0 points Most recent by GowriTatikonda Reporting and Analytics for HCM
-
Customize Career Development Report not workingGreetings team! The customize feature in BI Publisher for the 'Career Development Report', that is available in the Oracle HCM Cloud application in Person Spotlight > Ca… -
hcm - document of records - flex fields and attachmenthcm - document of records - I NEED TO GET THIS SAME FIELDS TO BE AVAILABLE IN DOCUMENT OF RECORDS APPROVAERS AND IN EMAIL AS ATTACHMENT -
Creating a Business Unit-Specific Lead and Opportunity Dashboard in Oracle FusionHi Community, I'm working on creating a dashboard in Oracle Fusion CX Sales to provide insights into lead and opportunity performance for specific business units. My goa…User_5FJ4I 78 views 5 comments 0 points Most recent by Sheela Pai-Oracle Reporting & Analytics for Sales
-
How to display the content of the PO PDF document in the Email body of the Approval NotificationApart from getting the attachment as a PDF, need to display a few columns in the email body as well
-
Is it possible to create a security context in oracle cloud?I want to create that combo in oracle cloud: define a role with a security context that I create and security context valueACNROMA2023 45 views 4 comments 0 points Most recent by HimanshuSetia123 Reporting & Analytics for Fusion Service
-
BI Publisher report to join MSC_CUSTOMER_SITES to MSC_CALENDAR_ASSIGNMENTS and MSC_REGIONSI'm trying to write a BI Publisher report to join MSC_CUSTOMER_SITES to MSC_CALENDAR_ASSIGNMENTS and MSC_REGIONS and how to best join these planning tables to the custom…Sera Hager 12 views 1 comment 0 points Most recent by Angel Jimenez-Support-Oracle Supply Chain Planning and Collaboration -
how to link Absences table with work force scheduling table in oracle fusionI am looking for a query which list employee work schedule including leaves. Any suggestion on how to join absences module with work force module tables
-
Invoice summary details table for APWhich table stores Invoice summary details in Fusion cloud. I am looking for the column which stores Accounting informationKavya Gururaj 1 view 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
Fusion Data Intelligence - System settingsHello, Trying to do some configuration for the Oracle Data Intelligence, and when I'm logged in and go to the Console and System Settings. It says I don't have permissio…BenSayers 52 views 2 comments 0 points Most recent by Amanda Hope Fusion Applications Administration -
Required SQL query to get Customer Opt in featureSummary: Required SQL query to get Customer Opt in feature Content (please ensure you mask any confidential information): Hi Team, We need the SQL query to get Oracle fu…Opkey PA 97 views 2 comments 0 points Most recent by Biju Radhakrishnan-Oracle Supply Chain Orchestration
-
Oracle Delivered ReportHi Team, I noticed that there's a delivered analysis for Leaver details categorized by Grade, Age, and Gender as separate analyses. However, is there a standard delivere…Oviya 11 views 1 comment 0 points Most recent by Cătălin Hurjui-Support-Oracle Reporting and Analytics for HCM
-
Which PVO contains the organization unit legal info ?Hi, Do you know which PVO contains all the legal info of the organization unit in hcm please ? I'm trying to augment the data for FDI and I'm not able to find the right …Lauriane Massin Whitaker 16 views 3 comments 0 points Most recent by Cătălin Hurjui-Support-Oracle Reporting and Analytics for HCM
-
Export the list of configured time attributes and display value from Time entry layout componentsIs there a way to export the list of configured time attributes and display value from Time entry layout components? We are comparing 2 different layouts and it will be …
-
requires work schedule table which has effective from date as columnHi Team, We want to use work schedule effective start date to differentiate which day will be week off and working day of the employee in the report. Please suggest the …Ankita Choudheri 13 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
jl_br_ar_collection_docs is empty in oracle cloudThe Table jl_br_ar_collection_docs is empty in oracle cloud. Does anyone know how this table gets populated? This table is being used for Brazil Boleto report which can …
-
CRC 32 - Hash in Oracle fusionHello , We have one requirement where it has been asked to convert the 16 digits column value ( The site ID from Account Payable) into a CRC 32 HASH value. I did not fin…VarshaK 41 views 1 comment 0 points Most recent by Angel Jimenez-Support-Oracle Reporting & Analytics for Fusion Service
-
Assistance Needed for Custom Query Mapping in ORC to CORE HRHi Team, I hope this message finds you well. I wanted to reach out regarding a custom query I created for the offer creation page in ORC. While I’ve made some progress, …Girish Kushibi 22 views 2 comments 2 points Most recent by Girish Kushibi Recruiting, Opportunity Marketplace