Goldengate Replicate Abending when calling SP to convert DATE/DATETIME2 value

Environment:

• Source DB: SQL Server 2019
• Source GG Version: 21.4
• Target DB: Oracle 19.3
• Target GG Version: 21.3

I have a test scenario where I have a table named sqlrep.TestDateTbl in SQL Server with the following structure:

CREATE TABLE sqlrep.TestDateTbl (
  Id            NUMERIC(38,0) NOT NULL,
  DateAdded     DATETIME2     NOT NULL,
  DbName        VARCHAR(30)   NOT NULL
)

which is being replicated to an Oracle table named ORAREP.TEST_DATE_TBL with the following structure:

CREATE TABLE orarep.test_date_tbl (
  id             NUMBER   NOT NULL PRIMARY KEY,
  date_added     DATE     NOT NULL DEFAULT SYSDATE,
  dbname         VARCHAR2(30) NOT NULL 
);

The DateAdded value in the SQL Server table is being written in UTC timezone, but in the Oracle table, DATE_ADDED needs to be in Pacific timezone.