This post will cover API ego_item_pub.assign_item_to_org used to assign item to an organization.
Step by step demonstration of code.
Please download attached file to use as sample code. This sample code assign single item at a time to single organization you can modify it for multiple items or multiple organizations at a time.
This API assigns a specific item to any inventory organization. The item to be assigned must already assigned to parent organization before running this API.
Input parameters.
P_param1 pass inventory item id.
P_organization_id organization id to which you want to assign item
P_organization_code organization code of specific organization
Variables need to be assign values by you.
l_user_id your used id
l_resp_id your responsibility id
l_application_id application id
Get this information from fnd_responsibility table.
Running attached code I recommend to run it initially for some items and verify that these items are assigned to specific organizations.
Download.
2
replies
Recent Comments
- Pradeep Kumar Devarakonda on Rollup Groups
- Pradeep on Rollup Groups
- Aqeel on Oracle E-Business Suite 12 Free Vision Instance
- Balaji on How to Use Flexfields in Custom forms
- Guru on R12 Supplier Contact creation API
Latest Posts
- R12 – How to Handle NULL for :$FLEX$.VALUE_SET_NAME In Oracle ERPAugust 25, 2023 - 1:20 pm
- R12 – How to Delete Oracle AR TransactionsMarch 22, 2019 - 8:37 pm
- How to Define Custom Key Flexfield (KFF) in R12January 19, 2018 - 5:43 pm
- AutoLock Box Concepts In R12November 10, 2017 - 8:30 am
- R12 – java.sql.SQLException: Invalid column type in OAFSeptember 15, 2017 - 9:39 am
not able to view the script. i want update the price
Hi,
Try to download in your system and check the code.
Regards,
Velmurugan