Oracle EBS中通过API创建销售订单的示例-优快云博客

本文链接：https://blog.youkuaiyun.com/chosen1brain/article/details/46544877

该博客展示了如何在Oracle E-Business Suite (EBS) 中使用API创建销售订单。通过初始化环境、设置订单头和行记录，然后调用oe_order_pub过程来处理订单。示例代码包括了必要的变量声明、用户和责任ID的获取，以及订单详细信息的填充。最后，检查API调用返回的状态，确定订单创建是否成功。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

DECLARE
  v_api_version_number NUMBER := 1;
  v_return_status      VARCHAR2(2000);
  v_msg_count          NUMBER;
  v_msg_data           VARCHAR2(2000);
  -- IN Variables --
  v_header_rec         oe_order_pub.header_rec_type;
  v_line_tbl           oe_order_pub.line_tbl_type;
  v_action_request_tbl oe_order_pub.request_tbl_type;
  v_line_adj_tbl       oe_order_pub.line_adj_tbl_type;
  -- OUT Variables --
  v_header_rec_out             oe_order_pub.header_rec_type;
  v_header_val_rec_out         oe_order_pub.header_val_rec_type;
  v_header_adj_tbl_out         oe_order_pub.header_adj_tbl_type;
  v_header_adj_val_tbl_out     oe_order_pub.header_adj_val_tbl_type;
  v_header_price_att_tbl_out   oe_order_pub.header_price_att_tbl_type;
  v_header_adj_att_tbl_out     oe_order_pub.header_adj_att_tbl_type;
  v_header_adj_assoc_tbl_out   oe_order_pub.header_adj_assoc_tbl_type;
  v_header_scredit_tbl_out     oe_order_pub.header_scredit_tbl_type;
  v_header_scredit_val_tbl_out oe_order_pub.header_scredit_val_tbl_type;
  v_line_tbl_out               oe_order_pub.line_tbl_type;
  v_line_val_tbl_out           oe_order_pub.line_val_tbl_type;
  v_line_adj_tbl_out           oe_order_pub.line_adj_tbl_type;
  v_line_adj_val_tbl_out       oe_order_pub.line_adj_val_tbl_type;
  v_line_price_att_tbl_out     oe_order_pub.line_price_att_tbl_type;
  v_line_adj_att_tbl_out       oe_order_pub.line_adj_att_tbl_type;
  v_line_adj_assoc_tbl_out     oe_order_pub.line_adj_assoc_tbl_type;
  v_line_scredit_tbl_out       oe_orde