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');