Home » Applications » Oracle Fusion Apps & E-Business Suite » Problem in When Running Autoinvoice
Problem in When Running Autoinvoice [message #204615] Tue, 21 November 2006 06:49 Go to next message
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 Go to previous messageGo to next message
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

Cool HTH

David

[Updated on: Wed, 22 November 2006 04:21]

Report message to a moderator

icon7.gif  Re: Problem in When Running Autoinvoice [message #205040 is a reply to message #204615] Thu, 23 November 2006 02:27 Go to previous messageGo to next message
abed24
Messages: 16
Registered: October 2006
Location: Jordan
Junior Member

INTERFACE_LINE_CONTEXT,INTERFACE_LINE_ATTRIBUTE1,INTERFACE_LINE_ATTRIBUTE2
are required flex fields

INTERFACE_LINE_ATTRIBUTE1 : this value will become the transaction reference

when I loaded the invoices I set
INTERFACE_LINE_CONTEXT = VISION BUILD
INTERFACE_LINE_ATTRIBUTE1 = invoice reference
INTERFACE_LINE_ATTRIBUTE2 = serial/sequence

note : combination of INTERFACE_LINE_ATTRIBUTE1 and INTERFACE_LINE_ATTRIBUTE2 should be unique and not exists in ra_interface_lines_all or RA_CUSTOMER_TRX_LINES_ALL

try it Wink
Re: Problem in When Running Autoinvoice [message #205752 is a reply to message #204615] Mon, 27 November 2006 06:29 Go to previous message
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
Previous Topic: Abt New Customer Interface
Next Topic: Help with item delete please
Goto Forum:
  


Current Time: Mon Dec 05 04:29:17 CST 2016

Total time taken to generate the page: 0.24356 seconds