Hiding XML nodes in HCM Extract Output

  • Post published:June 30, 2020
  • Post category:HCM Extract
  • Post comments:2 Comments
  • Post last modified:June 30, 2020
Hiding XML nodes in HCM Extract Output
Hiding XML nodes in HCM Extract Output

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 Reading Hiding XML nodes in HCM Extract Output

SQL Query to find pending approval transactions from Workflow tables

  • Post published:June 26, 2020
  • Post category:BI Publisher
  • Post comments:0 Comments
  • Post last modified:June 26, 2020
SQL Query to find pending approval transactions from Workflow tables
SQL Query to find pending approval transactions

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 Reading SQL Query to find pending approval transactions from Workflow tables

Bypass the FROM Clause limit in Table based Valueset

  • Post published:June 23, 2020
  • Post category:Others
  • Post comments:3 Comments
  • Post last modified:July 31, 2020
Bypass the FROM Clause limit in Table based Valueset
Bypassing the from clause limit in Table Based Valueset

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 Reading Bypass the FROM Clause limit in Table based Valueset

List of functions available in per_extract_utility package

  • Post published:June 18, 2020
  • Post category:BI Publisher
  • Post comments:0 Comments
  • Post last modified:June 18, 2020
List of functions available in per_extract_utility package
List of functions available in per_extract_utility package

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 Reading List of functions available in per_extract_utility package

Legal Employer and Enterprise Service Dates in Fusion

  • Post published:June 16, 2020
  • Post category:Others
  • Post comments:0 Comments
  • Post last modified:June 16, 2020
Legal Employer and Enterprise Service Dates in Fusion
Legal Employer and Enterprise Dates on Work Relationship

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 Reading Legal Employer and Enterprise Service Dates in Fusion