My Oracle Support Banner

Cannot Deliver ASBN by MSCA - Create PO interface record failed. (Doc ID 2687343.1)

Last updated on JULY 03, 2020

Applies to:

Oracle Inventory Management - Version 12.2.8 and later
Information in this document applies to any platform.


Problem Statement
When attempting to deliver ASBN by MSCA,
the following error occurs.

Create PO interface record failed.
INV_ALL_SQL_ERROR (ROUTINE=INV_rcv_std_deliver_apis.create_po_rcvtxn_intf_rec) (ERR_NUMBER=70) (SQL_ERR=ORA-06502: PL/SQL: numeric or value error: character string buffer too small)

This issue only occurs for the deliver of ASBN by MSCA.
This issue doesn't occur for the deliver of PO and ASN by MSCA.
Also, there is no issue if performing deliver by Receiving Transactions form.

Steps to Reproduce

  1. Create PO
    Line 1
    Qty  4

  2. Purchase Orders - Shipments - Distributions
    Num    Qty
    1        1
    2        2
    1        1

    Purchase Orders - Terms
      Make sure Pay On is blank to be able to submit ASBN.

    Purchase Orders - Shipments - Receiving Controls
     Make sure Receipt Routing is Standard Receipt.

  3. Submit ASBN for PO through iSupplier Portal Full Access

  4. Run RTP
    ASBN Shipment is created.

  5. MSCA - Responsibility: Material & Mfg
    Navigate to Receiving > Receipt > All
      Query ASBN and complete Receipt.

  6. MSCA - Responsibility: Material & Mfg
    Navigate to Receiving > Deliver > Receipt
      Query ASBN and try to do Deliver.
      Error shows when Done is clicked.




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

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