Browsing articles tagged with "alacaklar - orasistem | Oracle E-Business Suite Paylaşım Platformu"
May
5
2015

AR-GL interface alanlarının ilişkisi

USER_JE_CATEGORY_NAME = Adjustment Reference21 : POSTING_CONTROL_ID Reference22 : AR_ADJUSTMENTS.ADJUSTMENT_ID Reference23 : AR_DISTRIBUTIONS.LINE_ID Reference24 : RA_CUSTOMER_TRX.TRX_NUMBER Reference25 : AR_ADJUSTMENTS.ADJUSTMENT_NUMBER Reference26 : RA_CUST_TRX_TYPES.TYPE Reference27 : RA_CUSTOMER_TRX.BILL_TO_CUSTOMER_ID Reference28 : ‘ADJ’ Reference29 : ‘ADJ_’||AR_DISTRIBUTIONS.SOURCE_TYPE Reference30 : ‘AR_ADJUSTMENTS’ ——————————————— USER_JE_CATEGORY_NAME = Sales Invoice</strong> Reference21 : POSTING_CONTROL_ID Reference22 : RA_CUSTOMER_TRX.CUSTOMER_TRX_ID Reference23 : RA_CUST_TRX_LINE_GL_DIST.CUST_TRX_LINE_GL_DIST_ID Reference24 : RA_CUSTOMER_TRX.TRX_NUMBER Reference25 : HZ_CUST_ACCOUNTS.ACCOUNT_NUMBER Reference26 : […]

Şub
26
2014

Banka Oluşturma Script API

CREATE OR REPLACE PROCEDURE APPS.xxxt_ap_bank_branches_cnv_prc ( ERRBUF OUT VARCHAR2, RETCODE OUT VARCHAR2 ) AS l_branch_id NUMBER := 0; CURSOR csr_bankbranches IS SELECT A.BANK_NAME, A.BRANCH_NAME bank_branch_name, A.BANK_NO bank_number, A.BRANCH_NO BANK_NUM, NULL bank_branch_type, ‘BANK’ institution_type, NULL END_DATE, NULL eft_user_number, NULL eft_swift_code, NULL edi_id_number, NULL ece_tp_location_code, NULL description, NULL from XXXT.XXXT_BANK_BRANCH_CODES A; BEGIN FOR v_bankbranch IN csr_bankbranches LOOP […]

Şub
25
2014

Alacaklar Muhasebesinde Alınan Ödeme Oluşturmak İçin Kullanılan Script Örneği

DECLARE p_return_status VARCHAR2 (1000); x_return_status VARCHAR2 (4000); x_message_count NUMBER; x_msg_data VARCHAR2 (4000); p_cr_id NUMBER; BEGIN fnd_global.apps_initialize (user_id => 1097,  resp_id => 50239, resp_appl_id => 222 ); ar_receipt_api_pub.create_cash ( p_api_version => 1, x_return_status => x_return_status, x_msg_count => x_message_count, x_msg_data => x_msg_data, p_currency_code => ‘INR’, p_amount => 50000, p_receipt_number => ‘PDC/1’, –> alınanan ödemenin makbuz numarası p_receipt_date […]

Şub
21
2014

Alacaklar muhasebesi modülünden genel muhasebeye aktarımı yapılan kayıtların genel muhasebedeki referans alanları ile bağlantısı

USER_JE_CATEGORY_NAME = Adjustment Reference21 : POSTING_CONTROL_ID Reference22 : AR_ADJUSTMENTS.ADJUSTMENT_ID Reference23 : AR_DISTRIBUTIONS.LINE_ID Reference24 : RA_CUSTOMER_TRX.TRX_NUMBER Reference25 : AR_ADJUSTMENTS.ADJUSTMENT_NUMBER Reference26 : RA_CUST_TRX_TYPES.TYPE Reference27 : RA_CUSTOMER_TRX.BILL_TO_CUSTOMER_ID Reference28 : ‘ADJ’ Reference29 : ‘ADJ_’||AR_DISTRIBUTIONS.SOURCE_TYPE Reference30 : ‘AR_ADJUSTMENTS’ USER_JE_CATEGORY_NAME = Sales Invoice Reference21 : POSTING_CONTROL_ID Reference22 : RA_CUSTOMER_TRX.CUSTOMER_TRX_ID Reference23 : RA_CUST_TRX_LINE_GL_DIST.CUST_TRX_LINE_GL_DIST_ID Reference24 : RA_CUSTOMER_TRX.TRX_NUMBER Reference25 : HZ_CUST_ACCOUNTS.ACCOUNT_NUMBER Reference26 : ‘CUSTOMER’ […]

Şub
21
2014

Alacaklar Muhasebesi Faturası Oluşturmak İçin Kullanılan Paket ve Paketin Kullanım Örneği

Alacaklar faturası oluşturmak için R11 de doğrudan kullanılan program ar_invoice_api_pub.create_single_invoice aşağıda canlı bir uygulama örneğidir. program hata ile tamamlandığıda  aşağıdaki temp tablo aracılığı ile programın hataları  kontrol edilebilir select * from ar_trx_errors_gt;   declare p_trx_header_tbl ar_invoice_api_pub.trx_header_tbl_type; p_trx_lines_tbl ar_invoice_api_pub.trx_line_tbl_type; p_trx_dist_tbl ar_invoice_api_pub.trx_dist_tbl_type; p_trx_salescredits_tbl ar_invoice_api_pub.trx_salescredits_tbl_type; p_batch_source_rec ar_invoice_api_pub.batch_source_rec_type; p_msg_count NUMBER; p_msg_data VARCHAR2 (2000); l_cnt             […]