payables accounting process error

[phanigajarao]

Hi every one,

When i am trying to run payables accounting process report in payables following error is coming.please help me how to resolve it.



+---------------------------------------------------------------------------+
Payables: Version : 11.5.0 - Development

Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

APACCENG module: Payables Accounting Process
+---------------------------------------------------------------------------+

Current system time is 03-MAR-2009 14:00:03

+---------------------------------------------------------------------------+


+-----------------------------
| Starting concurrent program execution...
+-----------------------------

Arguments
------------
P_JOURNAL_CATEGORY='All'
P_SUB_TRANSF_TO_GL='Y'
P_SUB_JOURNAL_IMP='Y'
P_VALIDATE_ACCTS='Y'
P_SUMMARIZE_FLAG='N'
P_COMMIT_CYCLE='50'
P_ORG_ID='101'
P_DEBUG_SWITCH='N'
P_TRACE_SWITCH='N'
P_RUN_ACCT_REPORT='Y'
------------

APPLLCSP Environment Variable set to :

XML_REPORTS_XENVIRONMENT is :
/d1/appl/dkvuatora/8.0.6/guicommon6/tk60/admin/Tk2Motif_UTF8.rgb

XENVIRONMENT is set to: /d1/appl/dkvuatora/8.0.6/guicommon6/tk60/admin/Tk2Motif_UTF8.rgb


Current NLS_LANG and NLS_NUMERIC_CHARACTERS Environment Variables are :
American_America.UTF8

'.,'

Spawned Process 712952
MSG-00002: Check that AX is not installed before calling the accounting engine
MSG-00003: AX is not installed, Calling the accounting engine
MSG-00004: After the call to AP_Accounting_Engine_Pkg.Do_Accounting
MSG-00005: Error occured in the accounting process
MSG-00006: Error Message:
REP-1419: 'beforereport': PL/SQL program aborted.

Report Builder: Release 6.0.8.25.0 - Production on Tue Mar 3 14:00:04 2009

(c) Copyright 1999 Oracle Corporation. All rights reserved.

Enter Username:
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
Starting to account all the events created ...
ORA-01403: no data found occurred in
AP_ACCOUNTING_MAIN_PKG.Create_Accounting_En
try<-AP_ACCOUNTING_ENGINE_PKG.do_accounting<-APXAEREP
with parameters (&PARAMETE
RS)
while performing the following operation:
&DEBUG_INFO
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+
Program exited with status 1
Concurrent Manager encountered an error while running Oracle*Report for your concurrent request 394385.

Review your concurrent request log and/or report output file for more detailed information.


+---------------------------------------------------------------------------+
Executing request completion options...


Output is not being printed because:
The print option has been disabled for this report.


Finished executing request completion options.

+---------------------------------------------------------------------------+
Concurrent request completed
Current system time is 03-MAR-2009 14:00:13

+---------------------------------------------------------------------------+

[karthikeyanp1981]

This can be a setup issue.

There is a Payables Option called "When Payment is issued" under the Account
for Payment section of the Payment Accounting tab. Navigate to Setup -> Options
-> Payables, then choose Payment Accounting tab. If the "When Payment is
issued" option is set to NO, you will get the above error.


The proper setup should be:
1. If you are not using Cash Management to reconcile payments,
and you would like to use Cash Account, please set:

When Payment is issued = Yes,
When Payment clears = No,

2. If you are using Cash Management to reconcile payments,
and you would like to use both Cash account and Cash Clearing
account, please set:

When Payment is issued = Yes,
When Payment clears = Yes,

At the same time, you need to setup the Cash Clearing Accounts for
all the bank accounts in Bank Setup form.