Search found 624 matches

by tgs100
Thu Jan 07, 2010 4:11 pm
Forum: Financials (GL, AP, AR, FA & CM)
Topic: GL Effective date
Replies: 8
Views: 2734

In the case of detail transfer, the transaction GL date (distribution line GL date, if applicable) will be considered as GL effective date. In the case of summary by GL period, it will be the last date of the period. In the case of summary by GL date, the transactions will be grouped based on the tr...
by tgs100
Thu Jan 07, 2010 12:18 pm
Forum: Financials (GL, AP, AR, FA & CM)
Topic: Document Sequence - Payables R12
Replies: 3
Views: 2399

What is the logic to populate the category automatically in the invoice screen? If you have a logic and if you want to populate the user defined category name automatically in invoice screen, then you need to do customization. There is no work around except entering it manually. You can make this fi...
by tgs100
Thu Jan 07, 2010 12:13 pm
Forum: Financials (GL, AP, AR, FA & CM)
Topic: automatic offset in payables
Replies: 4
Views: 1920

Here you go. https://support.oracle.com/CSP/ui/flash.html#tab=KBHome(page=KBHome&id=()),(page=KBNavigator&id=(bmDocTitle=Automatic%20Offsets%20and%20Pooled%20Accounts%20White%20Paper&viewingMode=1143&from=BOOKMARK&bmDocID=134117.1&bmDocType=WHITE%20PAPER&bmDocDsrc=DOCUMEN...
by tgs100
Wed Jan 06, 2010 6:51 pm
Forum: Financials (GL, AP, AR, FA & CM)
Topic: Document Sequence - Payables R12
Replies: 3
Views: 2399

You can create your own categories, but when you create invoice, you need to select the category in 'Document Category Name' field (which is generally a hidden field) before saving the invoice header. You may also make the field mandatory through personalization. If you use the seeded categories, yo...
by tgs100
Wed Jan 06, 2010 6:34 pm
Forum: Financials (GL, AP, AR, FA & CM)
Topic: GL Effective date
Replies: 8
Views: 2734

It also depends on the journal summarization value. In case of summarize by GL period, the GL date will the last date of the period.

Cheers,
Saravanan
by tgs100
Wed Jan 06, 2010 6:27 pm
Forum: Financials (GL, AP, AR, FA & CM)
Topic: automatic offset in payables
Replies: 4
Views: 1920

You may go through the whitepaper ID 134117.1 which can be downloaded from the oracle support site.

This is a bit old document, however the concept remains same.

Cheers,
Saravanan
by tgs100
Wed Jan 06, 2010 1:49 pm
Forum: Financials (GL, AP, AR, FA & CM)
Topic: Invoice Validation Issue
Replies: 9
Views: 2981

I think it is related to budget fund issue. As there was a hold "Funds Check", you will not be able to validate the invoice. We need to either increase the budget fund for the distribution account.


Cheers,
Saravanan
by tgs100
Wed Jan 06, 2010 1:45 pm
Forum: Financials (GL, AP, AR, FA & CM)
Topic: Unable to get the Expense Reports in Invoice wB
Replies: 4
Views: 1725

Try the solution given in oracle support id 453144.1

Cheers,
Saravanan
by tgs100
Mon Dec 28, 2009 8:13 pm
Forum: Financials (GL, AP, AR, FA & CM)
Topic: How to decid a Operating Unit?
Replies: 1
Views: 858

You may check the thread topic.asp?TOPIC_ID=7807

Cheers,
Saravanan
by tgs100
Mon Dec 28, 2009 8:09 pm
Forum: Financials (GL, AP, AR, FA & CM)
Topic: Payments are voided
Replies: 4
Views: 1665

I have asked the payment amount column in the front end. Are you checking the correct field in the table?

Cheers,
Saravanan
by tgs100
Mon Dec 28, 2009 8:08 pm
Forum: Financials (GL, AP, AR, FA & CM)
Topic: Unable to get the Expense Reports in Invoice wB
Replies: 4
Views: 1725

Run the expense report with debug parameter value as 'Yes' and then check the log file.

Post the log file message if you can't figure out the issue.

Cheers,
Saravanan
by tgs100
Mon Dec 28, 2009 8:05 pm
Forum: Financials (GL, AP, AR, FA & CM)
Topic: Invoice Distribution Line is Reversed and Manually
Replies: 6
Views: 1965

1. Is it a one-off case or you are able to reproduce the issue?
2. What is the SLA used in the ledger?

Cheers,
Saravanan
by tgs100
Mon Dec 28, 2009 8:02 pm
Forum: Financials (GL, AP, AR, FA & CM)
Topic: How to Change a Date for a Sales Invoice in AR
Replies: 1
Views: 778

The only way to change the date is to make the invoice 'Incomplete'. But now you can not make it incomplete as the invoice is already accounted (or you have made adjustments or receipts). Hence the only option now is to nullify the invoice (create credit memo and apply it) and then create the new in...
by tgs100
Fri Dec 25, 2009 2:04 pm
Forum: Application DBA & System Administration
Topic: Creating User based on another user account
Replies: 2
Views: 1427

There is no front end standard functionality available. I am not sure about the APIs. You may try the dataloader to upload the data if number of records are more.

Cheers,
Saravanan
by tgs100
Fri Dec 25, 2009 1:51 pm
Forum: Financials (GL, AP, AR, FA & CM)
Topic: cross validation in GL 11i
Replies: 4
Views: 2767

In addition to Karthikeyan's reply try the following.

First include all the account combinations and then exclude the account combinations you want to restrict.

Cheers,
Saravanan