bom_bo_pub.Process_Bom Gives Error "You Cannot Insert, Update or Delete Component" "Parent Component Does Not Exist" [ID 1064985.1]

修改时间 25-NOV-2010     类型 PROBLEM     状态 PUBLISHED

In this Document

Symptoms

Cause

Solution

Applies to:

Oracle Bills of Material - Version: 12.1.1 to 12.1.2 - Release: 12.1 to 12.1

Information in this document applies to any platform.

This document includes all versions of Oracle EBS 11i and R12

Symptoms

See the following errors similar when using the BOM API bom_bo_pub.Process_Bom:

1. Unable to create a substitute component using API.

Error: You cannot insert, update or delete substitute component 1 because its parent component 2 does not exist for item 3.

--> Component 2 does exist

2. Unable to update existing BOM components using the API (unless the component was created via the API).. In other words, cannot update components that were created manually through the form (but able to update if the component was created through the API)

Error: You cannot update or delete component 1 since it does not exist for item A.

--> Component 1 does exist

Cause

The system cannot interpret the Date/time information correctly as passed in the API.

The issue is caused by the following setup:

need to explicitly use datatype function TO_DATE when defining the dates for BOM Components in the API.

Date/time information passed in the API must EXACTLY match the existing information from the database for existing components; the Date/time information must be readable and understood by the API for it to function correctly.

Solution

Pass the date values using a to_date() function similar to this:

Start_Effective_Date := to_date('15-FEB-2010 13:55:21','DD-MON-YYYY HH24:MI:SS');