| AP Journal Import Error [message #228239] |
Mon, 02 April 2007 04:00 |
nankeen80
Messages: 32
Registered: April 2006
|
Member |
|
|
While running process to import journal error occured. Description of error are as below:
1) User run ACCOUNTS PAYABLE JOURNAL ENTRY EXCEPTION REPORT, run completed with no error.
2) The follow up auto run of JOURNAL IMPORT EXECUTION REPORT was interrupted due to failure of Oracle System resulting in a shutdown of the Server. Status Indicated Journal Import Completed with Error. No output file was generated.
3) User then follow up with GL Supervisor responsibility and when 'GL Supervisor --> Journal --> Enter' is run and posting the month is queried, no unposted posting can be found for the data imported.
4) Subsiquent re-run of ACCOUNTS PAYABLE JOURNAL ENTRY EXCEPTION REPORT and JOURNAL IMPORT EXECUTION REPORT completed with no error. However, output indicated NO DATA FOUND.
Below are the output for the re-run:
Sawit - Set of Books ACCOUNTS PAYABLE JOURNAL ENTRY EXCEPTION REPORT Date: 02-APR-07 Page: 1
Invoice Distributions with Exceptions
|----------------Invoice------------------| |--------------------Distribution------------------| Exception
Supplier Name Invoice Number Currency Amount Num Amount Description GL Date Code
-------------------- ---------------- -------- ----------------- --- ----------------- -------------------- --------- ---------
*** No data exists for this report ***
Sawit - Set of Books ACCOUNTS PAYABLE JOURNAL ENTRY EXCEPTION REPORT Date: 02-APR-07 Page: 2
Invoice Payments with Exceptions
|----------------Payment------------------| |----------------Invoice Payment---------------| Exception
Supplier Name Document Number Currency Amount Num Invoice Number Amount GL Date Code
-------------------- ---------------- -------- ----------------- --- ---------------- ----------------- --------- ---------
*** No data exists for this report ***
Sawit - Set of Books ACCOUNTS PAYABLE JOURNAL ENTRY EXCEPTION REPORT Date: 02-APR-07 Page: 3
Reconciliation Payment Distributions with Exceptions
Supplier Name Document Number Currency Amount Line Type GL Date Exception Code
-------------------- ---------------- -------- ----------------- --------------- --------- --------------
*** No data exists for this report ***
Sawit - Set of Books ACCOUNTS PAYABLE JOURNAL ENTRY AUDIT REPORT Date: 02-APR-07 Page: 1
TRANSFER TO GENERAL LEDGER : POSTED INVOICES
Currency :
Supplier Na Invoice Num GL Date Accounting Flex Entered Debit Entered Credit Accounted Debit Accounted Credit
----------- ------------ --------- ------------------------- ----------------- ----------------- ----------------- -----------------
*** No data exists for this report ***
Sawit - Set of Books ACCOUNTS PAYABLE JOURNAL ENTRY AUDIT REPORT Date: 02-APR-07 Page: 2
TRANSFER TO GENERAL LEDGER : POSTED PAYMENTS
Bank Acccount :
Payment Document :
Currency :
Supplier Na Document Num GL Date Accounting Flex Entered Debit Entered Credit Accounted Debit Accounted Credit
----------- ------------ --------- ------------------------- ----------------- ----------------- ----------------- -----------------
*** No data exists for this report ***
Sawit - Set of Books ACCOUNTS PAYABLE JOURNAL ENTRY AUDIT REPORT Date: 02-APR-07 Page: 3
TRANSFER TO GENERAL LEDGER : POSTED RECONCILIATION DISTRIBUTIONS
Bank Acccount :
Payment Document :
Currency :
Supplier Na Document Num GL Date Accounting Flex Entered Debit Entered Credit Accounted Debit Accounted Credit
----------- ------------ --------- ------------------------- ----------------- ----------------- ----------------- -----------------
*** No data exists for this report ***
Sawit - Set of Books Journal Import Execution Report Date: 02-APR-07 08:28
Concurrent Request ID: 706386 Page: 1
Journal Import finds no records in gl_interface for processing.
Check status, set_of_books_id, je_source_name and interface_run_id of import records.
***** End of Report *****
5) Check done on the gl.gl_interface show no data.
6) Check done on the gl.gl_je_batches show no such data.
7) A Sweep of un-imported journal before closing of period is done shows no record found of unposted records.
 As of date, user have closed the period of Mar-07.
The question is, how do we repost the required data for the month of Mar-07 and to allow for posting into GL using the 'GL Supervisor --> Journal --> Enter' form?
Pleas help...thanks a lot.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
