开票平台oracle,无法正常开票 - Oracle ERP - ITPUB论坛－中国专业的IT技术社区

To implement the immediate solution (to enable you to invoice the problem order), please execute the following steps:

1. Please run the following script in your production environment, where your  problem order exists. (This script is contained in Note 278947.1 AutoInvoice Fails To Import Invoices Due To Missing Sales Credits Message)

insert into ra_interface_salescredits_all (interface_line_context ,

interface_line_attribute1 ,

interface_line_attribute2 ,

interface_line_attribute3 ,

interface_line_attribute4 ,

interface_line_attribute5 ,

interface_line_attribute6 ,

interface_line_attribute7 ,

interface_line_attribute8 ,

interface_line_attribute9 ,

interface_line_attribute10 ,

interface_line_attribute11 ,

interface_line_attribute12 ,

interface_line_attribute13 ,

interface_line_attribute14 ,

interface_line_attribute15,

sales_credit_percent_split,

sales_credit_type_id,

salesrep_id

)

select

interface_line_context context,

interface_line_attribute1 ,

interface_line_attribute2 ,

interface_line_attribute3 ,

interface_line_attribute4 ,

interface_line_attribute5 ,

interface_line_attribute6 ,

interface_line_attribute7 ,

interface_line_attribute8 ,

interface_line_attribute9 ,

interface_line_attribute10 ,

interface_line_attribute11 ,

interface_line_attribute12 ,

interface_line_attribute13 ,

interface_line_attribute14 ,

interface_line_attribute15 ,

'100',

'1', --SALES_CREDIT_TYPE_ID

'&salesrep_id' --SALESREP_ID <== this is the sales representative id for the sales person

--                                                         receiving the sales credit

from ra_interface_lines_all

where interface_line_attribute1= '&ORDER_NUMBER'

2. Once the scripts complete, confirm that the data is corrected.

You can use the following SQL to confirm:

select * from * from ra_interface_salescredits_all

where interface_line_attribute1= '&ORDER_NUMBER'

3. If you are satisfied with the results, issue a commit.

4. Confirm that sales order 14715 can now be interfaced to Accounts Receivable without error.