My Oracle Support Banner

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 FEBRUARY 03, 2019

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.


To view full details, sign in with your My Oracle Support account.

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

In this Document
 1. Bug Summary
 2. Fixed File(s)
 3. Recommended Patch(es)
 4. Solution Steps

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.