ap导入 ebs oracle_Oracle EBS R12 通过供应商接口导入供应商

1.获取org_id,set_of_books_id,chart_of_accounts_id

Select * from org_organization_definitions;里面有

1.create table supplier_temp(suppliername varchar2(100),

num number,

country varchar2(100),

position varchar2(100),

adress varchar2(100),

bak1 varchar2(100),

bak2 varchar2(100));

2.select * from supplier_temp

for update;

3.把excel数据导入临时表中

4.记得跑TRUNCATE TABLE Ap.Ap_Suppliers_Int;

declare

begin

for item in (select * from supplier_temp) loop

insert into Ap_Suppliers_Int (vendor_interface_id,vendor_name,Segment1)

values (1,item.suppliername,item.num);

end loop;

end;

5.检查select * from Ap_Suppliers_Int;如果没问题就commit

6.运行请求:供应商开放接口导入

6.记得跑TRUNCATETABLE Ap.Ap_Supplier_Sites_Int;    --//[operating_unit]这玩意不一定一样

declare

vendorid number;

ccid1 number