AR Autoinvoice not working
When I interface a record from OM to AR and then run the Autoinvoice program, the invoice is not getting created. Though, when I run the program and pass the sales order # in the sales order high and low parameter, it creates.
Please let me know if any one has faced such issue.
It returns values for:
SELECT COUNT(*)
from ra_interface_lines
WHERE NVL(INTERFACE_STATUS, '~') != 'P'
AND (REQUEST_ID IS NULL
)
AND BATCH_SOURCE_NAME = 'ORDER MANAGEMENT'
AND LINK_TO_LINE_ATTRIBUTE1 IS NULL
AND LINK_TO_LINE_ATTRIBUTE2 IS NULL
AND LINK_TO_LINE_ATTRIBUTE3 IS NULL