ERPstuff - Oracle EBS Community

Hi,
Change the "Accounting Date" parameter value to an Open or Future Period, since there is a Open Period Validation in the process. You are supplying a closed period date.

Thanks
Regards
ramkic

Hi, The "ap_cancel_pkg" calls the mentioned packages to check whether the cancelling invoice has been accounted, paid or applied on any oyhe invoices. If your invoice is only validated then I think there is no problem with using this package. Do you receive any issues or errors while using...

Hi,
Please use "AP_CANCEL_PKG" to cancel the Invoices. This API will internally call all the related processes for the integration.
This will work for you. Good Luck

Thanks
Best Regards
ramkic

Hi, There is a column called "SALES_ORDER" in ra_interface_lines_all table which is the "Sales Order Number" for the transaction. The Validation goes like this: **** If LINE_TYPE = ?LINE?, ?CHARGES?, or you are passing header freight, this column is optional. If LINE_TYPE = ?TAX?...

Hi, If this is on Windows, Please do the following: 1) de-install concurent manager a) go the APPL_TOP and set up the apps environment b) check the environment setup properly c) go to FND_TOP/bin and run the following command ccmsvc.exe -r -a <APPL_CONFIG> ex: ccmsvc.exe -r -a vis_localhost 2) run a...

Hi, The following base tables will be populated with data for AP and AR Invoices Interfaces: For AP: 1) ap_batches_all (if batch controll is using) 2) ap_invoices_all 3) ap_invoice_distributions_all 4) ap_payment_schedules_all For AR: 1) ra_batches_all 2) ra_customer_trx_all 3) ra_customer_trx_lines...

Very Well explained Anurag.
Thanks
Regards
ramkic

Hi,
did you get only this error message or any other error messages along with this error? If you get any other messages with this error, probably issue with UTL_FILE_DIR parameter in <SID>init.ora file. Please check that.

Regards
ramkic

Hi,
Please check the profile option PA: Enable Budget Integration and Budgetary Control Feature. If Project modules are not in use, set this option to "No".
Thanks
Best of Luck
ramkic

Hi, The following processes will be performed when you create a payment batch. 1. Select Invoices When a payment batch is started one row for each record is created in the AP_INV_SELECTION_CRITERIA_ALL table. This table stores the criteria that a payment batch uses to select invoices for payments. T...

Hi,
I will be working on the script. Can you please send me your email id, so that I can send it. Once you have tested that, we can request "Admin" to upload the same for future use.
Thanks
ramkic

Hi,
One way you can achieve this by having an update trigger on Payment Terms on po_vendor_sites_all table and call utl_smtp protocol to send email notifications to responsible persons.
Regards
ramkic

Hi,
Since the Invoice has been accounted for, create an adjustment distribution with 0.40. This will add up the invoice total to the required amount. Before that, It is always advisable to have a different expense account to charge this amount for further accounting reporting purpose.
Regards
ramkic

Excellent abmian1981.
Regards
ramkic

Hi, Re-create the Concurrent Manager and re-start it. To do that ( make sure this is Vision instance and installed on Windows platform) 1) de-install concurent manager a) go the APPL_TOP and set up the apps environment b) check the environment setup properly c) go to FND_TOP/bin and run the followin...