Hi
We have a legacy apex application that was upgraded frodm R4.2 to R5.1 during oracle database upgrade from 12.1 to 12.2.
The application allows a user to update an organization or contact information and then send an email if anything changed to the admin email address showing the changes.
We found that the hidden item on update form that should be set to TRUE when updates takes place does not SET so no email is triggered.
Was there any behavior code changes in these releases or do you see any issues in the code? The code in the after submission process is shown below.
I could not find any pl/sql code or dynamic action associated with HIDDEN Field so i am not sure how it is supposed to set to TRUE when other fields are updates on form.
DECLARE
l_body clob;
l_subject varchar2(300) ;
BEGIN
IF :P430_ADR_CHANGED = 'TRUE' THEN
l_subject := :P430_LIBCD || ' Address Change';
l_body := l_body || 'ADDRESS CHANGE ' || utl_tcp.crlf || utl_tcp.crlf;
l_body := l_body || :P430_ADR_OLD_DATA ;
l_body := l_body || utl_tcp.crlf || utl_tcp.crlf;
l_body := l_body || '<<New Data>>'||utl_tcp.crlf ;
l_body := l_body || 'Orgtype:' || :P430_ORGTYPE ||utl_tcp.crlf ;
l_body := l_body || 'Libcd:'|| :P430_LIBCD || utl_tcp.crlf ;
END IF;
IF :P430_CONTACT_CHANGED = 'TRUE' THEN
l_subject := :P430_LIBCD || ' Contact Info Change';
l_body := l_body || 'CONTACT INFORMATION CHANGE ' || utl_tcp.crlf || utl_tcp.crlf;
l_body := l_body || :P430_CONTACT_OLD_DATA ;
l_body := l_body || utl_tcp.crlf || utl_tcp.crlf;
l_body := l_body || '<<New Data>>'||utl_tcp.crlf ;
END IF;
IF :P430_ADR_CHANGED = 'TRUE' or :P430_BULK_CHANGED = 'TRUE' or :P430_CONTACT_CHANGED = 'TRUE' THEN
l_body := l_body || 'Changed by:' || :APP_USER || ' Change Date/time: ' || TO_CHAR(systimestamp, 'MM/DD/YYYY HH:MI:SS AM') || utl_tcp.crlf ||
utl_tcp.crlf;
ND_EMAIL_PKG.SEND_EMAIL ('joe.blow@xyz.com','DO-NOT-REPLY@abc.com', L_subjecT,L_body);
END IF ;
END ;