Pjm_seiban_pub.create_seiban API Error When The MUTL ORG Enable Cost Group Id Passed To API

(Doc ID 1517341.1)

Last updated on JUNE 03, 2017

Applies to:

Oracle Project Manufacturing - Version 12.1.1 and later
Information in this document applies to any platform.


The Seiban API, as described in Doc ID 738452.1 fails to assign organizations if multi-org cost groups are assigned.

However, as the API should mirror the validation used in the Seiban wizard, these cost groups are valid and need to be accepted.


Create Seiban returnedE Error count1
1. The value for Cost Group is invalid.
l_err_buf The value for Cost Group is invalid.

The issue can be reproduced at will with the following steps:
1.Try to run the Seiban API by using a snippet such as the one defined in the notes. In our case, this would be

return_status VARCHAR2(1);
msg_count NUMBER;
msg_data VARCHAR2(2000);
orglistrec pjm_seiban_pub.orgrectype;
orglisttbl pjm_seiban_pub.orgtbltype;
dff pjm_seiban_pub.descflexrectype;
project_id NUMBER;
seiban_p VARCHAR2(20) := '&value1';
cost_group_id_p NUMBER := &cost_group_id_p;
orglistrec.organization_id := &org_id1; 
orglistrec.cost_group_id := cost_group_id_p;
orglisttbl(1) := orglistrec;
orglistrec.organization_id := &org_id2; 
orglistrec.cost_group_id := cost_group_id_p;
orglisttbl(2) := orglistrec;
PJM_SEIBAN_PUB.Create_Seiban ( P_api_version => 1.0 , P_commit => 'F' , X_return_status => return_status , X_msg_count => msg_count , X_msg_data => msg_data , P_seiban_number => seiban_p , P_seiban_name => seiban_p , P_operating_unit => '' , P_planning_group => '' , P_DFF => dff , P_org_list => orglisttbl , X_project_id => project_id );
IF ( return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
  FOR i IN 1..msg_count
  msg_data := FND_MSG_PUB.Get( p_msg_index => i , p_encoded => FND_API.G_FALSE );
  dbms_output.put_line(i || '. ' || msg_data);

2. Error occurs


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