Business Unit Table In Oracle Apps R12

From xx hrms manager people enter and maintain screen data goes into this table.

Business unit table in oracle apps r12. Check out here the differences between oracle e business suite and oracle fusion. Technical blog for oracle apps. Query to find legal entity organization company code.

Prior to oracle fusion applications operating units in oracle e business suite were assumed to perform all business functions while in peoplesoft each business unit had one specific business function. Oracle fusion applications blends these two models and allows defining business units with one or many business functions. Thus if a user in office smart canada needed access to data in office smart us then she would need to be assigned a responsibility that was tied to the us operating unit office smart operations.

Wsh delivery details released status pick release status query to fetch purchase receipt and its related purchase order vendor details in oracle apps r12 rcv transactions rcv shipment headers rcv shipment lines. What r12 brings to the table. Sql plus user s guide and reference.

Technical and functional help on oracle applications r12. This table gives us very basic information about the employee. Query to fetch legal entity business group details in oracle apps r12 per business groups xle firstparty information v.

Pl sql user s guide and reference. This blog is only for fresher who want to learn through practicing and on yourself specially in oracle related technology like forms reports pl sql sql oracle apps and retail and also for some kind of realistic people. Here is the list of all important tables of oracle hrms.

Oracle e business suite application and oracle fusion applications have a few key functional differences such as middleware concepts fusion enterprise structure and org structure that is detailed. Responsibilities were tied to operating units through the profile option mo.