Withholding Tax on Prepayments
Date: Sun, 29 Aug 1999 07:06:33 +0500
From: "Amir Anwer" amiranwr@pienet.net
Subject: AP - Withholding tax on prepayments
Hi all
We are on 10.7 SC.
Is it possible to apply withholding tax on prepayments? If not then is
there any alternative for this?
Any pointer or advise will be a great help.
Regards
Date: Sun, 29 Aug 1999 12:05:04 -0400 (EDT)
From: satyam@sri.lanka.net
To: oraapps-l@cpa.qc.ca, Multiple recipients of list oraapps-l@cpa.qc.ca
Subject: Re: AP - Withholding tax on prepayments
No. You can't apply withholding tax on Prepayments. You might have to look
at having Workarounds. Alternatively try contacting Oracle for any
localisation versions in which they might have incorporated this
functionality.
Prabu
Standard AP Check Report
Date: Mon, 30 Aug 1999 16:57:20 GMT
From: "Jaayanti Vishwanathan" vijaay@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: AP Checks Report File ...
Hi ,
Can anybody tell me what is the name of "Standard AP Checks" Report. In our
site we have modifield our AP Checks and somehow the original report file we
are not geeting.
Thanks a lot.
Date: Tue, 31 Aug 1999 04:00:10 +0100 (BST)
From: =?iso-8859-1?q?Mohan=20Dutt?= mohan_at_pwc@yahoo.co.uk
To: oraapps-l@cpa.qc.ca
Subject: Re: AP Checks Report File ...
APXPBFEG.rdf
Date: Tue, 31 Aug 1999 03:13:22 -0700 (PDT)
From: FMT firas70@yahoo.com
To: oraapps-l@cpa.qc.ca
Subject: Re: AP Checks Report File ...
Hi,
I think that the report name for formating the payment
depends on which format payment program you are using the
( APXPBFEG.RDF ) is for the "Format Payments (Evergreen)".
Any comments welcome ..
Firas
ADWEA OF Support
Date: Tue, 31 Aug 1999 15:48:17 GMT
From: "Jaayanti Vishwanathan" vijaay@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: Re: AP Checks Report File ...
What all other formats are available and Could you please send me .RDF for
all of them?
Thanks a lot.
Date: Sat, 4 Sep 1999 00:44:19 -0700 (PDT)
From: FMT firas70@yahoo.com
To: oraapps-l@cpa.qc.ca
Cc: vijaay@hotmail.com
Subject: Re: Re: AP Checks Report File ...
Hi,
the file ( APXPBFOR.RDF ) is another one !
What is the ver. of Financ. u r working on ?
Firas
ADWEA
On confirmation of a Payment Batch gets error :FRM-40735/ORA-06550 and 01008
Date: Sun, 1 Aug 1999 14:11:12 +0300
From: Kik Nichol m_sharawy@tccbce.com
Subject: AP:payment batch error
Hello
When i try to confirm payment batch I got the following error
FRM-40735: ON-LOCK trigger raised unhandled exception ORA-06550.
--------------------------------------------------------------
ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'LOCK_ROW'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
FRM-40735: ON-LOCK trigger raised unhandled exception ORA-01008.
--------------------------------------------------------------
ORA-01008: not all variables bound
AP Accrual Reconciliation and Blanket POs
Date: Tue, 31 Aug 1999 12:15:02 +0200
From: Mike Bennet MikeB@langeberg.co.za
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: AP and PO: AP Accrual Reconciliation
Hi
We are on 10.7 NCA 16.1 using AP, PO, GL, INV, amongst other modules.
We accrue expenses on receipt, rather than at period end.
Our users are finding that our Accrual Reconciliation Report is growing in
size to the extent of becoming unmanageable. Our main problem is that
blanket Purchase orders do not "drop off" the report as they are always open
(We run some blanket POs for a year).
Is there a way of clearing Blanket Releases that have been completed, off
the report, even though the Blanket Purchase Order is still open? We have
thought of using the accrual write-off process, but it is not possible,
based on the information available on the Accrual Reconciliation report, to
relate specific PO receipts with their related invoices . We have tried
tying up with dates but it is time consuming.
Help is much appreciated.
Regards
Mike Bennet
Discount Lost - how calculated
Date: Tue, 31 Aug 1999 09:24:27 -0700 (PDT)
From: Lucky Luke lucky_luke_junior@yahoo.com
To: OraApps-L@cpa.qc.ca
Subject: AP: How is Discount Lost calculated on Invoice Payments?
Does anybody know how column DISCOUNT_LOST is calculated in table
AP_INVOICE_PAYMENTS(_ALL).
(We're on 10.7 Char, but I suppose this doesn't matter much)
I appreciate any help.
Thanks,
Luc Vernieuwe
Genencor International.
BACS report - modified report errors
Date: Tue, 31 Aug 1999 18:32:30 -0400
From: "Innamuri, Chakrapani" cinnamuri@btg.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: Error while running modified report for BACS 1/2 inch tape format
Hi All,
I just modified Cust_init function in BACS 1/2 inch tape format in X-windows
on my erports server and saved it.
After doing the modification, I tried to CONFIRM a PAYMENT BATCH but I am
getting
the following error in report output. Please let me know if you came across
the following errors earlier.....
Thanks.
-chakrapani
+++++++++++++++++++++++++++++++
SQL-GENERIC ERROR (ERRNO=1458) (ROUTINE=set_token) (REASON=ORA-01458:
invalid length inside variable character string) (SQLSTMT=)
Content-type: text/plain
The Applications File Server could not open the file &FILE for read.
++++++++++++++++++++++++++++++++
Log output shows following:
++++++++++++++++++++++++++++++++
+-----------------------------
| Starting concurrent program execution...
+-----------------------------
Arguments
------------
P_PAYMENT_BATCH="test3"
------------
REP-1222: Invalid body size.
Reports: Release 2.5.7.7.0 - Production on Tue Aug 31 18:32:24 1999
(c) Copyright 1998 Oracle Corporation. All rights reserved.
Program exited with status 1
Cause: The program completed execution - in particular it exited with
status 1.
Action: If the program completed normally, no action is required.
Action: If the program completed with a status code indicat
Concurrent Manager encountered an error while running Oracle*Report for your
concurrent request 2635.
Review your concurrent request log and/or report output file for more
detailed information.
++++++++++++++++++++++++++++++++++
Invoice Hold with incorrect PO
Date: Wed, 1 Sep 1999 13:55:56 +0100
From: "Sabarad, Sateesh (GEAE, Caledonian)" Sateesh.Sabarad@ae.ge.com
To: "'OraApps-L@cpa.qc.ca'" OraApps-L@cpa.qc.ca
Subject: Invoice HOLD with a different PO.
Hi Friends,
We face this peculiar problem in Accounts Payable( APPS 11.0.2) that:
The Invoices were registered in Invoice Gateway with one particular PO and
the same exist in Invoice Distribution ( workbench).
But these invoices are on HOLD with hold reason as 'RNI' ( Received Not
Invoiced) and a totally different PO Number displayed
on each of them. This has caused great difficulty in Approving these
invoices.
I appreciate any help in this regard.
Thanks and Regards,
Sateesh Sabarad
g GE Caledonian
Credit Memo - Discount on
Date: Wed, 01 Sep 1999 15:11:03 -0500
From: "Sue Lynch" SueL@wma.clarkshoe.com
To: oraapps-l@cpa.qc.ca
Subject: AP-Discounts on Credit Memos
All,
We are on 10.7SC, Prod 16.1 AP.
My AP manager came to me with the following issue - A supplier is set up
with "Always Take Discounts" box checked in Supplier profile. However, we
did not think it would take a discount on a Credit Memo, but it did.
Additionally, we had a prior year transaction where we did NOT have the
discount taken on a credit memo and we cannot see that the supplier info
was recently updated.
If anyone else has dealt with this issue, your advice/solution would be
appreciated.
Thanks,
Sue
Date: Wed, 1 Sep 1999 16:50:09 -0400
From: "Maliszewski, Joseph" Joseph.Maliszewski@FMR.COM
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: AP-Discounts on Credit Memos
When you create a Credit Memo it gives you a warning about the Terms. It is
really about the payment but it also is in reference to discounts. Make sure
the terms are Immediate or some form of that without a discount. That
should eliminate your problem.
I am not sure what your question is on the last year issue. If you can
rephrase it we might be able to help.
Joe Maliszewski
Consultant
Date: Thu, 02 Sep 1999 07:15:03 -0500
From: "Sue Lynch" SueL@wma.clarkshoe.com
To: oraapps-l@cpa.qc.ca
Subject: RE: AP-Discounts on Credit Memos
Joe,
Thanks for the info. We're all set.
Thanks,
Sue
Cancelled Invoice - modify
Date: Thu, 2 Sep 1999 17:04:38 -0400
From: steve_veilleux@canammanac.com
To: OraApps-L@cpa.qc.ca
Subject: AP: Problem with cancelled invoice ...
Hi there,
We have an invoice with:
Status: Cancelled,
Posted: Partial
Hold: Distribution account is invalide
Amount: 0
We can not change the distribution account with the status Cancelled.
The status cancelled put the invoice amount at zero but the cancel
invoice(Negative amount) is not post to GL because of the hold .
At the end of the month the reconciliation didn't balance of the original
amount
of the invoice (The original invoice is not in the Aging and also the
cancel
invoice is not on the Posted Invoice Register).
How I can change the account distribution and release the hold ?
Richard Veilleux
Any Help will be appreciate...
Thanks!
Steve V.
Le Groupe Canam Manac
Date: Thu, 02 Sep 1999 16:30:31 -0500
From: "Debbie Griffin" dgriffin@fnal.gov
To: "oraapps-l" oraapps-l@cpa.qc.ca
Subject: AP: Problem with cancelled invoice ...
You will probably have to re-enable the code combination and let it post.
Before disabling it again, you may want to make an entry (invoice or
journal) to back out the charge to that disabled account.
-- Debbie Griffin
Fermilab
dgriffin@fnal.gov
630-840-8754
Date: Thu, 02 Sep 1999 15:48:31 -0600
From: Alex Waddell alex.waddell@shaw.ca
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Problem with cancelled invoice ...
Richard
It sounds like you are saying that your invoice distribution lines are out
of balance with the total amount of your invoice (zero dollars), but you can
not delete them since the status of the invoice is cancelled. Is this
correct?
If so, you may need to correct this problem at the operating level. Use a
SQL script to determine the invoice_id, make a note of the cancelled_date,
cancelled_by and cancelled_amount for that invoice_id.
The set those three fields to null (cancelled_date, cancelled_by,
cancelled_amount withing ap_invoices_all). Go into the application and
correct the distributions, then reset those three fields back to their
original value.
Alex
Expense Report Inv Import - No Home Address
Date: Fri, 3 Sep 1999 06:53:39 -0500
From: "Anderson, Darren" daanderson@unitrin.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: Need Help with Error: "No Home Address" when trying to import exp
After entering our expense reports we tried running the invoice import
program and for one of the employees(who we have processed before) we
received the "No Home Address" on the rejection report for this employee.
We have it setup so that the address used is supposed to be the 'Office'
address.
Oddly enough when we navigated to their address information under the "Enter
Employee" menu, it popped a ...........United States..... text string
in the address field. This allowed us to process it, but it printed 'United
States' on the check rather than their address.
Are there any AP experts out there who could help me resolve this. I
promise not to take up too much of your time. If so, please respond
to me directly at daanderson@unitrin.com mailto:daanderson@unitrin.com .
It is easier than trying to read through all the emails that come through the
list.
Thanks
Date: Fri, 3 Sep 1999 08:28:18 -0500
From: "Puchniak, Stan" Stan_Puchniak@standardaero.ca
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Cc: "'daanderson@unitrin.com'" daanderson@unitrin.com
Subject: RE:Need Help with Error: "No Home Address" when trying to import
Hi Darren,
Have you defined a location (Navigate\Setup\Organization\Locations)? This
location has to be assigned to the employee. This should be the address
defined when the employee vendor site is created. When defining the
location, please ensure that "office site" is "yes".
Stan
Open Invoice Import Interface-Poor performance
Date: Tue, 07 Sep 1999 16:45:02 -0500
From: Srini Chavali Srini.Chavali@Cummins.com
To: OraApps-L@cpa.qc.ca
Subject: AP 10.7 - Payables Open Invoice Import Interface - Performance
Problems
All,
(APPS Version is 10.7SC, Database version is 7.3.4.3)
We are testing the Payables Open Invoice Import Interface (executable is
APXIIMPT) in preparation for going live with Payables 10.7 and are
experiencing
performance problems. It takes over 25 hours to process about 30,000 rows in
the
interface table.
I was wondering if other customers out there had encountered similar issues
and
what, if any, they had done to speed up the import. I have an open TAR with
Oracle on this issue (and have not found anything of significance on
Metalink
related to this issue).
I am not the functional person but can get the required answers to any
follow-up
questions you may have !
Thanks in advance !
Srini Chavali
Oracle DBA
Cummins Engine Co
1099 payments - Import
Date: Wed, 08 Sep 1999 08:54:21 -0400
From: Tom Vereecke tjv7404@ritvax.isc.rit.edu
To: oraapps-l oraapps-l@cpa.qc.ca
Subject: AP - import 1099 payments
I am in need of some insight from the AP experts out there. We out
source our Workman's Comp payment process to an outside vendor who makes
all these payments for us. We have been able to incorporate these
payments into our legacy 1099 process without cutting any checks for
reporting purposes. Now that we have converted over to Oracle my
question is simple. How do I import these payments into Oracle so they
become part of my 1099 process without cutting an actual check?
Thanks.
Thomas J. Vereecke
Senior Systems Specialist
Rochester Institute of Technology
103 Lomb Memorial Drive
Rochester, New York 14623-5608
(716) 475-2252 phone
(716) 475-7520 fax
tjv7404@rit.edu
Expense Reports not working with Netscape
Date: Wed, 8 Sep 1999 14:18:50 -0400 (Eastern Daylight Time)
From: Mary Ann Carr macarr@cmu.edu
To: oraapps-l@cpa.qc.ca
Subject: Self Service Apps
Hello,
Has anyone experienced/overcome problems running expense reports
from Netscape. We are experiencing an overwhelming number of help desk
calls from folks attempting to enter expense reports in various
versions of Netscape. Typically when they attempt to enter receipts or
return from viewing receipts their sessions hang. To exit, they must
kill Netscape and/or reboot. This doesn't seem to happen in IE. In
some cases they eventually succeed but many have been unable to
complete an expense report after numerous attempts and reboots. A
folks see memory violation errors.
Any ideas?
Thanks so much!
MAC
Mary Ann Carr
Director of Administrative Computing
Carnegie Mellon
macarr@cmu.edu
(412) 268-8556
Expense Reports in AP Pmt through PeopleSoft Payroll
Date: Thu, 09 Sep 1999 08:52:38 -0400
From: "Dale Conway" DConway@lydall.com
To: OraApps-L@cpa.qc.ca
Subject: EE Expense Reports
We are investigating the idea of paying our employee expense reimbursements
through our Peoplesoft payroll system. Some would like to enter the
information into Oracle Payables then export the data to our payroll
system for payment. This means we would not process a check out of the
Payables system. Has anyone done this or investigated this method? I am
looking for reasons to do it or not to do it.
Tolerances - customize
Date: Mon, 13 Sep 1999 08:54:35 -0400
From: "Mario Simmons/MIS/HQ/KEMET/US" MarioSimmons@kemet.com
To: oraapps-l@cpa.qc.ca
Subject: AP: Tolerances
Issue From User:
The tolerances available for Price, which is a percentage, and Total
Shipment Amount, which is a fixed dollar amount, do not place the we would
like because they are based on purchase order price/totals, not receipt
price/totals. If the calculation was based on the receipt it would place
the appropriate hold(s). We want the system to place a hold on an invoice
that has a price variance of greater than 10% and with a cap of $100 per
receipt. Individual invoices could be under the 10% price tolerance (unit
price) but the cumulative shipment value (PO price x receipt quantities vs.
invoice price x receipt quantities) could still be greater than $100, and
therefore would go on hold for price.
Is there a way to make this happen in Rel 10.7 PROD 16.1??
Thanks
Mario Simmons
KEMET Electronics
Delte unwanted Invoices
Date: Tue, 14 Sep 1999 15:28:20 -0400
From: "Sue Lynch" SueL@wma.clarkshoe.com
To: oraapps-l@cpa.qc.ca
Subject: AP Unwanted Invoice Q
All,
We are on 10.7SC, Prod 16.1 AP. We have invoices that are over 1 yr old
but still show up on the AP trial balance report, even though we have
"canceled" the invoice.
When I pull up the invoice, it has been Posted and status of Canceled.
The "Delete" button looks like it's available, however, when I press it,
Oracle says that I "cannot delete invoices that have a status of posted."
The distributions on the invoice are equal debits and credits that
zero., therefore I really just want to get the info off of my report since
there is no balance to pay.
How can I delete these Invalid and unwanted invoices without having to
go behind the scenes into the tables? or do I have to go behind the
scenes?
Any advice is appreciated.
Thanks,
Sue
Date: Tue, 14 Sep 1999 16:58:19 -0400
From: Darlene_D_Dougherty@CORP.CNG.COM
To: oraapps-l@cpa.qc.ca
Subject: Re: AP Unwanted Invoice Q
hi sue,,, give oracle support a call their are patches that fix the problems
mentioned