Shulou(Shulou.com)05/31 Report--

In this issue, the editor will bring you how to understand the processing of receivables in EBS interface development. The article is rich in content and analyzed and described from a professional point of view. I hope you can get something after reading this article.

(1) introduction to Common Standard Table of Receivables 1.1 Common Standard Table

The tables and instructions related to the processing of receivables are listed in the following table:

Table name

Description

Additional information

AR_BATCHES_ALL

AR collection approval form

AR_BATCH_SOURCES_ALL

AR collection type table

Corresponding view

AR_CASH_RECEIPTS_ALL

AR collection table

Corresponding view

AR_CASH_RECEIPT_HISTORY_ALL

AR Collection History Table

Corresponding view

AR_MISC_CASH_DISTRIBUTIONS_ALL

AR Miscellaneous Collection allocation Table

Corresponding view

AP_BANK_ACCOUNTS_ALL

AR remittance bank

Corresponding view

AR_RECEIPT_METHODS

AR collection classification

Corresponding view

1.3 A general introduction to the fields in the table 1.3 description

Only most common tables related to the processing of receivables are listed here. There are some infrequently used ones that are not covered. For more information, please refer to the

II) A brief introduction to the API2.1 of Receivable processing

Create a collection

AR_RECEIPT_API_PUB.CREATE_CASH

Write-off of INVOICE receivable

AR_RECEIPT_API_PUB.APPLY

Create and write off INVOICE at the same time

AR_RECEIPT_API_PUB.CREATE_AND_APPLY

Cancel write-off of INVOICE

AR_RECEIPT_API_PUB. UNAPPLY

Write-off collection

AR_RECEIPT_API_PUB. REVERSE

Write-off account

AR_RECEIPT_API_PUB. APPLY_ON_ACCOUNT

Cancel the write-off account

AR_RECEIPT_API_PUB. UNAPPLY_ON_ACCOUNT

Write-off activity

AR_RECEIPT_API_PUB. ACTIVITY_APPLICATION

Create miscellaneous receipts

AR_RECEIPT_API_PUB. CREATE_MISC

Write off other account activities

AR_RECEIPT_API_PUB. APPLY_OTHER_ACCOUNT

Cancel the cancellation of other accounts

AR_RECEIPT_API_PUB. UNAPPLY_OTHER_ACCOUNT

Write-off cash receipts to write off other receipts

AR_RECEIPT_API_PUB. APPLY_OPEN_RECEIPT

Cancel write-off of cash receipts to write off other receipts

AR_RECEIPT_API_PUB. UNAPPLY_OPEN_RECEIPT

AR_RECEIPT_API_PUB. CREATE_APPLY_ON_ACC

Write-off to INVOICE line details

AR_RECEIPT_API_PUB. APPLY_IN_DETAIL

(3) accounts receivable processing API3.1 AR_RECEIPT_API_PUB. Create_cash

This API can create one collection at a time, and after successful creation, the status is not written off.

This API can only create one collection at a time, not a collection batch.

AR_RECEIPT_API_PUB. PROCEDURE Create_cash (--Standard API parameters. P_api_version IN NUMBER, p_init_msg_list IN VARCHAR2: = FND_API.G_FALSE, p_commit IN VARCHAR2: = FND_API.G_FALSE, x_return_status OUT NOCOPY VARCHAR2, x_msg_count OUT NOCOPY NUMBER, x_msg_data OUT NOCOPY VARCHAR2 -- Receipt info. Parameters p_currency_code IN VARCHAR2 DEFAULT NULL, p_amount IN NUMBER DEFAULT NULL, p_receipt_number IN VARCHAR2 DEFAULT NULL, p_receipt_date IN DATE DEFAULT NULL, p_gl_date IN DATE DEFAULT NULL P_customer_number IN VARCHAR2 DEFAULT NULL, p_receipt_method_id IN NUMBER DEFAULT NULL, p_cr_id OUT NOCOPY NUMBER)

Contains only the main parameters

X_return_status API return status x_msg_count API return information quantity x_msg_data API return message content p_currency_code currency value source select currency_code from fnd_currencies P_receipt_number collection number p_receipt_date collection date p_gl_date entry date p_customer_number customer code value source select b.account_numberfrom hz_parties a department custworthy collection bwhere a.party_name ='& Customer_name'and a.party_id = b.party_idp_receipt_method_id collection method value source select receipt_method_id from ar_receipt_methods After the collection IDAPI returned by p_cr_id is successful, the data will be submitted to the API code instance DECLARE l_return_status VARCHAR2 (1); l_msg_count NUMBER; l_msg_data VARCHAR2 (240,240); l_cash_receipt_id NUMBER; p_count number: = 0 AR' begin-- 1) Set the applications context mo_global.init ('AR') -- initialize MOAC mo_global.set_policy_context ('slots,' 261');-- 261 is the ID fnd_global.apps_initialize of OU (2125, 51260, 280,0) -- 2125 is USER_ID,51260 is application_id-- 2) Call the API AR_RECEIPT_API_PUB.CREATE_CASH (p_api_version = > 2125, p_init_msg_list = > FND_API.G_TRUE, p_commit = > FND_API.G_TRUE, p_validation_level = > FND_API.G_VALID_LEVEL_FULL, x_return_status = > l_return_status X_msg_count = > l_msg_count, x_msg_data = > l_msg_data, p_currency_code = > 'CNY', p_amount = > 10000, p_receipt_number = >' TEST20120120', p_receipt_date = >'20-01-2012, p_gl_date = >'20-01-2012, p_customer_number = > 1945, p_receipt_method_id = > 2004 P_cr_id = > l_cash_receipt_id) -- 3) Review the API output dbms_output.put_line ('Status' | | l_return_status); dbms_output.put_line ('Cash Receipt id' | | l_cash_receipt_id); dbms_output.put_line ('Message count' | | l_msg_count); if l_msg_count = 1 Then dbms_output.put_line ('l_msg_data' | | l_msg_data) Elsif l_msg_count > 1 Then loop p_count: = p_count + 1; l_msg_data: = FND_MSG_PUB.Get (FND_MSG_PUB.G_NEXT,FND_API.G_FALSE); if l_msg_data is NULL then exit; end if; dbms_output.put_line ('Message' | | p_count | |'. '| | l_msg_data); end loop; end if; END

3.2 AR_RECEIPT_API_PUB.APPLYAPI description

You can cancel one INVOICE at a time by changing API. If you need to write off more than one INVOICE, you can call it in a loop.

API code details AR_RECEIPT_API_PUB.APPLY (p_api_version IN NUMBER, p_init_msg_list IN VARCHAR2: = FND_API.G_FALSE, p_commit IN VARCHAR2: = FND_API.G_FALSE, p_validation_level IN NUMBER: = FND_API.G_VALID_LEVEL_FULL, p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPEDEFAULT NULL P_customer_trx_id INra_customer_trx.customer_trx_id%TYPE DEFAULT NULL, p_amount_applied INar_receivable_applications.amount_applied%TYPE DEFAULT NULL, x_return_status OUTNOCOPY VARCHAR2, x_msg_count OUTNOCOPY NUMBER,x_msg_data = > OUTNOCOPY VARCHAR2) These are the accounts receivable processing that Xiaobian shared with you about how to understand EBS interface development. If you happen to have similar doubts, you might as well refer to the above analysis to understand. If you want to know more about it, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.