Inteface error occure, but generate invoice ^^
540230Dec 8 2006 — edited Dec 8 2006I made interface procedure for invoice and
i did execute it ~~ and invoices is generated.
and status of interface table is 'processed'!!
but status of request is red !!
and indicate error !!
I don't know why this situation occured ~~
I'm korean so i comment korean ... so is this situation occur ?
help me ~~ I want perfect !!
there is log ^^
Thank you !!
---------------------------------------------------------------------------
Payables: Version : 11.5.0 - Development
Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.
APXIIMPT module: Payables Open Interface Import
---------------------------------------------------------------------------
Current system time is 06-DEC-2006 14:00:41
---------------------------------------------------------------------------
+-----------------------------
| Starting concurrent program execution...
+-----------------------------
Arguments
------------
p_source='PAYROLL'
p_batch_name='200611-PAYROLL'
p_purge_flag='Y'
p_trace_switch='N'
p_debug_switch='N'
p_summary_flag='Y'
p_commit_batch_size='1000'
p_user_id='1113'
p_login_id='28247'
------------
Current NLS_LANG and NLS_NUMERIC_CHARACTERS Environment Variables are :
American_America.EE8ISO8859P2
'.,'
Spawned Process 22677
MSG-01104: (Before Report) Modified file
MSG-00000: p_purge_flag :Y
MSG-00000: c_nls_yes :Yes
MSG-00000: c_nls_no :No
MSG-00000: p_summary_flag :Y
MSG-00000: p_nls_summary :Yes
MSG-00000: p_nls_purge :Yes
MSG-00000: 0 invoice(s) were created during the process run
MSG-00000: 0 invoice(s) were fetched during the process run
MSG-00000: summarize flagY
REP-1401: 'cf_source_nameformula': Fatal PL/SQL error occurred.
ORA-01403: no data found
Report Builder: Release 6.0.8.25.0 - Production on Wed Dec 6 14:00:41 2006
(c) Copyright 1999 Oracle Corporation. All rights reserved.
Enter Username:
---------------------------------------------------------------------------
Start of log messages from FND_FILE
---------------------------------------------------------------------------
---------------------------------------------------------------------------
End of log messages from FND_FILE
---------------------------------------------------------------------------
Program exited with status 1
Concurrent Manager encountered an error while running Oracle*Report for your concurrent request 260845.
Review your concurrent request log and/or report output file for more detailed information.
---------------------------------------------------------------------------
Executing request completion options...
Finished executing request completion options.
---------------------------------------------------------------------------
Concurrent request completed
Current system time is 06-DEC-2006 14:00:43
---------------------------------------------------------------------------