This content has been marked as final. Show 4 replies
Can you please check whether POR: Preferences - Inventory Replenishment profile is set to Yes?
This is because the profile option "POR : Preferences - SubInventory" is only valid if the above stated profile is set to Yes.
I checked the SQL in profile "POR : Preferences - SubInventory"
SQL="select secondary_inventory_name, secondary_inventory_name \"SubInventory\"
into :profile_option_value, :visible_option_value
from mtl_secondary_inventories where sysdate < nvl(disable_date, sysdate + 1) "
My mistake i actually could see my Sub-Inventory just that I could not recognise due to improper naming convention that i used.
Your note, "This is because the profile option "POR : Preferences - SubInventory" is only valid if the POR: Preferences - Inventory Replenishment profile is set to Yes" is raising more doubts to me. I think the connection is not relevant always.
For instance my requirement is that I actually want my sub inventory to be defaulted every time a buyer buys some item(s) through iprocurement and setting "POR : Preferences - SubInventory" worked like charm. It did not affect whether the profile "POR: Select Inventory Replenishment Lines For Confirm Receipts" is set to "Yes" or "No".
Let me know if i am missing something.. Thank you
Your issue has been fixed. Sounds great.
For more about these profile options, you can check the page 2.57 in the I-Procurement Implementation guide.