How You Import Large Negotiation Lines

As a Category Manager, you can import negotiation lines from external systems into a negotiation created in Oracle Sourcing.

Use the FBDI process to import negotiation lines into a draft negotiation. To import negotiation lines:

1. Before you start the FBDI process to import the large negotiation lines, create a draft negotiation.
2. Go to docs.oracle.com and in the Sourcing chapter, in the Import Negotiation Lines topic given in the Oracle Fusion Cloud Procurement: File-Based Data Import (FBDI) for Procurement guide, download the PONNegotiationLinesImportTemplate.xslm import template file.
3. In the worksheets that are available in the import template, you can add new lines, update or delete existing lines to existing draft large negotiations. You can add, update, and delete line level external cost factors, quantity-based price tiers, and price breaks.
   • In the worksheets that are provided, based on the outcome you have planned, if you’re planning a standard purchase order as outcome, delete the LinesAgreementOutcome worksheet and retain the LinesOrderOutcome worksheet. If you’re planning a blanket Purchase agreement or contracts purchase agreement as outcome, delete the LinesOrderOutcome worksheet and retain the LinesAgreementOutcome worksheet. Also, you can have either the worksheet for quantity-based price tiers or price breaks, you can’t have both.
4. Validate the data in the import template spreadsheet file.
   • After you enter all the negotiation lines in the import template spreadsheet file and before starting the FBDI import process, validate the information that’s entered using the Validate File macro. After the Validate File macro is run, the Validations worksheet is created in the import template file and the Validations worksheet contains more information on the validations that are done in each of the worksheet and errors that have occurred.
5. After validation of the import template spreadsheet, click the Generate CSV File macro to get the .zip file.
6. Use the Import Negotiation Lines schedule processes to load the information present in the CSV files into the negotiation.
   • For more information on the scheduled process available for Sourcing, see the Sourcing Scheduled Processes chapter in the Oracle Fusion Cloud Procurement: Scheduled Processes for Procurement guide.
   • These validations are done:
     • Validate Data in Import File
     • Load Interface File for Import Validations
     • Security and Status validations
     • Functional Validations

   The load interface tables activity will also validate the information that is provided and show if there are errors. The security and status validations are done first before the detailed row level validations. If at least one of these validations fail, the import process is stopped immediately. The functional validations are also done.

   As an administrator user, you can use the ORA_PON_LARGE_ERROR_THRESHOLD profile option to select the upper limit for the number of errors that can occur in an import. If the number of errors are above the error threshold value you set, then the import process isn’t done and a report is generated.

   If the number of errors are below the error threshold, then the import process is performed for the error free lines and for the bad rows, a spreadsheet file with the bad rows is generated.

   Fix the errors in the bad rows and import the corrected rows into the draft negotiation. The spreadsheet file with bad rows also provides information on the errors that have occurred, you can use this information to fix these errors.

   As an administrator user, you can use the ORA_PON_IMPORT_NEGOTIATION_LINES_PARALLEL_REQUESTS profile option to control the number of parallel requests that can run at a time for negotiation lines process.