Home » Applications » Oracle Fusion Apps & E-Business Suite » Autolockbox Validation
Autolockbox Validation [message #236972] Fri, 11 May 2007 08:19 Go to next message
kuda.oracleapps@gmail.com
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
vin_odks
Messages: 153
Registered: July 2006
Location: -
Senior Member
Hi,
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.



Regards
Vinod
Previous Topic: Data Loader
Next Topic: AP : Can not Validate APP-SQLAP-10000: ORA-06511 : PL/SQL
Goto Forum:
  


Current Time: Sat Dec 10 14:25:41 CST 2016

Total time taken to generate the page: 0.09568 seconds