Îĵµ¿ØÖÆ
Îĵµ¿ØÖÆ ................................................................................................................................................................................. I UNIT1 ¿â´æÄ£¿é¸ÅÊö ........................................................................................................................................................... 3 »ù±¾¸ÅÄî ............................................................................................................................................................................ 3 ×éÖ¯¶ÔӦͼ ........................................................................................................................................................................ 4 UNIT2 ϵͳ»ù±¾²Ù×÷ ........................................................................................................................................................... 5 ²Ù×÷˵Ã÷ ............................................................................................................................................................................ 5 ½øÈëϵͳ ............................................................................................................................................................................ 5 ¹¦ÄÜÌõͼ±í˵Ã÷ ................................................................................................................................................................ 5 ²Ëµ¥¹¤¾ßÌõ ........................................................................................................................................................................ 5 UNIT3 ¿â´æÏîÄ¿¹ÜÀí ........................................................................................................................................................... 7 ¸ÅÊö .................................................................................................................................................................................... 7 ¶¨ÒåÏîÄ¿ ............................................................................................................................................................................ 7
2¡¢¶¨ÒåÏîÄ¿ .................................................................................................................................................................................. 8 3¡¢¶¨ÒåÖÊÁ¿µÈ¼¶ÐÅÏ¢ ................................................................................................................................................................... 9 4¶¨Òåת»» ................................................................................................................................................................................... 10 5¡¢¶¨Òå³É±¾ÐÅÏ¢......................................................................................................................................................................... 11 6£®¶¨Òå·ÖÀà ................................................................................................................................................................................ 12
UNIT4 ¿â´æÒµÎñ ................................................................................................................................................................ 13 ¸ÅÊö .................................................................................................................................................................................. 13 µ¥¸öµÄ¿â´æ½»Ò× .............................................................................................................................................................. 14
1¡¢²Ù×÷·¾¶ ................................................................................................................................................................................ 14 2¡¢Á¢¼´´´½¨ ................................................................................................................................................................................ 14 3Á¢¼´µ÷Õû ................................................................................................................................................................................... 15 4¡¢Á¢¼´¸ü¸ÄµÈ¼¶......................................................................................................................................................................... 16 5¡¢Á¢¼´¸ü¸Ä״̬......................................................................................................................................................................... 17 6¡¢Á¢¼´Òƶ¯ ................................................................................................................................................................................ 18 7¡¢ ÑÓÆÚ´´½¨ ........................................................................................................................................................................ 19 8¡¢ ÑÓÆÚµ÷Õû ........................................................................................................................................................................ 20 9¡¢ ÑÓÆÚ¸ü¸ÄµÈ¼¶ ................................................................................................................................................................ 21 10¡¢ ÑÓÆÚÒÆ¶¯ ........................................................................................................................................................................ 22 11¡¢ ÑÓÆÚ¸ü¸Ä״̬ ................................................................................................................................................................ 23 12¡¢ ÑÓÆÚÒµÎñÌá½»ÈÕÖ¾......................................................................................................................................................... 24 1¡¢ 2¡¢ 3¡¢ 4¡¢
³ÉÅúÒÆ¶¯ ........................................................................................................................................................................ 26 ³ÉÅú¸ü¸Ä״̬ ................................................................................................................................................................ 26 ³ÉÅú¸ü¸ÄµÈ¼¶ ................................................................................................................................................................ 27 ÑÓÆÚÒµÎñ ........................................................................................................................................................................ 28
³ÉÅúÊÂÎï´¦Àí .................................................................................................................................................................. 25
¿â´æ×ªÒÆ .......................................................................................................................................................................... 28
1¡¢²Ù×÷·¾¶ ................................................................................................................................................................................ 28 2¡¢¶¨Òå×ªÒÆÐÅÏ¢......................................................................................................................................................................... 29 3¡¢È·ÈÏ·¢·Å×ªÒÆ......................................................................................................................................................................... 31 4¡¢ ½ÓÊÕ×ªÒÆ ........................................................................................................................................................................ 32
UNIT5 ¿â´æ²éѯ ................................................................................................................................................................. 33 ¸ÅÊö .................................................................................................................................................................................. 33
¿â´æÄ£¿éÖÐÌṩÁ½ÖÖ²éѯ·½Ê½£º ............................................................................................................................................... 33 Ö÷ÒªµÄ²éѯ¹¦ÄÜΪ£º ................................................................................................................................................................... 33 1¡¢ 2¡¢ 3¡¢ 4¡¢ 5¡¢ 6¡¢
¿â´æÁ¿²éѯ .................................................................................................................................................................... 33 ²éѯÏîÄ¿¿â´æÐÅÏ¢......................................................................................................................................................... 34 ¿â´æÊÂÎï´¦Àí¼Ç¼²éѯ ................................................................................................................................................. 35 Åú´ÎÀúÊ·¼Ç¼²éѯ......................................................................................................................................................... 37 Åú´Î/×ÓÅú´Î ................................................................................................................................................................... 41 ±¨±í²éѯ ........................................................................................................................................................................ 42
²éѯ¹¦ÄÜ .......................................................................................................................................................................... 33
UNIT6ʵµØÅ̵ã .................................................................................................................................................................. 43
¸ÅÊö .................................................................................................................................................................................. 43 Å̵㲽Öè .......................................................................................................................................................................... 43
UNIT7 ÖÜÆÚÅ̵ã ................................................................................................................................................................. 53 ¸ÅÊö .................................................................................................................................................................................. 53
ÖÜÆÚÅ̵㲽Ö裺........................................................................................................................................................................... 53 1¡¢ 2¡¢ 3¡¢ 4¡¢
¶¨ÒåABC¼¶±ð .............................................................................................................................................................. 53 ¶¨Òå¿ØÖÆ×é .................................................................................................................................................................... 54 ¶¨ÒåÅ̵ã·ÖÀà ................................................................................................................................................................ 54 ¶¨Òå²Ö¿â¹æÔò ................................................................................................................................................................ 55
1¡¢ 2¡¢ 3¡¢ 4¡¢ 5¡¢ 6¡¢ 7¡¢ 8¡¢ ¶¨ÒåʵµØÅ̵ã ................................................................................................................................................................ 43 ¶¨Òå/Æô¶¯Å̵ã ............................................................................................................................................................... 44 ´òӡʵµØÅ̵ã±íµ¥......................................................................................................................................................... 45 ¼ÈëÅ̵ãÊý¾Ý ................................................................................................................................................................ 47 ´òÓ¡Å̵ã¼Èë ................................................................................................................................................................ 48 Ìá½»Å̵ãµ÷Õû ................................................................................................................................................................ 50 Çå³ýÅ̵ãÊý¾Ý ................................................................................................................................................................ 51 ²éѯÅ̵ãµ÷Õû¿â´æ¼Ç¼ ................................................................................................................................................. 51
ǰÌáÌõ¼þ .......................................................................................................................................................................... 53
ÖÜÆÚÅ̵㲽Öè .................................................................................................................................................................. 55
1¡¢ ¶¨ÒåÖÜÆÚ ........................................................................................................................................................................ 55 2¡¢ ³õʼ»¯ÖÜÆÚÅ̵ã ............................................................................................................................................................ 56 3¡¢ ´òÓ¡ÖÜÆÚÅ̵ã±íµ¥......................................................................................................................................................... 57 4¡¢ ¼ÈëÅ̵ãÊýÁ¿ ................................................................................................................................................................ 59 5¡¢´òÓ¡Å̵ã¼Èë......................................................................................................................................................................... 60 6¡¢Ìá½»Éó¼Ç±¨¸æ......................................................................................................................................................................... 61 7¡¢Ìá½»µ÷Õû ................................................................................................................................................................................ 62 8¡¢²éѯÅ̵ãµ÷Õû¼Ç¼ ................................................................................................................................................................. 63
UNIT8 ¿â´æ»á¼ÆÆÚ ............................................................................................................................................................. 64 ¸ÅÊö .................................................................................................................................................................................. 64 ¹Ø±Õ¿â´æ»á¼Æ .................................................................................................................................................................. 64
²Ù×÷·¾¶£ºOPM¿â´æ¿ØÖÆ/¿â´æ¹Ø±Õ ........................................................................................................................................ 64
UNIT9 ÆäËû ......................................................................................................................................................................... 66
ii
UNIT1 ¿â´æÄ£¿é¸ÅÊö
»ù±¾¸ÅÄî
ORACLEϵͳÖÐÉæ¼°µ½µÄ×éÖ¯ÓйظÅÄîÖ÷Òª°üÀ¨£º
×éÖ¯ Organization£¬ÔÚOracleÓ¦ÓÃϵͳÖУ¬¿ÉÓÃ×éÖ¯À´±íʾһ¸öµ¥Î»£¬Ò»¸ö¹«Ë¾£¬»òÕßÊÇÒ»¸ö¼¯ÍŹ«Ë¾£¬Ò²¿ÉÒÔÖ»Êǹ«Ë¾µÄÒ»¸ö²¿ÃÅ£¬»òÕßÒ»¸öÐéÄâµÄ»ú¹¹£¬¸Ã¹«Ë¾/²¿ÃÅ/»ú¹¹µÄËùÓÐÒµÎñ¶¼¼Ç¼ÔÚÏàÓ¦µÄ×é֯ϡ£
×éÖ¯·ÖÀà Organization Classification£¬×éÖ¯ÔÚORACLEÓ¦ÓÃϵͳÖдæÔÚ·ÖÀ࣬ÀýÈ磺ҵÎñ×飬·¨ÈËʵÌ壬 ¾Óªµ¥Î»£¬ ¿â´æ×éÖ¯µÈµÈ¡£ÏµÍ³Í¨¹ý×éÖ¯µÄ·ÖÀàÀ´¿ØÖƲ»Í¬µÄÒµÎñÊý¾ÝÊÇÓ¦¸ÃÔÚÔõÑùµÄ×é֯Ϲ²ÏíºÍÆÁ±ÎµÄ¡£
ÒµÎñ×é Business Group£¬ÊÇ×éÖ¯µÄÒ»ÖÖ·ÖÀ࣬´ú±í¼¯ÍŹ«Ë¾£¬ÓÃÓÚ¸ôÀëÈËÊÂÐÅÏ¢¡£
Õʲ¾ Set of Books£¬Ê¹ÓÃij¸öÌØ¶¨»á¼Æ¿ÆÄ¿½á¹¹£¬±¾Î»±ÒºÍ»á¼ÆÈÕÀúµÄ²ÆÎñ±¨¸æµ¥Î»¡£
·¨ÈËʵÌå Legal Entity£¬Ò»¸ö¿É¶ÀÁ¢ºËËãµÄ¹«Ë¾£¬´æÔÚ¶ÀÁ¢Õʱ¾µÄ¹«Ë¾¡£ÊôÓÚ·¨ÈËʵÌåµÄ×éÖ¯±ØÐëÖ¸¶¨Õʱ¾£¬¾ßÌåµÄ¾ÓªÒµÎñ²»Ö±½ÓÔڸ÷ÖÀà×éÖ¯Öз´Ó³¡£
¾Óªµ¥Î» Operating Unit£¬¸ºÔð¾ßÌåÒµÎñµÄ¹«Ë¾£¬±ÈÈç²É¹º£¬Ó¦¸¶£¬ÏúÊÛ£¬Ó¦ÊÕÒµÎñ¡£ÊôÓÚ¾Óªµ¥Î»µÄ×éÖ¯±ØÐëÖ¸¶¨ÊôÓÚÄĸö·¨ÈËʵÌå¡£ ¿â´æ×éÖ¯ Inventory Organization£¬¹ÜÀí¸Ã¹«Ë¾ÏÂËùÓÐÎïÆ·µÄ¿â´æÒµÎñ£¬ÊôÓÚ¿â´æ×éÖ¯µÄ×éÖ¯±ØÐëÖ¸¶¨ÊôÓÚÄĸö·¨ÈËʵÌåºÍ¾Óªµ¥Î»¡£¸Ã¹«Ë¾ÏµIJֿ⽫´ÓÊôÓÚ¸Ã¿â´æ×éÖ¯£¬¼´²Ö¿â¿ÉÒÔ°´¿â´æ×éÖ¯·Ö±ð¹ÜÀí¡£
¿â´æÖ÷×éÖ¯ Item Master Organization£¬¸Ã×éÖ¯ÓÃÀ´¹ÜÀíËùÓÐÎïÆ·µÄ±ê×¼»¯¶¨Òå¡£¿â´æÖ÷×éÖ¯¿ÉÒÔÊÇʵ¼Ê´æÔÚµÄÒ»¼Ò¹«Ë¾£¬Ò²¿ÉÒÔÊÇÒ»¸öÐéÄâµÄ×éÖ¯£¬¼´²»´æÔÚʵ¼ÊµÄÒ»¸ö¹«Ë¾Óë¿â´æÖ÷×éÖ¯¶ÔÓ¦£¬¸Ã×éֻ֯ΪÁËͳһ¶¨ÒåÕû¸ö¼¯ÍŹ«Ë¾ËùʹÓõÄÎïÆ·¶ø´æÔÚ¡£ OPM¹«Ë¾£¬ÔÚOPMϵͳÖй«Ë¾¶ÔÓ¦ÓÚOAÖеľӪµ¥Î»£» OPM¹¤³§£¬¹¤³§Îª¹«Ë¾×éÖ¯µÄÏÂÊôµ¥Î»£» OPM²Ö¿â£¬¶ÔÓ¦OAÖÐµÄ¿â´æ×éÖ¯£» OPMµØµã£¬¶ÔÓ¦OAÖÐµÄ¿â´æ»õ룬
3
×éÖ¯¶ÔӦͼ
ÕÊÌ×ORACLE OAORACLE OPM·¨ÈËʵÌ幫˾¾Óªµ¥Î»¹¤³§¿â´æ×éÖ¯1¿â´æ×éÖ¯2¿â´æ×éÖ¯1¿â´æ×éÖ¯2×Ó¿â´æ¿âλµØµã
4