Inventory Management - EBS (MOSC)

MOSC Banner

Error while creating Stock Locators EBS 12.2.9

SET SERVEROUTPUT ON SIZE 1000000


DECLARE

  l_msg_data        VARCHAR2 (100);

  l_msg_count        NUMBER;

  l_return_status      VARCHAR2 (1);

  l_locator_id       NUMBER;

  l_locator_exists     VARCHAR2 (1);

  l_org_id         NUMBER := NULL;

  l_organization_code    VARCHAR2 (10) := 'CZK';         --'CZK';

  l_concatenated_segments  VARCHAR2 (100) := NULL;


  l_user_id         NUMBER := NULL;

  l_resp_id         NUMBER := NULL;

  l_resp_appl_id      NUMBER := NULL;

  l_cnt           NUMBER := 0;

BEGIN

  /*

  * APPS_INITIALIZE needed because Project/Task Valuesets indirectly use

  * profile options

  */


  SELECT fur.user_id,

     fur.responsibility_id,

     fur.responsibility_application_id

   INTO l_user_id, l_resp_id, l_resp_appl_id

   FROM fnd_user_resp_groups_direct fur,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center