Autoinvoice Master Program Does Not Trigger Autoinvoice Import Program--已解决

 (1)

Applies to:

Oracle Receivables - Version: 11.5.10.2
This problem can occur on any platform.
RAXTRX - Autoinvoice Import Program
RAXMTR - Autoinvoice Master Program

Symptoms

Autoinvoice Master Program does not trigger Autoinvoice Import Program even though there is relevant data in AR Interface tables.

Cause

User is importing data into Receivables from 'Contra' Source and 'Contra' Interface Context.

Batch Source name and Interface Context passed in AR interface tables are 'Contra' and 'Contra' respectively.

The corresponding Batch Source name and Interface Context defined in AR are 'CONTRA' and 'CONTRA' respectively.

Since the Batch Source name and Interface Context defined in AR and the Batch Source name and Interface Context passed in AR interface tables were not exactly the same (upper/lower case), Autoinvoice does not picking records when submitted for Batch Source 'CONTRA' and Interface Context 'CONTRA'

Solution

Change the Batch Source name and Interface Context name used in AR to 'Contra' and 'Contra' respectively so that they are in sync with the data coming into AR Interface tables.

This will ensure that Autoinvoice picks the correct data from AR Interface tables.

This problem can occur with any Batch Source and Interface Context defined which are not exactly same as the data in AR Interface tables.

 

 

(2)

The Import program (RAXTRX) does not get spawned when I run AutoInvoice. What could be the reason?

In this case the Master Program (RAXMTR) may complete without error but will
not spawn the Import Program (RAXTRX). The log file for RAXMTR will show the
'No data Found' message.

AutoInvoice executes a statement similar to the following to select records
for importing:

SELECT COUNT(*)
FROM RA_INTERFACE_LINES
WHERE NVL(INTERFACE_STATUS, '~') != 'P'
AND (REQUEST_ID IS NULL)
AND BATCH_SOURCE_NAME = 'POS Batches'
AND LINK_TO_LINE_ATTRIBUTE1 IS NULL
AND LINK_TO_LINE_ATTRIBUTE2 IS NULL
.
.
AND LINK_TO_LINE_ATTRIBUTE15 IS NULL

(Please see the Master program log to see what the exact sql statement is for your specific case).

In the above example:
'POS Batches' is the Batch Source name.

In your case, there may be no records returned by the above statement, and
hence the 'NO Data Found' message. You can verify if there are records in the
interface table (RA_INTERFACE_LINES_ALL) to be imported by running the
following statement:

Select BATCH_SOURCE_NAME, INTERFACE_STATUS, REQUEST_ID
from RA_INTERFACE_LINES_ALL
where BATCH_SOURCE_NAME='&batch_source_name';

The INTERFACE_STATUS should not be P and the REQUEST_ID column should be NULL.

Moreover, also verify if the necessary attributes (ATTRIBUTE1-ATTRIBUTE15) are  NULL.

If you have interfaced orders from Order Entry, the records may not have been
populated into the interface table. Check the log of the Receivables Interface
process for any error messages even if the process completed successfully.

 

 

(3)

 

fact: Oracle Receivables

fact: RAXMTR - Autoinvoice Master Program

symptom: Autoinvoice Master Program Log File Shows No Data Found

symptom: Autoinvoice Import Program is not kicked off

fix:

SELECT batch_source_name, request_id, interface_status,
interface_line_id
FROM ra_interface_lines_all
WHERE batch_source_name = '&batch_source_name from log file';

Note:
The INTERFACE_STATUS should not equal 'P' and the REQUEST_ID column should
equal NULL. FYI: interface_line_id may need to be nulled out if still fails.

 

 

(4)

Applies to:

Oracle Receivables - Version: 11.5.9
This problem can occur on any platform.
EXECUTABLE:RAXDEL - Autoinvoice Purge Program
EXECUTABLE:RAXTRX - Autoinvoice Import Program

Symptoms

RA_INTERFACE_LINES_ALL shows some records which do not process.
It looks like they are not picked up by Autoinvoice and they also do not show any errors.

Cause

The lines could have been processed already, but have not been purged from the interface tables.
INTERFACE_STATUS= 'P' for those records

Solution

To implement the solution, please execute the following steps:

(1)
select count(*)  from ra_interface_lines_all
where interface_status = 'P'
and batch_source_name = '&your_Batch_Source_Name'
and org_id= &your_org_id;

(2) If count > 0 then true ==>  Run Autoinvoice Purge concurrent request program
(N) Control-> Autoinvoice-> Purge concurrent request program

(3) Recheck using above sql ==>  if record ct = 0, then Purge is successful.

 

 

(5)

Problem Description:
====================
In Oracle Accounts Receivable, you are importing invoices from a legacy system
using Autoinvoice, and the run completes normally, but log says
'No Data Found'

Problem Explanation:
====================
There is one line in the RA_DISTRIBUTIONS_ALL and one line in the
RA_INTERFACE_LINES.

Not generating an Autoinvoice Processing Report, and there is no Autoinvoice
validation report.

Autoinvoice results on 'No data found' when running the following select
statement.

SELECT COUNT(*)
from   ra_interface_lines
WHERE NVL(INTERFACE_STATUS, '~') != 'P'
AND (REQUEST_ID IS NULL
)
AND BATCH_SOURCE_NAME = 'POS Batches'
AND LINK_TO_LINE_ATTRIBUTE1 IS NULL
AND LINK_TO_LINE_ATTRIBUTE2 IS NULL
AND LINK_TO_LINE_ATTRIBUTE3 IS NULL
AND LINK_TO_LINE_ATTRIBUTE4 IS NULL
AND LINK_TO_LINE_ATTRIBUTE5 IS NULL
AND LINK_TO_LINE_ATTRIBUTE6 IS NULL
AND LINK_TO_LINE_ATTRIBUTE7 IS NULL
AND LINK_TO_LINE_ATTRIBUTE8 IS NULL
AND LINK_TO_LINE_ATTRIBUTE9 IS NULL
AND LINK_TO_LINE_ATTRIBUTE10 IS NULL
AND LINK_TO_LINE_ATTRIBUTE11 IS NULL
AND LINK_TO_LINE_ATTRIBUTE12 IS NULL
AND LINK_TO_LINE_ATTRIBUTE13 IS NULL
AND LINK_TO_LINE_ATTRIBUTE14 IS NULL
AND LINK_TO_LINE_ATTRIBUTE15 IS NULL

len = 693
No data found

Running the statement from sqlplus also resulted in 'No Data Found'

Search Words:
=============
Autoinvoice RaxTrx raxmtr ai  no data found

Solution Description:
=====================
You were inserting spaces instead of the NULL values in the ATTRIBUTE1
through ATTRIBUTE15.
When this was modified by inserting null, the record was processed.

To see if a field has spaces in it, you can run this on each one:

select 'x'||attribute1||'x' from ra_interface_lines_all;

If you see a space between the two 'x''s then you have this issue.
Check each field.

 

 

(6)

 

 

Applies to:

Oracle Receivables - Version: 11.5.8
This problem can occur on any platform.
EXECUTABLE:RAXTRX - Autoinvoice Import Program

Symptoms

Autoinvoice is not picking up lines in the interface tables.  The Autoinvoice Validation report shows "No data found".  There are no errors in the log files. 

Following update has been done and Autoinvoice submitted again. You are still getting 'No data found':

UPDATE ra_interface_lines_all
SET   interface_line_id = null,
          request_id = null
WHERE interface_line_id = &interface_line_id;
COMMIT;
   
Then you navigated to Customers, Standard, Find appropriate customer record associated to customer record in Autoinvoice interface tables.  Clicked Ok and get following error message: 

FRM-40350: Query caused no records to be retrieved

Changes

Data migration of customer information.

Cause

There was a missing record in hz_customer_profiles table for this customer.

Solution

Please log a service request with Oracle Support to obtain a datafix for the corrupted customer record.

Please run the AR Customer Data Collections Script from Note 245256.1 for the Customers you are trying to import the invoices or at least for one sample customer.

@ For Support internal
@ Below referenced Note 296389.1 is not published but includes the datafix for this issue.

 

 

(7)

fact: Oracle Receivables

fact: RAXTRX - Autoinvoice Import Program

symptom: Rows are not picked up by Autoinvoice

symptom: Rows are stuck in the RA_INTERFACE_LINES_ALL Table

symptom: RA_INTERFACE_LINES_ALL.REQUEST_ID is not null

symptom: RA_INTERFACE_LINES_ALL.INTERFACE_STATUS is not equal to 'P'

cause: If the request_id is not null then any run of Autoinvoice with a
different request id will ignore that line.

This situation will happen if Autoinvoice has a fatal error.

fix:

Clear the request IDs so that Autoinvoice can pick up the line.

1.  First be sure that Autoinvoice is not running.

2.  Clear the request ids.

UPDATE ra_interface_lines_all
SET interface_line_id = null,
    customer_trx_id = null,
    request_id = null,
    link_to_line_id = null
WHERE nvl(interface_status,'x') != 'P';

3.  Commit;

4.  Rerun Autoinvoice and check the log.

 

 

FINAL SOLUTION:

 

按照remen老兄的办法可以解决这个问题的,我在此基础上加了一些限制条件,具体的SQL Script如下:
update ra_interface_lines_all
set request_id = null,
interface_line_id = null
where interface_status is null
and set_of_books_id=1003
and org_id=108
AND REQUEST_ID IS NOT NULL   --修改了374行

update ra_interface_salescredits_all
set request_id = null,
interface_line_id = null,
interface_salescredit_id = null
where interface_status is null
AND org_id=108
AND LAST_UPDATE_DATE>TO_DATE('2009-03-16','YYYY-MM-DD')
AND LAST_UPDATE_DATE<TO_DATE('2009-03-17','YYYY-MM-DD')  --修改了374行

update RA_INTERFACE_DISTRIBUTIONS_all
set request_id = null,
interface_line_id = null,
interface_distribution_id = null
where interface_status is null     --修改了0行

然后run AutoInvoice就可以了