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.


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:


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


 No changes


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 Files
 3. Recommended Patches
 4. Solution Steps
 Still Have Questions?

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