line 4: SQLPLUS Command Skipped: set trimspool on

line 5: SQLPLUS Command Skipped: set trimout on

old:Select A.module
, A.session_id
, A. process_id
, A.timestamp
, A.message_text
, A.user_id
, A.transaction_context_id
from fnd_log_messages A
,fnd_log_transaction_context b
Where a.transaction_context_id = b.transaction_context_id
And b.transaction_id in (&v_request_id)
new:Select A.module
, A.session_id
, A. process_id
, A.timestamp
, A.message_text
, A.user_id
, A.transaction_context_id
from fnd_log_messages A
,fnd_log_transaction_context b
Where a.transaction_context_id = b.transaction_context_id
And b.transaction_id in (8581621)
MODULE

SESSION_ID PROCESS_ID
TIMESTAMP ME
SSAGE_TEXT
 U
SER_ID TRANSACTION_CONTEXT_ID
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------- ---------- -----------------------------------------------------
------------------------------------------------------------------- --------- --
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
------------------------------------------------------------------------------ -
------ ----------------------
xla.plsql.xla_transfer_pkg.gl_transfer_main

-1 29648
29-APR-17 p_
ledger_id = 1
 4667 7461850
xla.plsql.xla_transfer_pkg.gl_transfer_main

-1 29648
29-APR-17 p_
securiy_id_int_1 =
 4667 7461850
wf.plsql.WF_BES_CACHE.GetEventByName.Cache_Get

-1 29648
29-APR-17 Ge
tting the event from Cache
 4667 7461850
wf.plsql.WF_OBJECT_CACHE.GetObject.Begin

-1 29648
29-APR-17 Ge
tting {oracle.apps.wf.event.any} from cache {1}

4667 7461850
wf.plsql.WF_OBJECT_CACHE.GetObject.Cache_Hit

-1 29648
29-APR-17 Ob
ject not found in cache for {oracle.apps.wf.event.any}

4667 7461850
wf.plsql.WF_BES_CACHE.GetEventByName.Load_Event

-1 29648
 29-APR-17 Ev
ent not found in cache. Loading from Database

4667 7461850
wf.plsql.WF_BES_CACHE.GetEventByName.Set_Cache

-1 29648
29-APR-17 Se
tting event {oracle.apps.wf.event.any} to cache
 4667 7461850
wf.plsql.WF_OBJECT_CACHE.SetObject.Begin

-1 29648
29-APR-17 Se
tting object {oracle.apps.wf.event.any} in cache {1}
 4667 7461850
wf.plsql.WF_OBJECT_CACHE.SetObject.Assign

-1 29648
29-APR-17 Ch
ecking cache size and storing object in cache
 4667 7461850
wf.plsql.WF_OBJECT_CACHE.Check_Size.Begin

-1 29648
29-APR-17 Ch
ecking size of Cache. CurrIdx {2}
 4667 7461850
wf.plsql.WF_OBJECT_CACHE.Assign_Object.Begin

-1 29648
29-APR-17 As
signing object at {14007320} in cache {1}
 4667 7461850
wf.plsql.WF_OBJECT_CACHE.Assign_Object.Begin

-1 29648
29-APR-17 Cu
rrent Idx for age table is {2}
 4667 7461850
wf.plsql.WF_OBJECT_CACHE.Assign_Object.End

-1 29648
29-APR-17 As
signed object to cache. Next Idx {3}
 4667 7461850
wf.plsql.WF_BES_CACHE.GetSubscriptions.Load_Subs

-1 29648
29-APR-17 Su
bscriptions for {oracle.apps.wf.event.any} is not already loaded. Loading from D
B for Source Type {LOCAL} Source Agt {}
 4667 7461850
wf.plsql.WF_BES_CACHE.Load_Subscriptions.active_event_subs

-1 29648
29-APR-17 Us
ing cursor active_event_subs for event {oracle.apps.wf.event.any}
 4667 7461850
wf.plsql.WF_BES_CACHE.Load_Subscriptions.End

-1 29648
29-APR-17 Lo
aded {0} LOCAL subscriptions for event {oracle.apps.wf.event.any}
 4667 7461850
wf.plsql.WF_OBJECT_CACHE.SetObject.Begin

-1 29648
29-APR-17 Se
tting object {oracle.apps.wf.event.any} in cache {1}
 4667 7461850
wf.plsql.WF_OBJECT_CACHE.SetObject.Overwrite

-1 29648
29-APR-17 Ob
ject already in cache. Overwriting.
 4667 7461850
wf.plsql.WF_BES_CACHE.GetSubscriptions.Begin

-1 29648
29-APR-17 Ge
tting subscriptions for event {oracle.apps.wf.event.unexpected} Source Type {LOC
AL} Source Agt {}

4667 7461850
wf.plsql.WF_BES_CACHE.GetEventByName.Begin

-1 29648
29-APR-17 Ge
tting event details for {oracle.apps.wf.event.unexpected}

4667 7461850
wf.plsql.WF_BES_CACHE.CacheValid.Check

-1 29648
 29-APR-17 La
st upload time {} Last cache time {2017/04/29 03:31:18}

4667 7461850
wf.plsql.WF_BES_CACHE.GetEventByName.Cache_Get

-1 29648
29-APR-17 Ge
tting the event from Cache
 4667 7461850
wf.plsql.WF_OBJECT_CACHE.GetObject.Begin

-1 29648
29-APR-17 Ge
tting {oracle.apps.wf.event.unexpected} from cache {1}
 4667 7461850
wf.plsql.WF_OBJECT_CACHE.GetObject.Cache_Hit

-1 29648
29-APR-17 Ob
ject not found in cache for {oracle.apps.wf.event.unexpected}
 4667 7461850
wf.plsql.WF_BES_CACHE.GetEventByName.Load_Event

-1 29648
29-APR-17 Ev
ent not found in cache. Loading from Database
 4667 7461850
wf.plsql.WF_BES_CACHE.GetEventByName.Set_Cache

-1 29648
29-APR-17 Se
tting event {oracle.apps.wf.event.unexpected} to cache
 4667 7461850
wf.plsql.WF_OBJECT_CACHE.SetObject.Begin

-1 29648
29-APR-17 Se
tting object {oracle.apps.wf.event.unexpected} in cache {1}
 4667 7461850
wf.plsql.WF_OBJECT_CACHE.SetObject.Assign

-1 29648
29-APR-17 Ch
ecking cache size and storing object in cache
 4667 7461850
wf.plsql.WF_OBJECT_CACHE.Check_Size.Begin

-1 29648
29-APR-17 Ch
ecking size of Cache. CurrIdx {3}
 4667 7461850
wf.plsql.WF_OBJECT_CACHE.Assign_Object.Begin

-1 29648
29-APR-17 As
signing object at {15658687} in cache {1}
 4667 7461850
wf.plsql.WF_OBJECT_CACHE.Assign_Object.Begin

-1 29648
29-APR-17 Cu
rrent Idx for age table is {3}
 4667 7461850
wf.plsql.WF_OBJECT_CACHE.Assign_Object.End

-1 29648
29-APR-17 As
signed object to cache. Next Idx {4}
 4667 7461850
wf.plsql.WF_BES_CACHE.GetSubscriptions.Load_Subs

-1 29648
29-APR-17 Su
bscriptions for {oracle.apps.wf.event.unexpected} is not already loaded. Loading
from DB for Source Type {LOCAL} Source Agt {}
 4667 7461850
wf.plsql.WF_BES_CACHE.Load_Subscriptions.active_event_subs

-1 29648
29-APR-17 Us
ing cursor active_event_subs for event {oracle.apps.wf.event.unexpected}

4667 7461850
wf.plsql.WF_BES_CACHE.Load_Subscriptions.End

-1 29648
29-APR-17 Lo
aded {0} LOCAL subscriptions for event {oracle.apps.wf.event.unexpected}

4667 7461850
wf.plsql.WF_OBJECT_CACHE.SetObject.Begin

-1 29648
 29-APR-17 Se
tting object {oracle.apps.wf.event.unexpected} in cache {1}

4667 7461850
wf.plsql.WF_OBJECT_CACHE.SetObject.Overwrite

-1 29648
29-APR-17 Ob
ject already in cache. Overwriting.
 4667 7461850
xla.plsql.xla_accounting_pkg.raise_accounting_event

-1 29648
29-APR-17 EN
D of procedure RAISE_ACCOUNTING_EVENT
 4667 7461850
xla.plsql.xla_psa_acct_hooks_pkg.main

-1 29648
29-APR-17 BE
GIN of procedure Main
 4667 7461850
xla.plsql.xla_psa_acct_hooks_pkg.main

-1 29648
29-APR-17 p_
application_id = 200
 4667 7461850
xla.plsql.xla_psa_acct_hooks_pkg.main

-1 29648
29-APR-17 p_
accounting_mode =
 4667 7461850
xla.plsql.xla_psa_acct_hooks_pkg.main

-1 29648
29-APR-17 p_
event_name = postaccounting
 4667 7461850
xla.plsql.xla_psa_acct_hooks_pkg.main

-1 29648
29-APR-17 p_
ledger_id = 1
 4667 7461850
xla.plsql.xla_psa_acct_hooks_pkg.main

-1 29648
29-APR-17 p_
process_category =
 4667 7461850
xla.plsql.xla_psa_acct_hooks_pkg.main

-1 29648
29-APR-17 p_
end_date = 30-APR-17
 4667 7461850
xla.plsql.xla_psa_acct_hooks_pkg.main

-1 29648
29-APR-17 p_
valuation_method =
 4667 7461850
xla.plsql.xla_psa_acct_hooks_pkg.main

-1 29648
29-APR-17 p_
security_id_int_1 =
 4667 7461850
xla.plsql.xla_psa_acct_hooks_pkg.main

-1 29648
29-APR-17 p_
security_id_int_2 =
 4667 7461850
xla.plsql.xla_psa_acct_hooks_pkg.main

-1 29648
29-APR-17 p_
security_id_int_3 =

4667 7461850
xla.plsql.xla_psa_acct_hooks_pkg.main

-1 29648
29-APR-17 p_
security_id_char_1 =

4667 7461850
xla.plsql.xla_psa_acct_hooks_pkg.main

-1 29648
 29-APR-17 p_
security_id_char_2 =

4667 7461850
xla.plsql.xla_psa_acct_hooks_pkg.main

-1 29648
29-APR-17 p_
security_id_char_3 =
 4667 7461850
xla.plsql.xla_psa_acct_hooks_pkg.main

-1 29648
29-APR-17 p_
report_request_id = 8581621
 4667 7461850
xla.plsql.xla_psa_acct_hooks_pkg.main

-1 29648
29-APR-17 Re
ady to call postaccounting API for Account Receivables
 4667 7461850
xla.plsql.xla_psa_acct_hooks_pkg.main

-1 29648
29-APR-17 Co
ntrol returned from postaccounting API
 4667 7461850
xla.plsql.xla_fv_acct_hooks_pkg.main

-1 29648
29-APR-17 BE
GIN of procedure Main
 4667 7461850
xla.plsql.xla_fv_acct_hooks_pkg.main

-1 29648
29-APR-17 p_
application_id = 200
 4667 7461850
xla.plsql.xla_fv_acct_hooks_pkg.main

-1 29648
29-APR-17 p_
accounting_mode =
 4667 7461850
xla.plsql.xla_fv_acct_hooks_pkg.main

-1 29648
29-APR-17 p_
event_name = postaccounting
 4667 7461850
xla.plsql.xla_fv_acct_hooks_pkg.main

-1 29648
29-APR-17 p_
ledger_id = 1
 4667 7461850
xla.plsql.xla_fv_acct_hooks_pkg.main

-1 29648
29-APR-17 p_
process_category =
 4667 7461850
xla.plsql.xla_fv_acct_hooks_pkg.main

-1 29648
29-APR-17 p_
end_date = 30-APR-17
 4667 7461850
xla.plsql.xla_fv_acct_hooks_pkg.main

-1 29648
29-APR-17 p_
valuation_method =
 4667 7461850
xla.plsql.xla_fv_acct_hooks_pkg.main

-1 29648
29-APR-17 p_
security_id_int_1 =

4667 7461850
xla.plsql.xla_fv_acct_hooks_pkg.main

-1 29648
29-APR-17 p_
security_id_int_2 =

4667 7461850
xla.plsql.xla_fv_acct_hooks_pkg.main

-1 29648
 29-APR-17 p_
security_id_int_3 =

4667 7461850
xla.plsql.xla_fv_acct_hooks_pkg.main

-1 29648
29-APR-17 p_
security_id_char_1 =
 4667 7461850
xla.plsql.xla_fv_acct_hooks_pkg.main

-1 29648
29-APR-17 p_
security_id_char_2 =
 4667 7461850
xla.plsql.xla_fv_acct_hooks_pkg.main

-1 29648
29-APR-17 p_
security_id_char_3 =
 4667 7461850
xla.plsql.xla_fv_acct_hooks_pkg.main

-1 29648
29-APR-17 p_
report_request_id = 8581621
 4667 7461850
xla.plsql.xla_fv_acct_hooks_pkg.main

-1 29648
29-APR-17 Re
ady to call postaccounting API for FV
 4667 7461850
fv.plsql.FV_SLA_PROCESSING_PUB.POSTACCOUNTING

-1 29648
29-APR-17 Be
gin of procedure fv.plsql.FV_SLA_PROCESSING_PUB.POSTACCOUNTING
 4667 7461850
fv.plsql.FV_SLA_PROCESSING_PUB.POSTACCOUNTING

-1 29648
29-APR-17 Fe
deral not enabled
 4667 7461850
xla.plsql.xla_fv_acct_hooks_pkg.main

-1 29648
29-APR-17 Co
ntrol returned from postaccounting API
 4667 7461850
xla.plsql.xla_igi_acct_hooks_pkg.main

-1 29648
29-APR-17 BE
GIN of procedure Main
 4667 7461850
xla.plsql.xla_igi_acct_hooks_pkg.main

-1 29648
29-APR-17 p_
application_id = 200
 4667 7461850
xla.plsql.xla_igi_acct_hooks_pkg.main

-1 29648
29-APR-17 p_
accounting_mode =
 4667 7461850
xla.plsql.xla_igi_acct_hooks_pkg.main

-1 29648
29-APR-17 p_
event_name = postaccounting
 4667 7461850
xla.plsql.xla_igi_acct_hooks_pkg.main

-1 29648
29-APR-17 p_
ledger_id = 1

4667 7461850
xla.plsql.xla_igi_acct_hooks_pkg.main

-1 29648
29-APR-17 p_
process_category =

4667 7461850
xla.plsql.xla_igi_acct_hooks_pkg.main

-1 29648
 29-APR-17 p_
end_date = 30-APR-17

4667 7461850
xla.plsql.xla_igi_acct_hooks_pkg.main

-1 29648
29-APR-17 p_
valuation_method =
 4667 7461850
xla.plsql.xla_igi_acct_hooks_pkg.main

-1 29648
29-APR-17 p_
security_id_int_1 =
 4667 7461850
xla.plsql.xla_igi_acct_hooks_pkg.main

-1 29648
29-APR-17 p_
security_id_int_2 =
 4667 7461850
xla.plsql.xla_igi_acct_hooks_pkg.main

-1 29648
29-APR-17 p_
security_id_int_3 =
 4667 7461850
xla.plsql.xla_igi_acct_hooks_pkg.main

-1 29648
29-APR-17 p_
security_id_char_1 =
 4667 7461850
xla.plsql.xla_igi_acct_hooks_pkg.main

-1 29648
29-APR-17 p_
security_id_char_2 =
 4667 7461850
xla.plsql.xla_igi_acct_hooks_pkg.main

-1 29648
29-APR-17 p_
security_id_char_3 =
 4667 7461850
xla.plsql.xla_igi_acct_hooks_pkg.main

-1 29648
29-APR-17 p_
report_request_id = 8581621
 4667 7461850
xla.plsql.xla_igi_acct_hooks_pkg.main

-1 29648
29-APR-17 Re
ady to call postaccounting API for IGI
 4667 7461850
xla.plsql.xla_igi_acct_hooks_pkg.main

-1 29648
29-APR-17 Co
ntrol returned from postaccounting API
 4667 7461850
xla.plsql.xla_accounting_pkg.handle_accounting_hook

-1 29648
29-APR-17 EN
D of procedure handle_accounting_hooks
 4667 7461850
fnd.plsql.fnd_file.PUT_LINE

-1 29648
29-APR-17 si
d:336453067: 29-APR-2017 03:31:18 - postaccounting hook executed successfully
 4667 7461850
fnd.plsql.fnd_file.PUT_LINE

-1 29648
29-APR-17 si
d:336453067: - Accounting Time = 0 secs

4667 7461850
fnd.plsql.fnd_file.PUT_LINE

-1 29648
29-APR-17 si
d:336453067: - Transfer Time = .51 secs

4667 7461850
xla.plsql.xla_accounting_pkg.event_application_manager

-1 29648
 29-APR-17 CO
MMIT issued in the procedure EVENT_APPLICATION_MANAGER

4667 7461850
xla.plsql.xla_accounting_pkg.event_application_manager

-1 29648
29-APR-17 EN
D of procedure EVENT_APPLICATION_MANAGER
 4667 7461850
xla.plsql.xla_accounting_pkg.accounting_program_batch

-1 29648
29-APR-17 g_
mpa_accrual_exists= N
 4667 7461850
xla.plsql.xla_accounting_err_pkg.insert_errors

-1 29648
29-APR-17 BE
GIN of procedure INSERT_ERRORS
 4667 7461850
xla.plsql.xla_accounting_err_pkg.insert_errors

-1 29648
29-APR-17 Co
unt of Error Messages in the stack = 0
 4667 7461850
xla.plsql.xla_accounting_err_pkg.reset

-1 29648
29-APR-17 BE
GIN of procedure RESET
 4667 7461850
xla.plsql.xla_accounting_err_pkg.reset

-1 29648
29-APR-17 EN
D of procedure RESET
 4667 7461850
xla.plsql.xla_accounting_err_pkg.insert_errors

-1 29648
29-APR-17 EN
D of procedure INSERT_ERRORS
 4667 7461850
xla.plsql.xla_accounting_pkg.accounting_program_batch

-1 29648
29-APR-17 l_
error_status = N
 4667 7461850
xla.plsql.xla_accounting_pkg.accounting_program_batch

-1 29648
29-APR-17 l_
warning_status = N
 4667 7461850
xla.plsql.xla_accounting_pkg.accounting_program_batch

-1 29648
29-APR-17 g_
total_error_count = 0
 4667 7461850
xla.plsql.xla_accounting_pkg.accounting_program_batch

-1 29648
29-APR-17 p_
retcode = 0
 4667 7461850
xla.plsql.xla_accounting_pkg.accounting_program_batch

-1 29648
29-APR-17 p_
errbuf = Accounting Program completed Normal
 4667 7461850
xla.plsql.xla_accounting_pkg.accounting_program_batch

-1 29648
29-APR-17 EN
D of procedure ACCOUNTING_PROGRAM_BATCH

4667 7461850
xla.plsql.xla_accounting_pub_pkg.accounting_program_batch

-1 29648
29-APR-17 EN
D of procedure ACCOUNTING_PROGRAM_BATCH

4667 7461850
xla.plsql.XLA_CREATE_ACCT_RPT_PVT

-1 29648
 29-APR-17 l_
accounting_batch_id = 3591

4667 7461850
xla.plsql.XLA_CREATE_ACCT_RPT_PVT

-1 29648
29-APR-17 l_
errbuf = Accounting Program completed Normal
 4667 7461850
xla.plsql.XLA_CREATE_ACCT_RPT_PVT

-1 29648
29-APR-17 C_
ACCT_PROG_RETURN_CODE = 0
 4667 7461850
xla.plsql.XLA_CREATE_ACCT_RPT_PVT

-1 29648
29-APR-17 En
d of BeforeReport
 4667 7461850
xla.plsql.XLA_CREATE_ACCT_RPT_PVT

-1 29648
29-APR-17 BE
GIN of AfterReport
 4667 7461850
xla.plsql.XLA_CREATE_ACCT_RPT_PVT

-1 29648
29-APR-17 C_
ACCT_PROG_RETURN_CODE = 0
 4667 7461850
xla.plsql.XLA_CREATE_ACCT_RPT_PVT

-1 29648
29-APR-17 EN
D of AfterReport
 4667 7461850
fnd.plsql.fnd_file.PUT_LINE

-1 29648
29-APR-17 si
d:336453067: 29-APR-2017 03:31:18 - End of the Report
 4667 7461850
fnd.cp.request.CpContext

-1 29648
29-APR-17 or
acle.apps.fnd.cp.request.CpContext.releaseJDBCConnection(oracle.jdbc.driver.T4CC
onnection@1a738cd,[oracle.apps.fnd.cp.request.CpContext@1847c5d $Revision: 120.4
5.12020000.4 $ extends [oracle.apps.fnd.common.Context@1847c5d $Revision: 120.31
$ {sessionId=0x1847c5d,conn=oracle.jdbc.driver.T4CConnection@1a738cd,state=ora
cle.apps.fnd.common.StateStack@ba181a}] {isDedicated=false}]): : BEGIN/END
 4667 7461850
fnd.cp.request.CpContext

-1 29648
29-APR-17 or
acle.apps.fnd.cp.request.CpContext.releaseJDBCConnection(oracle.jdbc.driver.T4CC
onnection@1a738cd,[oracle.apps.fnd.cp.request.CpContext@1847c5d $Revision: 120.4
5.12020000.4 $ extends [oracle.apps.fnd.common.Context@1847c5d $Revision: 120.31
$ {sessionId=0x1847c5d,conn=oracle.jdbc.driver.T4CConnection@1a738cd,state=ora
cle.apps.fnd.common.StateStack@ba181a}] {isDedicated=false}]): : (pConn == mCon
n) is true, isSplCtx is false, switchGenSol is false
 4667 7461850
fnd.plsql.MO_GLOBAL.INIT.begin

-1 29648
29-APR-17 Ca
lling PL/SQL procedure MO_GLOBAL.INIT
 4667 7461850
fnd.plsql.MO_GLOBAL.INIT.config

-1 29648
29-APR-17 MO
: Operating Unit=>303, MO: Security Profile=>, p_appl_short_name=>M
 4667 7461850
fnd.plsql.MO_GLOBAL.SET_ORG_ACCESS.begin

-1 29648
29-APR-17 Ca
lling PL/SQL procedure MO_GLOBAL.SET_ORG_ACCESS: p_org_id_char=>303, p_sp_id_cha
r=>, p_appl_short_name=>M
 4667 7461850
fnd.plsql.MO_GLOBAL.SET_ORG_ACCESS.access_status

-1 29648
29-APR-17 Ch
ecking access status within PL/SQL procedure MO_GLOBAL.SET_ORG_ACCESS: l_access_
ctrl_enabled=>Y

4667 7461850
fnd.plsql.MO_GLOBAL.DELETE_ORGS.begin

-1 29648
29-APR-17 Be
fore flushing MO_GLOB_ORG_ACCESS_TMP

4667 7461850
fnd.plsql.MO_GLOBAL.DELETE_ORGS.end

-1 29648
 29-APR-17 MO
_GLOB_ORG_ACCESS_TMP was flushed

4667 7461850
fnd.plsql.MO_GLOBAL.SET_ORG_ACCESS.after_delete

-1 29648
29-APR-17 Re
turning from PL/SQL procedure MO_GLOBAL.DELETE_ORGS
 4667 7461850
fnd.plsql.MO_GLOBAL.POPULATE_ORGS.begin

-1 29648
29-APR-17 Ca
lling PL/SQL procedure MO_GLOBAL.POPULATE_ORGS
 4667 7461850
fnd.plsql.MO_GLOBAL.POPULATE_ORGS.input_parameters

-1 29648
29-APR-17 p_
org_id=303, p_sp_id=
 4667 7461850
fnd.plsql.MO_GLOBAL.POPULATE_ORGS.retrieve_orgs_c2_cursor

-1 29648
29-APR-17 Re
trieving operating units using cursor c2
 4667 7461850
fnd.plsql.MO_GLOBAL.POPULATE_ORGS.temp_table_insert

-1 29648
29-APR-17 In
serted 1 record(s) into MO_GLOB_ORG_ACCESS_TMP
 4667 7461850
fnd.plsql.MO_GLOBAL.POPULATE_ORGS.end

-1 29648
29-APR-17 Re
turning from PL/SQL procedure MO_GLOBAL.POPULATE_ORGS: l_bg_id=, p_sp_id_char=,
l_sp_name=, p_org_id_char=303, is_view_all_org=
 4667 7461850
fnd.plsql.MO_GLOBAL.SET_ORG_ACCESS.After_Populate

-1 29648
29-APR-17 Re
turning from PL/SQL procedure MO_GLOBAL.POPULATE_ORGS
 4667 7461850
fnd.plsql.MO_GLOBAL.SET_POLICY_CONTEXT.begin

-1 29648
29-APR-17 Ca
lling PL/SQL procedure MO_GLOBAL.SET_POLICY_CONTEXT: p_access_mode=>S,p_org_id=>
303
 4667 7461850
fnd.plsql.MO_GLOBAL.SET_POLICY_CONTEXT.end

-1 29648
29-APR-17 Re
turning from PL/SQL prcedure MO_GLOBAL.SET_POLICY_CONTEXT
 4667 7461850
fnd.plsql.MO_GLOBAL.SET_ORG_ACCESS.end

-1 29648
29-APR-17 Ca
lling PL/SQL procedure MO_GLOBAL.SET_ORG_ACCESS: p_org_id_char=>303,p_sp_id_char
=>,p_appl_short_name=>M,l_view_all_orgs=>,g_ou_count=>1
 4667 7461850
fnd.plsql.MO_GLOBAL.INIT.end

-1 29648
29-APR-17 Ex
iting PL/SQL procedure MO_GLOBAL.INIT
 4667 7461850
fnd.plsql.MO_GLOBAL.SET_POLICY_CONTEXT.begin

-1 29648
29-APR-17 Ca
lling PL/SQL procedure MO_GLOBAL.SET_POLICY_CONTEXT: p_access_mode=>M,p_org_id=>
 4667 7461850
fnd.plsql.MO_GLOBAL.SET_POLICY_CONTEXT.end

-1 29648
29-APR-17 Re
turning from PL/SQL prcedure MO_GLOBAL.SET_POLICY_CONTEXT

4667 7461850
fnd.profiles.Profiles

-1 29648
29-APR-17 ge
tProfileOptionValue: name=AFLOG_ENABLED; levelID=10004; levelValue=4667; levelV
alueApplID=0

4667 7461850
fnd.cp.request.CpContext

-1 29648
 29-APR-17 or
acle.apps.fnd.cp.request.CpContext.getLocalJDBCConnection(): BEGIN

4667 7461850
fnd.cp.request.CpContext

-1 29648
29-APR-17 or
acle.apps.fnd.cp.request.CpContext.getLocalJDBCConnection(null,0x1847c5d): : BEG
IN/END
 4667 7461850
fnd.cp.request.CpContext

-1 29648
29-APR-17 or
acle.apps.fnd.cp.request.CpContext.getLocalJDBCConnection(null,0x1847c5d,false):
: BEGIN
 4667 7461850
fnd.cp.request.CpContext

-1 29648
29-APR-17 or
acle.apps.fnd.cp.request.CpContext.getJDBCConnection(null,0x1847c5d,false,false,
true): : BEGIN
 4667 7461850
fnd.cp.request.CpContext

-1 29648
29-APR-17 or
acle.apps.fnd.cp.request.CpContext.getJDBCConnection: END: returning oracle.jdbc
.driver.T4CConnection@1a738cd
 4667 7461850
fnd.cp.request.CpContext

-1 29648
29-APR-17 or
acle.apps.fnd.cp.request.CpContext.getLangInfo(null,AMERICAN,oracle.jdbc.driver.
T4CConnection@1a738cd): : BEGIN
 4667 7461850
fnd.cp.request.CpContext

-1 29648
29-APR-17 or
acle.apps.fnd.cp.request.CpContext.selectLangInfo(null,AMERICAN,oracle.jdbc.driv
er.T4CConnection@1a738cd): : BEGIN
 4667 7461850
fnd.cp.request.CpContext

-1 29648
29-APR-17 or
acle.apps.fnd.cp.request.CpContext.selectLangInfo: END
 4667 7461850
fnd.cp.request.CpContext

-1 29648
29-APR-17 or
acle.apps.fnd.cp.request.CpContext.getLangInfo: END: returning [oracle.apps.fnd.
common.LangInfo@1baee33 $Revision: 120.0 $ extends oracle.apps.fnd.common.LangIn
fo@1baee33 {US,AMERICAN,AMERICA,US7ASCII,null,B,American English}]
 4667 7461850
xla.plsql.xla_accounting_err_pkg.set_options

-1 29648
29-APR-17 p_
request_id = 8581621
 4667 7461850
xla.plsql.xla_accounting_err_pkg.set_options

-1 29648
29-APR-17 p_
application_id = 200
 4667 7461850
xla.plsql.xla_accounting_err_pkg.set_options

-1 29648
29-APR-17 g_
error_source = ACCT_PROGRAM
 4667 7461850
xla.plsql.xla_accounting_err_pkg.set_options

-1 29648
29-APR-17 g_
request_id = 8581621
 4667 7461850
xla.plsql.xla_accounting_err_pkg.set_options

-1 29648
29-APR-17 g_
application_id = 200

4667 7461850
xla.plsql.xla_accounting_err_pkg.set_options

-1 29648
29-APR-17 EN
D of procedure SET_OPTIONS

4667 7461850
xla.plsql.xla_accounting_pkg.accounting_program_batch

-1 29648
 29-APR-17 g_
security_condition =

4667 7461850
xla.plsql.xla_accounting_pkg.accounting_program_batch

-1 29648
29-APR-17 g_
process_category_condition =
 4667 7461850
xla.plsql.xla_accounting_pkg.accounting_program_batch

-1 29648
29-APR-17 g_
source_appl_condition = and source_application_id = 200
 4667 7461850
fnd.plsql.fnd_file.PUT_LINE

-1 29648
29-APR-17 si
d:336453067: 29-APR-2017 03:31:17 - Dynamic conditions built
 4667 7461850
fnd.plsql.fnd_file.PUT_LINE

-1 29648
29-APR-17 si
d:336453067: 29-APR-2017 03:31:17 - Event Applications Determined
 4667 7461850
xla.plsql.xla_accounting_pkg.accounting_program_batch

-1 29648
29-APR-17 Nu
mber of Event Applications = 1
 4667 7461850
xla.plsql.xla_accounting_pkg.accounting_program_batch

-1 29648
29-APR-17 Pr
ocessing event application = 200
 4667 7461850
xla.plsql.xla_accounting_pkg.event_application_manager

-1 29648
29-APR-17 BE
GIN of procedure EVENT_APPLICATION_MANAGER
 4667 7461850
xla.plsql.xla_accounting_pkg.event_application_manager

-1 29648
29-APR-17 p_
source_application_id = 200
 4667 7461850
xla.plsql.xla_accounting_pkg.event_application_manager

-1 29648
29-APR-17 p_
application_id = 200
 4667 7461850
xla.plsql.xla_accounting_pkg.event_application_manager

-1 29648
29-APR-17 p_
ledger_id = 1
 4667 7461850
xla.plsql.xla_transfer_pkg.gl_transfer_main

-1 29648
29-APR-17 p_
securiy_id_int_2 =
 4667 7461850
xla.plsql.xla_transfer_pkg.gl_transfer_main

-1 29648
29-APR-17 p_
securiy_id_int_3 =
 4667 7461850
xla.plsql.xla_transfer_pkg.gl_transfer_main

-1 29648
29-APR-17 p_
securiy_id_char_1 =

4667 7461850
xla.plsql.xla_transfer_pkg.gl_transfer_main

-1 29648
29-APR-17 p_
securiy_id_char_2 =

4667 7461850
xla.plsql.xla_transfer_pkg.gl_transfer_main

-1 29648
 29-APR-17 p_
securiy_id_char_3 =

4667 7461850
xla.plsql.xla_transfer_pkg.gl_transfer_main

-1 29648
29-APR-17 p_
valuation_method =
 4667 7461850
xla.plsql.xla_transfer_pkg.gl_transfer_main

-1 29648
29-APR-17 p_
process_category =
 4667 7461850
xla.plsql.xla_transfer_pkg.gl_transfer_main

-1 29648
29-APR-17 p_
accounting_batch_id = 3591
 4667 7461850
xla.plsql.xla_transfer_pkg.gl_transfer_main

-1 29648
29-APR-17 p_
entity_id =
 4667 7461850
xla.plsql.xla_transfer_pkg.gl_transfer_main

-1 29648
29-APR-17 p_
batch_name =
 4667 7461850
xla.plsql.xla_transfer_pkg.gl_transfer_main

-1 29648
29-APR-17 p_
end_date = 04/30/2017
 4667 7461850
xla.plsql.xla_transfer_pkg.gl_transfer_main

-1 29648
29-APR-17 p_
submit_gl_post = Y
 4667 7461850
xla.plsql.xla_transfer_pkg.gl_transfer_main

-1 29648
29-APR-17 p_
caller = ACCTPROG_BATCH
 4667 7461850
xla.plsql.xla_transfer_pkg.gl_transfer_main

-1 29648
29-APR-17 --
-------------------------------------------------
 4667 7461850
xla.plsql.xla_transfer_pkg.gl_transfer_main

-1 29648
29-APR-17 Gl
obal variables
 4667 7461850
xla.plsql.xla_transfer_pkg.gl_transfer_main

-1 29648
29-APR-17 --
-------------------------------------------------
 4667 7461850
xla.plsql.xla_transfer_pkg.gl_transfer_main

-1 29648
29-APR-17 g_
use_ledger_security = N
 4667 7461850
xla.plsql.xla_transfer_pkg.gl_transfer_main

-1 29648
29-APR-17 g_
access_set_id = 1000

4667 7461850
xla.plsql.xla_transfer_pkg.gl_transfer_main

-1 29648
29-APR-17 g_
sec_access_set_id =

4667 7461850
xla.plsql.xla_transfer_pkg.gl_transfer_main

-1 29648
 29-APR-17 --
-------------------------------------------------

4667 7461850
xla.plsql.xla_transfer_pkg.validate_input_parameters

-1 29648
29-APR-17 va
lidate_input_parameters.Begin
 4667 7461850
xla.plsql.xla_transfer_pkg.validate_input_parameters

-1 29648
29-APR-17 va
lidate_input_parameters.End
 4667 7461850
xla.plsql.xla_transfer_pkg.set_transaction_security

-1 29648
29-APR-17 se
t_transaction_security.Begin
 4667 7461850
xla.plsql.xla_transfer_pkg.set_transaction_security

-1 29648
29-APR-17 se
t_transaction_security.End
 4667 7461850
xla.plsql.xla_transfer_pkg.set_application_info

-1 29648
29-APR-17 se
t_application_info.Begin
 4667 7461850
xla.plsql.xla_transfer_pkg.set_application_info

-1 29648
29-APR-17 Po
pulate application level information
 4667 7461850
xla.plsql.xla_transfer_pkg.set_application_info

-1 29648
29-APR-17 se
t_application_info.End
 4667 7461850
xla.plsql.xla_transfer_pkg.gl_transfer_main

-1 29648
29-APR-17 Su
bmit Journal Import has been enabled.
 4667 7461850
xla.plsql.xla_transfer_pkg.get_ledgers

-1 29648
29-APR-17 ge
t_ledgers.Begin
 4667 7461850
xla.plsql.xla_transfer_pkg.get_ledgers

-1 29648
29-APR-17 p_
ledger_id = 1
 4667 7461850
xla.plsql.xla_transfer_pkg.get_ledgers

-1 29648
29-APR-17 De
riving ledgers associated with the primary ledger
 4667 7461850
xla.plsql.xla_transfer_pkg.get_ledgers

-1 29648
29-APR-17 Le
dger Rec Name = (ORAPTC) Nikon Precision Inc.
 4667 7461850
xla.plsql.xla_transfer_pkg.get_ledgers

-1 29648
29-APR-17 Le
dger Rec id = 1

4667 7461850
xla.plsql.xla_transfer_pkg.get_ledgers

-1 29648
29-APR-17 To
tal number of ledgers selected = 1

4667 7461850
fnd.cp.request.CpContext

-1 29648
 29-APR-17 or
acle.apps.fnd.cp.request.CpContext.releaseLocalJDBCConnection(oracle.jdbc.driver
.T4CConnection@1a738cd): : BEGIN

4667 7461850
fnd.cp.request.CpContext

-1 29648
29-APR-17 or
acle.apps.fnd.cp.request.CpContext.releaseLocalJDBCConnection: END
 4667 7461850
fnd.cp.request.Run.main.config

-1 29648
29-APR-17 JT
FDBCFILE System Property is not set. Internally setting it to dbcfile=/u02/app/o
raptc12/fs2/inst/apps/ORAPTC12_r12dev1app/appl/fnd/12.0.0/secure/ORAPTC12.dbc
 4667 7461850
fnd.profiles.Profiles

-1 29648
29-APR-17 ge
tProfileOptionValue: name=ORG_ID; levelID=10003; levelValue=20639; levelValueAp
plID=200
 4667 7461850
fnd.profiles.Profiles

-1 29648
29-APR-17 ge
tProfileOptionValue: name=ORG_ID; levelID=10001; levelValue=0; levelValueApplID
=0
 4667 7461850
fnd.plsql.fnd_file.open_files

-1 29648
29-APR-17 si
d:336453067: open OUT_FNAME =o0315044.tmp
 4667 7461850
fnd.plsql.fnd_file.open_files

-1 29648
29-APR-17 si
d:336453067: open LOG_FNAME =l0315044.tmp
 4667 7461850
fnd.plsql.fnd_file.write_buff.PUT_LINE

-1 29648
29-APR-17 si
d:336453067: 29-APR-2017 03:31:17 - FND: Debug Log Enabled : Yes
 4667 7461850
fnd.plsql.fnd_file.PUT_LINE

-1 29648
29-APR-17 si
d:336453067: 29-APR-2017 03:31:17 - Beginning of the Report
 4667 7461850
xla.plsql.XLA_CREATE_ACCT_RPT_PVT

-1 29648
29-APR-17 P_
CONC_REQUEST_ID =
 4667 7461850
xla.plsql.XLA_CREATE_ACCT_RPT_PVT

-1 29648
29-APR-17 P_
USER_ID = 4667
 4667 7461850
xla.plsql.XLA_CREATE_ACCT_RPT_PVT

-1 29648
29-APR-17 P_
REQUEST_ID = 8581621
 4667 7461850
xla.plsql.XLA_CREATE_ACCT_RPT_PVT

-1 29648
29-APR-17 P_
CONC_REQUEST_ID = 8581621
 4667 7461850
xla.plsql.XLA_CREATE_ACCT_RPT_PVT

-1 29648
29-APR-17 P_
ENTITY_ID = 8581621

4667 7461850
xla.plsql.XLA_CREATE_ACCT_RPT_PVT

-1 29648
29-APR-17 P_
END_DATE = 30-APR-17

4667 7461850
xla.plsql.xla_accounting_pkg.event_application_manager

-1 29648
 29-APR-17 p_
process_category =

4667 7461850
xla.plsql.xla_accounting_pkg.event_application_manager

-1 29648
29-APR-17 p_
end_date = 30-APR-17
 4667 7461850
xla.plsql.xla_accounting_pkg.event_application_manager

-1 29648
29-APR-17 p_
accounting_flag = N
 4667 7461850
xla.plsql.xla_accounting_pkg.event_application_manager

-1 29648
29-APR-17 p_
accounting_mode =
 4667 7461850
xla.plsql.xla_accounting_pkg.event_application_manager

-1 29648
29-APR-17 p_
error_only_flag =
 4667 7461850
xla.plsql.xla_accounting_pkg.event_application_manager

-1 29648
29-APR-17 p_
transfer_flag = Y
 4667 7461850
xla.plsql.xla_accounting_pkg.event_application_manager

-1 29648
29-APR-17 p_
gl_posting_flag = Y
 4667 7461850
xla.plsql.xla_accounting_pkg.event_application_manager

-1 29648
29-APR-17 p_
gl_batch_name =
 4667 7461850
xla.plsql.xla_accounting_pkg.event_application_manager

-1 29648
29-APR-17 p_
valuation_method =
 4667 7461850
xla.plsql.xla_accounting_pkg.event_application_manager

-1 29648
29-APR-17 p_
security_id_int_1 =
 4667 7461850
xla.plsql.xla_accounting_pkg.event_application_manager

-1 29648
29-APR-17 p_
security_id_int_2 =
 4667 7461850
xla.plsql.xla_accounting_pkg.event_application_manager

-1 29648
29-APR-17 p_
security_id_int_3 =
 4667 7461850
xla.plsql.xla_accounting_pkg.event_application_manager

-1 29648
29-APR-17 p_
security_id_char_1 =
 4667 7461850
xla.plsql.xla_accounting_pkg.event_application_manager

-1 29648
29-APR-17 p_
security_id_char_2 =

4667 7461850
xla.plsql.xla_accounting_pkg.event_application_manager

-1 29648
29-APR-17 p_
security_id_char_3 =

4667 7461850
xla.plsql.xla_accounting_pkg.event_application_manager

-1 29648
 29-APR-17 g_
processing_mode = BATCH

4667 7461850
xla.plsql.xla_accounting_pkg.event_application_manager

-1 29648
29-APR-17 g_
execution_mode = OFFLINE
 4667 7461850
xla.plsql.xla_accounting_pkg.event_application_manager

-1 29648
29-APR-17 g_
parent_request_id = 8581621
 4667 7461850
xla.plsql.xla_security_pkg.set_security_context

-1 29648
29-APR-17 BE
GIN of procedure SET_SECURITY_CONTEXT
 4667 7461850
xla.plsql.xla_security_pkg.set_security_context

-1 29648
29-APR-17 p_
application_id = 200
 4667 7461850
xla.plsql.xla_security_pkg.set_security_context

-1 29648
29-APR-17 l_
access_ctrl_enabled = Y
 4667 7461850
xla.plsql.xla_security_pkg.set_security_context

-1 29648
29-APR-17 MO
_GLOBAL.is_mo_init_done = Y
 4667 7461850
xla.plsql.xla_security_pkg.set_security_context

-1 29648
29-APR-17 l_
appl_short_name = SQLAP
 4667 7461850
xla.plsql.xla_security_pkg.set_security_context

-1 29648
29-APR-17 l_
policy_function = XLA_SECURITY_POLICY_PKG.MO_POLICY
 4667 7461850
xla.plsql.xla_security_pkg.set_security_context

-1 29648
29-APR-17 l_
resp_appl_short_name =
 4667 7461850
xla.plsql.xla_security_pkg.set_security_context

-1 29648
29-APR-17 l_
use_trx_security = N
 4667 7461850
xla.plsql.xla_security_pkg.set_security_context

-1 29648
29-APR-17 l_
security_group = SQLAP
 4667 7461850
xla.plsql.xla_security_pkg.set_security_context

-1 29648
29-APR-17 EN
D of procedure SET_SECURITY_CONTEXT
 4667 7461850
xla.plsql.xla_accounting_pkg.event_application_manager

-1 29648
29-APR-17 Se
curity_context set for application = 200

4667 7461850
fnd.plsql.fnd_file.PUT_LINE

-1 29648
29-APR-17 si
d:336453067: 29-APR-2017 03:31:17 - Security Context Set

4667 7461850
xla.plsql.xla_accounting_pkg.event_application_manager

-1 29648
 29-APR-17 Se
ssion identifier set to = 8581621

4667 7461850
fnd.plsql.fnd_file.PUT_LINE

-1 29648
29-APR-17 si
d:336453067: 29-APR-2017 03:31:17 - Session Identifier Set
 4667 7461850
xla.plsql.xla_accounting_pkg.event_application_manager

-1 29648
29-APR-17 g_
queue_table_name = XLA.xla_accounting_qtab
 4667 7461850
xla.plsql.xla_accounting_pkg.event_application_manager

-1 29648
29-APR-17 g_
queue_name = XLA.XLA_8581621_DOC_Q
 4667 7461850
xla.plsql.xla_accounting_pkg.event_application_manager

-1 29648
29-APR-17 Tr
ansfer to GL process being called
 4667 7461850
xla.plsql.xla_accounting_err_pkg.set_options

-1 29648
29-APR-17 BE
GIN of procedure SET_OPTIONS
 4667 7461850
xla.plsql.xla_transfer_pkg.get_ledgers

-1 29648
29-APR-17 ge
t_ledgers.End
 4667 7461850
xla.plsql.xla_transfer_pkg.gl_transfer_main

-1 29648
29-APR-17 Ch
ecking for failed batches
 4667 7461850
xla.plsql.xla_transfer_pkg.Recover_Batch

-1 29648
29-APR-17 re
cover_batch.Begin
 4667 7461850
xla.plsql.xla_transfer_pkg.Recover_Batch

-1 29648
29-APR-17 Fo
und 0 batches to recover
 4667 7461850
xla.plsql.xla_transfer_pkg.Recover_Batch

-1 29648
29-APR-17 re
cover_batch.End
 4667 7461850
xla.plsql.xla_transfer_pkg.gl_transfer_main

-1 29648
29-APR-17 Nu
mber of primary and secondary ledgers to process = 1
 4667 7461850
xla.plsql.xla_transfer_pkg.gl_transfer_main

-1 29648
29-APR-17 Pr
imary/Secondary ledger loop
 4667 7461850
xla.plsql.xla_transfer_pkg.gl_transfer_main

-1 29648
29-APR-17 Lo
op for each primary and secondary ledger

4667 7461850
xla.plsql.xla_transfer_pkg.gl_transfer_main

-1 29648
29-APR-17 Le
dger Name = (ORAPTC) Nikon Precision Inc. Ledger Id = 1

4667 7461850
xla.plsql.xla_transfer_pkg.get_ledger_options

-1 29648
 29-APR-17 ge
t_ledger_options.Begin

4667 7461850
xla.plsql.xla_transfer_pkg.get_ledger_options

-1 29648
29-APR-17 p_
ledger_id = 1
 4667 7461850
xla.plsql.xla_transfer_pkg.get_ledger_options

-1 29648
29-APR-17 g_
transfer_summary_mode = P
 4667 7461850
xla.plsql.xla_transfer_pkg.get_ledger_options

-1 29648
29-APR-17 l_
access_set_id = 1000
 4667 7461850
xla.plsql.xla_transfer_pkg.get_ledger_options

-1 29648
29-APR-17 ge
t_ledger_options.End
 4667 7461850
xla.plsql.xla_transfer_pkg.get_alc_ledgers

-1 29648
29-APR-17 ge
t_alc_ledgers.Begin
 4667 7461850
xla.plsql.xla_transfer_pkg.get_alc_ledgers

-1 29648
29-APR-17 ge
t_alc_ledgers.End
 4667 7461850
xla.plsql.xla_transfer_pkg.gl_transfer_main

-1 29648
29-APR-17 Up
dating Group ID
 4667 7461850
xla.plsql.xla_transfer_pkg.gl_transfer_main

-1 29648
29-APR-17 Le
dgers selected for the processing
 4667 7461850
xla.plsql.xla_transfer_pkg.gl_transfer_main

-1 29648
29-APR-17 Le
dger id = 1
 4667 7461850
xla.plsql.xla_transfer_pkg.gl_transfer_main

-1 29648
29-APR-17 Gr
oup_id = 687833
 4667 7461850
xla.plsql.xla_transfer_pkg.gl_transfer_main

-1 29648
29-APR-17 In
terface_run_id = 494339
 4667 7461850
xla.plsql.xla_transfer_pkg.gl_transfer_main

-1 29648
29-APR-17 In
serting an entry into the audit table
 4667 7461850
xla.plsql.xla_transfer_pkg.select_journal_entries

-1 29648
29-APR-17 se
lect_journal_entries.Begin

4667 7461850
xla.plsql.xla_transfer_pkg.select_journal_entries

-1 29648
29-APR-17 Nu
mber of ledgers selected = 1

4667 7461850
xla.plsql.xla_transfer_pkg.select_journal_entries

-1 29648
 29-APR-17 St
andalone batch transfer.

4667 7461850
xla.plsql.xla_transfer_pkg.select_journal_entries

-1 29648
29-APR-17 l_
statement_2 := UPDATE
 4667 7461850

(S
ELECT /*+ leading(aeh) use_nl(xte) */ -- added for bug12542507
 ae
h.program_update_date -- added hint per performance change 7259699
 ,a
eh.program_id
 ,a
eh.request_id
 ,a
eh.gl_transfer_date
 ,a
eh.gl_transfer_status_code
 ,a
eh.group_id
 FR
OM xla_ae_headers aeh
 ,x
la_transaction_entities xte
 --
,xla_event_types_b xet
 --
,xla_event_class_attrs xeca
 --
,xla_event_classes_b xec -- commented for bug12542507 and made it as IN cla
use
 WH
ERE xte.entity_id = aeh.entity_id
 AN
D xte.application_id = :1 --g_application_id

AN
D aeh.application_id = xte.application_id
 AN
D aeh.ledger_id = :2 --g_ledger_id_tab(i)
 AN
D aeh.je_category_name in (select je_category_name from gl_je_categories) -
-8417930
 AN
D EXISTS(select 1 from gl_period_statuses glp
 wh
ere glp.application_id = 101
 an
d glp.ledger_id = aeh.ledger_id
 an
d glp.period_name = aeh.period_name) --8417930
 AN
D aeh.accounting_date <= :3 --g_end_date
 /*
AND xte.entity_code = xec.entity_code
 AN
D xeca.application_id = xec.application_id
 AN
D xeca.event_class_code = xec.event_class_code
 AN
D xeca.entity_code = xec.entity_code
 AN
D xeca.event_class_group_code = Nvl(:4,xeca.event_class_group_code)
 AN
D xec.event_class_code = xet.event_class_code
 AN
D xet.event_type_code = aeh.event_type_code

AN
D xet.application_id = aeh.application_id
 AN
D xec.application_id = xet.application_id
 AN
D xet.event_class_code = xec.event_class_code */ --commented for bug125425
07 and made it as IN clause as below
 AN
D (aeh.application_id , aeh.event_type_code) IN ( SELECT xet.application_i
d , xet.event_type_code
 FR
OM xla_event_types_b xet
 ,x
la_event_class_attrs xeca
 ,x
la_event_classes_b xec
 WH
ERE 1 = 1
 AN
D xeca.event_class_group_code = Nvl(:4,xeca.event_class_group_code)
 AN
D xeca.application_id = :5
 AN
D xeca.application_id = xec.application_id
 AN
D xeca.event_class_code = xec.event_class_code
 AN
D xeca.entity_code = xec.entity_code
 AN
D xec.event_class_code = xet.event_class_code
 AN
D xec.application_id = xet.application_id

)
 AN
D aeh.gl_transfer_status_code = 'N'
 AN
D aeh.accounting_entry_status_code = 'F'
 AN
D EXISTS
(
 SE
LECT 1 FROM xla_ae_lines xal
 WH
ERE aeh.ae_header_id = xal.ae_header_id
 AN
D aeh.application_id = xal.application_id
)
 AN
D EXISTS
(
 SE
LECT 1 FROM xla_events xle
 WH
ERE aeh.event_id = xle.event_id
 AN
D aeh.application_id = xle.application_id
 AN
D xle.event_status_code = 'P'

AN
D xle.process_status_code = 'P'
)
 )
SET program_update_date = SYSDATE
 ,p
rogram_id = :6 --g_program_id
 ,r
equest_id = :7 --g_request_id
 ,g
l_transfer_date = Sysdate
 ,g
roup_id = :8 --g_group_id
 ,g
l_transfer_status_code = 'S'
xla.plsql.xla_security_policy_pkg.MO_Policy

-1 29648
29-APR-17 MO
_Policy.Begin
 4667 7461850
xla.plsql.xla_security_policy_pkg.MO_Policy

-1 29648
29-APR-17 l_
mo_policy after calling mo_global.org_security = EXISTS (SELECT /*+ no_unnest
*/ 1 --bug 13891445
 4667 7461850

FR
OM mo_glob_org_access_tmp oa
 WH
ERE oa.organization_id = org_id)
xla.plsql.xla_security_policy_pkg.MO_Policy

-1 29648
29-APR-17 MO
_Policy.End
 4667 7461850
xla.plsql.XLA_CREATE_ACCT_RPT_PVT

-1 29648
29-APR-17 Ca
lling xla_accounting_pub_pkg.accounting_program_batch

4667 7461850
xla.plsql.xla_accounting_pub_pkg.accounting_program_batch
 -1 29648
29-APR-17 BE
GIN of procedure ACCOUNTING_PROGRAM_BATCH

4667 7461850
fnd.plsql.fnd_file.PUT_LINE

-1 29648
29-APR-17 si
d:336453067: 29-APR-2017 03:31:17 - Starting of the Parent Thread
 4667 7461850
xla.plsql.xla_accounting_err_pkg.initialize

-1 29648
29-APR-17 BE
GIN of procedure INITIALIZE
 4667 7461850
xla.plsql.xla_accounting_err_pkg.initialize

-1 29648
29-APR-17 p_
client_id =
 4667 7461850
xla.plsql.xla_accounting_err_pkg.initialize

-1 29648
29-APR-17 p_
error_limit =
 4667 7461850
xla.plsql.xla_accounting_err_pkg.initialize

-1 29648
29-APR-17 p_
error_source =
 4667 7461850
xla.plsql.xla_accounting_err_pkg.initialize

-1 29648
29-APR-17 p_
request_id =
 4667 7461850
xla.plsql.xla_accounting_err_pkg.initialize

-1 29648
29-APR-17 p_
application_id =
 4667 7461850
xla.plsql.xla_accounting_err_pkg.reset

-1 29648
29-APR-17 BE
GIN of procedure RESET
 4667 7461850
xla.plsql.xla_accounting_err_pkg.reset

-1 29648
29-APR-17 EN
D of procedure RESET
 4667 7461850
xla.plsql.xla_accounting_err_pkg.initialize

-1 29648
29-APR-17 EN
D of procedure INITIALIZE
 4667 7461850
xla.plsql.xla_accounting_pkg.accounting_program_batch

-1 29648
29-APR-17 BE
GIN of procedure ACCOUNTING_PROGRAM_BATCH
 4667 7461850
xla.plsql.xla_accounting_pkg.accounting_program_batch

-1 29648
29-APR-17 p_
source_application_id = 200
 4667 7461850
xla.plsql.xla_accounting_pkg.accounting_program_batch

-1 29648
29-APR-17 p_
application_id = 200
 4667 7461850
xla.plsql.xla_accounting_pkg.accounting_program_batch

-1 29648
29-APR-17 p_
ledger_id = 1

4667 7461850
xla.plsql.xla_accounting_pkg.accounting_program_batch
 -1 29648
29-APR-17 p_
process_category =

4667 7461850
xla.plsql.xla_accounting_pkg.accounting_program_batch

-1 29648
29-APR-17 p_
end_date = 30-APR-2017
 4667 7461850
xla.plsql.xla_accounting_pkg.accounting_program_batch

-1 29648
29-APR-17 p_
accounting_flag = N
 4667 7461850
xla.plsql.xla_accounting_pkg.accounting_program_batch

-1 29648
29-APR-17 p_
accounting_mode =
 4667 7461850
xla.plsql.xla_accounting_pkg.accounting_program_batch

-1 29648
29-APR-17 p_
error_only_flag =
 4667 7461850
xla.plsql.xla_accounting_pkg.accounting_program_batch

-1 29648
29-APR-17 p_
transfer_flag = Y
 4667 7461850
xla.plsql.xla_accounting_pkg.accounting_program_batch

-1 29648
29-APR-17 p_
gl_posting_flag = Y
 4667 7461850
xla.plsql.xla_accounting_pkg.accounting_program_batch

-1 29648
29-APR-17 p_
gl_batch_name =
 4667 7461850
xla.plsql.xla_accounting_pkg.accounting_program_batch

-1 29648
29-APR-17 p_
valuation_method =
 4667 7461850
xla.plsql.xla_accounting_pkg.accounting_program_batch

-1 29648
29-APR-17 p_
security_id_int_1 =
 4667 7461850
xla.plsql.xla_accounting_pkg.accounting_program_batch

-1 29648
29-APR-17 p_
security_id_int_1 =
 4667 7461850
xla.plsql.xla_accounting_pkg.accounting_program_batch

-1 29648
29-APR-17 p_
security_id_int_3 =
 4667 7461850
xla.plsql.xla_accounting_pkg.accounting_program_batch

-1 29648
29-APR-17 p_
security_id_char_1 =
 4667 7461850
xla.plsql.xla_accounting_pkg.accounting_program_batch

-1 29648
29-APR-17 p_
security_id_char_2 =
 4667 7461850
xla.plsql.xla_accounting_pkg.accounting_program_batch

-1 29648
29-APR-17 p_
security_id_char_3 =

4667 7461850
fnd.plsql.fnd_file.PUT_LINE
 -1 29648
29-APR-17 si
d:336453067: Starting main program for the source application = 200

4667 7461850
xla.plsql.xla_accounting_pkg.accounting_program_batch

-1 29648
29-APR-17 g_
report_request_id = 8581621
 4667 7461850
xla.plsql.xla_accounting_pkg.accounting_program_batch

-1 29648
29-APR-17 g_
accounting_batch_id = 3591
 4667 7461850
xla.plsql.xla_accounting_err_pkg.set_options

-1 29648
29-APR-17 BE
GIN of procedure SET_OPTIONS
 4667 7461850
xla.plsql.xla_accounting_err_pkg.set_options

-1 29648
29-APR-17 p_
error_source = ACCT_PROGRAM
 4667 7461850
xla.plsql.xla_accounting_err_pkg.set_options

-1 29648
29-APR-17 p_
error_source = TRANSFER_TO_GL
 4667 7461850
xla.plsql.xla_accounting_err_pkg.set_options

-1 29648
29-APR-17 p_
request_id =
 4667 7461850
xla.plsql.xla_accounting_err_pkg.set_options

-1 29648
29-APR-17 p_
application_id =
 4667 7461850
xla.plsql.xla_accounting_err_pkg.set_options

-1 29648
29-APR-17 g_
error_source = TRANSFER_TO_GL
 4667 7461850
xla.plsql.xla_accounting_err_pkg.set_options

-1 29648
29-APR-17 g_
request_id = 8581621
 4667 7461850
xla.plsql.xla_accounting_err_pkg.set_options

-1 29648
29-APR-17 g_
application_id = 200
 4667 7461850
xla.plsql.xla_accounting_err_pkg.set_options

-1 29648
29-APR-17 EN
D of procedure SET_OPTIONS
 4667 7461850
xla.plsql.xla_accounting_pkg.event_application_manager

-1 29648
29-APR-17 l_
transfer_mode = STANDALONE
 4667 7461850
xla.plsql.xla_accounting_pkg.event_application_manager

-1 29648
29-APR-17 Ca
lling transfer routine XLA_TRANSFER_PKG.GL_TRANSFER_MAIN
 4667 7461850
fnd.plsql.fnd_file.PUT_LINE

-1 29648
29-APR-17 si
d:336453067: 29-APR-2017 03:31:17 - Submitting the transfer to GL

4667 7461850
xla.plsql.xla_transfer_pkg.gl_transfer_main
 -1 29648
29-APR-17 gl
_transfer_main.Begin

4667 7461850
xla.plsql.xla_transfer_pkg.gl_transfer_main

-1 29648
29-APR-17 --
-------------------------------------------------
 4667 7461850
xla.plsql.xla_transfer_pkg.gl_transfer_main

-1 29648
29-APR-17 p_
application_id = 200
 4667 7461850
xla.plsql.xla_transfer_pkg.gl_transfer_main

-1 29648
29-APR-17 p_
transfer_mode = STANDALONE
 4667 7461850
xla.plsql.xla_transfer_pkg.select_journal_entries

-1 29648
29-APR-17 No
subledger journal entries were found for the specified criteria.
 4667 7461850
xla.plsql.xla_transfer_pkg.select_journal_entries

-1 29648
29-APR-17 se
lect_journal_entries.End
 4667 7461850
xla.plsql.xla_transfer_pkg.gl_transfer_main

-1 29648
29-APR-17 Th
ere are no entries to process in the ledger (ORAPTC) Nikon Precision Inc.
 4667 7461850
xla.plsql.xla_transfer_pkg.gl_transfer_main

-1 29648
29-APR-17 GL
_TRANSFER_MAIN.End
 4667 7461850
fnd.plsql.fnd_file.PUT_LINE

-1 29648
29-APR-17 si
d:336453067: 29-APR-2017 03:31:18 - End of the transfer to GL
 4667 7461850
xla.plsql.xla_accounting_pkg.event_application_manager

-1 29648
29-APR-17 Tr
ansfer routine XLA_TRANSFER_PKG.GL_TRANSFER_MAIN executed
 4667 7461850
xla.plsql.xla_accounting_err_pkg.set_options

-1 29648
29-APR-17 BE
GIN of procedure SET_OPTIONS
 4667 7461850
xla.plsql.xla_accounting_err_pkg.set_options

-1 29648
29-APR-17 p_
error_source = ACCT_PROGRAM
 4667 7461850
xla.plsql.xla_accounting_err_pkg.set_options

-1 29648
29-APR-17 p_
request_id =
 4667 7461850
xla.plsql.xla_accounting_err_pkg.set_options

-1 29648
29-APR-17 p_
application_id =
 4667 7461850
xla.plsql.xla_accounting_err_pkg.set_options

-1 29648
29-APR-17 g_
error_source = ACCT_PROGRAM

4667 7461850
xla.plsql.xla_accounting_err_pkg.set_options
 -1 29648
29-APR-17 g_
request_id = 8581621

4667 7461850
xla.plsql.xla_accounting_err_pkg.set_options

-1 29648
29-APR-17 g_
application_id = 200
 4667 7461850
xla.plsql.xla_accounting_err_pkg.set_options

-1 29648
29-APR-17 EN
D of procedure SET_OPTIONS
 4667 7461850
xla.plsql.xla_accounting_pkg.event_application_manager

-1 29648
29-APR-17 Tr
ansfer to GL process completed
 4667 7461850
fnd.plsql.fnd_file.PUT_LINE

-1 29648
29-APR-17 si
d:336453067: 29-APR-2017 03:31:18 - executing postaccounting hook
 4667 7461850
xla.plsql.xla_accounting_pkg.handle_accounting_hook

-1 29648
29-APR-17 BE
GIN of procedure handle_accounting_hook
 4667 7461850
xla.plsql.xla_ap_acct_hooks_pkg.main

-1 29648
29-APR-17 BE
GIN of procedure Main
 4667 7461850
xla.plsql.xla_ap_acct_hooks_pkg.main

-1 29648
29-APR-17 p_
application_id = 200
 4667 7461850
xla.plsql.xla_ap_acct_hooks_pkg.main

-1 29648
29-APR-17 p_
accounting_mode =
 4667 7461850
xla.plsql.xla_ap_acct_hooks_pkg.main

-1 29648
29-APR-17 p_
event_name = postaccounting
 4667 7461850
xla.plsql.xla_ap_acct_hooks_pkg.main

-1 29648
29-APR-17 p_
ledger_id = 1
 4667 7461850
xla.plsql.xla_ap_acct_hooks_pkg.main

-1 29648
29-APR-17 p_
process_category =
 4667 7461850
xla.plsql.xla_ap_acct_hooks_pkg.main

-1 29648
29-APR-17 p_
end_date = 30-APR-17
 4667 7461850
xla.plsql.xla_ap_acct_hooks_pkg.main

-1 29648
29-APR-17 p_
valuation_method =
 4667 7461850
xla.plsql.xla_ap_acct_hooks_pkg.main

-1 29648
29-APR-17 p_
security_id_int_1 =

4667 7461850
xla.plsql.xla_ap_acct_hooks_pkg.main
 -1 29648
29-APR-17 p_
security_id_int_2 =

4667 7461850
xla.plsql.xla_ap_acct_hooks_pkg.main

-1 29648
29-APR-17 p_
security_id_int_3 =
 4667 7461850
xla.plsql.xla_ap_acct_hooks_pkg.main

-1 29648
29-APR-17 p_
security_id_char_1 =
 4667 7461850
xla.plsql.xla_ap_acct_hooks_pkg.main

-1 29648
29-APR-17 p_
security_id_char_2 =
 4667 7461850
xla.plsql.xla_ap_acct_hooks_pkg.main

-1 29648
29-APR-17 p_
security_id_char_3 =
 4667 7461850
xla.plsql.xla_ap_acct_hooks_pkg.main

-1 29648
29-APR-17 p_
report_request_id = 8581621
 4667 7461850
xla.plsql.xla_ap_acct_hooks_pkg.main

-1 29648
29-APR-17 Re
ady to call postaccounting API for Account Payables
 4667 7461850
AP.PLSQL.AP_SLA_PROCESSING_PKG.POST_ACCOUNTING_PROC

-1 29648
29-APR-17 Be
gin of procedure POST_ACCOUNTING_PROC
 4667 7461850
AP.PLSQL.AP_SLA_PROCESSING_PKG.POST_ACCOUNTING_PROC

-1 29648
29-APR-17 ca
se p_accounting_mode :=
 4667 7461850
AP.PLSQL.AP_SLA_PROCESSING_PKG.POST_ACCOUNTING_PROC

-1 29648
29-APR-17 En
d of procedure POST_ACCOUNTING_PROC
 4667 7461850
xla.plsql.xla_ap_acct_hooks_pkg.main

-1 29648
29-APR-17 Co
ntrol returned from postaccounting API
 4667 7461850
xla.plsql.xla_accounting_pkg.raise_accounting_event

-1 29648
29-APR-17 BE
GIN of procedure RAISE_ACCOUNTING_EVENT
 4667 7461850
xla.plsql.xla_accounting_pkg.raise_accounting_event

-1 29648
29-APR-17 p_
application_id = 200
 4667 7461850
xla.plsql.xla_accounting_pkg.raise_accounting_event

-1 29648
29-APR-17 p_
ledger_id = 1
 4667 7461850
xla.plsql.xla_accounting_pkg.raise_accounting_event

-1 29648
29-APR-17 p_
process_category =

4667 7461850
xla.plsql.xla_accounting_pkg.raise_accounting_event
 -1 29648
29-APR-17 p_
end_date = 30-APR-17

4667 7461850
xla.plsql.xla_accounting_pkg.raise_accounting_event

-1 29648
29-APR-17 p_
accounting_mode =
 4667 7461850
xla.plsql.xla_accounting_pkg.raise_accounting_event

-1 29648
29-APR-17 p_
valuation_method =
 4667 7461850
xla.plsql.xla_accounting_pkg.raise_accounting_event

-1 29648
29-APR-17 p_
security_id_int_1 =
 4667 7461850
xla.plsql.xla_accounting_pkg.raise_accounting_event

-1 29648
29-APR-17 p_
security_id_int_2 =
 4667 7461850
xla.plsql.xla_accounting_pkg.raise_accounting_event

-1 29648
29-APR-17 p_
security_id_int_3 =
 4667 7461850
xla.plsql.xla_accounting_pkg.raise_accounting_event

-1 29648
29-APR-17 p_
security_id_char_1 =
 4667 7461850
xla.plsql.xla_accounting_pkg.raise_accounting_event

-1 29648
29-APR-17 p_
security_id_char_2 =
 4667 7461850
xla.plsql.xla_accounting_pkg.raise_accounting_event

-1 29648
29-APR-17 p_
security_id_char_3 =
 4667 7461850
xla.plsql.xla_accounting_pkg.raise_accounting_event

-1 29648
29-APR-17 p_
report_request_id = 8581621
 4667 7461850
xla.plsql.xla_accounting_pkg.raise_accounting_event

-1 29648
29-APR-17 p_
event_name = postaccounting
 4667 7461850
xla.plsql.xla_accounting_pkg.raise_accounting_event

-1 29648
29-APR-17 p_
event_key = 3591-8581621
 4667 7461850
fnd.plsql.fnd_file.PUT_LINE

-1 29648
29-APR-17 si
d:336453067: event key = 3591-8581621
 4667 7461850
wf.plsql.WF_EVENT.raise3.Begin

-1 29648
29-APR-17 Ev
ent Name:oracle.apps.xla.accounting.postaccounting Event Key:3591-8581621Maximum
nested raise count:100Nested raise count: 0
 4667 7461850
wf.plsql.WF_EVENT.dispatch.Begin

-1 29648
29-APR-17 Di
spatching event oracle.apps.xla.accounting.postaccounting

4667 7461850
wf.plsql.WF_BES_CACHE.GetEventByName.Begin
 -1 29648
29-APR-17 Ge
tting event details for {oracle.apps.xla.accounting.postaccounting}

4667 7461850
wf.plsql.WF_BES_CACHE.CacheValid.Check

-1 29648
29-APR-17 La
st upload time {} Last cache time {}
 4667 7461850
wf.plsql.WF_BES_CACHE.GetEventByName.Create_Cache

-1 29648
29-APR-17 Ca
che is not created for EVENTS index {1}
 4667 7461850
wf.plsql.WF_BES_CACHE.GetEventByName.Load_Event

-1 29648
29-APR-17 Ev
ent not found in cache. Loading from Database
 4667 7461850
wf.plsql.WF_BES_CACHE.GetEventByName.Set_Cache

-1 29648
29-APR-17 Se
tting event {oracle.apps.xla.accounting.postaccounting} to cache
 4667 7461850
wf.plsql.WF_OBJECT_CACHE.SetObject.Begin

-1 29648
29-APR-17 Se
tting object {oracle.apps.xla.accounting.postaccounting} in cache {1}
 4667 7461850
wf.plsql.WF_OBJECT_CACHE.SetObject.Assign

-1 29648
29-APR-17 Ch
ecking cache size and storing object in cache
 4667 7461850
wf.plsql.WF_OBJECT_CACHE.Check_Size.Begin

-1 29648
29-APR-17 Ch
ecking size of Cache. CurrIdx {1}
 4667 7461850
wf.plsql.WF_OBJECT_CACHE.Assign_Object.Begin

-1 29648
29-APR-17 As
signing object at {13604823} in cache {1}
 4667 7461850
wf.plsql.WF_OBJECT_CACHE.Assign_Object.Begin

-1 29648
29-APR-17 Cu
rrent Idx for age table is {1}
 4667 7461850
wf.plsql.WF_OBJECT_CACHE.Assign_Object.End

-1 29648
29-APR-17 As
signed object to cache. Next Idx {2}
 4667 7461850
wf.plsql.WF_EVENT.dispatch.no_event

-1 29648
29-APR-17 Ev
ent is either disabled or product not licensed or event not registered
 4667 7461850
wf.plsql.WF_BES_CACHE.GetSubscriptions.Begin

-1 29648
29-APR-17 Ge
tting subscriptions for event {oracle.apps.wf.event.any} Source Type {LOCAL} Sou
rce Agt {}
 4667 7461850
wf.plsql.WF_BES_CACHE.GetEventByName.Begin

-1 29648
29-APR-17 Ge
tting event details for {oracle.apps.wf.event.any}
 4667 7461850
wf.plsql.WF_BES_CACHE.CacheValid.Check

-1 29648
29-APR-17 La
st upload time {} Last cache time {2017/04/29 03:31:18}

4667 7461850
401 rows selected