Receipts Workbench: Unable to Search Transaction by PO Numbers in Search and Apply Window - PO Number is Over 50 Characters (Doc ID 1496488.1)

Last updated on NOVEMBER 16, 2016

Applies to:

Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

RA_CUSTOMER_TRX_ALL.purchase_order is char(50).  User can enter value by 50 bites in transaction window, but in search and apply window, the field allow to enter value only by 30 bites.

Because of this, user can not query transaction in search and apply window in case the PO number is over 30 bites.

Responsibility:  Receivables Manager
Navigation:  Transactions > Transaction
Create transaction with long PO number. (ex. F0000001 CA000011-000011 ACCOUNT_CUSTOMER011_INV)
This field's max lengh is 50 bites.

Navigation:  Receipts > Receipts
Create receipt and enter customer name, then push 'Search and Apply' button.

In Search and Apply window, enter PO number 'F0000001 CA000011-000011 ACCOUNT_CUSTOMER011_INV'.
In this field, the max lengh is only 30 bites, so the last several character is cut.

Push 'Apply' button, but the transaction is not selected.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms