CSV Import: Line Item data is not being created in the Payment Applications record. The import seems to complete but no Line Item data is created. (Doc ID 2517123.1)

Last updated on JUNE 27, 2023

Applies to:

Symptoms

On Unifier : Any Version

When importing Line Item Data with a zero dollar amount (0.00) to a Payment Applications type Business Process record by way of a CSV file:

Expected Result

Line Item data should be created after the import is complete.

Actual Result

Line Item data is not being created in the Payment Applications record. The import seems to complete but no Line Item data is created.

Steps To Reproduce

1. To export the payment application line item template
   • Navigate to the payment application business process log.
   • Click New to create a new business process.
   • Select a Reference Base Commit for the business process. If you do not select a Reference Base Commit, the exported template will not contain data. Data from all columns
     in the Reference Base Commit is exported.
   • Choose File > Export Line Item Template.
   • Click Open to open the file in Microsoft Excel, or click Save to save the file to your local drive. The template exports with SOV line item data in it, based on the selected Reference
     Base Commit.
2. To modify the payment application line item template
   • Open the exported CSV file in Microsoft Excel. The SOV line items are listed.
   • Enter the line item information into the spreadsheet. Each line must begin with a "D". For multiple tabs, you must enter appropriate tab name in the Tab Name column.
   • Enter data into the required fields, as well as non-required fields as needed.
3. To import the payment application line item template
   • Navigate to the Payment Application business process log.
   • Select a business process and click Open.
   • Click the Import button. The imported line items replace any existing line items. If there are any import errors, you can open the CSV file to view and correct the error. No line
     items are imported if any row contains an import error.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.