Native Postgres - Error in Material Receipt and GenericPaymentExport (Oracle specific SQL)

Description

Test case in server https://test-postgresql.idempiere.org/webui/

  • as GardenWorld Admin

  • Open Material Receipt window on insert mode

  • Fill the business partner field with "Patio" and push Tab button

  • Error shown to the user: ERROR: syntax error at or near ")" Position: 323

In log it records:

Environment

None

Activity

Show:
Carlos Ruiz
July 31, 2020, 11:42 AM

Problem is a query written in oracle syntax in CalloutInOut.bpartner

Found another similar query in GenericPaymentExport.getBPartnerInfo

Heng Sin Low
July 31, 2020, 3:41 PM

The oracle syntax in CalloutInOut.bpartner have been changed at pull request 191 for IDEMPIERE-4383

Heng Sin Low
July 31, 2020, 3:42 PM

Fixed by changes for

Carlos Ruiz
July 31, 2020, 3:55 PM

Reopening to review the other incidence in GenericPaymentExport.getBPartnerInfo

Carlos Ruiz
July 31, 2020, 3:58 PM

Sorry - just saw you opened for that purpose, closing this ticket again

Assignee

Heng Sin Low

Reporter

Carlos Ruiz

Labels

None

Tested By

None

Fix versions

Priority

Major
Configure