When importing invoices by the Autoinvoice Import Program , many times we are faced with the error : Please provide a value for the line transaction flexfield.
If we check the setup we see that even though the flexfield has been enabled in the setup the Requeired flag is not checked. How ever Auto invoice when importing the invoice does not check for the required flag being set or not. If the Flexfield is enabled Oracle expects a value to be provided in the interface if the value is not provided the record will be errored out in import.
Moreover the combination of the flexfield values need to be unique , else we will get the error : This line has the same transaction flexfield as another row in the interface table. For each transaction line, the
combination of interface_line_context and interface_line_attribute values must be unique
If we check the setup we see that even though the flexfield has been enabled in the setup the Requeired flag is not checked. How ever Auto invoice when importing the invoice does not check for the required flag being set or not. If the Flexfield is enabled Oracle expects a value to be provided in the interface if the value is not provided the record will be errored out in import.
Moreover the combination of the flexfield values need to be unique , else we will get the error : This line has the same transaction flexfield as another row in the interface table. For each transaction line, the
combination of interface_line_context and interface_line_attribute values must be unique
