費(fèi)用采購訂單導(dǎo)入和接收

1、費(fèi)用采購訂單創(chuàng)建和接收文檔作者:孫令朝創(chuàng)建日期:2017-08-27更新日期:2017-08-27當(dāng)前版本:1.0文檔控制更改記錄日期作者版本更改參考2017-08-27孫令朝1.0審閱姓名職位簽字分布編碼姓名地點(diǎn)和位置目錄文檔控制1更改記錄1審閱1分布1目錄11文檔簡介11.1 項(xiàng)目背景11.2 范圍11.3 相關(guān)文檔12費(fèi)用采購介紹22.1 費(fèi)用物料介紹22.2費(fèi)用采購類型23 采購訂單的導(dǎo)入44 采購訂單的接收75未解決的問題115.1 未解決的問題111 文檔簡介1.1 項(xiàng)目背景費(fèi)用采購在企業(yè)中也有部分存在，本穩(wěn)定對于費(fèi)用采購的創(chuàng)建和接收進(jìn)行了驗(yàn)證。1.2 范圍本文檔適用于涉及到費(fèi)用采

2、購訂單的創(chuàng)建本文檔是基于版本的EBS作以總結(jié)。1.3 相關(guān)文檔無2 費(fèi)用采購介紹費(fèi)用采購是采購訂單的一種，與標(biāo)準(zhǔn)采購訂單不同的是費(fèi)用采購訂單所采購的物料為費(fèi)用物料。2.1 費(fèi)用物料介紹費(fèi)用采購的使用業(yè)務(wù)場景：企業(yè)存在著低值易損耗，服務(wù)性質(zhì)的采購。針對這種采購，不需要?jiǎng)?chuàng)建過多的物料編碼，只有財(cái)務(wù)管理財(cái)務(wù)信息的需求，對于庫存沒有管理的必要。費(fèi)用物料主要體現(xiàn)在物料的屬性上面。2.2費(fèi)用采購類型費(fèi)用物料有三種類型，分別適用于不同的業(yè)務(wù)場景：1.存在著物料編碼，但是僅記賬 物料屬性中的庫存物料、庫存資產(chǎn)、計(jì)算成本不勾選，同時(shí)需要設(shè)置費(fèi)用賬戶2.存在物料編碼，記賬的同時(shí)還要體現(xiàn)庫存 物料屬性中庫存資產(chǎn)、計(jì)

3、算成本不勾選；庫存物料和費(fèi)用賬戶需要設(shè)置3.不存在物料編碼，常為服務(wù)類的采購采購訂單行的單價(jià)不能修改為固定值，只能修改數(shù)量。本文檔這次測試的是第一種情況，對應(yīng)的物料屬性設(shè)置如下圖所示3 采購訂單的導(dǎo)入對費(fèi)用物料創(chuàng)建采購訂單時(shí)和通常的物料創(chuàng)采購訂單沒有區(qū)別需要注意的是必須給采購訂單行上面的借記賬戶賦值測試SQL（已在R11上測試通過）Declarel_Iface_RecPo.Po_Headers_Interface%Rowtype;l_Iface_Lines_RecPo.Po_Lines_Interface%Rowtype;l_Iface_Dis_RecPo.Po_Distributions_I

4、nterface%Rowtype;g_User_IdNumber :=Fnd_Global.User_Id;l_Iface_Header_IdNumber;l_Iface_Line_IdNumber;g_Session_IdNumber :=Userenv(SESSIONID);l_Line_NumNumber;l_Variance_Account_Id Number;BeginFnd_Global.Apps_Initialize(User_Id= 2040,Resp_Id=50352,Resp_Appl_Id = 201);Select Po_Headers_Interface_s.Next

5、val Intol_Iface_Header_Id From Dual;l_Iface_Rec:= Null;l_Iface_Rec.Creation_Date:= Sysdate;l_Iface_Rec.Last_Update_Date := Sysdate;l_Iface_Rec.Created_By:= g_User_Id;l_Iface_Rec.Last_Updated_By:= g_User_Id;l_Iface_Rec.Interface_Header_Id:=l_Iface_Header_Id;l_Iface_Rec.Org_Id:= 82;l_Iface_Rec.Process

6、_Code:= PENDING;l_Iface_Rec.Action:= ORIGINAL;l_Iface_Rec.Document_Type_Code:= STANDARD;l_Iface_Rec.Document_Num:= Null;l_Iface_Rec.Approval_Status:= APPROVED;l_Iface_Rec.Agent_Id:= 4088; -周康l_Iface_Rec.Vendor_Num:= 04015005;l_Iface_Rec.Vendor_Id:= 4233;l_Iface_Rec.Ship_To_Location_Id:= 8666; -專用車部l

7、_Iface_Rec.Bill_To_Location_Id:= 141; -陜重汽東廠l_Iface_Rec.Comments:= Null;l_Iface_Rec.Currency_Code:= CNY;l_Iface_Rec.Interface_Source_Code :=DMSWG_IMPORT;l_Iface_Rec.Attribute3:= 041; -業(yè)務(wù)部門：銷售_專用車部-l_Iface_Rec.Attribute15:= DMSWG_|l_Po_Inference_Id;l_Iface_Rec.Note_To_Receiver := 銷司專用車部;l_Iface_Rec.B

8、atch_Id:= g_Session_Id;Insert Into Po.Po_Headers_Interface Valuesl_Iface_Rec;l_Line_Num := 1;l_Iface_Lines_Rec:= Null;l_Iface_Lines_Rec.Creation_Date:= Sysdate;l_Iface_Lines_Rec.Last_Update_Date := Sysdate;l_Iface_Lines_Rec.Created_By:= g_User_Id;l_Iface_Lines_Rec.Last_Updated_By:= g_User_Id;l_Iface

9、_Lines_Rec.Interface_Line_Id:=l_Iface_Line_Id;l_Iface_Lines_Rec.Interface_Header_Id :=l_Iface_Header_Id;l_Iface_Lines_Rec.Process_Code:=PENDING;l_Iface_Lines_Rec.Action:=ORIGINAL;l_Iface_Lines_Rec.Line_Num:=l_Line_Num;l_Iface_Lines_Rec.Item:=WGDX0000000000002;l_Iface_Lines_Rec.Vendor_Product_Num:=24

10、00*3200;l_Iface_Lines_Rec.Uom_Code:= Pcs;l_Iface_Lines_Rec.Note_To_Vendor:=CK-2017;l_Iface_Lines_Rec.Promised_Date:=Sysdate;l_Iface_Lines_Rec.Need_By_Date:=Sysdate;l_Iface_Lines_Rec.Shipment_Num:= 1;l_Iface_Lines_Rec.Quantity:= 2;l_Iface_Lines_Rec.Unit_Price:=1000;l_Iface_Lines_Rec.Ship_To_Organizat

11、ion_Id := 85;l_Iface_Lines_Rec.Taxable_Flag:=Y;l_Iface_Lines_Rec.Tax_Name:=VAT17;Insert Into Po_Lines_Interface Valuesl_Iface_Lines_Rec;l_Iface_Dis_Rec := Null;l_Iface_Dis_Rec.Creation_Date:= Sysdate;l_Iface_Dis_Rec.Last_Update_Date := Sysdate;l_Iface_Dis_Rec.Created_By:= g_User_Id;l_Iface_Dis_Rec.L

12、ast_Updated_By:= g_User_Id;Into l_Iface_Dis_Rec.Interface_Distribution_IdFrom Dual;BeginSelect Msi.Expense_AccountInto l_Variance_Account_Id -費(fèi)用賬戶idFrom Mtl_System_Items_b MsiWhere Msi.Segment1 = WGDX0000000000002 And Msi.Organization_Id= 85;ExceptionWhen Others ThenNull;End;l_Iface_Dis_Rec.Interfac

13、e_Header_Id :=l_Iface_Header_Id;l_Iface_Dis_Rec.Interface_Line_Id:=l_Iface_Line_Id;l_Iface_Dis_Rec.Quantity_Ordered:=l_Iface_Lines_Rec.Quantity;l_Iface_Dis_Rec.Distribution_Num:= 1;l_Iface_Dis_Rec.Quantity_Delivered:= 0;l_Iface_Dis_Rec.Quantity_Billed:= 0;l_Iface_Dis_Rec.Quantity_Cancelled:= 0; -Mus

14、tBe 0-L_Iface_Dis_Rec.Charge_Account_Id:= 40693;-L_Iface_Dis_Rec.Accrual_Account_Id:= 1121;l_Iface_Dis_Rec.Charge_Account_Id :=l_Variance_Account_Id;-l_Iface_Dis_Rec.Variance_Account_Id :=l_Variance_Account_Id;Insert Into Po.Po_Distributions_Interface Valuesl_Iface_Dis_Rec;l_Line_Num := l_Line_Num +

15、 1; -End If;Commit; -call apiPo_Docs_Interface_Sv5.Process_Po_Headers_Interface(x_Selected_Batch_Id= g_Session_Id,x_Buyer_Id= Null,x_Document_Type= STANDARD,x_Document_Subtype= Null,x_Create_Items= N,x_Create_Sourcing_Rules_Flag = Null,x_Rel_Gen_Method= Null,x_Approved_Status= APPROVED,x_Commit_Inte

16、rval= 1,x_Process_Code= PENDING,x_Interface_Header_Id= Null,x_Org_Id_Param= Null,x_Ga_Flag= Null);End;4 采購訂單的接收采購接收有三種類型，不同的類型賦不同的值。1。直接入庫的接收 rcv_transactions_interface.transaction_type:= RECEIVE;rcv_transactions_interface.auto_transact_code:= DELIVER;rcv_transactions_interface.destination_type_code

17、:= INVENTORY;2. 只完成接收，不入庫 rcv_transactions_interface.transaction_type:= RECEIVE;rcv_transactions_interface.auto_transact_code:= NULL;rcv_transactions_interface.destination_type_code:= RECEIVING ;3.|對于接收后需要入庫 rcv_transactions_interface.transaction_type:= DELIVER; rcv_transactions_interface.auto_trans

18、act_code:= NULL; rcv_transactions_interface.destination_type_code:= INVENTORY;費(fèi)用接收的時(shí)候不同的是對于 l_Iface_Rcv_Rec.Destination_Type_Code :=EXPENSE; -接收至費(fèi)用 因?yàn)槭琴M(fèi)用物料，設(shè)置的為庫存物料沒勾選，所以接收時(shí)不需要指定子庫。Declarel_ProgressVarchar2(200);x_Header_RecordRcv_Shipment_Header_Sv.Headerrectype;l_Iface_Rcv_RecRcv_Transactions_Inte

19、rface%Rowtype;x_Group_IdNumber;x_Shipment_Header_Id Number;l_Iface_Trxn_IdNumber;x_Request_IdNumber;l_Po_Header_IdNumber;l_Po_Line_IdNumber;l_Line_Location_IdNumber;l_Dis_IdNumber;l_Vendor_IdNumber;l_Item_IdNumber;l_Process_FlagVarchar2(32);l_Item_Uom_CodeVarchar2(32);l_StatusVarchar2(240);l_Message

20、Varchar2(2000);l_CntNumber;l_Transaction_TypeVarchar2(32);Beginx_Header_Record.Header_Record := Null;x_Header_Record.Error_Record:= Null;From Dual;Select Vendor_IdInto l_Vendor_IdFrom Po_Vendors PvWhere Pv.Segment1 = 04015005;test999;-Invoke APIRcv_Shipment_Header_Sv.Create_Shipment_Header(x_Header_

21、Record = x_Header_Record);Elsex_Shipment_Header_Id := Null;Return;End If;Into l_Iface_Trxn_IdFrom Dual;Select Msi.Primary_Unit_Of_MeasureInto l_Item_Uom_CodeFrom Mtl_System_Items_b Msi Where Msi.Organization_Id= 85And Msi.Inventory_Item_Id = 941481;-l_Progress:=Insert_Rcv_Trxn_Iface;l_Iface_Rcv_Rec:

22、=Null;l_Iface_Rcv_Rec.Last_Update_Date:=Sysdate;l_Iface_Rcv_Rec.Last_Updated_By:=-1;l_Iface_Rcv_Rec.Creation_Date:=Sysdate;l_Iface_Rcv_Rec.Created_By:=-1;l_Iface_Rcv_Rec.Last_Update_Login:=-1;l_Iface_Rcv_Rec.Interface_Transaction_Id :=l_Iface_Trxn_Id;l_Iface_Rcv_Rec.Group_Id:=x_Group_Id;l_Iface_Rcv_

23、Rec.Shipment_Header_Id:=x_Shipment_Header_Id;l_Iface_Rcv_Rec.Transaction_Date:=Sysdate;l_Iface_Rcv_Rec.Processing_Status_Code:=PENDING;l_Iface_Rcv_Rec.Transaction_Status_Code :=PENDING;l_Iface_Rcv_Rec.Processing_Mode_Code:=BATCH;l_Iface_Rcv_Rec.Validation_Flag:=Y;l_Iface_Rcv_Rec.Transaction_Type:=RE

24、CEIVE;l_Iface_Rcv_Rec.Auto_Transact_Code:=DELIVER;l_Iface_Rcv_Rec.Destination_Type_Code:=EXPENSE;-目的地為費(fèi)用l_Iface_Rcv_Rec.Destination_Context:=EXPENSE;l_Iface_Rcv_Rec.Receipt_Source_Code :=VENDOR;l_Iface_Rcv_Rec.Vendor_Id:=l_Vendor_Id;-l_Iface_Rcv_Rec.Vendor_Site_Id:=11086;l_Iface_Rcv_Rec.Source_Docum

25、ent_Code := PO;l_Iface_Rcv_Rec.Po_Header_Id:=1367094;l_Iface_Rcv_Rec.Po_Line_Id:=2656091;l_Iface_Rcv_Rec.Po_Line_Location_Id:=2442218;l_Iface_Rcv_Rec.Po_Distribution_Id:=2437195;l_Iface_Rcv_Rec.Ship_To_Location_Id:= 8666;l_Iface_Rcv_Rec.To_Organization_Id:= 85;-l_Iface_Rcv_Rec.Subinventory:=Rec_Hdr.Subinv_Name;-費(fèi)用采購，不需要指定子庫l_Iface_Rcv_Rec.Item_Id:=941481;l_