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.

Symptoms

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.


ERROR
-----------------------

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




STEPS
-----------------------
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

DECLARE
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;
i NUMBER;
seiban_p VARCHAR2(20) := '&value1';
cost_group_id_p NUMBER := &cost_group_id_p;
BEGIN
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
  LOOP
  msg_data := FND_MSG_PUB.Get( p_msg_index => i , p_encoded => FND_API.G_FALSE );
  dbms_output.put_line(i || '. ' || msg_data);
  END LOOP;
END IF;
END;

2. Error occurs



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