R12: Error Invalid Item Id When Running API "ar_invoice_api_pub.create_single_invoice" in the Same Session for Different Operating Unit (Doc ID 2968063.1)

Last updated on MAY 20, 2024

Applies to:

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

Symptoms

When attempting to run ar_invoice_api_pub.create_single_invoice API to create a new transaction for different organizations in the same session, using parameter inventory item _ID, the API is failing with
the following error:

'INVALID ITEM ID'

The issue can be reproduced at will with the following steps:

Using SQL Developer/SQL Plus
1. Initializing the session for one operating unit
2. Run API to create transaction for that operating unit
3. Commit when Transaction is created successfully
5. Initializing the session for a different operating unit
6. Run API to create transaction for the second operating unit