saurabh shirke
09-Dec-2024 12:48:14
Hello team, I'm try to update multiple rows using interactive grid custom process. But I'm getting this error *1 error has occurred*
• Session state protection violation: This may be caused by manual alteration of protected page item BUDGET_PERIOD. If you are unsure what caused this error, please contact the application administrator for assistance.
i have set source attribute for page item (BUDGET_PERIOD) to query only but still not working. This is my custom process BEGIN
IF :APEX$ROW_STATUS = 'C' THEN
INSERT INTO XXPAN_BUDGET_MONTH_CONSUME (
REC_GUID,
BUDGET_PERIOD,
BUDGET_YEAR,
DEPARTMENT_NAME,
VENDOR_CODE,
MONTH_AMOUNT,
DESCRIPTION,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATED_BY
)
VALUES (
:P121_GUID,
:BUDGET_PERIOD,
:P121_BUDGET_YEAR,
:P121_LEGAL_CONTENT,
:VENDOR_CODE,
:MONTH_AMOUNT,
:DESCRIPTION,
SYSDATE,
:SESSION_EMAIL,
SYSDATE,
:SESSION_EMAIL
);
COMMIT;
ELSIF :APEX$ROW_STATUS = 'U' THEN
UPDATE XXPAN_BUDGET_MONTH_CONSUME
SET
VENDOR_CODE = :VENDOR_CODE,
MONTH_AMOUNT = :MONTH_AMOUNT,
DESCRIPTION = :DESCRIPTION,
PURCHASE_ORDER_NUMBER = :PURCHASE_ORDER_NUMBER,
LAST_UPDATE_DATE = SYSDATE,
LAST_UPDATED_BY = :SESSION_EMAIL
WHERE ID_NO = :ID_NO;
COMMIT;
END IF;
END; Any idea how to solve this error?