Signal 4 Error
Date: Mon, 22 Mar 1999 15:27:41 -0800
Date: Mon, 22 Mar 1999 15:33:17 -0800 Customer Interface
--- Kumaran Ravindaran kumaranr30@yahoo.com wrote:
Date: Wed, 24 Mar 1999 09:57:16 -0800 (PST)
Date: Wed, 24 Mar 1999 13:57:49 -0500
Date: Wed, 24 Mar 1999 13:01:23 -0800 (PST)
Date: Fri, 26 Mar 1999 08:25:15 PST
Date: Mon, 29 Mar 1999 05:06:54 PST Tables mismatch
Date: Mon, 12 Apr 1999 10:59:05 +0800
Date: Mon, 12 Apr 1999 13:45:34 +1000 Valid Cust profile
Date: Thu, 6 May 1999 09:51:57 +0100 Importing multiple customers
Date: Fri, 25 Jun 1999 18:42:11 -0500
Date: Fri, 25 Jun 1999 18:36:09 -0600
Date: Mon, 28 Jun 1999 09:58:27 -0400 (EDT)
Date: Fri, 2 Jul 1999 11:48:49 -0400 Customer Interface finished with error : Error from racvci
Date: Tue, 29 Jun 1999 17:06:07 -0400
Date: Tue, 29 Jun 1999 18:05:24 -0700 (PDT) Customer Interface Loading
From: Terry_Woodson@taylorbigred.com [SMTP:Terry_Woodson@taylorbigred.com]
Date: Tue, 13 Jul 1999 17:59:34 +0300
Date: Tue, 13 Jul 1999 08:20:29 -0700 (PDT) Interface Parameters
Date: Wed, 31 Mar 1999 11:37:46 PST
From: "Ishihara, Bill" bishihara@trimarine-usa.com
-----Original Message-----
Date: Tue, 30 Mar 1999 14:17:30 -0600 How to Repopulate GL Interface
From: On Behalf Of Taran, Delfino
Date: Sun, 11 Jun 2000 09:42:18 -0700
Date: Thu, 8 Jun 2000 08:37:55 -0500
From: "Raman Anand"
Subject: Signal 4 error
The print invoices report in AR is terminating with signal 4 error.This
is not happening
with all the invoices.1 out of 10 invoices is having this problem.We are
on 10.7 NCA
now.We were having the same problem on 10.7 Character also.
Any leads to this problem will be greatly appreciated.
Thanks
Raman
From: nandak@edify.com
Subject: RE: Signal 4 error
I came across these errors sometime ago, but I noticed that, in our system ,
we used to get these errors mainly because of report writer errors. One
problem I identified was when the text/value does not fit in the report
template. So try fixing this in the layout.
It worked for me, hope it works for you too!!
--Nanda
Hi All,
I tried to import just one customer through Customer
Interface. I just
manually inserted all following the mandatory columns
in
RA_CUSTOMER_INTERFACE table.
CUSTOMER_CATEGORY_CODE
CUSTOMER_NAME
CUSTOMER_NUMBER
CUSTOMER_STATUS
CREATION_DATE
CREATED_BY
INSERT_UPDATE_FLAG
LAST_UPDATE_DATE LAST_UPDATED_BY
ORIG_SYSTEM_CUSTOMER_REF
And then I ran the Customer Interface through
Application.I didn't get
any error. But in log script, it was like '0 rows
marked to process.'
Do I need to populate all the mandatory columns in
all the Customer
interface tables to create one customer.
Can anyone please help me with this.
Thanks
Kumar
From: Sitikantha Panigrahi sitikantha@yahoo.com
Subject: Re: AR: Customer Interface
Hi Kumar,
To import any new customer thru' customer interface, you need to have a
customer level profile in RA_CUSTOMER_PROFILES_INT_ALL interface table.
You have to provide data for required columns in this table.
-Sitikantha
From: "Vijay Kumar Addanki" vijaykumar@email.msn.com
Subject: Re: Customer Interface
Hi,
In customer interface u need to populate three tables
ra_customers_interface_all, ra_customer_profiles_int_all and
ra_cust_pay_method_int_all.
To create a Bill to site u need to have atleast one legal site (site use
code).
some columns are not mandatory but required for the interface to run.
Hope this helps
Thanks
Vijay K. Addanki
Mastech Corp.
From: Kumaran Ravindaran
Subject: Re: Customer Interface
Hi,
I inserted all the mandatory columns in RA_CUSTOMERS_INTERFACE and
A_CUSTOMER_PROFILE_INT_ALL.
And this time when I ran the Customer Interface, It was completed
Successfully and created a customer too.
I don't why it was not working before. Anyway now I am clear that you
can import a customer just using these two tables.
I really appreciate all your help.
Thanks
Kumar.
From: "tayi sanjit" sandytayi@hotmail.com
Subject: Re: AR: Customer Interface
Kumaran,
To run customer interface from AR you have to populate the
Ra_customer_profile_class table also in addition to the Customer
interface table. After all the required / not null fields are populated
in these 2 tables, then u can run the Customer Interface Program and
your customer record will be inserted in AR.
Hope this helps!
Bye
sandy
From: "Basanta Kumar Dash" dashbk@hotmail.com
Subject: Customer Interface
Hi,
I am facing some problem while uploading customer bank information from
my legacy system.
I have my bank master table with the branches, but, no account name
defined for the bank and branch.
As per the document I am assigning values to the bank_account_name,
bank_account_currency_code, bank_account_num, bank_name and
bank_branch_name fields.
This is working fine when there is only one bill to location for a
customer. However, if the customer is having more than one bill to
location then the error message is appearing as "Bank name and branch
name already exists". The message is valid as the bank nams and the
branch name already exists in AP_BANKS. But, I need to provide this
information as the bank account name does not exist. Now, I don't know
what to do.
Has anybody encountered this error before? Is it a bug or there is some
solution to this problem.
Your help is most appreciated.
Thanks and regards,
Basanta.
From: "Sriram, PUC - 4055" sriram@panunited.com.sg
Subject: AR Customer Interface error
Hi All
Here with I am attaching the log file for the error in AR Customer
Interface. Could you please also help me to clear the
relation ship and uniqueness of the interface tables. When I search for
the index, I found there are composite indices
created on non unique basis.
ra_customers_interface -
orig_system_customers_ref,orig_system_address_ref,site_use_code
ra_customer_profiles_interface -
orig_system_customers_ref,orig_system_address_ref
Can you also tell how many profile records should be populated in the
profiles interface table for each customer
with different bill_to and ship_to and site_use_codes.
Please cc your response to
sriram@panunited.com.sg
Thanking you
The Log is
Oracle Receivables: Version : 7.0.152 - Development
Copyright (c) Oracle Corporation 1979, 1991. All rights reserved.
RACUST module: Customer Interface
+---------------------------------------------------------------------------+
Current system time is 12-APR-1999 09:28:56
+---------------------------------------------------------------------------+
Connected To Oracle.
racmar: mark records for processing.
Current system time is 12-APR-1999 09:28:56
racmar: marked 1508 rows in RA_CUSTOMERS_INTERFACE
Current system time is 12-APR-1999 09:28:57
racmar: marked 1146 rows in RA_CONTACT_PHONES_INTERFACE
Current system time is 12-APR-1999 09:28:58
racmar: marked 0 rows in RA_CUST_PAY_METHOD_INTERFACE
Current system time is 12-APR-1999 09:28:58
racmar: marked 0 rows in RA_CUSTOMER_BANKS_INTERFACE
Current system time is 12-APR-1999 09:28:58
racmar: marked 393 rows in RA_CUSTOMER_PROFILES_INTERFACE
Current system time is 12-APR-1999 09:28:58
Current system time is 12-APR-1999 09:28:58
racmar: mark records for processing.
racvci: validating data.
Current system time is 12-APR-1999 09:28:58
Validate cust_int-Aa
racvci: records in error 0
Current system time is 12-APR-1999 09:28:58
racvci: records in error 14
Current system time is 12-APR-1999 09:28:59
Validate cust_int-Ab
racvci: records in error 0
Current system time is 12-APR-1999 09:29:00
Validate cust_int-B
racvci: ORA-00904: invalid column name
racvci: Error validating field level data.
Current system time is 12-APR-1999 09:29:00
Error from racvci.
+---------------------------------------------------------------------------+
Concurrent request completed
Current system time is 12-APR-1999 09:29:00
+---------------------------------------------------------------------------+
Sriram
From: "Bevin Watson"bevin.watson@abs.gov.au
Cc: sriram@panunited.com.sg
Subject: AR Customer Interface error
Sriram, I suspect it is seriously broken and you should contact support.
Your tables do not match the program which is trying to use those tables.
Is there a possibility that you have applied some patches to Receivables
but had either the relink fail, or the database objects change fail?
Just regarding the uniqueness, you can set profiles at the customer level,
or optionally down to the address level but only for billing sites (because
it only makes sense for billing sites).
Therefore you may only have one record in the profiles interface for a
particular customer and address.
So, imagine
Customer ACME Bomb Co
Shipping Address 1 Nevada
Shipping and Billing Hollywood
Billing Address Kowloon
You might end up with
ra_customers_interface
ACME Bomb Co, Nevada, SHIP_TO
ACME Bomb Co, Hollywood, BILL_TO
ACME Bomb Co, Hollywood, SHIP_TO
ACME Bomb Co, Kowloon, BILL_TO
and you, depending on your requirement, might either put into
ra_customer_profiles_interface:
ACME Bomb Co,, My_Best_Customers_Profile
or if you want to have different setting for each billing address:
ACME Bomb Co, Hollywood, My_Best_Customers_Profile
ACME Bomb Co, Kowloon, Keep_An_Eye_On_This_One_Profile
Hope this makes sense
Bevin Watson
Financial Systems Administrator
Australian Bureau of Statistics
From: Chris.Phillips@blackwell.co.uk
Subject: Solution - Receivables Customer Interface (10.7)
Hello All,
Thanks to all of you who responded. I should have mentioned that I
already had a Customer Profile set up and that I was referencing that in the
ra_customer_profiles_int_all table. I finally got through to Oracle Helpdesk
and they gave me the solution. I was entering a value in the
orig_system_address_ref column in the ra_customer_profiles_int_all table and
this caused the problem.
Solution Description:
=====================
You need to have at least a customer-level profile.
Don't specify a value for orig_system_address_ref.
Original Problem
I've been having problems with the Receivables Customer Interface. I
have cut the data that I am putting into the two tables
ra_customers_interface_all and ra_customer_profiles_int_all down to just one
record each. I am getting the error:
APP-43560 Customer record for insert must have validated profile record
defined
for Exception records in RA_CUSTOMERS_INTERFACE, which is not unusual, but I
am also getting exactly the same error for the for the exception records in
RA_CUSTOMER_PROFILES_INTERFACE.
Regards,
Chris
01865 791926
From: "Mittal, Anjula" MittalA@bvsg.com
Subject: AR: Customer Interface
We are trying to use customer Interface to import customers. When we are
trying to run the process it error out saying:
'Error while trying to insert record into customer profile: SELECT... INTO
return multiple rows'. But when I try to import just one customer from same
data, it works fine. I have inserted customer and address info in
RA_CUSTOMERS_INTERFACE_ALL and one profile record for each customer in
RA_CUSTOMER_PROFILES_INT_ALL table.
We are on 11.0.3 . Any help is appreciated.
Thanks in advance.
Anjula.
From: srmeka@amrion.com
Subject: RE: Customer Interface
Hi Anjula.,
I experienced the same problem in 10.7 version. It is Oracle bug. After
applying patch it is working. Eventhough we are in megapatch 'Q', after
applying this specific patch related to customer conversion it worked well.
With regards.,
SrinivasMeka
From: Patty Phelan jpiphelan@stlnet.com
Subject: Re: Customer Interface
We also are experiencing this problem (only after installing AR-Q). Do
you know the bug number or patch number? OWWS doesn't know what I'm
talking about when I called.
Thanks,
-Patty Phelan
From: ngptbyt@bse01.ae.ge.com (Chetan G Manjarekar)
Subject: Re: Customer Interface
HI Patty,
This is a known Oracle Receivables problem. The bug number is 822300.
Don't recall the patch number. Please check on metalink site and
confirm if your symptoms are the same as mentioned. I had this problem
on Release 11, Oracle Receivables while importing Customers thru
Customer Interface. The patch sure worked for me.
- Chetan Manjarekar
Data Conversion Inc.
From: "John Langenfelder" John_Langenfelder@norstanconsult.com
Subject: AR:Cust Interface error
To all,
I am getting a completed error when running the customer interface. We
have been running it for the past
couple of weeks on small batches without any problems. It was fully loaded
with all customers and the job started
getting the resulting error. We cut the batch down to 5 customer and it is
still erring. Below is the request log and diagnostic log (no report -
never gets that far)
TIAFYH
Below is the request log from running the Customer Interface program.
There is no report as the request errored. After the request log, is the
report diagnostic text. Please feel free to contact me at 440-329-6734.
+------------------------------------------------------------------------+
Oracle Receivables: Version : 7.0.152 - Development
Copyright (c) Oracle Corporation 1979, 1991. All rights reserved.
RACUST module: Customer Interface
+-----------------------------------------------------------------------+
Current system time is 28-JUN-1999 09:07:46
+--------------------------------------------------------------------- -+
Connected To Oracle.
racmar: mark records for processing.
Current system time is 28-JUN-1999 09:07:46
racmar: marked 295 rows in RA_CUSTOMERS_INTERFACE
Current system time is 28-JUN-1999 09:07:47
racmar: marked 221 rows in RA_CONTACT_PHONES_INTERFACE
Current system time is 28-JUN-1999 09:07:47
racmar: marked 384 rows in RA_CUST_PAY_METHOD_INTERFACE
Current system time is 28-JUN-1999 09:07:48
racmar: marked 0 rows in RA_CUSTOMER_BANKS_INTERFACE
Current system time is 28-JUN-1999 09:07:48
racmar: marked 153 rows in RA_CUSTOMER_PROFILES_INTERFACE
Current system time is 28-JUN-1999 09:07:48
Current system time is 28-JUN-1999 09:07:48
<>racvci: validating data.
Current system time is 28-JUN-1999 09:07:48
Validate cust_int-Aa
racvci: records in error= 6
Current system time is 28-JUN-1999 09:07:49
racvci: records in error= 0
Current system time is 28-JUN-1999 09:07:49
Validate cust_int-Ab
racvci: records in error= 22
Current system time is 28-JUN-1999 09:07:49
Validate cust_int-B
racvci: records in error = 8
Current system time is 28-JUN-1999 09:07:51
Validate cust_int-C
racvci: records in error = 80
Current system time is 28-JUN-1999 09:07:51
Validating cust_int-DE
racvci: records in error = 0
Current system time is 28-JUN-1999 09:07:52
raclfv: Validate tax location flexfield data
Current system time is 28-JUN-1999 09:07:52
raclfv: ORA-01401: inserted value too large for column
ORA-06512: at "APPS.ARP
racvci: Error from raclfv, tax location flexfield validation
Current system time is 28-JUN-1999 09:07:54
racvci: Error validating field level data.
Current system time is 28-JUN-1999 09:07:54
Error from racvci.
+-----------------------------------------------------------------+
Concurrent request completed
Current system time is 28-JUN-1999 09:07:55
+---------------------------------------------------------------+
This is the text from the Request disagnostics:
This request finished with an error and produced the following completion
message: Error from racvci.
The processing began on 28-JUN-99 09:07:44 and ended on 28-JUN-99
09:07:55. You may find more information
on the cause of the error in the request log or the concurrent manager log.
From: Alok Chadda aschadda@yahoo.com
Subject: RE:AR:Cust Interface error
Hi John,
I never seen this error before but I want you to look for couple of
things.
I think you alraedy know about following
Whenever you run CUstomer Interface, the Customer Interface program
along with inserting data into customer tables, it also sees your TAX
setup and check for option (I don't remember the name of it but it is
in System->System Options->Tax alternate region, it has three values
error, warning and one more). It checks whether the tax location
combination value is (province/city-county-state combination) already
in the system. If it is not, program inserts this value into tax
tables.
Check whether the value you are passing is bigger in province field is
larger than the length defined in your tax location flexfield segment.
I don't think it has anything to do with number of records.
HTH
Alok
Sent: Tuesday, July 13, 1999 3:51 PM
Subject: CUSTOMER_INTERFACE loading problems
Need help loading data to the CUSTOMER_INTERFACE.
Receive the following error when trying to add just a few records to
the CUSTOMER_INTERFACE:
I have sent an example showing the record that I'm trying to add.
The error message I'm getting follows:
Cause: A new customer record marked for insert must have
02633100 A02633100001
SHIP_TO
Customer record for insert must have validated profile record defined
RA_ CUSTOMERS_INTERFACE fields are populated as such
(2) records are being passed : one for 'SHIP_TO' and another for
'BILL_TO'
ORIG_SYSTEM_CUST_REF = '02633100'
SITE_USE_CODE = 'Ship To'
SYSTEM_ADDRESS_REF = 'a02633100001' *note* last three digits
being seq# if customer exist
---- more than once but in a different location.
1) 02633100 - ABC Corporation New York NY
2) 02633200 - ABC Corporation Jackson MS
* This customer exist more than one time. The SYSTEM_ADDRESS_REF
will be defined as 'a02633100001' for
* the first record and 'a02633100002' for the second record with
the CUSTOMER_NUMBER being different. Correct ?
* If so, will ORIG_SYSTEM_CUST_REF = '02633100' and
SYSTEM_ADDRESS_REF = '02633100002' in the
* RA_CUSTOMERS_PROFILES_INTERFACE and CONTACE_PHONES_INTERFACE for
the second record ?
* Does the customer # '02633200' need to be defined anywhere else
besides in the
* RA_CUSTOMER_INTERFACE' ?
INSERT_UPDATE_FLAG = 'I'
CUSTOMER_NAME = 'ABC Corporation'
CUSTOMER_NUMBER = '02633100' and another record sent for
same customer '02633200'
CUSTOMER_STATUS = 'A'
PRIMARY_SIT_USE_FLAG = 'Y'
ADDRESS1 = address
ADDRESS2 = " "
CITY = city
STATE = state
COUNTY = county
POSTAL_CODE = zip
COUNTRY = usa
CATEGORY_CODE = 'dealer'
RA_CONTACE_PHONES_INTERFACE fields are populated as such:
INSERT-UPDATE_FLAG = 'I'
ORIG_SYSTEM_CUST_REF = '02633100'
CUSTOMER_PROFILE_CLASS_NAME = Net 30 Days'
CREDIT_HOLD = 'N'
SYSTEM_ADDRESS_REF = 'A02633100001' *
another record with this field changing to 'A02633100002'
RA_CONTACT_PHONES_INTERFACE
ORIG_SYSTEM_CUST_REF = '02633100'
ORIG_SYSTEM_REF =
'T02633100001' *another record with this field changing to 'T02633100002'
SYSTEM_TELEPHONE_REF = 'T02633100001T001'
TELEPHONE =
'1234567890'
TELEPHONE_TYPE = 'PHO'
The following error occurs trying to load RA_CONTACT_PHONES_INTERFACE
TELEPHONE_TYPE must be defined as 'COMM'
If any questions or if anyone can lend assistance, it will be much
welcomed.
THANKS
From: Mohammad Fouwaaz Mfouwaaz@savola.com
Subject: RE: CUSTOMER_INTERFACE loading problems
Hi Terry,
It is a very straightforward exercise once you get the knack of it. The
method I adopt is as follows
Step 1
Create Excel sheet with customer data from legacy system with following
columns:
ORIG_SYSTEM_CUSTOMER_REF
, INSERT_UPDATE_FLAG
, CUSTOMER_NAME
, CUSTOMER_NUMBER
, CUSTOMER_STATUS
, ORIG_SYSTEM_ADDRESS_REF
, SITE_USE_CODE
, PRIMARY_SITE_USE_FLAG
, LOCATION
, ADDRESS1
, CITY
, COUNTRY
, DEMAND_CLASS_CODE
, ORG_ID
, ADDRESS_ATTRIBUTE3
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, CREATED_BY
Save Excel sheet as .csv comma-delimited file
FTP .csv file to unix
Create .ctl control file to transfer .csv file to RA_CUSTOMERS_INTERFACE_ALL
standard table with identical column names
Run sqlloader
Step 2
Create Excel sheet with customer data from legacy system with following
columns:
CREATED_BY
, CREATION_DATE
, CUSTOMER_PROFILE_CLASS_NAME
, INSERT_UPDATE_FLAG
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, ORG_ID
, ORIG_SYSTEM_CUSTOMER_REF
, CREDIT_HOLD
Save Excel sheet as .csv comma-delimited file
FTP .csv file to unix
Create .ctl control file to transfer .csv file to
RA_CUSTOMER_PROFILES_INT_ALL standard table identical column names
Run sqlloader
Step 3
Create Excel sheet with customer data from legacy system with following
columns:
CREATED_BY
, CREATION_DATE
, INSERT_UPDATE_FLAG
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, ORG_ID
, ORIG_SYSTEM_CUSTOMER_REF
, ORIG_SYSTEM_TELEPHONE_REF
, TELEPHONE
, TELEPHONE_TYPE
Save Excel sheet as .csv comma-delimited file
FTP .csv file to unix
Create .ctl control file to transfer .csv file to RA_CONTACT_PHONES_INT_ALL
standard table identical column names
Run sqlloader
Step 4
Run Customer Interface
This is a dump from one of my files and if you require further assistance
please do not hesitate to ask.
Regards
From: Betty Chacko maria_francis@yahoo.com
Subject: Re: CUSTOMER_INTERFACE loading problems
Hi Terry ,
In order to insert a Customer Record at any time you must have a
Customer profile defined at the Customer Level.
Soln.
Check if if you have created a profile for the Customer , If not do so.
Then run the Interface it will go thru.
Betty
From: "tayi sanjit" sandytayi@hotmail.com
Subject: RE: receivables interface parameter invoice source returns no list of values
Ishihara,
Go to the Receivables Interface Program in System Administration and
find out the value set attached to the program parameter Batch Source.
The value set is OE: AR Batch Source . Go to that Value set, which is
table validated and change the name of the table to RA_BATCH_SOURCES_ALL
instead of RA_BATCH_SOURCES
This was one of the ways we got over the problem during the previuos
implementations.
If it doesn't work let me know...I have other solutions.
Bye
sandy
Subject: RE: receivables interface parameter invoice source returns no
list of values
Date: Wed, 31 Mar 1999 12:33:33 -0500 (EST)
Krishna,
Yes, the source is set to 'Imported'
Thanks,
Bill
From: Ishihara, Bill [SMTP:bishihara@trimarine-usa.com]
Sent: Wednesday, March 31, 1999 12:09 PM
Subject: receivables interface parameter invoice source returns no
list of values
We are currently in the process of implementing 11.2 on NT and we are
multi-org. We cannot run receivables interface because we cannot
pick an
invoice source in the parameters window. When we navigate to invoice
source
and click on LOV we get the message "No entries found for list of
values".
I have defined a batch source of "Order Entry" with a transaction
type of
"INVOICE". The transaction type has a class of "Invoice" and is
tagged
with
a valid credit memo type. The attributes for the batch source are
set to
"Id" and the profile WSH: Invoice Numbering Method is set to
Automatic.
Can any one give me a clue as to what the problem may be?
Thanks,
Bill Ishihara
(310) 548-6245
bishihara@trimarine-usa.com
From: "Ishihara, Bill" bishihara@trimarine-usa.com
Subject: RE: receivables interface parameter invoice source returns no lis
Thanks to all for the numerous replies. The solution was that I had set the
attributes in the various regions of the batch source to 'Id' but I did not
have the attribute for 'Sales Credit' set to 'Percent'. Once I set the
attribute to 'Percent' the LOV had values in the Receivable Interface job.
Bill
Sent: Thursday, June 08, 2000 2:01 AM
Subject: How to repopulate GL_interface_table from AR
Dear All,
I have run gl interface from AR, then it populated the interface table, with
few
errors, then I deleted the journal import.
After I made corrections in AR, then I run GL interface again, but it only
creates
transaction that I have corrected. How about the others that I have deleted
in the
journal import.
Somebody told me, because the system creates a flag to the transactions that
have been
transferred to GL.
How to repopulate GL interface table again ?
Thanks and regards,
Fino
Author: "Mohan Iyer" miyer@fortuna.com
Subject: RE: How to repopulate GL_interface_table from AR
I amnot sure why you deleted the GL interface table records. Because if the
records have been sent to GL (Interface) form the AR module there is no easy
way for you to have them sent again. The Unposted Items Report actualy shows
you what has not been sent. These can be corrected and sent again only.
I am not sure you are in a position to make those records that came over to
the GL Interface be sent again easily.
There are just too many tables you need to look at! You could give it a try,
check the TRM to identify the tables (I do not have the names readily
avaialble) and then you will have to make a SQL update! Always a problem
here (Support and all that).
Thanks,
Mohan Iyer
Financials Consultant
Sunnyvale, CA
Author: "Robertson, Cassandra F." cfrobert@southernco.com
Subject: RE: How to repopulate GL_interface_table from AR
Defino,
AR thinks that the other entries went through. What you need to do is flag
the transactions in that batch. You need to run the ARGCGP to reset the
posted status. You need to verify that the AR period affected is open.
Make sure you have the correct posting_control_id. Go to System Admin /
Concurrent Program Define and Query the ARGCGP short name. Copy this
program to a custom program, click on USE in SRS save and click on
parameters and enter the following.
Parameter ValueSet Default
Value Req Display
Set of books id AR_SRS_SET_OF_BOOKS_ID Constant
Y Y
Posting_control_id 15 Char
Y Y
Reset_gl_pst_date 4 Char Constant
Y Y Y
del_gl_interface 4 Char
Constant Y Y Y
debug_flag 6 char Constant
N Y Y
Add the program to a request group.. Save . Run the program
And rerun the gl interface.
HOPE THIS HELPS.
Be careful when running this, this is a unsupported feature. But it worked
for us. We had the same problem.
Be Blessed!!!
Cassandra Robertson
Southern LINC - CIS Operations
(desk) 678-443-1619
(LINC) 770-550-0484 PRVT ID. 4484
cfrobert@southernco.com