For more information, please refer to this announcement explaining best practices for getting answers to questions.
OTBI Edit Column Formula for YYYYMMDD
Summary:
Hello, We tried using the solution listed in the Oracle Doc below but unable to successfully edit the column formula of the OTBI analysis for Workforce Management - Worker Assignment Real Time SA | Worker Folder | Date of Birth and Enterprise Hire Date so that the format shows as YYYYMMDD. This is ncessary as this analysis is the basis for a data model and BIP Report.
Oracle Fusion BIP: How to change the date Format in OTBI analysis so that it keeps the formatting in BI Publisher Reporting. (Doc ID 2184776.1)
Solution: CASE WHEN "Worker"."Employee Hire Date" is not null THEN CONCAT (CONCAT( CONCAT( CONCAT(SUBSTRING((CAST("Worker"."Employee Hire Date" AS CHAR)) FROM 9 FOR 2), '/') , SUBSTRING((CAST("Worker"."Employee Hire Date" AS CHAR)) FROM 6 FOR 2)), '/'), SUBSTRING((CAST("Worker"."Employee Hire Date" AS CHAR)) FROM 1 FOR 4)) ELSE '' END