ERPstuff - Oracle EBS Community

Hi kareem

I don't know if your report are standard report in Oracle application or customized report.

I think if it's customized please try to tell the development team to check their condition in the report & fix it.

Thanks
Hisham

Hi MMRAPPS

You can go to metalink if you have access then search on Applications electronic Technical Reference Manuals (eTRM). It contains all tables & views of each module & the relation between all tables.

Thanks
Hisham

Hi Folks

I think AmanKha is right but I have another workaround for this issue. We can adjust the first asset by reduce his cost & increase the other asset cost with the same amount.

This is just an idea if it work let us know.

Thanks
Hisham

Hi oracleapps I think from my low experience it couldn't generate invoice number automatic fro AP module because you use the invoice number field to enter the supplier's invoice number not your invoice number. I think you can do this in AR by using Document sequence in AR & make it generate the ...

Hi wenjie If you use TOAD tools to get the data from this view "ar_misc_cash_distributions_v" then you can run this program before read the data. begin fnd_client_info.set_org_context(:P_ORG_ID); end; by change the parameter P_ORG_ID from 102 to 104. Be carful the view only read the data a...

Hi DSSantha

Try to use Oracle diagnostic tools to know if these entries have an error or them in normal case. Once you know the status you can solve the issue by open a service request if you need to do that.

Thanks
Hisham

Hi Jayasree

In the analysis time, check with financial department about the currency precision they want to be in the system.

Thanks
Hisham

Hi faizan

I think ou can search o metalink about create new KPI's in DBI. I don't remmember the file name but I think you can find it very easy.

Thanks
Hisham

Hi farhatmfc

You can get the table name from the payment screen by go to help menu --> record history. It will show you the table name of this form.

Thanks
Hisham

Hi vasanthchegu

In AP you can pay an asset & make it add automaically in the FA module by using Mass Addition reports.

ALl supplier information will be shared in AP & FA modules after you run this request.

Hope I can help you.
Thanks
Hisham

Hi Murthyoracle When I create a debit memo I choose for ex. an account 1234 in the disruption & the total debit memo will be = (1000$) with negative sign. So when I validate this debit memo & create account process will be Dr. \ Supplier account 2215 Cr. \ Account 1234 Then when you pay this...

Hi sandhyagulipalli

Please check all period date in AR, OM & GL it must be open in all these modules to can transfer within the same period.

Thanks
Hisham

Hi nagaramesh According to your customer request, I think it will be available by using oracle report builder & customized a report with these details. After you finish this report, you can put it under oracle application to running under AP module. You must ask an developer person on your team ...

Hi Lucky, Be inform that you must make sure that you must enable Freeze Journals for AP in the journal sources form. If you enable this check box, journals from this source cannot be changed in the Enter Journals window. If you subsequently disable this check box, you can make changes to journals fr...

Hi vasanthchegu I think that you can define supplier site for different suppliers in oracle because each supplier has a number & id so when you define supplier site for each supplier, it take a supplier site id related to the supplier id you define. You can use the same supplier in multi-organiz...