Monday, March 11, 2013

Autoinvoice Error The Bill To address id must exist in Oracle Receivables



If this is setup, then please check that the value in the interface table RA_INTERFACE_LINES_ALL
for columns ORIG_SYSTEM_BILL_CUSTOMER_ID and ORIG_SYSTEM_BILL_ADDRESS_ID has a value that is seen in columns
CUST_ACCT_SITE_ID and CUST_ACCOUNT_ID in the table HZ_CUST_ACCT_SITES_ALL.


select  ORIG_SYSTEM_BILL_CUSTOMER_ID ,
        ORIG_SYSTEM_BILL_ADDRESS_ID ,
        ORIG_SYSTEM_SHIP_CUSTOMER_ID ,
        ORIG_SYSTEM_SHIP_ADDRESS_ID  
from RA_INTERFACE_LINES_ALL
 where interface_line_id = 639754

update RA_INTERFACE_LINES_ALL
set ORIG_SYSTEM_BILL_ADDRESS_ID =  1818
where interface_line_id = 639754

 commit

 rollback

ORIG_SYSTEM_BILL_ADDRESS_ID     1818
ORIG_SYSTEM_BILL_CUSTOMER_ID    1816

select
      c.cust_acct_site_id orig_system_bill_address_id,
      b.cust_account_id orig_system_bill_customer_id
from
      hz_parties a,
      hz_cust_accounts b,
      hz_cust_acct_sites_all c,
      hz_cust_site_uses_all d
where
      a.party_name = '&Customer_Name'  --Enter Your Customer Name Here
and a.party_id = b.party_id
and c.cust_account_id = b.cust_account_id
and c.cust_acct_site_id = d.cust_acct_site_id
and d.site_use_code = 'BILL_TO';