Reports
Discussion List
-
How to pass custom BI Publisher parameters (p_start_date, p_end_date) from HCM Extract than and HDLSummary: Hi everyone, We have a requirement to run a parameterized BI Publisher (BIP) report from an HCM Extract and then auto‑load the generated HDL file. The report us… -
Query to fetch Transaction console entries along with multiple Approver detailsSummary: Need a Query to fetch Transaction console entries along with multiple Approver details Content (please ensure you mask any confidential information): Version (i…NagasaiM135 25 views 6 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP -
Data Not visible in Financial reports but able to see data in smartview for the same POV in FCCS appThis basically happened when i did a metadata load and refresh database then i suddenly loose data in Financial Report but can see the data in Smartview with the same PO…Shahnawaz 41 views 8 comments 0 points Most recent by Ija Vidaurri Financial Consolidation and Close -
How to split EPM Financial Reporting (Reporting) AliaseName using Delimiter featureSummary: Hi, we have specific requirement where MemberAlias Name to be split based on Delimiter in EPM Financial Reports (Reporting). Ex: PRODUCT Alias Name 1233444 1233… -
Security for OTBI Subject Area "Projects - Labor Distribution Costs Analysis Real Time"Summary: We need to expose OTBI queries written against the subject area "Projects - Labor Distribution Costs Analysis Real Time" to a larger population. Right now, it i…Jonathan Ruth 21 views 2 comments 0 points Most recent by Jonathan Ruth Reporting and Analytics for ERP -
Does BIP reports support docuSign?Summary: Content (please ensure you mask any confidential information): In this discussion it seems docuSign is not supported for BIP reports. Can someone from Oracle co…Stefano_Mazzocca 1 view 0 comments 0 points Started by Stefano_Mazzocca Reporting and Analytics for HCM -
FCCS Report round off issuesI am facing round off issues with FCCS MR reports. I have given the samples values in the attachment. Please check. The decimal places is not enabled in the report and u…AravindhK02 11 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Lease amortization to be posted to different GL account from Lease RevenueOrganization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Description (Required): Currently Lea… -
Is there log available in FCCS to identify whether any change was done to audit trail configuration?Summary: Is there log available in the FCCS application to identify whether any changes were done to the audit trail configuration, please advise. Content (please ensure…KC-2109 11 views 6 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
How to search for future approvers in an approval process in Oracle HCM Cloud by query?Good morning! How are you? I have a question, exists any VIEW objects or table (Im creating a bi publisher) that I can use to get the information of all the approvers of… -
ICP Matching Report CustomizationHi everyone. Is there any way to modify the ICP reports in order to create new columns, for example to include comments or notes, as well as additional dimensions? The i…Mayela Vega Duque 12 views 1 comment 0 points Most recent by Anand Thota Financial Consolidation and Close -
Need to get referrer Job Title and Referrer assignment status in OTBISummary: We are using "Recruiting - Recruiting Real Time" subject area to get Requistion number, requistion title, referrer person number, referrer person name, worker p…Rama123-Oracle 11 views 3 comments 0 points Most recent by Vasanthakumar Ravi Reporting and Analytics for HCM -
While loading worker dat file, getting error the error for PersonLegislativeDataSummary: While loading the worker dat file getting the below error for PersonLegislativeData component You can't update this record because the SourceSystemId {SRC_SYSTE…Gali Sujana 133 views 4 comments 0 points Most recent by Vasanthakumar Ravi Reporting and Analytics for HCM -
Date changes by1 day while formattingSummary: Hi, I am using Oracle template builder for one of my reports which has date column, when I apply date formatting date changes by one day (example: 4712-12-31 ch…Eshwar Kappala 1 view 1 comment 0 points Most recent by Vasanthakumar Ravi Reporting and Analytics for HCM -
Anytime Feedback Report template - need helpSummary: Need help on this: When I use the Subject Are: Work Profiles - Feedback Notes by Recipient Real Time, the report is fetching all data from feedback and meeting … -
Report on Anytime FeedbackContent Hi All, Is there a delivered report for anytime feedback that we can leverage? If not, has anyone built one and how? Please share any information you might have.…PriyaPenugonda-SC 102 views 2 comments 0 points Most recent by Marilyn O Reporting and Analytics for HCM -
Sending of analysis to managers via agentsSummary Sending of analysis to managers via agentsContent Hi - We have set up a number of Analysis which are currently being sent to different business units / locations…Roy Paolo Paunlagui 76 views 10 comments 0 points Most recent by Vivek Balchandani Reporting and Analytics for HCM -
How to get Branding Image URL for Course created in Oracle Fusion HCMHello Everyone, We are developing a custom report to list courses, and one of the requirements is to display or extract the URL of the uploaded branding image for each c…Sammeta Srividya 2 views 3 comments 0 points Most recent by ShahzaibShaukat Reporting and Analytics for ERP -
Can we customize the error message Access Denied for user to path <Path Name>Summary: We are calling one OTBI report from another using the column action. All users do not have access to all reports. When an employee clicks on a report they lack … -
FCCS - EPMAutomate downloadFile IssueI exported the MR report to the Library path using BusrstingDefinition and am trying to download that exported file to a local directory in FCCS application using EPM Au…AravindhK02 31 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
OTBI report is generating single row output when language preference is changedSummary: OTBI report is generating single row output when language preference is changed and when language preference is set to English, then output looks good and otbi … -
OTBI – Workforce Profiles: Person Profile Real Time pulling deleted competenciesSummary: I have a reporting requirement to identify the competencies workers have entered on their Person Profile, including workers who have not entered any competencie… -
How can I pull all reports and their permissions available /shared folder/custom/ pathSummary: How can I pull all the reports available in "/Shared folder/Custom/" path with their permissions through backend(sql) or any other alternate, with environment h… -
Need help with Cost Accounting Distributions CodeSummary: Hy Experts. I am developing a Purchase Register Report where I have to fetch a column named Inventory Charge Account in which this value of Inventory Valuation … -
missing national identifierSummary: Technical user cannot extract National Identifier (Codice Fiscale) from PER_NATIONAL_IDENTIFIERS despite ORA_FND_INTEGRATION_SPECIALIST_JOB + custom role duties…Claudio De Castiglioni 12 views 0 comments 0 points Started by Claudio De Castiglioni Reporting and Analytics for HCM -
How to add multiple filters in HCM Extract Filter CriteriaSummary: We want to add another filter under HCM Extract Data Group Filter Criteria to filter out terminated employees who has been rehired later from our result set. Co…GauravGupta39 622 views 5 comments 0 points Most recent by Viswanadh Reporting and Analytics for HCM -
Regarding - Alerts Failure during Bulk LoadSummary: We have implemented multiple custom BI Publisher–based alerts that are triggered on specific business scenarios and scoped to particular Business Units. During … -
ORA-01427: single-row subquery returns more than one row ERRORSummary: Have a Payroll Config workbook and returning error. We can't seem to identify the issue. it exists in one of the 3 attached data sets. https://us.v-cdn.net/6034…