Search found 451 matches

by oteixeira
Mon Apr 26, 2010 7:49 am
Forum: Financials (GL, AP, AR, FA & CM)
Topic: Invoice Validation error :Effective tax paid amoun
Replies: 3
Views: 2589

Hello Bhupati.

MOS Doc ID 462545.1 shows exactly the error you are receiving.

Octavio
by oteixeira
Thu Apr 15, 2010 5:58 am
Forum: Financials (GL, AP, AR, FA & CM)
Topic: Problem with Document Sequencing in AR
Replies: 5
Views: 2945

Hello Ganguly. Well, if you are sure that the sequence setup is ok it is difficult to find out what can be wrong. Anyway, you should have a Sequence Assignment with the type of your problematic transactions with: Application=Receivables Category=The name of your transaction type End Date=Null Set of...
by oteixeira
Wed Apr 14, 2010 6:10 am
Forum: Financials (GL, AP, AR, FA & CM)
Topic: Problem with Document Sequencing in AR
Replies: 5
Views: 2945

Hello. Try the following: -Obtain the DOC_SEQUENCE_ID used by one of the problematic transactions SELECT doc_sequence_id FROM ra_customer_trx_all WHERE customer_trx_id = <your customer_trx_id> Check to see if it is using the correct one: SELECT name FROM fnd_document_sequences WHERE doc_sequence_id ...
by oteixeira
Tue Apr 13, 2010 10:45 am
Forum: Financials (GL, AP, AR, FA & CM)
Topic: Problem with Document Sequencing in AR
Replies: 5
Views: 2945

Hello.
What kind of transactions are being numbered by this Document Sequence?

Octavio
by oteixeira
Tue Apr 13, 2010 10:39 am
Forum: Financials (GL, AP, AR, FA & CM)
Topic: COA design
Replies: 1
Views: 2182

Hello. Globa Consolidation System The flexibility of the Global Consolidation System (GCS) allows you to manage financial information within any company structure. You can maintain multiple companies with similar or different accounting structures, and consolidate their results for meaningful financ...
by oteixeira
Mon Apr 12, 2010 6:58 am
Forum: Financials (GL, AP, AR, FA & CM)
Topic: How to Merge 2 Assets into One Asset
Replies: 3
Views: 2172

Hello.

Set the asset cost of one of the assets to zero and increase the cost of te other asset in the same amount.

Octavio
by oteixeira
Wed Apr 07, 2010 8:29 am
Forum: Financials (GL, AP, AR, FA & CM)
Topic: Assets
Replies: 2
Views: 1692

Hello. Here are some explanations to your questions: 1)How Asset Key flexfield helps Fixed Assets? Oracle Assets uses the asset key flexfield to group your assets by non-financial information. You design your asset key flexfield to record the information you want. Then you group your assets by asset...
by oteixeira
Tue Mar 30, 2010 5:41 am
Forum: Financials (GL, AP, AR, FA & CM)
Topic: Execute ap_checks_v showing "no rows returned"?
Replies: 6
Views: 2786

Hello. Open the payments window and search for the check number. Then use Diagnostics/Examine and look for the ORG_ID value, not under the $PROFILE Block but unser the PAY_SUM_FOLDER Block. This should give you the correct org_id. Are you using multiorg? Also execute the following query and see if y...
by oteixeira
Mon Mar 29, 2010 10:28 am
Forum: Application DBA & System Administration
Topic: load data from excel to oracle apps
Replies: 7
Views: 4204

Hello.

Probably you are not filling in all the requested data. Do you see any message at the bottom? Execute Dataload in Step Mode to see what is failing.

Octavio
by oteixeira
Mon Mar 29, 2010 10:16 am
Forum: Financials (GL, AP, AR, FA & CM)
Topic: Execute ap_checks_v showing "no rows returned"?
Replies: 6
Views: 2786

Hello.

The org_id can't be zero. That corresponds to a seeded organization. You should go to Payments windows, locate the check number and examine to see which is value for ORG_ID field.

Octavio
by oteixeira
Mon Mar 29, 2010 8:26 am
Forum: Financials (GL, AP, AR, FA & CM)
Topic: Execute ap_checks_v showing "no rows returned"?
Replies: 6
Views: 2786

Hello.

To see the records in AP_CHECK_V you need to set the org_id before executing the query.

Octavio.
by oteixeira
Mon Mar 29, 2010 8:22 am
Forum: Application DBA & System Administration
Topic: load data from excel to oracle apps
Replies: 7
Views: 4204

Hello.

Do you mean to load the data from Excel into Oracle Forms?

Octavio
by oteixeira
Thu Mar 25, 2010 8:43 am
Forum: Financials (GL, AP, AR, FA & CM)
Topic: Invoice and payment booked for wrong Vendor - 11i
Replies: 1
Views: 857

Hello. You solution is correct. However, when this cases happen, the situation may become complicated. Depending on the way you made the payment, you may have difficulty on cancelling it. A bank tranfer, for example, or even a cheque if the supplier already cashed it. In this case, the supplier will...
by oteixeira
Thu Mar 25, 2010 8:32 am
Forum: Financials (GL, AP, AR, FA & CM)
Topic: FA
Replies: 6
Views: 2096

Hello. Answering your questions: a) why do we have to assign an asset to an employee? You can assign an asset to an employee. However, this is not mandatory. b) Is there any link from FA to AP. Yes. Whenever you enter an invoice in AP which distribution includes the Asset Clearing Account, those dis...
by oteixeira
Wed Mar 24, 2010 8:07 am
Forum: Financials (GL, AP, AR, FA & CM)
Topic: Revaluation/Reinstatement of Forex Transactions
Replies: 3
Views: 1940

Hello Emanuel. Navigate to /Currency/Revaluation. Use the Revaluation window to define, run, update, and delete revaluations for foreign currency-denominated balances. Revaluation launches a process that revalues the functional currency equivalent balances for the accounts and currencies you select,...