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 JULY 10, 2020

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 bytes 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. X0000001 XX000011-000011 XXXXXXX_CUSTOMERXXX_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 "X0000001 XX000011-000011 XXXXXXX_CUSTOMERXXX_INV".
In this field, the max lenght is only 30 bytes, so the several characters are truncated.

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.