Change API (Eng_Eco_PUB) Fails If Just Created New Bill Via API (Bom_Bo_Pub) With Error: Error Occurred While Performing Database Writes

(Doc ID 2230771.1)

Last updated on FEBRUARY 06, 2017

Applies to:

Oracle Engineering - Version 12.1.3 and later
Information in this document applies to any platform.
Create Bill Via API (Bom_Bo_Pub)
Change API (Eng_Eco_PUB)

Symptoms

Error occurred while performing database writes in Change API (Eng_Eco_PUB) when access new bill just created via Bill API (Bom_Bo_Pub).

Error


API
1) API Bom_Bo_Pub.Process_Bom
2) API Eng_Eco_PUB.Process_Eco

What is working
Works fine if bill already existed earlier.  Only fails when create bill via API and directly call change API to use the new bill.

Steps
1. Run custom program.
2. Call bill API to create bill by copy.
3. Call Change order API to add bill.
4. Receive an error.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms