Categories

JAVA DATEBASE
Technology Network Community
Oracle Database
Fusion Middleware
Development Tools
Java
Desktop
Server & Storage Systems
Enterprise Management
Berkeley DB Family
Cloud Computing
Big Data
Business Intelligence
Architecture
Migration and Modernization
E-Business Suite
Siebel
PeopleSoft Enterprise
JD Edwards World
Industries
JD Edwards EnterpriseOne
User Productivity Kit Pro (UPK) and Tutor
Governance, Risk & Compliance (GRC)
Master Data Management (MDM)
Oracle CRM On Demand
On Demand: SaaS and Managed Applications
AutoVue Enterprise Visualization
Primavera
ATG
Agile PLM
Endeca Experience Management
Fusion Applications
Archived Forums

 



Tags

Financials


APP-SQLAP-10710: online accounting could not be created


Hi,  In Oracle applications 11i, Payables module. we have an invoice that has been cancelled and we cannot account all it's lines.Invoice Status: Cancelled, Accounted Status: Partial.  on the user 's attempt to account the invoice by choosing the Actions-> Create Accounting , we get the following error:  APP-SQLAP-10710: online accounting could not be created. Please Submit the Payables Accounting Process instead to create accouning entries for this transaction.  The invoice problem exists since November ,2009 and the payables process was run multiple times since the problem showed up.  Please guide me with any hints please or areas to investigate .  Thank you....

Try and run accounting from requests>new request>sumit new>payables accounting program. else find if the payments associated which were voided are accounted.

Hi,  The invoice is in functional / local currency.I queried the tables:  - ap_invoice_distributions_all  and - ap_accounting_events_all .  I can see that all distribution lines of our  invoice have three event codes:  -Invoice -Invoice Adjustment -Invoice Cancellation  Only invoice distribution lines with Invoice Adjustment code  have a status flag of accounted while the others have status of created.  I tried the following:  from Help-> Diagonistics -> DEBUG. I ran the request Payables Accounting Process and found that there are two line with line type as Invoice Price and Exception : Invalid Acct and their account column is empty.   I could not match the report with neither the application nor the tables as I could not find a row with same AMOUNT and same LINE TYPE : Invoice Price.  how can identify I the records with wrong account?  Please help...  Edited by: AHS on Nov 4, 2010 12:07 AM

Hi,  Please see if these docs help.  Online Accounting not working for an invoice with prepayment: APP-SQLAP-10710 [ID 460728.1] 11.5-AP: APP-SQLAP-1070: Online accounting could not be created [ID 215125.1] Accounting For Voided Payment Fails with APP-SQLAP-10710 [ID 229910.1] Online Accounting Could Not Be Created For Standard Invoice [ID 401709.1]   Thanks, Hussein

thank you for the reply.  Online Accounting not working for an invoice with prepayment: APP-SQLAP-10710 [ID 460728.1] :  solution is for prepayments and  does not apply for our case. we have laready run the payables accounting process multiple times and it did not solve our problem  11.5-AP: APP-SQLAP-1070: Online accounting could not be created [ID 215125.1] :  suggested solution does not apply as invoice is already cancelled and had no prepayments before that  Accounting For Voided Payment Fails with APP-SQLAP-10710 [ID 229910.1]:    fix one and two did not work  Online Accounting Could Not Be Created For Standard Invoice [ID 401709.1]  :  already tried that  Is there any specific table/way where i can identify the records with the problem?  your help is appreciated...

thank you for the reply.  Online Accounting not working for an invoice with prepayment: APP-SQLAP-10710 [ID 460728.1] :  solution is for prepayments and  does not apply for our case. we have laready run the payables accounting process multiple times and it did not solve our problem  11.5-AP: APP-SQLAP-1070: Online accounting could not be created [ID 215125.1] :  suggested solution does not apply as invoice is already cancelled and had no prepayments before that  Accounting For Voided Payment Fails with APP-SQLAP-10710 [ID 229910.1]:    fix one and two did not work  Online Accounting Could Not Be Created For Standard Invoice [ID 401709.1]  :  already tried that  Is there any specific table/way where i can identify the records with the problem?  your help is appreciated...

Hi,  Please ensure that all the accounts have been defined in the system correctly. In case the invoice is in foreign currency then all the Exchange gain & loss accounts should be defined in the bank setup in addition to Payable optopn.


Related Links

Receivables Journal Entries Report
Oracle APPS
API In AR to update Printing Option in ra_customer_trx table
Designing org structure and COA
Upload Dun's Number into vendor tables
Term Loan Repayment
Loading Bank Transaction Codes
Release 12 - Positive Pay File
Oracle Financial logical floww
Carrying Forward Year-End
AP to GL and AR to GL transfer processes
Any template for BR100 in R12?
AR to GL transfer ?
Bank transaction codes
Cash Management: Importing Bank Statements
Journal Import Attributes not processed