| Problem in When Running Autoinvoice [message #204615] |
Tue, 21 November 2006 06:49  |
seenujanu
Messages: 53
Registered: August 2006
Location: chennai
|
Member |
|
|
Hai Fri,
Problem in When Running Autoinvoice
i have inserted data into interface tables,then i am running the conc program i am getting this error.
i have created the batch source batch_source_name = SAPPS_INV_SOURCE
and then i have given INTERFACE_LINE_CONTEXT is SAPPS_INVOICES,
INTERFACE_LINE_ATTRIBUTE1,
INTERFACE_LINE_ATTRIBUTE2,
the error is this
Invalid context field value "SAPPS_INVOICES" passed to flexfield routine FDFDFA
would u Plz let me know the columns in detail how to use this
INTERFACE_LINE_CONTEXT,
INTERFACE_LINE_ATTRIBUTE1,
INTERFACE_LINE_ATTRIBUTE2,
+---------------------------------------------------------------------------+
Oracle Receivables: Version : 11.5.0 - Development
Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.
RAXTRX module: Autoinvoice Import Program
+---------------------------------------------------------------------------+
Current system time is 21-NOV-2006 17:12:26
+---------------------------------------------------------------------------+
raagsp()+ Current system time is 21-NOV-2006 17:12:26
raagsp()- Current system time is 21-NOV-2006 17:12:26
raaini()+ Current system time is 21-NOV-2006 17:12:26
raaapx()+ Current system time is 21-NOV-2006 17:12:26
raaapx()- Current system time is 21-NOV-2006 17:12:27
raagbo()+ Current system time is 21-NOV-2006 17:12:27
Dumping data fetched from RA_BATCH_SOURCES
batch_source_name = SAPPS_INV_SOURCE
auto_trx_numbering_flag = Y
copy_doc_number_flag = N
cust_trx_type_rule = I
sold_customer_rule = I
bill_customer_rule = I
bill_address_rule = I
bill_contact_rule = N
ship_customer_rule = I
ship_address_rule = I
ship_contact_rule = N
memo_reason_rule = I
term_rule = I
invoicing_rule_rule = I
accounting_rule_rule = I
unit_of_measure_rule = I
agreement_rule = I
inventory_item_rule = I
fob_point_rule = N
ship_via_rule = N
invalid_lines_rule = R
salesperson_rule = I
sales_credit_type_rule = I
accounting_flexfield_rule = I
invalid_tax_rate_rule = C
rev_acc_allocation_rule = P
gl_date_period_rule = R
create_clearing_flag = Y
derive_date_flag = Y
sales_credit_rule = P
sales_territory_rule = I
receipt_method_rule = I
customer_bank_account_rule = I
related_document_rule = N
memo_line_rule = I
allow_sales_credit_flag = Y
raagbo()- Current system time is 21-NOV-2006 17:12:27
raaggi()+ Current system time is 21-NOV-2006 17:12:27
raagixpfx = 0
raagixtpf = 0
raagixddf = 1
raagixacf = 1
raagixrit = 0
raagixagd = 0
raagixatn = 1
raagixcte = 0
raagixdfd =
raagixctc = 2012970596
raagixrmx = T
raagixfdx = 21-NOV-06
raagixbix =
raagixbsi = 2188
raagixbnx = SAPPS_INV_SOURCE
raagixoix = 204
raagixrix = 2171971
raagixpix = 20428
raagixpai = 222
raagixuix = 0
raagixunx = SYSADMIN
raagixanx = AR
raagixlul = 1997704
raagixasc = 1
raagixrsf = 0
raagixcbf = 0
raagixuax = 1
Argtcm = 0
Argtvd = 0
raagixsnf = 1
raagixtao = 1
raagixptf = 1
raagixstf = 0
raagixrfi = 0
raagixtac = 0
raagixcai = 101
raagixsbi = 1
raagixcpr = 2
raagixmau =
raagixmlx = 3
raagixmbx = 131070
raagixafp = Account
raagixifp = Item
raagixtfp = Country
Argbdf = 1
Argddo = -9999
raaggi()- Current system time is 21-NOV-2006 17:12:27
raaseb()+ Current system time is 21-NOV-2006 17:12:27
raaseb()- Current system time is 21-NOV-2006 17:12:27
arcdsu()+ Current system time is 21-NOV-2006 17:12:27
arcdsu() error level: 3 array size: 131070 insert array size: 131070
arcdsu() Use Invoice Accounting For Credit Memo: Y
arcdsu()- Current system time is 21-NOV-2006 17:12:28
raaini()- Current system time is 21-NOV-2006 17:12:28
raapft()+ Current system time is 21-NOV-2006 17:12:28
raagtr()+ Current system time is 21-NOV-2006 17:12:28
FDPGRS cannot find your concurrent request 1959235
FDPGRS found no rows while selecting your concurrent request 1959235.
Please contact your support representative.
crb->raaucrpn = RAXTRX
crb->raaucrcr = 2171971
crb->raaucrnt = 0
crb->raaucrml = 3
raagtr()- Current system time is 21-NOV-2006 17:12:28
raamil()+ Current system time is 21-NOV-2006 17:12:28
raaasf()+ Current system time is 21-NOV-2006 17:12:28
raaasf()- Current system time is 21-NOV-2006 17:12:28
raaasf()+ Current system time is 21-NOV-2006 17:12:28
raaasf()- Current system time is 21-NOV-2006 17:12:28
raaasf()+ Current system time is 21-NOV-2006 17:12:28
raaasf()- Current system time is 21-NOV-2006 17:12:28
raaasf()+ Current system time is 21-NOV-2006 17:12:28
raaasf()- Current system time is 21-NOV-2006 17:12:28
raaasf()+ Current system time is 21-NOV-2006 17:12:28
raaasf()- Current system time is 21-NOV-2006 17:12:28
raaasf()+ Current system time is 21-NOV-2006 17:12:28
raaasf()- Current system time is 21-NOV-2006 17:12:28
raaasf()+ Current system time is 21-NOV-2006 17:12:28
raaasf()- Current system time is 21-NOV-2006 17:12:28
raaasf()+ Current system time is 21-NOV-2006 17:12:28
raaasf()- Current system time is 21-NOV-2006 17:12:28
raaasf()+ Current system time is 21-NOV-2006 17:12:28
raaasf()- Current system time is 21-NOV-2006 17:12:28
raaasf()+ Current system time is 21-NOV-2006 17:12:28
raaasf()- Current system time is 21-NOV-2006 17:12:28
raaasf()+ Current system time is 21-NOV-2006 17:12:28
raaasf()- Current system time is 21-NOV-2006 17:12:28
raaasf()+ Current system time is 21-NOV-2006 17:12:28
raaasf()- Current system time is 21-NOV-2006 17:12:28
raaasf()+ Current system time is 21-NOV-2006 17:12:28
raaasf()- Current system time is 21-NOV-2006 17:12:28
raaasf()+ Current system time is 21-NOV-2006 17:12:28
raaasf()- Current system time is 21-NOV-2006 17:12:28
raaasf()+ Current system time is 21-NOV-2006 17:12:28
raaasf()- Current system time is 21-NOV-2006 17:12:28
raaasf()+ Current system time is 21-NOV-2006 17:12:28
raaasf()- Current system time is 21-NOV-2006 17:12:28
raaasf()+ Current system time is 21-NOV-2006 17:12:28
raaasf()- Current system time is 21-NOV-2006 17:12:28
raaasf()+ Current system time is 21-NOV-2006 17:12:28
raaasf()- Current system time is 21-NOV-2006 17:12:28
raaasf()+ Current system time is 21-NOV-2006 17:12:28
raaasf()- Current system time is 21-NOV-2006 17:12:28
UPDATE RA_INTERFACE_LINES
SET
LAST_UPDATE_DATE = sysdate,
LAST_UPDATED_BY = :b1,
LAST_UPDATE_LOGIN = :b2,
TRX_DATE = TRUNC(TRX_DATE),
GL_DATE = TRUNC(GL_DATE),
ORIGINAL_GL_DATE = TRUNC(GL_DATE),
CONVERSION_DATE = TRUNC(CONVERSION_DATE),
PURCHASE_ORDER_DATE = TRUNC(PURCHASE_ORDER_DATE),
RULE_START_DATE = TRUNC(RULE_START_DATE),
SALES_ORDER_DATE = TRUNC(SALES_ORDER_DATE),
SHIP_DATE_ACTUAL = TRUNC(SHIP_DATE_ACTUAL),
CUSTOMER_TRX_ID = NULL,
INTERFACE_LINE_ID = NVL(INTERFACE_LINE_ID, RA_CUSTOMER_TRX_LINES_S.NEXTVAL)
WHERE NVL(INTERFACE_STATUS, '~') != 'P'
AND REQUEST_ID = :b3
AND LINK_TO_LINE_ATTRIBUTE1 IS NULL
AND LINK_TO_LINE_ATTRIBUTE2 IS NULL
AND LINK_TO_LINE_ATTRIBUTE3 IS NULL
AND LINK_TO_LINE_ATTRIBUTE4 IS NULL
AND LINK_TO_LINE_ATTRIBUTE5 IS NULL
AND LINK_TO_LINE_ATTRIBUTE6 IS NULL
AND LINK_TO_LINE_ATTRIBUTE7 IS NULL
AND LINK_TO_LINE_ATTRIBUTE8 IS NULL
AND LINK_TO_LINE_ATTRIBUTE9 IS NULL
AND LINK_TO_LINE_ATTRIBUTE10 IS NULL
AND LINK_TO_LINE_ATTRIBUTE11 IS NULL
AND LINK_TO_LINE_ATTRIBUTE12 IS NULL
AND LINK_TO_LINE_ATTRIBUTE13 IS NULL
AND LINK_TO_LINE_ATTRIBUTE14 IS NULL
AND LINK_TO_LINE_ATTRIBUTE15 IS NULL
len = 1135
2 rows updated Current system time is 21-NOV-2006 17:12:28
raagtf()+ Current system time is 21-NOV-2006 17:12:28
APP-FND-00778: Invalid context field value "SAPPS_INVOICES" passed to flexfield routine FDFDFA
Action: Pass an existing context field value or define this context value using the Define Descriptive Segments form.
Error calling fdfdfa()
Error calling raagtf()
Error calling raamil()
Error calling raapft()
raafds()+ Current system time is 21-NOV-2006 17:12:28
raafeb()+ Current system time is 21-NOV-2006 17:12:28
raafeb()- Current system time is 21-NOV-2006 17:12:28
arcdcu()+ Current system time is 21-NOV-2006 17:12:28
arcdcu()- Current system time is 21-NOV-2006 17:12:28
raafds()- Current system time is 21-NOV-2006 17:12:28
+---------------------------------------------------------------------------+
Start of log messages from Plsql program
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
End of log messages from PlSql program
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
No completion options were requested.
+---------------------------------------------------------------------------+
Concurrent request completed
Current system time is 21-NOV-2006 17:12:28
+---------------------------------------------------------------------------+
Regards
seenu
|
|
|
|
| Re: Problem in When Running Autoinvoice [message #204817 is a reply to message #204615] |
Wed, 22 November 2006 04:18  |
David.K.Dickson
Messages: 413
Registered: October 2005
Location: Surrey, England
|
Senior Member |
|
|
| seenujanu wrote on Tue, 21 November 2006 12:49 | Problem in When Running Autoinvoice
.
.
.
Invalid context field value "SAPPS_INVOICES" passed to flexfield routine FDFDFA
.
.
.
APP-FND-00778: Invalid context field value "SAPPS_INVOICES" passed to flexfield routine FDFDFA
.
Action: Pass an existing context field value or define this context value using the Define Descriptive Segments form.
|
Seenu,
If you look in the log, as I have highlighted above, you will find the Action that you need to take.
I do not have access to a system right now, so I can't give you any more precise instructions on how to "define this context value using the Define Descriptive Segments form", but if you need any more information, you should probably look in the "Oracle Applications Flexfields Guide". If you don't have a copy of the "Oracle Applications Flexfields Guide", it can be downloaded, with all of the other Applications Documentation from http://www.oracle.com/technology/documentation/applications.html
 HTH
David
[Updated on: Wed, 22 November 2006 04:21] Report message to a moderator |
|
|
|
|
|
| Re: Problem in When Running Autoinvoice [message #205752 is a reply to message #204615] |
Mon, 27 November 2006 06:29 |
seenujanu
Messages: 53
Registered: August 2006
Location: chennai
|
Member |
|
|
hi abed24
i have tried wat u have said.
it fines work but i got another problem is
when i query the customer information in AR ->customer->standard forms ,i will get the details of customer name,no
but the problem is it is not populating in the address field...and when i click on the open to get the details also...
i have searched in metalink i got the error but how should i rectify this i am not getting.
wat should i do for this
it is not showing any error but the output file shows like this
Customer Reference Address Reference Error Message ------------------------------- ----------------------------- ---------------------------------------
c10009 A20006
Warning: The Postal Code is not within the range defined in the System Options window. ========================================
Exception Records in RA_CUSTOMER_PROFILES_INTERFACE =======================================
Customer Reference Address Reference Currency Error Message --------------------------- --------------------------- -----------
c10009
The customer reference specified does not exist in the HZ_CUST_A CCOUNTS table or the RA_CUSTOMERS_INTERFACE table. The customer reference could also be in error in the RA_CUSTOMERS_INTERFACE table.
Thans in Advace
Regards
Seenu
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
