Oracle EBS: 資料轉入manufacturer part (mtl_mfg_part_numbers)

要把資料批次轉入mtl_mfg_part_numbers, 先找找有沒有API.

有幾篇文章提到, 沒有API或interface可用.

再多看幾篇, 12.1.3及之後的版本有importing related items and cross references的功能, 但現行使用中的版本就沒這麼新, 直接忽略.

由於table看起來不複雜, 直接寫入資料應也不會有大問題.

再找找, 有人分享用系統標準程式的作法, mtl_mfg_part_numbers_pkg.insert_row , 測試的結果正常, 真是感恩~


DECLARE
   l_rowid   VARCHAR2 (30);
BEGIN
   fnd_global.apps_initialize (1007941, 20567, 703);
   mtl_mfg_part_numbers_pkg.insert_row (l_rowid,
                                        69, --mfg_xref_load_rec.manufacturer_id,
                                        'Test Part', --mfg_xref_load_rec.ls_mfg_part_number,
                                        173, --mfg_xref_load_rec.inventory_item_id,
                                        SYSDATE,
                                        1007941,                  --l_user_id,
                                        SYSDATE,
                                        1007941,                  --l_user_id,
                                        1007941,                  --l_user_id,
                                        204, --mfg_xref_load_rec.organization_id,
                                        '',
                                        '',
                                        NULL, --mfg_xref_load_rec.ls_authorization_status,
                                        '',
                                        '',
                                        '',
                                        '',
                                        '',
                                        '',
                                        '',
                                        '',
                                        '',
                                        '',
                                        '',
                                        '',
                                        '',
                                        '');
   COMMIT;
END;


Ref:
1.Is it Possible to Populate MTL_MFG_PART_NUMBERS Using an API or Interface? (Doc ID 435146.1)

2.Need Interface Or API For Loading Manufacturers: MTL_MANUFACTURERS and MTL_MFG_PART_NUMBERS? (Doc ID 1338078.1)

3.Mfg Cross References Single Record Script
https://arunrathod.blogspot.com/2009/08/mfg-cross-references-single-record.html

4.cobra_utility_ebs.sql
https://github.com/AdriRibeiro/PROJETO_RICHFACES_DOTACAO/blob/master/CobraHrDotacao/src/java/br/com/cobra/sql/cobra_utility_ebs.sql