ERPstuff - Oracle EBS Community

check the following thread
topic.asp?TOPIC_ID=7184

There are lot of issues like this in R12. What I do is, create a new invoice in R12 and compare that data with old invoice and find the difference. Once you find the difference then log Oracle SR and they will provide you with the fix. we have done that kind of debugging in our upgrade. Look for all ...

Reference_2 in gl_je_lines table will have asset_id. But it idepends on the information you are looking for. Suppose you are looking for a Addition journal ? in that case reference_2 will be populated with asset_id. If you are looking for a Depreciation or Retirement journal, reference_2 will not be ...

Hi,
you can monitor user logins from System Administrator Responsibility.
Navigate to Security-->User-->Monitor and do a query and you can see all the users loged into EBS.

Thanks
ramkic

Hi,
I am not familiar with R12, but it is standard functionality. Transfer from sub-ledgers transactions to GL, even though you choose posting as Yes, will transfer them to gl with unposted batches and you have to post them manually. I may be wrong.

Thanks
ramkic

Hi,
Re-create the Concurrent Manager and re-start it.
To do that ( make sure this is Vision instance and installed on Windows platform)

1) de-install concurent manager
a) go the APPL_TOP and set up the apps environment
b) check the environment setup properly
c) go to FND_TOP/bin and run the ...

Hi,
Answer to your question:
Q)When we create one journal entry, will have 1 record each in GL_INTERFACE table and GL_BALANCES for each set of book?

A)When you create a manual Journal entry GL_JE_BATCHES, GL_JE_HEADERS, GL_JE_LINES tables will be pouplated.
GL_INTERFACE will be used for ...

Hi,
Open a Service Request with Oracle Support and they will provide you with data fix.

Best Regards
ramkic

Hi,
Asset Book from FA_ADDTIONS_B and FA_ADDITIONS_TL AND FA_BOOKS
Asset No FA_ADDTIONS_B and FA_ADDITIONS_TL
,Asset Gross Block Code Combination --> No idea may be you are looking at a FORM derived volumns
,Acc Dep Code Combination and Depreciation Code Combination can get from FA_DISTRIBUTION ...

Nice job Sivakumar!
My two cents here: Please post your feeback once you have tried the solutions suggested by the members for your posting or issue. That's how one will know their solutions have resolved your issue, so other members make use of the solution.
Thanks
Best Regards
ramkic

This is not an issue buT the intented functionality.

From a transaction window, you can create accounting entries for a
selected invoice, payment, invoice batch, or payment batch. For a
single invoice or payment, the accounting completes online. For
batches, the accounting process is submitted as a ...

Hi Oracle_Demand,
This i forum meant for sharing the knowledge and helping each other. Please don't mis-use this forum for your personal stuff. If you really want to help this forum, sell that material and donate that amount to this forum.
Good Luck and Best Regards
ramkic

Hi,
Try this:
fix:

Change Receipt date : Action to 'None'.

The DEFAULT for this field (Receipt Date Action) is from :
1. Items - Master Items - Receiving, Receipt Date Controls: Action
2. Setup - Organization - Receiving Options, Receipt Date: Action
3. Purchase Order -> Shipments -> Receiving ...

You can either pass one of the parameters or both. It doesn't matter/ but shuld be in open or future period.

Best Regards
ramkic

Hi,
Did you open period for the accounting date that you are providing? For example: your accounting period date is 01-AUG-2004 then open period AUG-04 (as per the setup).
Try to use the latest open period date, rather than opening an already closed very old accounting peroiod. Also provide the ...