My Oracle Support Banner

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 SEPTEMBER 19, 2023

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

Changes

 No changes

Cause

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
Symptoms
Changes
Cause
Solution
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
 Still Have Questions?
References


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