Home » Applications » Oracle Fusion Apps & E-Business Suite » payables accounting process error
payables accounting process error [message #389702] Tue, 03 March 2009 05:37 Go to next message
phani2327
Messages: 20
Registered: April 2008
Junior Member
Hi all,


when i am trying to run payables accounting process in payables modual following error is coming can anybody 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

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

Re: payables accounting process error [message #389706 is a reply to message #389702] Tue, 03 March 2009 05:53 Go to previous messageGo to next message
Littlefoot
Messages: 21811
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
There's a SELECT statement in the BEFORE REPORT trigger which didn't return a value. That was the reason for the NO-DATA-FOUND error.

I don't know anything about Oracle Applications so I don't know whether you can edit this report or not. If possible, check the trigger, run this (these) statement(s) in SQL*Plus using the same arguments and see what happens.
Re: payables accounting process error [message #389971 is a reply to message #389702] Wed, 04 March 2009 06:49 Go to previous message
shashidhar.k
Messages: 127
Registered: January 2006
Location: India
Senior Member
Hi Phani,

Regarding this issue, i hope there could one reason is 'If you mach /create multipile invoice's for a single PO you will get this problem'. I am all other possible ways , coz few days back i also had same problem , so Oracle suggested to apply patch some patch.

Pl refer Note: 332242.1 in metalink.

Thanks
Shashidhar K
Previous Topic: Approver List is not displayed
Next Topic: GL eTRM File (merged 3)
Goto Forum:
  


Current Time: Fri Jun 28 01:03:39 CDT 2024