Creating a blog is not just a hobby it’s a partnership to grow together.
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';
Subscribe to:
Posts (Atom)