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

Description
Oracle Receivables (AR): AutoInvoice Information Center > Troubleshooting AutoInvoice for Oracle Receivables Release 11.5 Through 12 > Note 1080995.1
This Blitz Report was created to facilitate troubleshooting issues regarding AutoAccounting in AutoInvoice.

In Receivables, AutoAccounting is enabled for the following Accounts:

AutoInvoice Clearing
Bills Receivable
 ... 
Oracle Receivables (AR): AutoInvoice Information Center > Troubleshooting AutoInvoice for Oracle Receivables Release 11.5 Through 12 > Note 1080995.1
This Blitz Report was created to facilitate troubleshooting issues regarding AutoAccounting in AutoInvoice.

In Receivables, AutoAccounting is enabled for the following Accounts:

AutoInvoice Clearing
Bills Receivable
Factored Bills Receivable
Freight
Receivable
Remitted Bills Receivable
Revenue
Tax
Unbilled Receivable
Unearned Revenue
Unpaid Bills Receivable
   more
Run Month End Speed Up - AutoInvoice / AutoAccounting Issues - Part 4 and other Oracle EBS reports with Blitz Report™ on our demo environment
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')
Blitz Report™