Skip to Main Content

Energy and Water Integrations

Announcement

This area allows you to enter ideas for Oracle Utilities products. You can help promote an idea by:

  • Being as specific as possible about your request.
  • Clearly articulating the benefits. For example, reducing implementation effort or reducing cost to serve.
  • Calling out if you have seen this requirement from other utilities.
  • Voting for suggestions you think should be implemented.

Auto-Create Invoice Items Should Function Even When Other PO Lines Are Closed

Srinija Dusa6 days ago

Current Behavior:

When a Purchase Order (PO) contains multiple PO lines, and one of those lines is fully received, invoiced, approved, and posted to ERP, the OIC integration closes the PO line as part of the posting process.

If a user later receives quantity for a different PO line of the same Purchase Order, and creates an invoice header for that line, the Auto Create Invoice Items action fails. The following error message is displayed:

“Quantity is missing”

This occurs because the system incorrectly considers the closed PO line during quantity validation—even though the invoice is being created for another PO line that is still open and has valid received quantity.

As a result, the auto-creation process does not generate invoice lines simply because some other PO line (not the one being invoiced) has been closed by the OIC integration.

Business Impact:

  • Users cannot auto-create invoice lines for valid, open PO lines when any unrelated PO line on the same PO is closed.
  • This forces manual entry of invoice lines, adding time and increasing the chance of human error.
  • Invoices for open PO lines are delayed, impacting Accounts Payable throughput.
  • The issue disrupts the intended end-to-end workflow between Receiving, Invoicing, and ERP posting through OIC.

Example Use Case:

  1. A PO has multiple lines (e.g., Line 1 and Line 2).
  2. Line 1 quantity is fully received, invoiced, approved, and posted to ERP by OIC integration.
  3. The OIC integration closes PO Line 1.
  4. Later, Line 2 quantity is received, and an invoice header is created.
  5. The user selects Auto Create Invoice Items.
  6. The process fails with error: “Quantity is missing”, even though Line 2 is fully valid for invoicing.

This prevents invoice line creation for Line 2 solely because Line 1 was already closed by the integration.

Expected / Requested Enhancement:

We request an enhancement that ensures the Auto Create Invoice Items functionality evaluates only the specific PO line being invoiced, without being blocked by the status of other PO lines on the same Purchase Order.

This enhancement would enable:

  • Successful auto-creation of invoice items for PO lines with valid received quantities, even if other PO lines are closed by the OIC integration.
  • A smoother and more accurate invoice creation process.
  • Reduced manual intervention and fewer data entry errors.
  • Better alignment between receiving, invoicing, and ERP posting processes.
Comments
Post Details
Added 6 days ago
New
0 people have voted for this idea
0 comments
21 views