ERPstuff - Oracle EBS Community

Hi,

XLA views are based on the product specific views. Patches may exist within those products that can increase performance.

You can raise the Service Request to Oracle.

Thanks & Regards,

Siva

Hi, For tax_id / code disabling.. Account Payables -->Tax --> Taxes. Query the respective tax name and put the end date in to date field. otherwise through backend.. using following query. select * from ja_in_tax_codes where tax_id='<>' update ja_in_tax_codes set END_DATE='<date>' where tax_id='tax_...

Hi, Please use the following query to find the same. select distinct(pv.segment1), pv.VENDOR_NAME, pvs.VENDOR_SITE_CODE site, pvs.ADDRESS_LINE1, pvs.ADDRESS_LINE2, pvs.ADDRESS_LINE3, pvs.CITY, pvs.ZIP, pvs.STATE,jav.PAN_NO, jav.WARD_NO,jav.SECTION_code from po.po_vendors pv, po.po_vendor_sites_all p...

Hi,

Instead of updateing through backend GL_DATE ,Better to open period (GL period) and import the group id manually.

Thanks & Regards,

Siva

Hi,

Localization is the country specific like TDS,excise,VAT, Service Tax.

Taxing rules are different from one country to another.


Thanks & Regards,

Siva

Hi, The below note explanation:(813653.1) Oracle applications database contains many default, open schemas with default passwords. These accounts and corresponding passwords are well-known, and they should be changed, especially for a database to be used in a production environment as a best practic...

Hi,

Your issue seems to be Bug. Please log a Service request to Oracle. They will provide the patch for this issue.I have checked in Oracle Metalink and various Notes too.

Thanks & Regards,

Siva

Hi,

Please try from from this table:

select * from JAI_AP_TDS_PAYMENTS

Thanks & Regards,

Siva

Hi, Please help me this scenario,its very very urgent.... Example: Departments ----> A,B,C,D Supplier-------->ABC Ltd. 1. Dept A has raised the invoice to the supplier in same day:ABC Ltd, 2. Dept B has raised the invoice to the supplier in same day :ABC Ltd etc., Now i need to give single check for...

Hi, Please try following solution: Cause The issue is caused by the parameter utl_file_dir in the pfile is being taken as a complete string. Modification to the pfile resolved the issue. Solution 1. On the Database created pfile from spfile. 2. Modified pfile with the entries, utl_file_dir='/usr/tmp...

Hi,

If you have metalink access you can downlaod from following link.


https://etrm.oracle.com/pls/trm11510

Thanks & Regards,

Siva

Hi,

You will not cancel the invoice batch.You have to open the invoice workbench and as follows

1. Select the all invoice at a time
2. Click on actions and do cancel invoices.

I hope you will understood now.

Thanks & Regards,

Siva

Hi,

Please clarify,What is closed Invoices?

Normally data migration process from one instance to another instance as follows

1.Take the latest backup of source server data.
2.copy to target server
3.Do the cloning activity.


Thanks & Regards,

Siva

Hi,

In every invoice it should come to following tables.

AP_INVOICES_ALL ---->Invoice Header level details
AP_INVOICE_DISTRIBUTIONS_ALL ---->invoice Distribution details
AP_HOLDS_ALL ----->Inovoice Hold Details


Thanks & regards,

Siva

Hi, You can use Payment batch sets option to process multipls payment batches at a time as many as you want. You have to do the following setup. 1. Create the Bank account name,Bank account number 2. Cash account 3.Select the payment type as Check or Electronic,Wire.. 4.Provide the details of Last u...