Category 385
Discussion List
-
Request SQL to Extract All Agent Configuration DetailsHi Team, We would like assistance in building a SQL query that retrieves complete Agent configuration details from the backend tables in Oracle Fusion. Currently, we can…Gulab_Ansari 37 views 1 comment 0 points Most recent by Angel Jimenez-Support-Oracle Reporting & Analytics for Fusion Service -
Unable to add security permissions for HCM seeded report folderWe need to give customized access to seeded HCM report folders in the Reports and Analytics page but unable to edit security permissions for the same. We have copied the… -
Issue Using Two Subject Areas in a Single OTBI Analysis to Bring Budget and End Of The Day Balance.We are trying to build an OTBI analysis that contains Ending balances and End Of The Balance(EOD) related transactions within a period. To achieve this, we are using two…Sri Sai Kiran Tekumudi 22 views 0 comments 0 points Started by Sri Sai Kiran Tekumudi Reporting and Analytics for ERP
-
Dynamic Deep Link URL in BI Publisher Report not workingSummary: I have a RTF template that shows details of AR Invoices. I have inserted a link on Invoice Number to take the user to the transaction in the application using D… -
We have a requirement to fetch the Pending change order amount for a particular projectWe are fetching the change order amount from 'Procurement- Pending change Orders Real Time' subject area but we are not getting the exact amount changed column. Kindly l…
-
Trouble Querying For PO Delegation DetailsI am trying to query for delegation details of a PO. Currently only able to query for the approver name for each PO, but cant seem to join delegations table to properly …
-
ESS JOB SHWOING DIFFRENT OUTPUTHi Experts! Greetings! Recently I Came across an issue in ESS JOB FOR BIP REPORT. When I run the ESS JOB then in the attachment (pdf) one part of the report is missing ,…Mainur-Oracle 54 views 2 comments 0 points Most recent by Crescentia David Reporting & Analytics for Fusion Service
-
Where to Find Extract Data Stores Documentation for HCM related PVO'sSummary: Hello, We are unable to find the documentation for the Extract Data Stores for HCM . The same is available for Financials, Procurement and SCM. Can you please a…Amritha2184-Oracle 83 views 5 comments 1 point Most recent by Todd Hensley Reporting and Analytics for HCM
-
Unable to see the DFF attribute which are based on Table type value set in the OTBI subject areaHi All, We have created a few custom DFF attributes under Manage Customer Account Descriptive Flexfields. Few are based on independent value sets, and few use table-type…Gurujothi D 187 views 10 comments 0 points Most recent by Malleswara_Rao_P Reporting and Analytics for ERP
-
How to schedule an OTBI report using agent with effective date prompt?I have OTBI analysis where I have added 'Effective date' prompt. I want to schedule this analysis via agent. However, wants to select date in prompt under 'condition' se…
-
Customization of Standard Trial Balance Reportwe have a requirement to create custom trial balance report using customize option from the standard Trial Balance report. The same time we want to keep both the reports…
-
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 16 views 4 comments 0 points Most recent by Salu Prabhakaran Payables, Payments & Cash Management
-
Payables to General Ledger reconciliation report runs by business unit not legal entity instead?The Payables to General Ledger reconciliation report runs by business unit. Is there any possibility to run it by legal entity instead? There was a requirement to reconc…Pandeyujjwal007 12 views 1 comment 0 points Most recent by AnamariaRoman-Oracle Payables, Payments & Cash Management
-
Timecard not populating to HXT_TM_MTRX table .When we are submitting Time card through Redwood page one of the attribute value of timecard not populating to HXT_TM_MTRX table . Still, we are getting data once creati…Mazumder Sourav-Oracle 101 views 4 comments 1 point Most recent by David Boudreau Workforce Management
-
How to display date in the format (like April 1st 2025) using RTF tags.The requirement is to display the date like April 1st, 2025 in the RTF Template using RTF Tags.Nalsoft Pvt Ltd 33 views 3 comments 0 points Most recent by Hari Haran Reporting & Analytics for Fusion Service
-
While selecting parameters for custom ess job I am getting error.Hi Team, One of our client wanted to make a parameter mandatory while submitting Create Electronic Payment files ess job, which is seeded ESS job. We have duplicated the…Syamakalla_Venugopal 66 views 5 comments 0 points Most recent by Sudheer P Payables, Payments & Cash Management
-
Difference between Oracle Delivered OTBI Report-Budgets Wrksheet & Budgets Wrksheet Worksheet MgnrWhat is the difference between these two out of the box OTBI reports? Budgets Worksheet and Budgets Worksheet for Worksheet Manager Path: /Human Capital Management/Compe…MeghnaDe 11 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How to disable Approve Reject from workflow bell icon notification?Proposed Email template & resignation approval process to People Leader: 1. We are requesting to remove the ‘Approve or Reject’ button from the current resignation email…Nagendra Chitra-Oracle 948 views 22 comments 0 points Most recent by Rabia Hasan Human Capital Management
-
Extract journal with debit and credit in the same lineSummary:Extract journal with debit and credit in the same line Content (please ensure you mask any confidential information): The client requested the extraction of acco…User_Q4SYX 6 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
I am trying to populate latest date record to be printed for BPA from PO tables in a custom BIPPer the business requirement, we need to print COO from BPA attached to the shipment, if the shipment lines having country of origin code is NULL, and since there maybe …Shahid Qureshi 01 1 view 0 comments 0 points Started by Shahid Qureshi 01 BI Publisher Learning Center
-
Getting the the error when executing the ess job ?####[2023-10-26T09:15:36.294+00:00] [INFO] dummy file is deleted ================ BIPJobExecutable Execution Started ============ OutputFile : /u01/APPLTOP/instance/ess/…ak1707 1.1K views 6 comments 0 points Most recent by Mariangela Semeraro BI Publisher Learning Center
-
How do we track / audit of the PVO customization in BICC?How do we track / audit of the PVO customization in BICC? We have multiple teams working on creating Jobs in BICC after doing some PVO customization. It is overriding th…
-
withdraw issuewithdraw issue
-
the end date of assignment is 4712for the previous assignmentHi, Currently just Working on one requirement where i encountered a scenario is(Using Per_all_assignments_m) The person has four Assignments Active employee where the en…Kande Likhitha 3 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
The US Periodic Tax Filing ext- why New version does not work; Old version renamed to Obsolete work?Change title to The US Periodic Tax Filing ADP Quarterly Extract - New version does not work; Old version renamed to "Obsolete. This is a follow-up email to our conversa…Pamela Price-Oracle 32 views 3 comments 0 points Most recent by Faithe Chu-Oracle Payroll and Global Payroll Interface (GPI) -
Roles: Missing Report and Analytics in Home > Menu after Role ChangesSummary: Hi everyone, Can anyone clarify what exact privileges are required to display the Report and Analytics function under Home > Menu? I’ve created a new role by re…Yahya Khan 53 views 2 comments 0 points Most recent by Yahya Khan Reporting & Analytics for Fusion Service -
Roles/access required to fetch the deletion group datawe are using the below query to fetch the deletion group detailsSELECT edg.DELETE_GROUP_NAME, esi.ITEM_NUMBER, iop.ORGANIZATION_codeFROM EGP_DELETE_GROUPS edg, EGP_DELET…Vagicherla Harish 3 views 1 comment 0 points Most recent by Aditi Srivastav-Oracle Inventory Management
-
audit reportSummary: Requesting an audit report, which must contain the information listed in the attached images. It must be filtered by report name and the date the scheduled repo…ALFONSO JIMENEZ-Oracle 12 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service
-
MICR line zeros showing too smallHi, We have created a cheque rtf template and to display the MICR line we have used MICRE13B font as per the bank suggested font and font size is 13. However in the MICR…Krishna Kishore 29 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service
-
How To Remove Data Augmentation Column From Subject AreaSetup data augmentation to bring additional attributes to the subject area. Now I've deleted that data augmentation table from data augmentation screen, But still I can …Raghu_Nandan 11 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service