These source might help: https://docs.oracle.com/en/error-help/db/ora-00904/?r=23ai  https://support.pega.com/question/getting-ora-00904-invalid-identifier-…

@DharmaReddy This error means Oracle can’t find Pega’s UDF PR_READ_DECIMAL_FROM_STREAM and you’re calling it from the data schema (PEGA_DATA_OWNER), where it doesn’t exist. In split-schema setups those UDFs live in the RULES schema and must be installed, granted, and visible to the DATA schema. Fix it by: 1) check the RULES schema for the function (SELECT OBJECT_NAME FROM ALL_OBJECTS WHERE OBJECT_NAME='PR_READ_DECIMAL_FROM_STREAM'); 2) if missing, run the Pega Oracle UDF script for your platform version (often named prreadstream_udf.sql) in the RULES schema; 3) GRANT EXECUTE ON rules_owner.PR_READ_DECIMAL_FROM_STREAM TO PEGA_DATA_OWNER; 4) in PEGA_DATA_OWNER create a SYNONYM pointing to rules_owner.PR_READ_DECIMAL_FROM_STREAM; 5) avoid qualifying the function with PEGA_DATA_OWNER in any SQL—use the RULES owner or leave it unqualified with the correct current_schema; 6) recompile invalid objects and restart the node/clear caches; 7) re-run “Search duplicate cases.” If you recently upgraded or cloned DBs, repeat these steps for all related UDFs (PR_READ_FROM_STREAM, PR_READ_INT_FROM_STREAM, etc.).