ERPstuff - Oracle EBS Community

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...

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...

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...

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...

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

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

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

Try the solution given in oracle support id 453144.1

Cheers,
Saravanan

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

Cheers,
Saravanan

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

Cheers,
Saravanan

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

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

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...

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

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