{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Instructions and CSV Generation","AP_INVOICES_INTERFACE","AP_INVOICE_LINES_INTERFACE"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":2,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions and CSV Generation","index":0,"n_rows":30,"n_cols":3,"rows_kept":30,"cut":false,"hidden":false,"merged":[[15,1,15,2],[29,1,29,2],[11,1,11,2],[13,1,13,2],[10,1,10,2],[12,1,12,2],[14,1,14,2],[9,1,9,2],[4,1,4,2],[8,1,8,2],[3,1,3,2],[5,1,5,2],[6,1,6,2],[7,1,7,2]]}
[]
[null,null,"Fusion Applications"]
[null,null,"Payables Invoice Import Interface"]
[null,"Overview"]
[null,"You can import invoices from legacy systems using the Payables Invoice Import Interface. The Payables Invoices Import Interface uses a parent table and a child table to represent an invoice and its lines.\n 1. The parent table AP_INVOICES_INTERFACE contains invoice header level information and the child table AP_INVOICE_LINES_INTERFACE contains invoice line level information.\n 2. Use this Excel template to upload data to the invoice interface tables. \n 3. Use the Import Payables Invoices process to create invoices from the data in the invoice interface tables.\n"]
[null,"Preparing the Table Data"]
[null,"1. Prepare the data for each interface table using the corresponding worksheet in this template. See the section Excel Template Format for details about this template.\n2. Refer to the bubble text on each column header either for detailed instructions on preparing the data in that column, or for a description of the data and data type that the column requires.\n3. Common tasks for preparing table data include setting up for data merge, and searching for internal identifiers.\n"]
[null,"Loading the Data"]
[null,"After you finish preparing the data in the parent and child sheets, click the Generate CSV File button to generate a ZIP file containing one or more CSV files. \nFor information on loading the CSV files into the interface tables, see Using External Data Integration Services for Oracle ERP Cloud (2102800.1) on My Oracle Support at https://support.oracle.com.\n"]
[]
[null,"Excel Template Format"]
[null," • Each interface table is represented as a separate Excel sheet.\n • The first row in each sheet contains column headers that represent the interface table columns. The columns are in the order that the control file expects them to be in the data file. \n    Do not change the order of the columns in the Excel sheets. Changing the order of the columns will cause the load process to fail.\n    You can hide columns that you do not intend to use, but you cannot delete columns. Deleting columns will cause the load process to fail.\n • Each column header contains bubble text about the expected data type and, in some cases, instruction text.\n • You must enter data that conforms to what the control file can accept and process for the associated database column.\n   - Date fields must be entered in YYYY/MM/DD format.\n   - Amount columns must not contain a thousands separator and must use a period (.) as the decimal separator.\n   - Columns that must be whole numbers have data validation to allow only whole numbers\n • Columns have been formatted, where applicable, to match the expected data type to eliminate data entry errors.\n • For columns that require internal ID values, refer to the bubble text for additional guidance about finding these values."]
[null,"Recommendations for Loading Invoice Data"]
[null,"Because the details of any data conversion will vary, the scope of this document is limited to a best practices approach. If you are new to data conversion, we recommend consulting Oracle resources on open interfaces and the strategies for populating them.\n\nIn general, we recommend the following:\n1. Build an export file in the same format as the Payables invoices interface described in this template. You can build an export file in one of two ways: \n    • Extract data into a spreadsheet that contains the same structure as this template.\n    • Use SQL, ODI, or a similar tool to extract data into a CSV file with the same structure as the CSV  file generated by this template (as described in the section Loading the Data). \n2. Your spreadsheet must have the same columns, and the columns must be in the same order, as in this template. \n3. Once you have extracted the data into your temporary spreadsheet, cut and paste the data into the relevant sheets provided in this template. \n4. Should the load of your consolidated .CSV fail on any row, all rows in the interface will be deleted and rolled back (even those that were successful).  This allows you to edit the problematic data in the spreadsheet (using the information contained in the log and output files) and then resubmit without having to separate the successful rows from those needing modification.  \n\n"]
[null,"Importing the Loaded Data"]
[null,"After you successfully load your data, you must submit the Import Payables Invoice process to import the data into the application tables and create the invoices. \n\nTo submit the Import Payables Invoices process:\n1. Navigate to the Invoices work area under Payables.\n2. Click on the Import Invoices link in the Tasks region.\n3. Enter values for the parameters as follows:\n\n\n"]
[null,"Parameter","Description"]
[null,"*Report Ledger","Specify the name of a ledger."]
[null,"Business Unit","Specify the name of the business unit for which the invoices are to be imported."]
[null,"*Source","Select the source of invoices to import."]
[null,"Import Set","Specify an import set to limit the import to invoices with a particular import set in the Payables Open Interface tables. You can import data for the same source by specifying a unique import set for each request. This reduces the processing time of your import. The Import Payables Invoices process imports data with the source and group combination that you specify."]
[null,"Invoice Group","Specify the name of an invoice group. "]
[null,"Hold","If you want to apply a hold to all imported invoices, enter the name of an invoice hold."]
[null,"Hold Reason","Edit or accept the defaulted invoice hold reason description."]
[null,"Accounting Date","Specify an accounting date. Payables assigns the entered Accounting Date to any invoice in the batch that does not already have an accounting date at the line or header level. If you do not enter a value here, or at the line or header level, then during import the Accounting Date is assigned based on the Accounting Date Basis option."]
[null,"Purge","Select whether to delete from the Payables Open Interface tables all successfully imported invoice records that match the business unit, source, and import set. The purge process always purges successful records based on business unit, source, and import set. So records which were processed in any earlier run are also purged in the current run if the three parameters match. Payables does not delete any invoice data for which it has not yet created invoices. The best practice is to set this parameter to Yes to purge successful records."]
[null,"Summarize Report","Select whether to summarize the audit portion of the Payables Open Invoices Interface Import Report. If you do not summarize, and you are importing a large number of invoice records, the report could be very long."]
[null,"Report Ledger and Source are mandatory parameters. All others are optional."]
[]
[null,"4. Monitor the process in the Scheduled Processes page.\n5. If the Import Payables Invoices process ends in error or warning,  review the log file for details about the rows that caused the failure.\n \nTo correct import errors:\n1. Navigate to the Invoices work area under Payables.\n2. Click on Correct Import Errors in the Tasks region. This will download a spreadsheet with the name CorrectImportErrors.xlsx.\n3. Open the spreadsheet CorrectImportErrors.xlsx. \n4. Enter the login details.\n5. Review and correct the import errors in the spreadsheet.\n6. Once all errored rows are corrected, resubmit the process by clicking on the Save and Submit Invoice Import button. \n7. Repeat the submit and error correction steps in this section until all rows are imported successfully and the invoices are created."]

{"sheet":"AP_INVOICES_INTERFACE","index":1,"n_rows":6,"n_cols":130,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
["Invoice Headers"]
["* Required","** At least one is required"]
["*Invoice ID","*Business Unit","*Source","*Invoice Number","*Invoice Amount","*Invoice Date","**Supplier Name","**Supplier Number","*Supplier Site","Invoice Currency ","Payment Currency","Description","Import Set","*Invoice Type","Legal Entity","Customer Tax Registration Number","Customer Registration Code","First-Party Tax Registration Number","Supplier Tax Registration Number","*Payment Terms","Terms Date","Goods Received Date","Invoice Received Date","Accounting Date","Payment Method","Pay Group","Pay Alone","Discountable Amount","Prepayment Number","Prepayment Line Number","Prepayment Application Amount","Prepayment Accounting Date","Invoice Includes Prepayment","Conversion Rate Type","Conversion Date","Conversion Rate","Liability Combination","Document Category Code","Voucher Number","Requester First Name","Requester Last Name","Requester Employee Number","Delivery Channel Code","Bank Charge Bearer","Remit-to Supplier","Remit-to Supplier Number","Remit-to Address Name","Payment Priority","Settlement Priority","Unique Remittance Identifier","Unique Remittance Identifier Check Digit","Payment Reason Code","Payment Reason Comments","Remittance Message 1","Remittance Message 2","Remittance Message 3","Withholding Tax Group","Ship-to Location","Taxation Country","Document Sub Type","Tax Invoice Internal Sequence Number","Supplier Tax Invoice Number","Tax Invoice Recording Date","Supplier Tax Invoice Date","Supplier Tax Invoice Conversion Rate","Port Of Entry Code","Correction Year","Correction Period","Import Document Number","Import Document Date","Tax Control Amount","Calculate Tax During Import","Add Tax To Invoice Amount","Attribute Category","Attribute 1","Attribute 2","Attribute 3","Attribute 4","Attribute 5","Attribute 6","Attribute 7","Attribute 8","Attribute 9","Attribute 10","Attribute 11","Attribute 12","Attribute 13","Attribute 14","Attribute 15","Attribute Number 1","Attribute Number 2","Attribute Number 3","Attribute Number 4","Attribute Number 5","Attribute Date 1","Attribute Date 2","Attribute Date 3","Attribute Date 4","Attribute Date 5","Global Attribute Category","Global Attribute 1","Global Attribute 2","Global Attribute 3","Global Attribute 4","Global Attribute 5","Global Attribute 6","Global Attribute 7","Global Attribute 8","Global Attribute 9","Global Attribute 10","Global Attribute 11","Global Attribute 12","Global Attribute 13","Global Attribute 14","Global Attribute 15","Global Attribute 16","Global Attribute 17","Global Attribute 18","Global Attribute 19","Global Attribute 20","Global Attribute Number 1","Global Attribute Number 2","Global Attribute Number 3","Global Attribute Number 4","Global Attribute Number 5","Global Attribute Date 1","Global Attribute Date 2","Global Attribute Date 3","Global Attribute Date 4","Global Attribute Date 5"]
[100003,"US1 Business Unit","External","100003",6200,"2020-06-01","Staffing Services",1253,"Staffing US1","USD","USD","FROM ICS","AP_Cloud_Demo","STANDARD",null,null,null,null,null,"Immediate","2020-06-01",null,null,"2020-06-01","CHECK","Standard","#NULL",null,null,null,null,null,null,null,null,null,null,"#NULL",null,null,null,null,"#NULL","#NULL",null,null,null,21,"#NULL",null,null,"#NULL","#NULL",null,null,null,"#NULL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N","N"]
[100004,"US1 Business Unit","External","100004",7200,"2020-06-01","Staffing Services",1253,"Staffing US1","USD","USD","FROM ICS","AP_Cloud_Demo","STANDARD",null,null,null,null,null,"Immediate","2020-06-01",null,null,"2020-06-01","CHECK","Standard","#NULL",null,null,null,null,null,null,null,null,null,null,"#NULL",null,null,null,null,"#NULL","#NULL",null,null,null,1,"#NULL",null,null,"#NULL","#NULL",null,null,null,"#NULL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N","N"]

{"sheet":"AP_INVOICE_LINES_INTERFACE","index":2,"n_rows":6,"n_cols":152,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
["Invoice Lines"]
["* Required"]
["*Invoice ID","Line Number","*Line Type","*Amount","Invoice Quantity","Unit Price","UOM","Description","PO Number","PO Line Number","PO Schedule Number","PO Distribution Number","Item Description","PO Release Number","Purchasing Category","Receipt Number","Receipt Line Number","Consumption Advice Number","Consumption Advice Line Number","Packing Slip","Final Match","Distribution Combination","Distribution Set","Accounting Date","Overlay Account Segment","Overlay Primary Balancing Segment","Overlay Cost Center Segment","Tax Classification Code","Ship-to Location","Ship-from Location","Location of Final Discharge","Transaction Business Category","Product Fiscal Classification","Intended Use","User-Defined Fiscal Classification","Product Type","Assessable Value","Product Category","Tax Control Amount","Tax Regime Code","Tax","Tax Status Code","Tax Jurisdiction Code","Tax Rate Code","Tax Rate","Withholding Tax Group","Income Tax Type","Income Tax Region","Prorate Across All Item Lines","Line Group Number","Cost Factor Name","Statistical Quantity","Track as Asset","Asset Book Type Code","Asset Category ID","Serial Number","Manufacturer","Model Number","Warranty Number","Price Correction Line","Price Correction Invoice Number","Price Correction Invoice Line Number","Requester First Name","Requester Last Name","Requester Employee Number","Attribute Category","Attribute 1","Attribute 2","Attribute 3","Attribute 4","Attribute 5","Attribute 6","Attribute 7","Attribute 8","Attribute 9","Attribute 10","Attribute 11","Attribute 12","Attribute 13","Attribute 14","Attribute 15","Attribute Number 1","Attribute Number 2","Attribute Number 3","Attribute Number 4","Attribute Number 5","Attribute Date 1","Attribute Date 2","Attribute Date 3","Attribute Date 4","Attribute Date 5","Global Attribute Category","Global Attribute 1","Global Attribute 2","Global Attribute 3","Global Attribute 4","Global Attribute 5","Global Attribute 6","Global Attribute 7","Global Attribute 8","Global Attribute 9","Global Attribute 10","Global Attribute 11","Global Attribute 12","Global Attribute 13","Global Attribute 14","Global Attribute 15","Global Attribute 16","Global Attribute 17","Global Attribute 18","Global Attribute 19","Global Attribute 20","Global Attribute Number 1","Global Attribute Number 2","Global Attribute Number 3","Global Attribute Number 4","Global Attribute Number 5","Global Attribute Date 1","Global Attribute Date 2","Global Attribute Date 3","Global Attribute Date 4","Global Attribute Date 5","Project ID","Task ID","Expenditure Type ID","Expenditure Item Date","Expenditure Organization ID","Project Number","Task Number","Expenditure Type","Expenditure Organization","Funding Source Id","PJC Reserved Attribute 2","PJC Reserved Attribute 3","PJC Reserved Attribute 4","PJC Reserved Attribute 5","PJC Reserved Attribute 6","PJC Reserved Attribute 7","PJC Reserved Attribute 8","PJC Reserved Attribute 9","PJC Reserved Attribute 10","PJC User Defined Attribute 1","PJC User Defined Attribute 2","PJC User Defined Attribute 3","PJC User Defined Attribute 4","PJC User Defined Attribute 5","PJC User Defined Attribute 6","PJC User Defined Attribute 7","PJC User Defined Attribute 8","PJC User Defined Attribute 9","PJC User Defined Attribute 10","Fiscal Charge Type"]
[100003,1,"ITEM",200,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N",null,"#NULL","2020-06-01",null,null,null,null,"#NULL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"#NULL",null,null,"N",1,null,null,"N",null,null,null,null,null,null,"N"]
[100004,1,"ITEM",300,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N",null,"#NULL","2020-06-01",null,null,null,null,"#NULL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"#NULL",null,null,"N",1,null,null,"N",null,null,null,null,null,null,"N"]