Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Inteface error occure, but generate invoice ^^

540230Dec 8 2006 — edited Dec 8 2006
I 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

---------------------------------------------------------------------------

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jan 5 2007
Added on Dec 8 2006
2 comments
340 views