Inventory Items (APC/PLM/PIM) - EBS (MOSC)

MOSC Banner

Script to Update the Item Revision with API (INV_ITEM_REVISION_PUB.UPDATE_ITEM_REVISION)

edited Mar 15, 2020 7:01PM in Inventory Items (APC/PLM/PIM) - EBS (MOSC) 1 commentAnswered

Hello Team,

Can anyone please share the script to update Item Revision Implementation date through API, I have tried with below script but unable to update the value can you lease help me.

DECLARE

   l_return_status               VARCHAR2 (10000);

   l_errorcode                   NUMBER;

   l_msg_count                   NUMBER;

   l_msg_data                    VARCHAR2 (10000);

   l_api_version                 NUMBER := 1.0;

   -- l_organization_id             NUMBER := 204;

   -- l_inventory_item_id           NUMBER := 592008;

   L_ITEM_REVISION_REC             INV_ITEM_REVISION_PUB.ITEM_REVISION_REC_TYPE;

BEGIN

   DBMS_OUTPUT.put_line ('Starting ...');

   FND_GLOBAL.APPS_INITIALIZE(54883,20634,401);

   DBMS_OUTPUT.put_line ('INV Debug Profile: ' || fnd_profile.VALUE ('INV_DEBUG_TRACE'

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