ERPstuff - Oracle EBS Community

That is nice...


So you mean cost center is not mandatory?

Even if we have only one company (only one balancing segment value), should we include balancing segment in COA?

Cheers,
Saravanan

In R12, banks are owned by Legal entities and access is granted for OUs. If a bank account is not given access to a OU, then you can not use that bank account in that particular OU. You should give bank account access to OU1 and OU2. You can also have the same GL account codes. System will automatic...

The strategy depends on the availability of tool and volume of data.

Tools available are SQL Loader, PL/SQL scripts, APIs, Data Loader Tools, ADI, etc

Cheers,
Saravanan

There are many dataloader tools are available. One of the site is http://www.dataload.com/. The basic version is available for free (no trial) and can be used for uploading account balances.

May be your trial version tool could have been expired.

Cheers,
Saravanan

Generic Discussion Topic
================

What are the mandatory segments in COA and <b>why</b>?

Cheers,
Saravanan

You can go through the questions in "Application DBA and System Admin" forum.

Apps DBA Interview questions are available in lot of websites. Try searching in Google.

Cheers,
Saravanan

If "validate application accounting definition program" is not run, then create accounting can not be done at the transaction level also.

Log and output files are needed to know the exact issue.

Cheers,
Saravanan

To my knowledge, you can't make payment from OU2 bank accounts for OU1 invoices. Your requirement defeats the concept of OU. You should create the bank accounts in OU1. If you have intercompany segment in your COA, then you can use this segment to capture this information.

Cheers,
Saravanan

I don't think shortcuts are available to close periods for multiple IOs simultaneously.

Apart from standard reports, you can customize your own reports to print the transaction details preventing period closing.

Cheers,
Saravanan

I could not see any option to modify the number of lines in OA framework personalization. May be you can contact your technical team for customizing if it is really required.

Cheers,
Saravanan

You can also go through "Oracle Applications Upgrade Guide: Release 11i to Release 12.1.1" document (E14010-01)" which can be downloaded from the following URL. http://download.oracle.com/docs/cd/B40089_10/current/html/homeset.html If you are having below 11.5.7, then you should first...

You don't want to apply the receipt against the invoices forever? I don't understand the reasons behind this. However you can follow the below steps 1. Find out the credit account for that particluar receipt (Unapplied Account). 2. Create credit memo with debit account as same account found in step1...

The deliverables can not be redistributed as these documents are clients property. You can download the templates and create your own documents. I found the templates in the following link. http://www.bryanthompsononline.com/oracle/2008/05/06/download-oracle-aim-applications-implementation-methodolo...

1. When you run open interface import program itself, you can purge the interface lines (after successful import) by selecting Purge parameter as Yes. 2. The purge program will purge only the processed records (I have not tried in R12). If you have only few sources, you can purge by giving source as...

Payables to GL
Receivables To GL
Assets to GL
Inventory to GL, etc

You can count all the modules in apps, that many reconciliation will be there... You need to reconcile all the subledger modules implemented with GL.

Cheers,
Saravanan