Receipts Workbench: Unable to Search Transaction by PO Numbers in Search and Apply Window - PO Number is Over 50 Characters
Last updated on NOVEMBER 16, 2016
Applies to:Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms