Home » Applications » Oracle Fusion Apps & E-Business Suite » Invoice Workbench Custom Code (12.1.3)
icon8.gif  Invoice Workbench Custom Code [message #591683] Tue, 30 July 2013 22:52
Messages: 23
Registered: August 2010
Location: Adelaide, Australia
Junior Member
Hi all.
I have a requirement to add custom code to the invoice workbench.
This custom code is required to take the PO number the invoice is matched to and add it to the invoice header description field.
Currently I can't get it to fire correctly. It's firing before the invoice has been matched.
Here is my current setup:

Trigger Object: LINE_SUM_FOLDER (have used INV_SUM_FOLDER as well)
Condition: -blank-
Processing Mode: Not in Enter-Query Mode

Object Type: Item
Property Name: VALUE
Value: =select 'PO NUM'||max(po_number_ from ap_invoice_lines_v where match_type = 'ITEM_TO_PO' and invoice_id =${item.inv_sum_folder.invoice_id.value}

If i select Validate it comes up with the 'PO NUM' and the po number. However, when i enter the invoice, it enters PO NUM into the description field, but after matching, it doesn't update the field.
Any help would be great.

Previous Topic: Records Not Found in mtl material transactions
Next Topic: Enable record history option for selected users
Goto Forum:

Current Time: Mon Nov 30 16:41:26 CST 2015

Total time taken to generate the page: 0.08676 seconds