Payables and Cash Management - EBS (MOSC)

MOSC Banner

Provided solution in Doc ID 2051809.1 is not working

edited Jul 21, 2023 9:18PM in Payables and Cash Management - EBS (MOSC) 5 commentsAnswered

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'

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center