Category 385
Discussion List
-
How to update the timezone in reports?Hi, I have my time zone set at the user preference level. However when I run the seeded Trial Balance Report, the time is wrong on the output (showing UTC): How to corre…OConsHD 102 views 1 comment 0 points Most recent by Angel Jimenez-Support-Oracle Reporting and Analytics for ERP -
How can we migrate BIP scheduled jobs (Definitions) from one env to another env?Hi, We are refreshing multiple lower instances for go-live, and during this process, the BIP schedule jobs are not being migrated from the source to the target instance.…Praveen_Paul_raj 75 views 4 comments 0 points Most recent by Swapnil Kashid Reporting & Analytics for Fusion Service
-
Service Time per Ticket - Report (Classic HR Help Desk)Hi all, We need a Report to calculate the time between the ticket's opening date and closing date and time, considering customer calendar (Considering work hours and exc… -
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 21 views 1 comment 0 points Most recent by Angel Jimenez-Support-Oracle Reporting & Analytics for Fusion Service
-
How can I grant "GL users" access to the seeded "Payables Trial Balance Report"?We have a requirement in which "GL users" can generate the seeded "Payables Trial Balance Report" on their own to expedite their tasks. How can we configure this in Orac…Arsen Guevara-CITCO 73 views 4 comments 0 points Most recent by JohnG Reporting and Analytics for ERP -
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 622 views 1 comment 0 points Most recent by GowriTatikonda Reporting and Analytics for HCM
-
Oracle Fusion OCI Console user login reportSummary: Oracle Fusion OCI Console user login report Content (please ensure you mask any confidential information): We have recently migrated our Oracle Fusion HCM insta…
-
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 -
General Ledger Journal Entry Database InquiryHi Oracle Experts, I have a question regarding the General Ledger Journal Entry report. Could you please clarify if the field JRNL_Effective_Date refers to the journal c…
-
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…Fareeha Altaf 101 views 5 comments 0 points Most recent by Sheela Pai-Oracle Reporting & Analytics for Sales
-
Oracle Fusion BI Publisher - Pivot table - Dynamically derive headerSummary: Hi All, We have a requirement where we have to calculate opening balance of a fund(GL_CODE_COMBINATIONS.SEGMENT6) from GL balances and pivot it to the fund name…Surya Chandaka 43 views 1 comment 0 points Most recent by Anca A-Oracle Reporting and Analytics for ERP
-
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 42 views 4 comments 0 points Most recent by HimanshuSetia123 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 142 views 3 comments 0 points Most recent by Amr Hassan Reporting & Analytics for Fusion Service -
Archive/Unarchive permission to My folders onlySummary: BI Administrator role generally gives archive/Unarchive access to entire catalog. Here the requirement is for few users, we would need archive/Unarchive permiss…Karthik Soundarapandian1 71 views 3 comments 0 points Most recent by Karthik Soundarapandian1 Reporting & Analytics for Fusion Service -
Help on finding out the right PVOs...Hi, I'm trying to pull HCM data through data augmentation (FDI) and I'm struggling a bit. I'm trying to have a report with all the legal employer information (name, tax …Lauriane Massin Whitaker 241 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
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 11 views 1 comment 0 points Most recent by Angel Jimenez-Support-Oracle Supply Chain Planning and Collaboration -
report for tax rates by jurisdictionWe are looking for a report for tax rates by jurisdictionCindy Souvagis 31 views 2 comments 0 points Most recent by Cindy Souvagis Reporting and Analytics for ERP
-
Hello experts, do you have the SQL query to get the list of employees and their HR representativesHello experts, Do you have the SQL query to get the list of employees and their HR representatives? Regards, Hazel
-
How to check if TDE is enabled in my POD oracle fusion cloud?Summary: how to check if TDE is enabled in my POD oracle fusion cloud? Content (please ensure you mask any confidential information): how to check if TDE is enabled in m…Rodrigo Williams 42 views 0 comments 0 points Started by Rodrigo Williams Identity and Access Management
-
Sql query or Table for Manage Content Types in HelpdeskSummary: Hi team, Need a table or SQL quere where the setup "Manage content type" information stored in helpdesk module. Content (please ensure you mask any confidential…
-
What are the tables or SQL query to fetch ESS job name, Report name, Report path detailsHi Team, I have requirement to develop custom SQL query to fetch details like All ESS Job names, Display names, Report names, Report paths etc. I have used tables like E…anusha chunduru 4.2K views 6 comments 1 point Most recent by User_S6U3H Reporting and Analytics for ERP
-
How to purge records from ZX_LINESHow to purge unaccounted Transaction records from ZX_LINES Table. Any one have idea please let me know. Iam trying to purge by using "Purge Tax Transactions" Program.But…Sagar Reddy 21 views 3 comments 0 points Most recent by Rasheed - Fusion Support Engineer-Oracle Tax & Global
-
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 271 views 2 comments 1 point 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
-
Need table name where Service Level Agreements are storedSummary: Hi All, I am trying to find table name where Service Level Agreements are stored. I have a requirement to build a report on the data. If anyone know/ used pleas…
-
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 22 views 3 comments 0 points Most recent by Cătălin Hurjui-Support-Oracle Reporting and Analytics for HCM
-
Can you programmatically extract an audit log for narrative reporting?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Kunal Prasad 21 views 2 comments 0 points Most recent by Kunal Prasad Reporting & Analytics for Fusion Service
-
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 …