Invoices was not created from Sales order(Autoimport and AutoInvoices)

We are having a custom process from which Order numbers will be generated and then automatically Invoices will be created through AutoInvoice Process

Now the Invoices were not created for 1 week of records and again the invoices get started to get created.

After that for 1 week we tried to create Auto Invoice but the records were not taken as it has been already processed.

So we have taken the selected records from ra_interface_lines_all table and the we applied the below script

UPDATE ra_interface_lines_all
SET request_id = NULL,
customer_trx_id = NULL,
request_id = NULL,
link_to_line_id = NULL
WHERE interface_line_id IN
(SELECT interface_line_id
FROM ra_interface_lines_all
WHERE     trx_date >= TO_DATE (’01-SEP-2016′, ‘DD-MON-YYYY’)
AND interface_status IS NULL);

So this will remove the processed flags of the receivable interface data and show it as a fresh one so the AutoImport or AutoInvoice Program will again fetch the same records.



About pacesettergraam

A good and realistic person

Posted on October 5, 2016, in Oracle, oracle apps and tagged , , , , , , . Bookmark the permalink. Leave a comment.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: