chosen1brain的专栏

DECLARE l_return_status VARCHAR2(1); l_msg_count NUMBER; l_msg_data VARCHAR2(240); l_count NUMBER; l_cash_receipt_id NUMBER; l_msg_data_out VARCHAR2

declare p_api_version NUMBER := 1.0; p_init_msg_list VARCHAR2(1) := 'F'; x_return_status VARCHAR2(2000); x_msg_count NUMBER(5); x_msg_data VARCHAR2(2000); x_

客户联系方式，可以使用接口表ra_contact_phones_int_all导入结束之后，可以在表HZ_CONTACT_POINTS，通过owner_table_id（value for party_site_id）根据对ra_contact_phones_int_all表字段ORIG_SYSTEM_ADDRESS_REF的解读：Unique address identifier f

最近用了一个别人写的客户导入程序，大概流程是：1. 利用SQL Loader大批量将用户整理的客户主数据导入到客户化接口表2.在程序中验证某些字段成功后，插入标准接口表3.提交标准请求：Customer Interfaceln_request_id := fnd_request.submit_request( appl

DECLARE p_api_version NUMBER; p_init_msg_list VARCHAR2(200); p_commit VARCHAR2(200); p_validation_level NUMBER; x_return_status

DECLARE --8000000063 l_dummy varchar2(240); l_customer_trx_id ra_customer_trx.customer_trx_id%type; l_line_credits_flag ra_cm_requests.line_credits_flag%type; l_line_amount

创建收款可以使用API - ar_receipt_api_pub.create_cash但在跨ou的时候，比如我是ou_1,需要在程序中同时为ou_2,ou_3创建收款。如果创建的两个收款方法相同，会产生ERROR，根据matelink显示如下：iReceivables: No Data Found In Package AR_RECEIPT_API_PUB Procedure Creat

Run following API to create and complete a deposit. You need to enter a value for following parametes:currency_code: Currency Code for the Depositdeposit_amount: Amount of the Deposittrx_type_id

--Disable customer siteDECLARE lv_party_site_number VARCHAR2(30) := &p_party_site_number; lr_party_site_rec_type hz_party_site_v2pub.party_site_rec_type; lr_cust_acct_site_rec hz_cu

select hca.account_number CUSTOMER_NUMBER, hp.party_name CUSTOMER_NAME, --fcv.NAME CURRENCY_CODE, --TAX_RATE_CODE (select hcpa.TRX_CREDIT_LIMIT fro