· 5 years ago · Feb 20, 2020, 09:36 AM
1+---------------------------------------------------------------------------+
2Payables: Version : 12.2
3
4Copyright (c) 1998, 2013, Oracle and/or its affiliates. All rights reserved.
5
6APXIIMPT: Payables Open Interface Import
7+---------------------------------------------------------------------------+
8
9Current system time is 20-FEB-2020 16:04:05
10
11+---------------------------------------------------------------------------+
12
13
14+-----------------------------
15| Starting concurrent program execution...
16+-----------------------------
17
18Arguments
19------------
20p_org_id='81'
21p_source='RETUR'
22p_group_id='RETUR-125179'
23p_batch_name='RT/T/JBS/2018/01/CPS-TEA'
24p_purge_flag='N'
25p_trace_switch='Y'
26p_debug_switch='Y'
27p_summary_flag='N'
28p_commit_batch_size='1000'
29p_user_id='1111'
30p_login_id='145237'
31------------
32
33 Current NLS_LANG, NLS_NUMERIC_CHARACTERS and NLS_SORT Environment Variables are :
34American_America.US7ASCII
35
36'.,'
37
38BINARY
39
40Enter Password:
41MSG-00001: (Before Report) After SRWINIT
42MSG-00002: (Before Report) After Get_Company_Name
43MSG-00003: (Before Report) After Get_NLS_Strings
44MSG-00001: (Get Base Curr data 1) Get the Base Currency Information
45MSG-00004: (Before Report) After Get_Base_Curr_Data
46MSG-00005: After Get Operating Unit
47MSG-00006: After Get Purge Flag
48MSG-00002: (Before Report Trigger 1) Import Invoices.
49MSG-00000: ------------------> l_batch_error_flag = N
50MSG-00013: (Before Report Trigger 4) Commit.
51MSG-00000: 1 invoice(s) were created during the process run
52MSG-00000: 1 invoice(s) were fetched during the process run
53MSG-00000: summarize flagN
54REP-1401: 'cf_source_nameformula': Fatal PL/SQL error occurred.
55ORA-01403: no data found
56
57REP-0069: Internal error
58REP-57054: In-process job terminated:Terminated with error:
59REP-1401: MSG-00001: (Before Report) After SRWINIT
60MSG-00002: (Before Report) After Get_Company_Name
61MSG-00003: (Before Report) After Get_NLS_Strings
62MSG-00001: (Get Base Curr data 1) Get the Base Currency Information
63MSG-00004: (Before Report) After Get_Base_Curr_Data
64MSG-00005: After Get Operating Unit
65MSG-00006: After Get Purge Flag
66MSG-00002: (Before Report Trigger 1) Import Invoices.
67MSG-00000: ------------------> l_
68
69Report Builder: Release 10.1.2.3.0 - Production on Thu Feb 20 16:04:06 2020
70
71Copyright (c) 1982, 2005, Oracle. All rights reserved.
72
73
74+---------------------------------------------------------------------------+
75Start of log messages from FND_FILE
76+---------------------------------------------------------------------------+
77Request_id555919
78(Import_invoice 0.1) Calling Caching Function for Org Id/Name
79Cache_Org_Id_Name <- Import_invoices<- Before Report Trigger
80Caching Org_id , Name from MO: Security Profile
81Caching Org_id from Financials Systems
82(Import_Invoices 0.2) Calling Caching Function for Currency
83Cache_Fnd_Currency <- Import_invoices<- Before Report Trigger
84Caching Currency from Fnd Currency
85(Import_Invoices 0.3) Calling Caching Function for Payment Method
86Cache_Payment_Method <- Import_invoices<- Before Report Trigger
87Caching Payment Method from IBY
88(Import_Invoices 0.4) Calling Caching Function for Payment Group
89Cache_Pay_group <- Import_invoices<- Before Report Trigger
90Caching Pay Group from PO Lookup Codes
91(Import_Invoices 0.5) Caching Structure Id
92(Import_invoice 1) Check control table for the import batch
93(Import_invoice 2) Print Source
94p_sourceRETUR
95(Import Invoice 3) Delete Rejections from previous failed imports
96(Check_lines 3a) Select all the Rejected Invoices
97(Check_lines 3b) Delete invoices from ap_interface_rejections
98(Check_lines 3c) Update requestid on the Selected Invoices
99(Import Invoice 4) Update the org_id
100(Import_Invoices 4a) Updating Interface WHERE org_id is null but operating unit
101is not null
102(Import_Invoices 4b) Getting Deafult Operating Unit Information
103(Import Invoices 5) Get The Total Number of Invoices In Interface
104(Import_Invoices 5a) Total Invoices l_stmt:SELECT count(*) FROM ap_invoices_inte
105rface WHERE source = 'RETUR' AND ((status is NULL) or (status = 'REJECTED'))
106 AND group_id = 'RETUR-125179' AND NVL(invoice_type_lookup_code, 'STANDARD') <
107> 'PAYMENT REQUEST' AND ( (org_id IS NULL) OR (org_id IS NOT NULL AND org_id =
108 81) ) AND nvl(workflow_flag,'D') = 'D'
109(Import_Invoices 4c) Total Invoices: l_total_count:1
110(Import_Invoices 4d) l_continue_flag:Y
111(Import_invoice 5.5) Unwinding Caching Org Id/Name
112Index Value: 81, MOAC Cached Org_Id: 81, MOAC Cached Operating Unit: OU ARTA JAB
113AR SELATAN
114Index Value: 81, FSP Cached Org_Id: 81
115(Import_invoice 6) Open import_invoices cursor
116(Import_invoice -->Execution started for first loop:20-FEB-20 16:04:23
117(Import_invoice 7) FETCH import_invoices
118------------------> invoice_id = 17010 invoice_num = RT/JBS/2018/01/01/001/CPS-
119TEA invoice_type_lookup_code = DEBIT invoice_date = 01-JAN-18 po_number = ve
120ndor_id = 6002 vendor_num = vendor_name = vendor_site_id = 6011 vendor_sit
121e_code = party_id = party_site_id = pay_proc_trxn_type_code = payment_fu
122nction = invoice_amount = -1304350 base_currency_code = invoice_currency_code
123 = payment_currency_code = exchange_rate = exchange_rate_type = exchange_d
124ate = terms_id = 10001 terms_name = description = JBS/2018/01/001 RETUR JB
125S awt_group_id = awt_group_name = pay_awt_group_id = pay_awt_group_name =
126 last_update_date = 20-FEB-20 last_updated_by = last_update_login = creati
127on_date = 20-FEB-20 attribute_category = attribute1 = attribute2 = 2018/01/01
128 00:00:00 attribute3 = attribute4 = 130435 attribute5 = attribute6 = JBS/2018/
12901/001 attribute7 = attribute8 = attribute9 = 1304350 attribute10 = attribute
13011 = 85 attribute12 = 111.111-11.11111111 attribute13 = attribute14 = attribut
131e15 = global_attribute_category = global_attribute1 = global_attribute2 = gl
132obal_attribute3 = global_attribute4 = global_attribute5 = global_attribute6 =
133 global_attribute7 = global_attribute8 = global_attribute9 = global_attribut
134e10 = global_attribute11 = global_attribute12 = global_attribute13 = global_
135attribute14 = global_attribute15 = global_attribute16 = global_attribute17 =
136 global_attribute18 = global_attribute19 = global_attribute20 = doc_category_
137code = voucher_num = payment_method_code = pay_group_lookup_code = goods_r
138eceived_date = invoice_received_date = exclusive_payment_flag = prepay_num =
139 prepay_line_num = prepay_apply_amount = prepay_gl_date = set_of_books_id =
140legal_entity_id = tax_only_flag = N tax_only_rcv_matched_flag = N remit_to_supp
141lier_name = remit_to_supplier_id = remit_to_supplier_site = remit_to_supplier
142_site_id = relationship_id = remit_to_supplier_num =
143(Import Invoices 8) Checking for Inconsistent OU
144(Import Invoice 9a) Setting the org Context
145(Import_invoice 9b) Call get_info to get required info
146(Get_info 1) Read from ap_system_parameters
147(Get_info 2) Get Batch Control Profile Option
148(Get_info 3) Get encumbrance option
149(Get_info 4) Get minimum_accountable_unit
150(Get_info 5) Get p_sequence_numbering
151(Get_info 6) Get gl_date based on report parameters
152(Get_info 7) Check if PA is installed
153------------------> l_status = S l_industry = C p_pa_installed = N
154(Get_info 8) Get chart_of_accounts_id from p_set_of_books_id
155(Get_info 9) Get system tolerances
156------------------> p_org_id = 81 p_set_of_books_id = 2021 l_multi_currency_fla
157g = Y l_make_rate_mANDatory_flag = l_default_exchange_rate_type = l_base_cu
158rrency_code = IDR l_batch_control_flag = Y l_payment_cross_rate = l_base_min
159_acct_unit = l_base_precision = 0 l_sequence_numbering = N l_awt_include_tax
160_amt = N l_gl_date_from_get_info = l_gl_date_from_receipt_flag = I l_purch_enc
161umbrance_flag = Y l_chart_of_accounts_id = 50388 l_pa_installed = N l_positive
162_price_tolerance = l_negative_price_tolerance = l_qty_tolerance = l_max_qty
163_ord_tolerance = l_inv_doc_cat_override = N l_allow_interest_invoices = N
164------------------> l_transfer_desc_flex_flag = N l_retainage_ccid = l_calc_
165user_xrate = N l_approval_workflow_flag = N l_freight_code_combination_id =
166l_add_days_settlement_date = l_disc_is_inv_less_tax_flag = N l_asset_book_typ
167e =
168(Import_invoice 9c) Get batch_id IF batch_control is on
169(Get_batch_id 1) Get old batch id
170------------------> l_batch_id = 27001 l_batch_type = OLD BATCH
171(Import Invoice 10b) Default GL Date Based on Calculation
172(Import_invoice 11) Validate invoice
173SOBID is :
174(Check Invoice Validation 0) Initialize invoice_date if null
175(Check Invoice Validation 1) Check for Invalid and Inactive PO
176(Check Invoice Validation 2) Check for Invalid Legal Entity
177(Check Invoice Validation 2) Check for Invalid Supplier
178(Check Invalid Supplier 2) Validate vendor id.
179(Check Invalid Supplier 7) Save Supplier id for further processing.
180(Check Invoice Validation 2) Validated Supplier
181------------------>
182 l_temp_invoice_status = Y l_vendor_id
183 = 6002
184(Check Invoice Validation 3) Check for Invalid Supplier Site, if Supplier is val
185id
186(Check Invoice Validation 3.2) Supplier Site is per EDI
187(Check Invalid Site 1) Check Supplier Site
188(Check Invalid Site 3) Get Supplier Site details from p_invoice_rec.vendor_site_
189id
190(Check Invalid Site 6) Check Supplier Site for given vendor
191------------------> l_valid_vendor = X
192(Check Invoice Validation 3) Validated Supplier Site
193------------------>
194 l_temp_invoice_status = Y l_vendor_site_i
195d = 6011 l_party_site_id =
196(Check Invoice Validation 3.5) Validated party and vendor info l_temp_invoice_st
197atus = Y
198(Get_tolerance_info 1) Get tolerance info...
199(get_tolerance_info 2) NO_DATA_FOUND exception
200------------------> p_vendor_site_id = 6011 l_price_tolerance = 0 l_positive_pr
201ice_tolerance = 1 l_negative_price_tolerance = 1 l_qty_tolerance = 1 l_qty_re
202ceived_tolerance = 1.0000001 l_max_qty_ord_tolerance = l_max_qty_rec_toleranc
203e = l_amt_tolerance = l_amt_received_tolerance = l_max_amt_ord_tolerance
204= l_max_amt_rec_tolerance = l_goods_ship_amt_tolerance = l_goods_rate_amtto
205lerance = l_goods_total_amt_tolerance = l_services_ship_amt_tolerance = l_
206services_rate_amttolerance = l_services_total_amt_tolerance =
207(Check Invoice Validation 4) Check for Invalid Invoice Number ,if Supplier Site
208is valid
209------------------> l_invoice_num =
210 RT/JBS/2018/01/01/0
21101/CPS-TEA
212(Check Invoice Number 2) Check for Invalid Invoice Number.
213(Check Invoice Number 3) Check for Duplicate Invoice Number.
214------------------> l_temp_invoice_status = Y
215(Check Invoice Validation 5) Check for Currency Code ,if Invoice No. is valid
216(Check Invoice Currency Code 1) Invoice Currency Code is null ,default from PO V
217endor Sites.
218(Check Invoice Currency Code 2) Get precision, mau for Invoice Currency Code.
219l_valid_inv_currency: IDR
220--------------> l_temp_invoice_status = Y l_inv_currency_code = IDR
221(Check Invoice Validation 6) Check for Invoice Lookup Code and Amount ,if Invoic
222e No. is valid
223(Check Invoice Type and Amount 1) Check for Invalid Invoice type lookup code.
224(Check Invoice Type and Amount 2) Check for Null Invoice amount.
225(Check Invoice Type and Amount 3) Check for Invalid Invoice amount.
226(Check Invoice Type and Amount 4) Check for Invoice amount to match sum of invoi
227ce line amounts.
228(Check Invoice Type and Amount 6) Determine Match Mode.
229------------------>
230 l_temp_invoice_status = Y p_match_mode =
231(Check Invoice Validation 7) Check for AWT Group ,if Invoice No. is valid
232(Check AWT Group 2) Check for Inactive AWT Group
233------------------>
234 l_temp_invoice_status = Y
235(Check Invoice Validation 7) Check for pay AWT Group ,if Invoice No. is valid
236(Check AWT Group 2) Check for Inactive pay AWT Group
237------------------>
238 l_temp_invoice_status = Y
239(Check Invoice Validation 8) Check for Exchange Rate Type ,if Invoice No. is val
240id
241------------------>
242 l_temp_invoice_status = Y
243(Check Invoice Validation 9) Check for Terms Info ,if Invoice No. is valid
244(Check Invalid Terms 6a) Check for Terms Date provided as input :
245(Check Invalid Terms 6b) Check for Invoice and Goods Received Date
246(Check Invalid Terms 8) Check calendar based payment terms
247AP_IMPORT_UTILITIES_PKG.Check_For_Calendar_Term<-v_check_invalidate_terms
248OPEN cursor c
249Fetch cursor C
250CLOSE cursor c
251------------------>
252 l_temp_invoice_status = Yterms_id = 10001
253(Check Invoice Validation 10) Check for Misc Info
254(step 10.1 default the liability account
255(Check Misc Invoice Info 1) Check for valid accts_pay_ccid.
256(Check Misc Invoice Info 5) Check for valid employee
257------------------>
258 l_temp_invoice_status = Y
259(Check Invoice Validation 11a) Check for LE Info
260(Check Legal Entity Info 2) Check for reg code/number and Get LE.
261(Check Legal Entity Info 2.1) Get Bill TO Location ID
262(Check Legal Entity Info 2.2) Call LE API
263(Check Legal Entity Info 2.3) Valid LE Flow
264(Check Legal Entity Info 2.4a) Legal Entity ID: 23281
265------------------>
266 l_temp_invoice_status = Y
267(Check Invoice Validation 11) Check for Payment Currency Info ,if Invoice No. is
268 valid
269(Check Invalid Pay Currency 0) Calling Caching Function for Currency
270Cache_Fnd_Currency <- AP_IMPORT_VALIDATION_PKG.v_check_invalid_pay_curr<-AP_IMPO
271RT_VALIDATION_PKG.v_check_invoice_validation<-Import_invoices<- Before Report Tr
272igger
273Caching Currency from Fnd Currency
274------------------>
275 l_temp_invoice_status = Y
276(Check Invoice Validation 15) Check for tax drivers or invoice level tax validat
277ions.
278(Check tax info 1) Check for control_amount
279(Check tax info 2) Check for tax_related_invoice_id
280(Check tax info 3) Check for calc_tax_during_import_flag
281(Check tax info 4) Validate if allocation structure is provided for inclusive li
282nes when the invoice has more than one item line.
283(Check tax info 5) Check if any non-tax line has tax information
284(Check tax info 6) Check if an invoice has a tax line matched to receipt and ano
285ther allocated to item lines
286------------------> l_temp_invoice_status = Y
287Check for Invalid Remit to Supplier
288Check valid remit to supplier details
289Remit to supplier Name
290Remit to supplier Id
291Remit to supplier Site Id
292Remit to supplier Site Name
293If Remit to supplier Name
294If Remit to supplier Id
295Remit to supplier Num
296Remit to supplier Site Id
297Remit to supplier Site
298Data To IBY
299Party Id 14052
300Vendor Site id 6011
301Invoice Date 01-JAN-18
302Remit Party Id
303Remit Supplier Site Id
304Data From IBY
305x_result : T
306------------------> l_temp_invoice_status = Y
307(Check Invoice Validation 16) Check for Exchange Rate Info.
308(Check No Xrate Base Amount 1) Is Xrate_Base_Amount invalid?
309(Check Invoice Validation 17) Check Payment Info
310------------------>
311 l_temp_invoice_status = Y
312------------------> vendor_id = 6002 vendor_site_id = 6011 invoice_status = Y te
313rms_id = 10001 fatal_error_flag = invoice_type_lookup_code = DEBIT match_mode
314=
315(Import_invoice 12) Validate line
316SOBID is :
317(Check_lines 1) Call Get_employee_id
318(Get_employee_id 1) Get employee id from po_vendors
319(Get_employee_id 3) Employee_id id Null
320------------------> l_temp_line_status = Y l_employee_id =
321(Check Lines 2) Get Max Line Number
322(Check Lines 3) Open Cursor: invoice_lines
323(Check Lines 4) Looping through fetched invoice lines
324------------------> invoice_line_id = 6008 line_type_lookup_code = ITEMline_num
325ber = 1line_group_number = amount = -1304350base amount accounting_date = defer
326red_acctg_flag = def_acctg_start_date = def_acctg_end_date = def_acctg_number_of
327_period = def_acctg_period_type = description = Teh Gelas Rasa Originalprorate_a
328cross_flag = po_header_id = po_number = po_line_id = po_line_number = po_release
329_id = release_num = po_line_location_id = po_shipment_num = po_distribution_id =
330 po_distribution_num = unit_of_meas_lookup_code = inventory_item_id = item_descr
331iption = purchasing_category_id = purchasing_category = quantity_invoiced = ship
332_to_location_code = unit_price = final_match_flag = distribution_set_id = distri
333bution_set_name = dist_code_concatenated = 50-111-242201-00-0000-00-000000-00000
3340dist_code_combination_id = awt_group_id = awt_group_name = balancing_segment =
335cost_center_segment = account_segment = attribute_category = attribute1 = attrib
336ute2 = attribute3 = attribute4 = attribute5 = attribute6 = attribute7 = attribut
337e8 = attribute9 = attribute10 = 1attribute11 = attribute12 = attribute13 = attri
338bute14 = attribute15 = global_attribute_category = global_attribute1 = global_at
339tribute2 = global_attribute3 = global_attribute4 = global_attribute5 = global_at
340tribute6 = global_attribute7 = global_attribute8 = global_attribute9 = global_at
341tribute10 = global_attribute11 = global_attribute12 = global_attribute13 = globa
342l_attribute14 = global_attribute15 = global_attribute16 = global_attribute17 = g
343lobal_attribute18 = global_attribute19 = global_attribute20 = project_id = task_
344id = award_id = expenditure_type = expenditure_item_date = expenditure_organizat
345ion_id = pa_addition_flag = pa_quantity = stat_amount = type_1099 = income_tax_r
346egion = asset_tracking_flag = asset_book_type_code = asset_category_id = serial_
347number = manufacturer = model_number = warranty_number = price_correction_flag =
348 price_correct_inv_num = price_correct_inv_id = price_correct_inv_line_num = rec
349eipt_number = receipt_line_number = rcv_transaction_id = match_option = packing_
350slip = vendor_item_num = pa_cc_ar_invoice_id = pa_cc_ar_invoice_line_num = pa_cc
351_processed_code = reference_1 = reference_2 = credit_card_trx_id = requester_id
352= org_id = 81expense_start_date = expense_end_date =
353(Check Lines 5) Validate org id for line
354(Check_lines 5.0) Org Id Is Not Null
355(v_check_lines 7.0) Check for partial Segments
356------------------> partial_segments = Nl_error_message = dist_code_concatenated
357 = 50-111-242201-00-0000-00-000000-000000
358(Check Invoice Line amount 8) Check for invoice line amount if it is not exceedi
359ng precision
360------------------>
361 l_temp_invoice_status = Y
362(Check_lines 9) Call v_check_po_info only for ITEM Lines
363(Check_lines 9.1) This is an ITEM Line
364(v_check_line_po_info 35) Call v_check_line_po_info2
365------------------> l_current_invoice_status = Y
366(v_check_line_po_info 36) Call v_check_po_overlay
367------------------> l_current_invoice_status = Y
368------------------> l_temp_line_status = Y
369(Check_lines 10) Call v_check_receipt_info
370------------------> l_temp_line_status = Y
371(Check_lines 13) Call v_check_line_accounting_date
372(Check_line_accounting_date 1) Default line_accounting_date from Invoice gl_date
373(v_check_line_accounting_date 3) Check IF gl date is not in open period
374------------------> l_period_name = JAN-18l_accounting_date = 01-JAN-18
375(v_check_line_accounting_date 4) Reject IF the year of gl date is beyond encumbr
376ance year
377------------------> l_temp_line_status = Y
378(Check_lines 14) Call v_check_line_project_info
379(Check_lines 15.0) Call Is_Product_Registered
380(Check_lines 15.1) l_product_registered: N
381(Check_lines 15) Call v_check_line_account_info
382Before deriving l_dist_code_combination_id is :
383(v_check_line_account_info 1) Check IF item line doesnt have account info
384l_dist_code_combination_id: 2003, l_validate_res: TRUE
385------------------> l_temp_line_status = Ydist_code_combination_id = 2003
386(Check_lines 16) Call v_check_deferred_accounting
387------------------> l_temp_line_status = Y
388(Check_lines 17) Call v_check_line_dist_set
389(Check Line Dist Set 1) Validate Distribution Set Id
390(Check Line Dist Set 3.1) Check for inactive DIST SET
391------------------> l_temp_line_status = Y
392(Check_lines 18) Call v_check_qty_uom_info
393(Check Qty UOM non PO 2) Check Qty related information vs line type.
394(Check Qty UOM non PO 4) Check Qty information when UOM populated
395------------------> l_temp_line_status = Y
396(Check_lines 19) Call v_check_invalid_awt_group
397(Check AWT Group 2) Check for Inactive AWT Group
398------------------> l_temp_line_status = Y
399(Check_lines 19) Call v_check_invalid_line_pay_awt_g
400(Check Pay AWT Group 2) Check for Inactive Pay AWT Group
401------------------> l_temp_line_status = Y
402(Check_lines 20) Call v_check_duplicate_line_num
403(Check Duplicate Line Number 1) Check for Duplicate Line Number.
404------------------> l_temp_line_status = Y
405(Check_lines 21) Call v_check_asset_info
406(Check Asset Book 1) Verify asset info not on non-item line
407(Check Asset Book 2) Verify asset book if not null
408(Check Asset Book 3) Verify asset category if not null
409------------------> l_temp_line_status = Y
410(Check_lines 22) Call v_check_misc_line_info
411(Check Misc Line Info 3) Defaulting type 1099 from
412 supplier
413------------------> l_temp_line_status = Y
414------------------> p_invoice_lines_tab(i).ship_to_location_id = 142
415(Check_lines 23) Call v_check_tax_line_info
416(Check Tax Line Info 2) Check for control_amount greater than line amount
417(Check Tax Line Info 3) Tax should not be inclusive if tax line is PO matched
418(Check Tax Line Info 4.8) Tax_regime_code and tax are required in tax lines to b
419e imported
420------------------> l_temp_line_status = Y
421(Check Lines 25) Checking the total dist amount to be prorated
422(Check Lines 28) Update global context code
423(Check_lines 28) Call V_CHECK_GDF_VALIDATION
424CCID passing to FV API ----->
425(Check GDF VALIDATION) Call CHECK_GDF_VALID
426(Check GDF VALIDATION) GDF is valid
427------------------> l_temp_line_status = Y
428invoice_status is:Y
429(Import_invoice 17.2) Change the invoice status to PROCESSING
430(Change_invoice_status 1) Change invoice status to PROCESSING
431(Import_invoice 7) FETCH import_invoices
432(Import_invoice) CLOSE import_invoices
433(Import_invoice -->Execution completed for first loop:20-FEB-20 16:04:23
434(Import_invoice 13) Validate tax info for tax and taxable lines
435SOBID is :2021
436(Import_invoice 13.1) Header table count 1
437Call validate_and_default_tax_attr service start 20-FEB-20 16:04:23
438Call validate_and_default_tax_attr service ends 20-FEB-20 16:04:23
439Return_Default_Import was fine
440(Import_invoice 13) Validate tax info for tax and taxable lines completed: 20-FE
441B-20 16:04:23
442(Import_invoice -->Execution started for second loop:20-FEB-20 16:04:23
443(Import_invoice 13.3) check Invoice Status Loop 1 17010
444(Import_invoice 13.3.1) Deleting the LINES_TAB collection
445(Import_invoice 13.4) Before loop 2
446(Import_invoice 13.4) Before loop 2 1
447(Get_tolerance_info 1) Get tolerance info...
448(get_tolerance_info 2) NO_DATA_FOUND exception
449------------------> p_vendor_site_id = 6011 l_price_tolerance = 0 l_positive_pr
450ice_tolerance = 1 l_negative_price_tolerance = 1 l_qty_tolerance = 1 l_qty_re
451ceived_tolerance = 1.0000001 l_max_qty_ord_tolerance = l_max_qty_rec_toleranc
452e = l_amt_tolerance = l_amt_received_tolerance = l_max_amt_ord_tolerance
453= l_max_amt_rec_tolerance = l_goods_ship_amt_tolerance = l_goods_rate_amtto
454lerance = l_goods_total_amt_tolerance = l_services_ship_amt_tolerance = l_
455services_rate_amttolerance = l_services_total_amt_tolerance =
456(Import_invoice 13.5) Lines Loop 2
457(Import_invoice 13.5.1) Assign Lines Collection,Lines Loop 2 1
458(Import_invoice 13.5.2) Assign Lines Collection,Lines Loop 2 1
459 Call v_check_po_info only for ITEM Lines
460(Check_lines in before insert) This is an ITEM Line
461Quantity Invoiced :
462Unit Price:
463Amount:-1304350
464(v_check_line_ext_po_info2 35) Call v_check_line_po_info2
465------------------> l_current_invoice_status = Y
466------------------> l_temp_line_status = Y
467(Check_lines 10) Call v_check_receipt_info
468------------------> l_temp_line_status = Y
469(Import_invoice 13.5) Assign Lines Collection,Lines Loop 2 end
470Before Call to sequential numbering------------------> l_current_invoice_status
471= Y
472Check Prepayment Info at invoice importImport_invoices<- Before Report Trigger
473(Import_invoice 14) Get Doc Sequence
474SOBID is :2021
475------------------> l_invoice_status = Y l_seqval = l_dbseqnm = l_dbseqid =
476(Import_invoice 15.1a) Call get_invoice_info
477(Get Invoice Info step 1) Calculate invoice amount in payment currency
478(Get Invoice Info step 2) Get amt_applicable_to_discount value if not given
479(Get Invoice Info step 3) Get supplier site default info
480(Get Invoice Info step 4) Get WHO columns
481------------------> l_pay_curr_invoice_amount = -1304350 l_payment_priority =
48299 l_invoice_amount_limit = l_hold_future_payments_flag = N l_supplier_hold_r
483eason =
484(Import_invoice 15.1b) Update global context code
485(Import_invoice 15.2) Insert record INTO ap_invoices
486(Insert ap invoices step 1) Get duplicate invoice number check status for invoic
487e: RT/JBS/2018/01/01/001/CPS-TEA
488(Insert ap invoices step 1) Get new invoice_id for base table ap_invoices
489(Insert ap invoices step 2)-Get wfapproval_status depends on profile value
490(Insert ap invoices step 3) Calculate earliest settlement date for Prepayment ty
491pe invoices
492(Insert ap invoices step 4) - Insert into ap_invoices
493(Insert ap invoices step 5) before copy attachments: source = RETUR, from_invoic
494e_id = 17010, to_invoice_id = 28007
495(Insert ap invoices step 5) copy attachments done: 0
496(Insert ap invoices step 6) - Return the new invoice_id-> 28007
497------------------> l_base_invoice_id = 28007 l_valid_invoices_count = 1
498(Import_invoice 15.4) Insert holds for this invoice
499(Insert Holds 1) Insert invoice holds FROM the import batch
500(Insert Holds 2) Insert Suppler holds
501(Import_invoice 15.5) Create invoice lines
502SOBID is :2021
503(Import_invoice 15.5) Create invoice lines 1
504(Create lines 1) Call API to Insert all the lines
505(Insert ap invoice lines step 2) - Loop the Pl/sql table
506(Create lines 2) Call Utility function to round the line before create distribu
507tions
508(Create lines 3) Call Matching or Allocations
509(Import_invoice 15.6) Execute the Argentine/Colombian defaulting procedure
510(Import_invoice 15.7) Call import before any prepayment application if the user
511intention is to import TAX
512(Import_invoice 15.8) Call calculate or the prepayment application
513(Import_invoice 15.8a) calc_tax_during_import_flag = Y, Call calculate tax
514(Import_invoice 15.9) Update the invoice amount if flag add_tax_to_inv_amt_flag
515is set with the total of the exclusive tax lines created for the invoice
516(Import_invoice 15.9a) Insert payment schedules from terms after invoice amount
517has been updated
518(Import_invoice 15.10) Delete the contents of the l_invoice_lines_tab Lines Tabl
519e
520(Import_invoice 15.11) Delete the contents of the eTax global temp tables
521(Import_invoice 17.2) Change the invoice status to PROCESSING
522(Change_invoice_status 1) Change invoice status to PROCESSING
523(Import_invoice -->Execution completed for second loop:20-FEB-20 16:04:23
524(Import_invoice) CLOSE import_invoices
525(Import_invoice 18a) Get/Initialize batch name
526(Import_invoice 18d) Create ap_batches
527(Import_invoice 18e) Set batch exists flag to Y
528(Import_invoice 19) COMMIT to the database
529(Import_purge 20) Check IF there is still any record left
530(Import_invoice 20a) l_invoices_fetched:1
531(Import_Invoices 20b) l_total_count:1
532------------------> l_continue_flag = N
533(Import_invoice -->Execute outer while loop end:20-FEB-20 16:04:23
534(Import_invoice 21) Update temporary status
535(Update_temp_invoice_status 1) Change PROCESSING to PROCESSED
536(Update_temp_invoice_status 2) Change REJECTING to REJECTED
537(Import_invoice 22) Return No of invoices fetched during process ,p_invoices_fet
538ched1
539Now Block to Raise the Business event to pass the Concurrent request_id555919
540After raising workflow event : event_name = oracle.apps.ap.invoice.import event_
541key = 10146
542Returned True
543+---------------------------------------------------------------------------+
544End of log messages from FND_FILE
545+---------------------------------------------------------------------------+
546Program exited with status 1
547Concurrent Manager encountered an error while running Oracle*Report for your concurrent request 555919.
548
549Review your concurrent request log and/or report output file for more detailed information.
550
551
552+---------------------------------------------------------------------------+
553No completion options were requested.
554
555Output file size:
556
557
558+---------------------------------------------------------------------------+
559Concurrent request completed
560Current system time is 20-FEB-2020 16:04:23
561
562+---------------------------------------------------------------------------+