A couple of days ago, I encountered an interesting case with a customer concerning a rebuild index operation on a datawarehouse environment. Let me introduce the situation: a “usual DBA day” with an almost usual error message found in your dedicated mailbox: “The transaction log for database 'xxx' is full”. After checking the concerned database, I notice that its transaction log has grown up and has fulfilled the entire volume.
While we try to create a new Business Group or Inventory organization, before we start it we need to have the location created to use while you create the organization. If its 11i then list becomes bigger and its needed for Legal Entity and Operating Units. With R12 that’s not the case. You have the ability to create address locations while you create the legal entity using Accounting Setup.Now lets see how to create Inventory Locations.