Error on creating internet expenses

Hi,

I'm facing the below java error stack when I try to create an internet expense, duplicate an existing one or even modify. Anyone who can assist me, I will be grateful. EBS version is 12.2.7 and DB is 12.1

You have encountered an unexpected error. Please contact your System Administrator for assistance.

Exception Details.

oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT lookup_code lookup_code, meaning description FROM fnd_lookup_values_vl WHERE lookup_type = 'HOME_OFFICE' AND AP_WEB_DB_HR_INT_PKG.isPersonCwk(:1) = 'N' UNION SELECT TO_CHAR(vendor_site_id) lookup_code, vendor_site_code description FROM ap_supplier_sites WHERE SYSDATE < NVL(INACTIVE_DATE, SYSDATE + 1) AND NVL(pay_site_flag,'N')='Y' and vendor_id is not null AND vendor_id = (SELECT paaf.vendor_id FROM per_all_assignments_f paaf WHERE paaf.person_id = :2 AND paaf.primary_flag = 'Y' AND trunc(fnd_date.canonical_to_date((:3))) BETWEEN trunc(paaf.effective_start_date ) AND trunc(paaf.effective_end_date ) AND paaf.vendor_id IS NOT NULL )) QRSLT ORDER BY description at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:661) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:283) at oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(Unknown Source) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:1073) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:1040) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:704) at