Modifying VO, receive error oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement prepa
Hi,
I'm trying to customize the following VO to include project information oracle.apps.ap.invoice.request.negotiation.server.NotifPGLineDetailsVO. The query will run in sql developer, but I am receiving an exception in the application. Anyone have any recommendations on how to resolve this? Thanks!
Exception Details. oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: select lines.description, ph.segment1, lines.quantity_invoiced, lines.unit_meas_lookup_code, lines.unit_price, lines.amount, alc.displayed_field approval_status, to_char(lines.unit_price,FND_CURRENCY.SAFE_GET_FORMAT_MASK(ai.INVOICE_CURRENCY_CODE,25)) unit_price_disp, to_char(lines.amount,FND_CURRENCY.SAFE_GET_FORMAT_MASK(ai.INVOICE_CURRENCY_CODE,25)) amount_disp, xxtgen_ap_inv_apprv_not.get_cost_center(lines.invoice_id, lines.line_number) xxtgen_cost_center, xxtgen_ap_inv_apprv_not.get_project_number(lines.invoice_id, lines.line_number) xxtgen_project_number, xxtgen_ap_inv_apprv_not.get_project_name(lines.invoice_id, lines.line_number) xxtgen_project_name from
I'm trying to customize the following VO to include project information oracle.apps.ap.invoice.request.negotiation.server.NotifPGLineDetailsVO. The query will run in sql developer, but I am receiving an exception in the application. Anyone have any recommendations on how to resolve this? Thanks!
Exception Details. oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: select lines.description, ph.segment1, lines.quantity_invoiced, lines.unit_meas_lookup_code, lines.unit_price, lines.amount, alc.displayed_field approval_status, to_char(lines.unit_price,FND_CURRENCY.SAFE_GET_FORMAT_MASK(ai.INVOICE_CURRENCY_CODE,25)) unit_price_disp, to_char(lines.amount,FND_CURRENCY.SAFE_GET_FORMAT_MASK(ai.INVOICE_CURRENCY_CODE,25)) amount_disp, xxtgen_ap_inv_apprv_not.get_cost_center(lines.invoice_id, lines.line_number) xxtgen_cost_center, xxtgen_ap_inv_apprv_not.get_project_number(lines.invoice_id, lines.line_number) xxtgen_project_number, xxtgen_ap_inv_apprv_not.get_project_name(lines.invoice_id, lines.line_number) xxtgen_project_name from
0