Hi anyone know what the installer parameter name and the value for it ?
Only place in the tech doc is the system parameters where it’s refers to a installer parameter?
When performing the upgrade we get this exception
!!!Error deploying file fndbas\24R1-GA.cdb at 03-JUN-24 09:08:44
!!!Error occurred while executing Plsql Block
DECLARE
server_time_zone_ FND_SETTING_TAB.VALUE%TYPE := 'NOT_SET';
parameter_ FND_SETTING_TAB.PARAMETER%TYPE := 'SERVER_TIME_ZONE';
fnd_setting_record_ FND_SETTING_TAB%ROWTYPE;
FUNCTION Is_Valid_Time_Zone(time_zone_ IN VARCHAR2) RETURN BOOLEAN
IS
time_zone_count_ NUMBER;
BEGIN
SELECT COUNT(*)
INTO time_zone_count_
FROM V$TIMEZONE_NAMES
WHERE TZNAME = time_zone_;
RETURN time_zone_count_ > 0;
END Is_Valid_Time_Zone;
BEGIN
IF Is_Valid_Time_Zone(server_time_zone_) = FALSE THEN
RAISE_APPLICATION_ERROR(-20001, 'Set_Server_Time_Zone: The time zone specified via the global.serverTimeZone parameter is invalid -> ' || server_time_zone_ || '. Please provide a valid time zone value.');
END IF;
SELECT *
INTO fnd_setting_record_
FROM FND_SETTING_TAB
WHERE PARAMETER = parameter_;
IF fnd_setting_record_.VALUE IS NULL OR fnd_setting_record_.VALUE = 'NOT_SET' THEN
UPDATE FND_SETTING_TAB
SET VALUE = server_time_zone_
WHERE PARAMETER = parameter_;
COMMIT;
dbms_output.put_line('Set_Server_Time_Zone: Server time zone is updated to ' || server_time_zone_);
ELSIF fnd_setting_record_.VALUE = server_time_zone_ THEN
dbms_output.put_line('Set_Server_Time_Zone: Server time zone is already set to ' || server_time_zone_);
ELSE
RAISE_APPLICATION_ERROR(-20001, 'Set_Server_Time_Zone: Server time zone is already set to ' || fnd_setting_record_.VALUE || '. Cannot update to ' || server_time_zone_);
END IF;
EXCEPTION
WHEN NO_DATA_FOUND THEN
INSERT INTO IFSAPP.FND_SETTING_TAB
("PARAMETER", "PARAMETER_DESC", "DYNAMIC", "VALUE", "DOMAIN", "DOMAIN_DESC", "CLIENT_READ_ONLY", "VALUE_TYPE", "CATEGORY", "MODULE", "ROWVERSION")
VALUES(parameter_, 'Server timezone', '999', server_time_zone_, '*^', 'Server timezone', 'FALSE', 'CUSTOM STRING', 'System Settings', 'FNDBAS', SYSDATE);
COMMIT;
dbms_output.put_line('Set_Server_Time_Zone: Server time zone is set to ' || server_time_zone_);
END;
ORA-20001: Set_Server_Time_Zone: The time zone specified via the global.serverTimeZone parameter is invalid -> NOT_SET. Please provide a valid time zone value.
ORA-06512: at line 19
