MODULE MESSAGE
[Link] request_session_lock called for apid=0, qid=0, pid=18114
[Link] lock name=FNDCPLK_0_0_18114
[Link] for lock name=FNDCPLK_0_0_18114 hndl=107378135810737813587
[Link] result of request_lock: 0
[Link] Returning zis_adb = N
[Link] Queue Application id 0 Concurrent queue id 0 Resource consumer group switched. Previous group: New group: DE
[Link] 04-SEP-2024 [Link] - afpnlssort- Request NLS_SORT = BINARY
[Link]. Calling PL/SQL procedure MO_GLOBAL.INIT
[Link]. MO: Operating Unit=>221, MO: Security Profile=>4062, p_appl_short_name=>M
[Link] Calling PL/SQL procedure MO_GLOBAL.SET_ORG_ACCESS: p_org_id_char=>221, p_sp_id_char=>4062, p_appl_shor
[Link] Checking access status within PL/SQL procedure MO_GLOBAL.SET_ORG_ACCESS: l_access_ctrl_enabled=>Y
[Link] Before flushing MO_GLOB_ORG_ACCESS_TMP
[Link] MO_GLOB_ORG_ACCESS_TMP was flushed
[Link] Returning from PL/SQL procedure MO_GLOBAL.DELETE_ORGS
[Link] Calling PL/SQL procedure MO_GLOBAL.POPULATE_ORGS
[Link] p_org_id=, p_sp_id=4062
[Link] per_security_profiles.security_profile_name=>DF UAT Security Profile, per_security_profiles.business_group_id=>8
[Link] Retrieving operating units using cursor c1
[Link] Inserted 1 record(s) into MO_GLOB_ORG_ACCESS_TMP
[Link] Returning from PL/SQL procedure MO_GLOBAL.POPULATE_ORGS: l_bg_id=81, p_sp_id_char=4062, l_sp_name=DF
[Link] Returning from PL/SQL procedure MO_GLOBAL.POPULATE_ORGS
[Link] Calling PL/SQL procedure MO_GLOBAL.SET_POLICY_CONTEXT: p_access_mode=>S,p_org_id=>221
[Link] Returning from PL/SQL prcedure MO_GLOBAL.SET_POLICY_CONTEXT
[Link] Calling PL/SQL procedure MO_GLOBAL.SET_ORG_ACCESS: p_org_id_char=>221,p_sp_id_char=>4062,p_appl_short_
[Link]. Exiting PL/SQL procedure MO_GLOBAL.INIT
[Link] Calling PL/SQL procedure MO_GLOBAL.SET_POLICY_CONTEXT: p_access_mode=>S,p_org_id=>221
[Link] Returning from PL/SQL prcedure MO_GLOBAL.SET_POLICY_CONTEXT
[Link] Returning zis_adb = N
[Link]. Request id 1919823 Resource consumer group switched. Previous group: DEFAULT_CONSUMER_GROUP New group
[Link] **Starts**
[Link]. End of subprogram.
[Link].P End of subprogram.
[Link].P End of subprogram.
[Link].P p_api_version = 1
[Link].P p_init_msg_list = F
[Link].P p_validation_level = 100
[Link].P p_commit = T
[Link].P p_gather_intf_tbl_stat = F
[Link].P p_calling_module = CONCURRENT PROGRAM
[Link].P p_selected_batch_id is null
[Link].P p_batch_size = 5000
[Link].P p_buyer_id is null
[Link].P p_document_type = STANDARD
[Link].P p_document_subtype is null
[Link].P p_create_items = N
[Link].P p_create_sourcing_rules_flag is null
[Link].P p_rel_gen_method is null
[Link].P p_sourcing_level is null
[Link].P p_sourcing_inv_org_id is null
[Link].P p_approved_status = APPROVED
[Link].P p_process_code = PENDING
[Link].P p_interface_header_id is null
[Link].P p_org_id is null
[Link].P p_ga_flag is null
[Link].P p_submit_dft_flag is null
[Link].P p_role = BUYER
[Link].P p_catalog_to_expire is null
[Link].P p_err_lines_tolerance is null
[Link].P p_group_lines is null
[Link].P p_group_shipments = N
[Link].P p_clm_flag = N
[Link].P Start of subprogram.
[Link].P AUDSID = 13916981
[Link].f sid:13916981: open OUT_FNAME =[Link]
[Link].f sid:13916981: open LOG_FNAME =[Link]
[Link]. sid:13916981: To get the log messages for PDOI, please use the following id to query against FND_LOG_MESSAGES
[Link]. sid:13916981: AUDSID = 13916981
[Link].P End of subprogram.
[Link].P Start of subprogram.
[Link].P End of subprogram.
[Link].P Start of subprogram.
PO_PURCHretrieveOption function starts
PO_PURCHp_org_id :221
PO_PURCHp_option_column :DEFAULT_DISTRIBUTIONS
PO_PURCHl_query:SELECT DEFAULT_DISTRIBUTIONS FROM PO_SYSTEM_PARAMETERS_ALL WHERE ORG_ID=221
PO_PURCHreturn value:
PO_PURCHretrieveOption function ends
[Link].P Start of subprogram.
[Link].P currency_code = PKR
[Link].P coa_id = 50508
[Link].P po_encumbrance_flag = N
[Link].P req_encumbrance_flag = N
[Link].P sob_id = 2101
[Link].P ship_to_location_id is null
[Link].P bill_to_location_id is null
[Link].P fob_lookup_code is null
[Link].P freight_terms_lookup_code is null
[Link].P terms_id is null
[Link].P default_rate_type is null
[Link].P taxable_flag is null
[Link].P receiving_flag = Y
[Link].P line_type_id = 1
[Link].P manual_po_num_type = NUMERIC
[Link].P user_defined_po_num_code = AUTOMATIC
[Link].P price_type_lookup_code is null
[Link].P def_inv_org_id = 241
[Link].P min_rel_amount is null
[Link].P def_quote_warning_delay is null
[Link].P inspection_required_flag = Y
[Link].P user_defined_quote_num_code = AUTOMATIC
[Link].P manual_quote_num_type = NUMERIC
[Link].P ship_via_lookup_code is null
[Link].P qty_rcv_tolerance = 0
[Link].P price_break_lookup_code = CUMULATIVE
[Link].P invoice_close_tolerance is null
[Link].P receive_close_tolerance is null
[Link].P expense_accrual_code = RECEIPT
[Link].P master_inv_org_id = 104
[Link].P supplier_auth_acc is null
[Link].P cat_admin_auth_acc is null
[Link].P invoice_match_option is null
[Link].P def_business_group_id = 81
[Link].P def_structure_id = 50428
[Link].P def_cat_set_id = 1100000041
[Link].P def_category_id = 6123
[Link].P is_federal_instance = N
[Link].P group_shipments_flag = Y
[Link].P g_igt_flag = N
[Link].P End of subprogram.
[Link].P Start of subprogram.
[Link].P pdoi_write_to_file = N
[Link].P service_uom_class = 999
[Link].P override_funds is null
[Link].P xbg = N
[Link].P po_price_update_tolerance is null
[Link].P allow_tax_rate_override = Y
[Link].P group_by_need_by_date = Y
[Link].P group_by_ship_to_location = Y
[Link].P default_promised_date is null
[Link].P auto_create_date_option is null
[Link].P use_req_num_in_autocreate = Y
[Link].P deafult_promise_date_leadtime = Y
[Link].P pa_allow_flexbuilder_overrides is null
[Link].P End of subprogram.
[Link].P Start of subprogram.
[Link].P wip_installed = T
[Link].P inv_installed = T
[Link].P project_11510_installed = T
[Link].P pa_installed = T
[Link].P pjm_installed = T
[Link].P gms_enabled = F
[Link].P project_cwk_installed = T
[Link].P End of subprogram.
[Link].P g_processsing_id = 95015
[Link].P End of subprogram.
[Link]. Start of subprogram.
[Link]. Start of subprogram.
[Link]. # of records to eval = 1
[Link].P p_old_request_id = 1919812
[Link].P l_complete = T
[Link]. # of processable rec = 1
[Link].P after header assignment. Updated 1 records
[Link].P after line assignment. Updated 1 records
[Link].P after line location assignment. Updated 0 records
[Link].P after price diff assignment. Updated 0 records
[Link].P after distirbution assignment. Updated 1 records
[Link].P after attr value assignment. Updated 0 records
[Link]. after attr values tlp assignment. Updated 0 records
[Link]. End of subprogram.
[Link].P Start of subprogram.
[Link].P # of records to reject: = 0
[Link].P Start of subprogram.
[Link].P End of subprogram.
[Link]. Start of subprogram.
[Link]. Start of subprogram.
[Link]. x_nextval = 695636
[Link]. End of subprogram.
[Link]. vendor [Link] = 0
[Link]. vendor [Link] = 0
[Link]. vendor [Link] = 0
[Link]. End of subprogram.
[Link].P Start of subprogram.
[Link]. End of subprogram.
[Link].P Start of subprogram.
[Link]. Start of subprogram.
[Link].P Start of subprogram.
[Link].P Start of subprogram.
[Link].P End of subprogram.
[Link]. Start of subprogram.
[Link]. End of subprogram.
[Link].P Start of subprogram.
[Link].P Start of subprogram.
[Link].P End of subprogram.
[Link]. End of subprogram.
[Link]. Start of subprogram.
[Link]. End of subprogram.
[Link]. End of subprogram.
[Link]. Start of subprogram.
[Link]. Start of subprogram.
[Link]. Current Round Number: 1
[Link]. updated 1rows with current round number
[Link]. End of subprogram.
[Link]. Start of subprogram.
[Link]. Start of subprogram.
[Link]. End of subprogram.
[Link].P Start of subprogram.
[Link]. Number of existing drafts: 0
[Link]. End of subprogram.
[Link].P Start of subprogram.
[Link].P Start of subprogram.
[Link].P End of subprogram.
[Link]. End of subprogram.
[Link]. Start of subprogram.
[Link]. End of subprogram.
[Link]. End of subprogram.
[Link]. start main process for header group = 1
[Link]. Start of subprogram.
[Link]. End of subprogram.
[Link]. Start of subprogram.
[Link]. p_max_intf_header_id = -1
[Link]. End of subprogram.
[Link]. Start of subprogram.
[Link]. End of subprogram.
[Link]. header count within batch = 0
[Link]. End of subprogram.
[Link]. Start of subprogram.
[Link]. Start of subprogram.
[Link].P duplicate count against txn table = 0
[Link].P duplicate count against draft table = 0
[Link]. End of subprogram.
[Link].P Start of subprogram.
[Link].P count of lines with invalid actions = 0
[Link].P Start of subprogram.
[Link].P End of subprogram.
[Link]. p_data_set_type = 0
[Link]. p_data_set_type = 0
[Link]. p_max_intf_line_id = -1
[Link]. End of subprogram.
[Link]. Start of subprogram.
[Link]. x_nextval = 695637
[Link]. End of subprogram.
[Link]. Start of subprogram.
[Link]. End of subprogram.
[Link]. line count in batch = 0
[Link].P Start of subprogram.
[Link]. Start of subprogram.
[Link]. Start of subprogram.
[Link]. x_nextval = 695638
[Link]. End of subprogram.
[Link]. Number of records inserted = 0
[Link]. End of subprogram.
[Link]. Start of subprogram.
[Link]. Start of subprogram.
[Link]. x_nextval = 695639
[Link]. End of subprogram.
[Link]. l_intf_hdr_id_tbl.COUNT = 0
[Link]. l_pcard_cnt_tbl.COUNT = 0
[Link]. l_emergency_cnt_tbl.COUNT = 0
[Link].P Start of subprogram.
[Link]. End of subprogram.
[Link].P End of subprogram.
[Link].P Start of subprogram.
[Link]. End of subprogram.
[Link]. p_data_set_type = 1
[Link]. p_data_set_type = 1
[Link]. p_max_intf_line_id = -1
[Link]. End of subprogram.
[Link]. Start of subprogram.
[Link]. x_nextval = 695640
[Link]. End of subprogram.
[Link]. Start of subprogram.
[Link]. End of subprogram.
[Link]. line count in batch = 0
[Link].P Start of subprogram.
[Link]. Start of subprogram.
[Link]. Start of subprogram.
[Link]. x_nextval = 695641
[Link]. End of subprogram.
[Link]. Number of records inserted = 0
[Link]. End of subprogram.
[Link]. Start of subprogram.
[Link]. Start of subprogram.
[Link]. x_nextval = 695642
[Link]. End of subprogram.
[Link]. l_intf_hdr_id_tbl.COUNT = 0
[Link]. l_pcard_cnt_tbl.COUNT = 0
[Link]. l_emergency_cnt_tbl.COUNT = 0
[Link].P Start of subprogram.
[Link]. End of subprogram.
[Link].P End of subprogram.
[Link].P Start of subprogram.
[Link]. End of subprogram.
[Link]. p_data_set_type = 2
[Link]. p_data_set_type = 2
[Link]. p_max_intf_line_id = -1
[Link]. End of subprogram.
[Link]. Start of subprogram.
[Link]. End of subprogram.
[Link]. line count in batch = 0
[Link].P Start of subprogram.
[Link]. End of subprogram.
[Link]. p_data_set_type = 3
[Link]. p_data_set_type = 3
[Link]. p_max_intf_line_id = -1
[Link]. End of subprogram.
[Link]. Start of subprogram.
[Link]. End of subprogram.
[Link]. line count in batch = 0
[Link].P Start of subprogram.
[Link]. End of subprogram.
[Link]. p_data_set_type = 4
[Link]. p_data_set_type = 4
[Link]. p_max_intf_line_id = -1
[Link]. End of subprogram.
[Link]. Start of subprogram.
[Link]. End of subprogram.
[Link]. line count in batch = 0
[Link]. End of subprogram.
[Link]. End of subprogram.
[Link]. Start of subprogram.
[Link]. Start of subprogram.
[Link]. p_max_intf_attr_values_id = -1
[Link]. End of subprogram.
[Link]. Start of subprogram.
[Link]. End of subprogram.
[Link]. attr values in batch = 0
[Link]. End of subprogram.
[Link]. Start of subprogram.
[Link]. Start of subprogram.
[Link]. End of subprogram.
[Link]. Start of subprogram.
[Link]. End of subprogram.
[Link]. attr values tlp in batch = 0
[Link]. End of subprogram.
[Link]. End of subprogram.
[Link]. Start of subprogram.
[Link].P Start of subprogram.
[Link].P interface header [Link] = 0
[Link].P interface line [Link] = 0
[Link].P draft [Link] = 0
[Link].P style [Link] = 0
[Link].P schedules_required_flag_tbl.COUNT = 0
[Link].P interface line [Link] = 0
[Link].P l_advances_flag_tbl.COUNT = 0
[Link].P interface line [Link] = 0
[Link].P l_complex_style_flag_tbl.COUNT = 0
[Link].P l_financing_style_flag_tbl.COUNT = 0
[Link].P l_schedules_required_flag_tbl.COUNT = 0
[Link]. End of subprogram.
[Link]. p_max_intf_line_loc_id = -1
[Link]. End of subprogram.
[Link]. Start of subprogram.
[Link]. x_nextval = 695643
[Link]. End of subprogram.
[Link]. Start of subprogram.
[Link]. End of subprogram.
[Link]. loc count in batch = 0
[Link]. Start of subprogram.
[Link]. l_line_locs.line_loc_id_tbl.COUNT = 0
[Link]. l_line_locs.draft_id_tbl.COUNT = 0
[Link]. l_line_locs.quantity_tbl.COUNT = 0
[Link]. l_line_locs.amount_tbl.COUNT = 0
[Link]. l_line_locs.secondary_quantity_tbl.COUNT = 0
[Link]. l_lines.po_line_id_tbl.COUNT = 0
[Link]. l_lines.draft_id_tbl.COUNT = 0
[Link]. l_lines.quantity_tbl.COUNT = 0
[Link]. l_lines.amount_tbl.COUNT = 0
[Link]. l_lines.secondary_quantity_tbl.COUNT = 0
[Link]. End of subprogram.
[Link]. Start of subprogram.
[Link]. Number of Records Deleted = 0
[Link]. l_line_id_tbl.COUNT = 0
[Link]. l_draft_id_tbl.COUNT = 0
[Link]. l_req_contr_status_tbl.COUNT = 0
[Link]. l_min_unit_price_tbl.COUNT = 0
[Link]. Number of Records Inserted = 0
[Link]. End of subprogram.
[Link]. End of subprogram.
[Link]. Start of subprogram.
[Link]. p_max_intf_pay_sch_link_id = -1
[Link]. End of subprogram.
[Link]. Start of subprogram.
[Link]. End of subprogram.
[Link]. Start of subprogram.
[Link]. End of subprogram.
[Link]. Start of subprogram.
[Link]. End of subprogram.
[Link]. End of subprogram.
[Link]. Start of subprogram.
[Link].P Start of subprogram.
[Link].P number of lines fetched: 0
[Link].P l_intf_line_id_tbl.COUNT = 0
[Link].P l_req_line_id_tbl.COUNT = 0
[Link].P l_draft_id_tbl.COUNT = 0
[Link].P No of records identified: = 0
[Link]. p_max_intf_dist_id = -1
[Link]. End of subprogram.
[Link]. Start of subprogram.
[Link]. End of subprogram.
[Link].P dist count in batch = 0
[Link]. Start of subprogram.
[Link]. Start of subprogram.
[Link]. x_nextval = 695644
[Link]. End of subprogram.
[Link]. No of rows inserted in session table: = 0
[Link]. No of rows inserted in session table: = 0
[Link]. draft [Link] = 0
[Link]. line location [Link] = 0
[Link]. [Link] = 0
[Link]. [Link] = 0
[Link]. draft [Link] = 0
[Link]. line [Link] = 0
[Link]. [Link] = 0
[Link]. [Link] = 0
[Link]. End of subprogram.
[Link]. End of subprogram.
[Link]. Start of subprogram.
[Link].P Start of subprogram.
[Link].P End of subprogram.
[Link]. p_max_intf_price_diff_id = -1
[Link]. End of subprogram.
[Link].P Start of subprogram.
[Link].P End of subprogram.
[Link]. price diffs in batch = 0
[Link]. End of subprogram.
[Link]. End of subprogram.
[Link]. Start of subprogram.
[Link]. Start of subprogram.
[Link].P Start of subprogram.
[Link]. Start of subprogram.
[Link]. Start of subprogram.
[Link]. x_nextval = 695645
[Link]. End of subprogram.
[Link]. # of records that have dft changes = 0
[Link].P Start of subprogram.
[Link]. Start of subprogram.
[Link]. x_nextval = 695646
[Link]. End of subprogram.
[Link].P # of records that have dft changes = 0
[Link]. Start of subprogram.
[Link]. Start of subprogram.
[Link]. x_nextval = 695647
[Link]. End of subprogram.
[Link]. # of records that have dft changes = 0
[Link]. Start of subprogram.
[Link]. Start of subprogram.
[Link]. x_nextval = 695648
[Link]. End of subprogram.
[Link]. # of records that have dft changes = 0
[Link]. Start of subprogram.
[Link]. Start of subprogram.
[Link]. x_nextval = 695649
[Link]. End of subprogram.
[Link]. # of records that have dft changes = 0
[Link].P Start of subprogram.
[Link]. Start of subprogram.
[Link]. x_nextval = 695650
[Link]. End of subprogram.
[Link].P # of records that have dft changes = 0
[Link]. Start of subprogram.
[Link]. Start of subprogram.
[Link]. x_nextval = 695651
[Link]. End of subprogram.
[Link]. # of records that have dft changes = 0
[Link]. Start of subprogram.
[Link]. Start of subprogram.
[Link]. x_nextval = 695652
[Link]. End of subprogram.
[Link]. # of records that have dft changes = 0
[Link]. Start of subprogram.
[Link]. Start of subprogram.
[Link]. x_nextval = 695653
[Link]. End of subprogram.
[Link]. # of records that have dft changes = 0
[Link]. Start of subprogram.
[Link]. Start of subprogram.
[Link]. x_nextval = 695654
[Link]. End of subprogram.
[Link].P # of records that have dft changes = 0
[Link]. Start of subprogram.
[Link]. Start of subprogram.
[Link]. x_nextval = 695655
[Link]. End of subprogram.
[Link]. # of records that have dft changes = 0
[Link].P End of subprogram.
[Link]. End of subprogram.
[Link]. inside loop
[Link]. num of records fetched: 1
[Link]. interface_header_id: 1000001, processing header_id: 329016, action: ADD
[Link]. rollback to savepoint po_pdoi_doc_postproc_sp
[Link]. ORA-01403: no data found in Package [Link].PO_PDOI_POSTPROC_PVT. Procedure process.20;SQLERRM = ORA-0
[Link].P Start of subprogram.
[Link].P End of subprogram.
[Link].P ORA-01403: no data found in Package [Link].PO_PDOI_PVT. Procedure start_process.120;SQLERRM = ORA-01403
[Link]. Start of subprogram.
[Link].P Start of subprogram.
[Link].P Start of subprogram.
[Link].P End of subprogram.
[Link]. End of subprogram.
[Link]. Timing Stat: PDOI_ALL-1: Start=[Link].394, End=[Link].480, Duration=+00 [Link].086403
[Link]. Timing Stat: PREPROCESSING-1: Start=[Link].416, End=[Link].428, Duration=+00 [Link].011269
[Link]. Timing Stat: HEADER_GROUPING-1: Start=[Link].428, End=[Link].431, Duration=+00 [Link].003048
[Link]. Timing Stat: MAIN_PROCESSING-1: Start=[Link].431, End=[Link].467, Duration=+00 [Link].035737
[Link]. Timing Stat: HEADER_PROCESS-1: Start=[Link].432, End=[Link].433, Duration=+00 [Link].000877
[Link]. Timing Stat: LINE_PROCESS-1: Start=[Link].433, End=[Link].447, Duration=+00 [Link].014484
[Link]. Timing Stat: ATTR_PROCESS-1: Start=[Link].448, End=[Link].449, Duration=+00 [Link].001963
[Link]. Timing Stat: LINE_LOC_PROCESS-1: Start=[Link].450, End=[Link].459, Duration=+00 [Link].008980
[Link]. Timing Stat: PAY_SCH_LINK_PROCESS-1: Start=[Link].459, End=[Link].460, Duration=+00 [Link].001174
[Link]. Timing Stat: DIST_PROCESS-1: Start=[Link].460, End=[Link].465, Duration=+00 [Link].004856
[Link]. Timing Stat: PRICE_DIFF_PROCESS-1: Start=[Link].466, End=[Link].467, Duration=+00 [Link].001292
[Link]. Timing Stat: POSTPROCESSING-1: Start=[Link].467, End=, Duration=
[Link]. End of subprogram.
[Link].P x_return_status = U
[Link].P User-Defined Exception in Package [Link].PO_PDOI_GRP. Procedure start_process.20;SQLERRM = User-Defined E
[Link] **SQL error and free**
[Link] The SQL statement being executed at
[Link] +---------------------------------------------------------------------------+
[Link] Start of log messages from FND_FILE
[Link] +---------------------------------------------------------------------------+
AUDSID = 13916981
[Link]
[Link] +---------------------------------------------------------------------------+
[Link] End of log messages from FND_FILE
[Link] +---------------------------------------------------------------------------+
[Link]
[Link] Name:[Link] Event Key:1814770Maximum nested raise count:100Nested raise co
[Link] event [Link]
[Link]. Getting event details for {[Link]}
[Link]. Last upload time {} Last cache time {}
[Link]. Cache is not created for EVENTS index {1}
[Link]. Event not found in cache. Loading from Database
[Link]. Setting event {[Link]} to cache
[Link]. Setting object {[Link]} in cache {1}
[Link] cache size and storing object in cache
[Link]. Checking size of Cache. CurrIdx {1}
[Link]. Assigning object at {2627262} in cache {1}
[Link]. Current Idx for age table is {1}
[Link]. Assigned object to cache. Next Idx {2}
[Link] subscriptions for event {[Link]} Source Type {LOCAL} Source Agt {}
[Link]. Getting event details for {[Link]}
[Link]. Last upload time {} Last cache time {2024/09/04 [Link]}
[Link]. Getting the event from Cache
[Link]. Getting {[Link]} from cache {1}
[Link]. Object found in cache for {[Link]}
[Link] for {[Link]} is not already loaded. Loading from DB for Source Type {LOCAL
[Link] cursor active_subs for event {[Link]}
[Link] {1} LOCAL subscriptions for event {[Link]}
[Link]. Setting object {[Link]} in cache {1}
[Link]. Object already in cache. Overwriting.
[Link] LOCAL subscription with Phase 99
[Link] for Java subscription/generate
[Link]. Getting event details for {[Link]}
[Link]. Last upload time {} Last cache time {2024/09/04 [Link]}
[Link]. Getting the event from Cache
[Link]. Getting {[Link]} from cache {1}
[Link]. Object found in cache for {[Link]}
[Link].w Start executing rule function - wf_rule.default_rule [Start time 82551405]
[Link] wf_engine.event()
WF_ENGINE OAM_BE is not RAC enabled
[Link] executing PLSQL procedure - fnd_oam_kbf_subs.CreateSubList [Start time 82551413]
[Link] executing PLSQL procedure - fnd_oam_kbf_subs.CreateSubList [End time 82551419] [Time taken - .06 secs]
[Link] executing PLSQL procedure - WF_STANDARD.COMPARE [Start time 82551419]
[Link] executing PLSQL procedure - WF_STANDARD.COMPARE [End time 82551419] [Time taken - 0 secs]
[Link].w End executing rule function - wf_rule.default_rule [End time 82551419] [Time taken - .14 secs]
[Link] Rule Function wf_rule.default_rule and returned SUCCESS
[Link] +---------------------------------------------------------------------------+
[Link] No completion options were requested.
[Link] Output file size:
[Link] Deleting empty output file.
[Link] FND
[Link] Name:[Link] Event Key:1814815Maximum nested raise count:100Nested raise co
[Link] event [Link]
[Link]. Getting event details for {[Link]}
[Link]. Last upload time {} Last cache time {2024/09/04 [Link]}
[Link]. Getting the event from Cache
[Link]. Getting {[Link]} from cache {1}
[Link]. Object found in cache for {[Link]}
[Link] subscriptions for event {[Link]} Source Type {LOCAL} Source Agt {}
[Link]. Getting event details for {[Link]}
[Link]. Last upload time {} Last cache time {2024/09/04 [Link]}
[Link]. Getting the event from Cache
[Link]. Getting {[Link]} from cache {1}
[Link]. Object found in cache for {[Link]}
[Link]. Subscriptions for {[Link]} is already loaded to cache
[Link] LOCAL subscription with Phase 99
[Link] for Java subscription/generate
[Link]. Getting event details for {[Link]}
[Link]. Last upload time {} Last cache time {2024/09/04 [Link]}
[Link]. Getting the event from Cache
[Link]. Getting {[Link]} from cache {1}
[Link]. Object found in cache for {[Link]}
[Link].w Start executing rule function - wf_rule.default_rule [Start time 82551420]
[Link] wf_engine.event()
WF_ENGINE OAM_BE is not RAC enabled
[Link] executing PLSQL procedure - fnd_oam_kbf_subs.CreateSubList [Start time 82551421]
[Link] executing PLSQL procedure - fnd_oam_kbf_subs.CreateSubList [End time 82551421] [Time taken - 0 secs]
[Link] executing PLSQL procedure - WF_STANDARD.COMPARE [Start time 82551421]
[Link] executing PLSQL procedure - WF_STANDARD.COMPARE [End time 82551421] [Time taken - 0 secs]
[Link].w End executing rule function - wf_rule.default_rule [End time 82551421] [Time taken - .01 secs]
[Link] Rule Function wf_rule.default_rule and returned SUCCESS
[Link] +---------------------------------------------------------------------------+
[Link] Exceptions posted by this request:
[Link] Contact your support representative.
[Link] Concurrent Request for "Import Standard Purchase Orders" has completed with error.
[Link] +---------------------------------------------------------------------------+
[Link] Concurrent request completed
[Link] Current system time is 04-SEP-2024 [Link]
[Link] +---------------------------------------------------------------------------+
Previous group: New group: DEFAULT_CONSUMER_GROUP
sp_id_char=>4062, p_appl_short_name=>M
access_ctrl_enabled=>Y
y_profiles.business_group_id=>81, per_security_profiles.view_all_organizations_flag=>
p_id_char=4062, l_sp_name=DF UAT Security Profile, p_org_id_char=, is_view_all_org=
p_org_id=>221
p_id_char=>4062,p_appl_short_name=>M,l_view_all_orgs=>N,g_ou_count=>1
p_org_id=>221
_CONSUMER_GROUP New group: DEFAULT_CONSUMER_GROUP
y against FND_LOG_MESSAGES table:
WHERE ORG_ID=221
re process.20;SQLERRM = ORA-01403: no data found
cess.120;SQLERRM = ORA-01403: no data found
00:00.086403
00 [Link].011269
n=+00 [Link].003048
n=+00 [Link].035737
=+00 [Link].000877
0 [Link].014484
0 [Link].001963
n=+00 [Link].008980
ration=+00 [Link].001174
0 [Link].004856
on=+00 [Link].001292
s.20;SQLERRM = User-Defined Exception
d raise count:100Nested raise count: 0
CAL} Source Agt {}
from DB for Source Type {LOCAL} Source Agt {}
1419] [Time taken - .06 secs]
Time taken - 0 secs]
n - .14 secs]
d raise count:100Nested raise count: 0
CAL} Source Agt {}
1421] [Time taken - 0 secs]
Time taken - 0 secs]
n - .01 secs]