Home » Applications » Oracle Fusion Apps & E-Business Suite » Autolockbox Validation
Autolockbox Validation [message #236972] Fri, 11 May 2007 08:19 Go to next message
Messages: 10
Registered: May 2007
Junior Member
Could someone please tell me how to validate that a customer already exist in the system. I am importing receipts via Autolockbox and have created a staging table ar_payments_iface that resembles ar_payments_interface_all. I would also like to know the sql statement that would validate the receipt number for me. I would appreciate any help as I have to have this completed by next Monday, so it is rather urgent. Thanks
So far this is the code I have.

--cursor to select the records to be validated
CURSOR cur_rcpt IS
SELECT a.* FROM ar_payments_iface a
WHERE nvl(a.process_flag,'E') = 'E';

-- Cursor to check the active customer already exists
CURSOR get_cust(p_cust_ref IN ra_customers.customer_number%TYPE) IS
SELECT hca.cust_account_id
FROM hz_cust_accounts hca
WHERE hca.orig_system_reference = p_cust_ref
AND hca.status = 'A';
Re: Autolockbox Validation [message #237879 is a reply to message #236972] Wed, 16 May 2007 01:20 Go to previous message
Messages: 153
Registered: July 2006
Location: -
Senior Member
There are many other validation to be performed for auto lock box

1) Validate operating unit (org_id)
2) Validate Exchange rate (Functional and entered currency)
3) valdiate Cross currency (Invoice currency is different from Receipt currency)
4) Validate sum of remittance amount does not exceed the applied amounts
5) Validate customer reference with BILL_TO usage
6) Validate customer account number
7) Validate if invoice number is valid
Cool As far as the receipt number is concerned , they are usually the check number provided ..
9) Generate Item number ,overflow indicator,Overflow sequence
10) Much more depends on your Lock box transmission formats.

Previous Topic: Oracle financials 11.i
Next Topic: What are the develop tools of Oracle EBS R12 customize?
Goto Forum:

Current Time: Sat Aug 19 13:53:42 CDT 2017

Total time taken to generate the page: 0.01029 seconds