Skip to content
Logo 0121 - Hiding XML nodes in HCM Extract Output
Menu
  • Home
  • VIP Access
    • Log In
    • Manage VIP Account
    • Register for VIP Plan
    • VIP Member-Only Content
  • Blog
  • About Us
  • Technical
    • HCM Data Loader
    • HCM Extract
    • BI Publisher
    • Fast Formula
    • Security
    • OTBI Analytics
    • Personalizations
    • Scheduled Processes
  • Functional
    • Core HR
    • Absence Management
    • Payroll
    • Benefits
    • Performance Management
    • Talent Management
    • Time & Labor
    • Helpdesk
    • Learning
    • Recruiting
    • Onboarding
  • Interview Tips
    • HCM Extracts Questions
    • HCM Data Loader Questions
    • BI Reports Questions
  • Store
  • More
    • Report Issues/suggestions
    • Your Feedback counts
    • Write for Us
    • Privacy Policy
    • Contact Us
    • Social
      • Join Telegram Group
      • Join LinkedIn Group
      • Join Facebook Page
  • Log In
    • Generic filters
      Exact matches only
      Search in title
      Search in content
      Search in excerpt
  • Home
  • VIP Access
    • Log In
    • Manage VIP Account
    • Register for VIP Plan
    • VIP Member-Only Content
  • Blog
  • About Us
  • Technical
    • HCM Data Loader
    • HCM Extract
    • BI Publisher
    • Fast Formula
    • Security
    • OTBI Analytics
    • Personalizations
    • Scheduled Processes
  • Functional
    • Core HR
    • Absence Management
    • Payroll
    • Benefits
    • Performance Management
    • Talent Management
    • Time & Labor
    • Helpdesk
    • Learning
    • Recruiting
    • Onboarding
  • Interview Tips
    • HCM Extracts Questions
    • HCM Data Loader Questions
    • BI Reports Questions
  • Store
  • More
    • Report Issues/suggestions
    • Your Feedback counts
    • Write for Us
    • Privacy Policy
    • Contact Us
    • Social
      • Join Telegram Group
      • Join LinkedIn Group
      • Join Facebook Page
  • Log In
  • Search
    • Search

Monthly Archives: June 2020

Hiding XML nodes in HCM Extract Output

  • Post category:HCM Extract
  • Post comments:2 Comments
  • Post last modified:June 30, 2020
  • Reading time:6 mins read

Do you know how to hide the XML tags on HCM Extract output? Can you hide all tags or is there any restriction? Read on to know more details.

Continue ReadingHiding XML nodes in HCM Extract Output

SQL Query to find pending approval transactions from Workflow tables

  • Post category:BI Publisher
  • Post comments:0 Comments
  • Post last modified:June 26, 2020
  • Reading time:10 mins read

Have you used the approval related tables to fetch the In Progress/Approved/Withdrawn transactions? Can you do another transaction on the business object which has an in process approval? Read on to know more details.

Continue ReadingSQL Query to find pending approval transactions from Workflow tables

Access contents of UCM file using BI Report

  • Post category:BI Publisher
  • Post comments:1 Comment
  • Post last modified:June 23, 2020
  • Reading time:10 mins read

Do you know that you can get the contents of the text files uploaded to UCM in BI Report? Read on to know more details.

Continue ReadingAccess contents of UCM file using BI Report

SQL Query to fetch Descriptive Flexfield information from an instance

  • Post category:Personalizations
  • Post comments:0 Comments
  • Post last modified:June 23, 2020
  • Reading time:4 mins read

Do you know how to fetch the configured Descriptive Flexfields from an instance? Do you know in which table and attribute the data resides?

Continue ReadingSQL Query to fetch Descriptive Flexfield information from an instance

Bypass the FROM Clause limit in Table based Valueset

  • Post category:Others
  • Post comments:3 Comments
  • Post last modified:July 31, 2020
  • Reading time:7 mins read

Do you know that you can bypass the FROM Clause character limit of 240 in table based valueset using a workaround? Read on to know more details.

Continue ReadingBypass the FROM Clause limit in Table based Valueset

Get the info of Attachments loaded to UCM

  • Post category:BI Publisher
  • Post comments:1 Comment
  • Post last modified:June 18, 2020
  • Reading time:3 mins read

Do you know how to get the documents information that have been uploaded to UCM using SQL Query? Read on to know more details.

Continue ReadingGet the info of Attachments loaded to UCM

List of functions available in per_extract_utility package

  • Post category:BI Publisher
  • Post comments:0 Comments
  • Post last modified:June 18, 2020
  • Reading time:44 mins read

Do you know the list of available functions in per_extract_utility seeded pl/sql package? These functions can be used in sql query to avoid unnecessary joins to tables. Read on to know more details.

Continue ReadingList of functions available in per_extract_utility package

Basics of HDL Transformation Formula Part 1

  • Post category:Fast Formula/HCM Data Loader
  • Post comments:0 Comments
  • Post last modified:January 22, 2021
  • Reading time:10 mins read

Do you know the HDL Transformation Formula in Fusion HCM? What are the use cases of it? How to use it? FAQs on it? Read on to know more details.

Continue ReadingBasics of HDL Transformation Formula Part 1

Legal Employer and Enterprise Service Dates in Fusion

  • Post category:Others
  • Post comments:0 Comments
  • Post last modified:June 16, 2020
  • Reading time:4 mins read

Do you know the Legal Employer and Enterprise service dates on Work Relationships? How are they derived and what is the significance of each of them? Read on to know more details

Continue ReadingLegal Employer and Enterprise Service Dates in Fusion

Auto Fit Contents in Excel output with RTF template in BIP

  • Post category:BI Publisher
  • Post comments:0 Comments
  • Post last modified:June 17, 2020
  • Reading time:6 mins read

Do you know how to set dynamic width for columns in excel output using RTF template? This works along with keep values in same column setting. Read on to know more details.

Continue ReadingAuto Fit Contents in Excel output with RTF template in BIP
Older Posts →

Search Knowledgebase

Generic filters
Exact matches only
Search in title
Search in content
Search in excerpt

VIP Membership Plans

VIP Membership 296x300 - Auto Fit Contents in Excel output with RTF template in BIP

Recent Posts

  • How to get the count of data loaded using HDL for business objects?
  • How do we extract the Grade Ladder step rates?
  • How do we reduce RTF template size when many images exist in the template?
  • How to find the Lookup Type for an attribute that supports HDL load?
  • How to modify the reports/value sets for Payroll table changes in 24A?
  • What is a Progression Grade Ladder and how to load it using HDL?
  • How to resolve “Template type etext is not yet supported” error for BI Report?
  • How to enable Advanced Edit for HCM Extracts in 24A?
  • PI Cube – FREE SQL Developer-like tool for Oracle Cloud
  • How to fetch the Contexts required for DBIs in Fast Formula?

Tag Cloud

Alerts Approvals Audit BI Publisher Bursting Calculation Cards content server Data Disposal Data Scrambling EL Expressions ERD etext Fast Formula Flexfields Functional General HCM Data Loader HCM Extract Helpful Tools Interview Questions Latest Features LBAC Lookup Migration Notifications Offer Letter OTBI Analytics Payroll Payroll Batch Loader Payroll Flow Performance Management Personalizations Profile Options REST Services Scheduled Processes Security SOAP Services SQL Query Tables Templates Transformation Formula UDT Valueset VIP Content Web Services

Archives

Free counters!

Subscribe to Newsletter

[mailpoet_form id="3"]
About
Technical
Functional
Popular
  • Home
  • About Us
  • Blog
  • VIP Membership Plans
  • Interview Tips
  • FusionHCMKB Tools
  • Report Issues/Suggestions
  • Privacy Policy
  • Contact Us
  • BI Publisher
  • HCM Extract
  • Others
  • HCM Data Loader
  • Personalizations
  • Fast Formula
  • Scheduled Processes
  • Security
  • OTBI Analytics
  • Core HR
  • Payroll
  • Benefits
  • Absence Management
  • Time & Labor
  • Onboarding
  • Performance Management
  • Recruiting
  • Talent Management
  • Learn HCM Technical Online
  • Learn HDL Online
  • FREE Oracle Learning
  • FREE Demo Instance
  • Top 10 FREE Tools
  • FREE Cloud SQL Tool
  • Sample HDL Files
  • Frequently used DOC IDs
  • Frequently used Tables

Quick Links

  • Home
  • About Us
  • Blog
  • VIP Membership Plans
  • Interview Tips
  • FusionHCMKB Tools
  • Report Issues/Suggestions
  • Privacy Policy
  • Contact Us
Linkedin Facebook Twitter Telegram
footer logo - Auto Fit Contents in Excel output with RTF template in BIP

Copyright © FusionHCMKnowledgebase 2024. All rights reserved

Disclaimer: All views expressed on site are my own and does not represent opinions of any entity. Reproducing articles without permission is prohibited.

Close Menu
Menu
  • Home
  • VIP Access
    • Log In
    • Manage VIP Account
    • Register for VIP Plan
    • VIP Member-Only Content
  • Blog
  • About Us
  • Technical
    • HCM Data Loader
    • HCM Extract
    • BI Publisher
    • Fast Formula
    • Security
    • OTBI Analytics
    • Personalizations
    • Scheduled Processes
  • Functional
    • Core HR
    • Absence Management
    • Payroll
    • Benefits
    • Performance Management
    • Talent Management
    • Time & Labor
    • Helpdesk
    • Learning
    • Recruiting
    • Onboarding
  • Interview Tips
    • HCM Extracts Questions
    • HCM Data Loader Questions
    • BI Reports Questions
  • Store
  • More
    • Report Issues/suggestions
    • Your Feedback counts
    • Write for Us
    • Privacy Policy
    • Contact Us
    • Social
      • Join Telegram Group
      • Join LinkedIn Group
      • Join Facebook Page
  • Log In
    • Generic filters
      Exact matches only
      Search in title
      Search in content
      Search in excerpt
>
Don`t copy text!