Month End Speed Up - AutoInvoice / AutoAccounting Issues - Part 4

SELECT ORGANIZATION_ID, --/**The following script will pick up Inventory Items from organizations involved in Order Management that do not have the Sales Account setup, this could assist you in proactively setting these up to avoid issues in AutoInvoice.**/
DESCRIPTION, INVENTORY_ITEM_ID,
       NVL(TO_CHAR(SALES_ACCOUNT),'NULL SALES ACCOUNT')
FROM   MTL_SYSTEM_ITEMS
WHERE  ((nvl(END_DATE_ACTIVE, sysdate) >=sysdate) AND
        (nvl(START_DATE_ACTIVE,sysdate) <=sysdate))
AND    ORGANIZATION_ID IN
      (SELECT MASTER_ORGANIZATION_ID
       FROM   OE_SYSTEM_PARAMETERS_ALL)
       AND    SALES_ACCOUNT IS NULL
       AND    EXISTS
             (SELECT 'x'
              FROM   RA_ACCOUNT_DEFAULTS_ALL a,
                     RA_ACCOUNT_DEFAULT_SEGMENTS s
              WHERE  s.GL_DEFAULT_ID = a.GL_DEFAULT_ID
              AND    s.CONSTANT is null
              AND    s.TABLE_NAME = 'RA_STD_TRX_LINES')
ORDER BY 1
 
 
SELECT T.NAME, --/**The following script will pick up Memo Lines that do not have all the Revenue account setup, this could assist you in proactively setting these up to avoid issues in AutoInvoice.**/
B.MEMO_LINE_ID,
       NVL(TO_CHAR(b.GL_ID_REV),'NULL REV') GL_ID_REV
FROM   AR_MEMO_LINES_ALL_TL T,
       AR_MEMO_LINES_ALL_B B
WHERE  b.MEMO_LINE_ID = t.MEMO_LINE_ID
AND    ((nvl(b.END_DATE, sysdate) >=sysdate) AND
        (nvl(b.START_DATE,sysdate) <=sysdate))
AND    b.GL_ID_REV IS NULL
AND EXISTS
(SELECT 'x'
 FROM   RA_ACCOUNT_DEFAULTS_ALL a,
        RA_ACCOUNT_DEFAULT_SEGMENTS s
 WHERE  s.GL_DEFAULT_ID = a.GL_DEFAULT_ID
 AND    s.CONSTANT is null
 AND    s.TABLE_NAME = 'RA_STD_TRX_LINES')