ERPstuff - Oracle EBS Community

Hi Members, We have a situation were we have forgot to take the WHT line while booking the AP invoice, we usually create a manual WHT line with a negative amount on the invoice. User has found that unfortunately she forgot to put in the WHT lines for a few invoices. These invoices are validated,acco...

Hi Octavio, I would like to gain technical knowledge of the financial tables. I'm looking for basic queries to start for example to look into GL interface table to see if any data is lying in the interface table during month end process, this goes same with AR, AP, PO etc. Others could be invoices, ...

Hi,

Is this happening for all your invoices or its just for this invoice?

If its just a one time issue, reverse the entries out and make fresh ones.

If its happening quiet often then raise a SR with oracle to fix it.

Rgrds
Ben[?]

Hi Members, Would request anyone of you to provide me some basic queries to check data for GL interfaces, invoices, payments and so on for the financial modules. I'm sure someone would be having a library of these basic queries or metalink notes or anything helpful that a functional person uses for ...

Hi,

We have loaded open invoices into our clients system for AP but the issue is we have loaded all Credit memo's as Standard invoices and Standard invoices as Credit memos. Could anyone suggest how can we correct these invoices in the systed.

Rgrds
Ben[?]

Hi Members, We are trying to make some setup changes to one of our Suppliers but when we try to change the WHT and payment type its giving us the error message "Frm-4 0654 record has been updated requery block ". We thougt it was a lock on some table and tried the next day but yet the same...

Hi members, We have wrongly paid an invoice and would like to use the same cheque number to reallocate the same payment to the correct invoice. I know that we can void the payment but the cheque would go to waste. This situation is possible in AR as we can unapply the receipt applied. Kindly provide...

Thanks to Saravanan and Octavio for your replies. I will work with our technical team for the same.

Rgrds
Ben[?]

Hi Members, I had got a query from one of users requesting of any report that could give us details of the reports a user had ran on a particular day for SOX purpose. Do we have any standard report in oracle that could give us info on these details. Your replies are appreciated...thanks in advance R...

We are using a customized payment format and while making the payment we just select the printer name. We do not run any std rdf report.

Rgrds
Ben[?]

Hi Members,

We are facing an issue with printing cheques as the alignment is not proper, the lines printed seem to be printing above the field where it needs to print. Could anyone let me know what setups do we check to correct this alignment issue.

Rgrds
Ben[?]

Hi Saravanan,

This a valid point that you have given and I agree with you. Thanks for clarifying my doubt.

Have a nice day....

Rgds
Ben[?]

Hi Saravanan, What is the use of us transfering the Subledger JVs to GL and reversing them? Instead cant we use a Transactions type with the Post to GL box unchecked and let the Transactions remain in AR itself. Could you explain on this in more detail. Thanks for your helpful contribution towards t...

Hi Members, I'm trying to delete an Invoice batch in AP 11i but I keep getting an error "CANNOT DELETE MASTER RECORD WHEN MATCHING DETAIL RECORD EXISTS" Could somone explain how can delete a invoice batch that has a large number of invoice at a single go. The invoice batch is note validate...

Hi Members,

Could anyone explain what is the difference between TE020 (unit test script) and the TE040 (system test script)?

Your replies are appreciated....

Rgrds
Ben[?]