Reports
Discussion List
-
Primary key PVO legal entity / legal entity registration numberHi, Can I join these 2 tables using the 2 primary keys ? Will my legal entities match the registration number in a report ? Regards, LaurianeLauriane Massin Whitaker 11 views 2 comments 0 points Most recent by Lauriane Massin Whitaker Reporting and Analytics for HCM -
Extract Delivery Options - Warning after the 24D update.Hi, After the 24D update, a warning popped up: "Warning: You need to configure the same values for the Print Header Record, Delimiter, and Print Default Attributes field…
-
EDI Transactions Each Day, Total for AP Checks and Total Funding Required for Paymode ReportTrying to Create a Report Current Reporting Tools: They currently don’t pull reports from the HOST system but use IBM Document Direct linked to HOST activities. Identify…
-
Getting correct calc_breakdown_id from pay_action_contextsTeam, We have developed one HCM Extract and having balancevalue field. This field gets value from Rule (Fast Formula). We have written the fast formula and calling one v…Manoharan 110 views 0 comments 0 points Started by Manoharan Payroll and Global Payroll Interface (GPI)
-
Borrowed and Lent ReportingSummary: I have a customer that has migrated from EBS, in EBS they used a process called EBS : AUD_ Cross Charge Audit Report to report on borrowed and lent charges. Doe…Maria Smith- de Novo Solutions 1 view 1 comment 0 points Most recent by Cristian Bilibou-Oracle Project Management
-
How to adjust the alignment of the bar graph for charts function in RTF Template of BIPSummary: Hi Team, The goal is to display a bar graph in RTF Template with question vs ratings. How to adjust the alignment of the bar graph for charts function in RTF Te…Harini Sairam 11 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
user email ID associated with the user name listed in the licenses usage reportsSummary: Hi, Anyone can help me to get the table and column name for the below screenshot im attaching. actually im working on active user role report, i need this colum…Supraja Sunnapu 11 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
How to get full length sentence of a label in bar graph for charts function in RTF Template of BIPSummary: We do have feedback questions and ratings against each question. The goal is to display a bar graph in RTF Template with question vs ratings. How to get full le…Harini Sairam 11 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Lease Detail Report & Leases Schedule IssuesIssue: The back-end table data is available until the Leases are in the draft Stage. The stage data is deleted once the leases are booked (and finalized). So the Future …
-
How to SUM G_1, G_2 and G_3 in DATA_DS summary record for ETEXT template?Summary: we have 3 Records as G_1, G_2 and G_3 and need to show the total number of records in each of them have to be sum and display in DATA_DS in E-text fixed length …Vinay Prasad 31 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Need to create a report on the bursting job history detailsHi, We have a job which triggers letter to employees. We need to create a report wo whom and all the letter is triggered from job history. Can you help me with the table…Shanmukhi 11 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
How to correctly write a BIP query in the OAC environmentSummary: Obtain the value list of launch parameters in a BIP report on the OAC environment Content (please ensure you mask any confidential information): Hi when I write…AM HRE 21 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Is CRC32 function supported by Oracle fuion BISummary: Is CRC32 function supported by Oracle fuion BI Content (please ensure you mask any confidential information): Version (include the version you are using, if app…Ishtiaque AHmed 31 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
What can be the sql query to determine the person address subject to LDG address configuration?What can be the sql query to determine the person address which satisfies the condition of having all the mandatory address field by the person LDG address configuration…
-
Query to get Report run History in Fusion HCMSummary: Query to get Report run History in Fusion HCM Content (required): Hi All, Can we get the detail who all have run the BI report, is there any query available. He…Swati U 1.8K views 11 comments 0 points Most recent by Punam Roy Karmokar Reporting and Analytics for HCM
-
Role assignment report for GroupsSummary: We are trying to pull a Role Assignment Report for Security Groups instead of Users. Is this possible? There does not seem to be a way in access control to run …Alyssa Longo 22 views 10 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
How to get Month name as abbrevation concat with year in OTBIHi Experts, Can someone please help me how can we get Month name Concat with year in the same column in OTBI. We have a requirement to show the date's in the below scree…Dinesh Jaini 91 views 2 comments 0 points Most recent by Dinesh Jaini Reporting and Analytics for HCM
-
what is the table that can pull Available absence plan balance.i just want to pull absence plan and balance available for each person in system . Can someone ping me the table name,and is it possible to pull the balance for each abs…
-
Document of record - config ignored + inconsistent behaviourSummary: Document of record is attaching even though configuration states that document name is required and relevant. HCM Extract has an output item that points to a BI… -
REST API Request for running a System Report in FCCSSummary: I would like to run one of the System Reports in FCCS. How can I use Oracle Cloud EPM REST API for running a system report. For example: Approval Status Report.…ArjunBhasin 62 views 6 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Exporting annotation from annotation manager in FRGiven that FR will be deprecated in June 2025, is it possible to extract annotations made across reports from annotation manager? Due to data integrity, the client would…
-
bursting definition library channelSummary: After creating a book, I tried to creation a bursting definition. I configured the library channel to save each report send by email a pdf in a folder patch I c…Mamouddeh 11 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
How would one create a report that drives from Month in the CurrentPOV to Last quarter?Summary: Assuming, the current pov is set to june, how can I show in a report the entire prior quarter (q1) actuals? The functino parent (period offset of current pov -1…Adam G1 21 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Some of reports when we try to download the report we are getting processing errorThere was an error rendering this rich post.AjayKumar Maddipati 22 views 4 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
SQL query to find the Users that has role provisioned by an role mappingI'm trying to create a query that return the MAPPING_NAME from the PER_ROLE_MAPPINGS table and the USER_ID from the PER_USER_ROLES table to know which USER_ID is associa…Letícia Costa-Oracle 490 views 0 comments 0 points Started by Letícia Costa-Oracle Reporting and Analytics for HCM -
'Ethnicity - All' Headcount for US legislation to include 'Two or more Races'Summary: Based on the current functionality the only way to report on employee headcount by ethnicity is to use 'Ethnicity' which selects a primary ethnicity for each em…Chelsea Holden 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Is there a way in BIP PL SQL to retrieve where the transaction has been done?Hello Experts, for example, the transaction was done in Me Tab, then PL SQL will tell that this is Me tab page, or in a My Team page. I am currently creating a transacti…Joliver Caangay 1 view 1 comment 0 points Most recent by Joliver Caangay Reporting and Analytics for HCM
-
Is it possible for Oracle Tables for all HCM transactions including archived transactionsSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
I assigned the cost center code at the Person Costing level to an Assignment.Summary: I assigned the cost center code at the Person Costing level to an Assignment. I need to pull the OTBI report with the effective start date and End date. Can I k…