Home » SQL & PL/SQL » SQL & PL/SQL » Update Match Flag Status in Invoice Distribution (Oracle Applications : 11.5.10.2)
Update Match Flag Status in Invoice Distribution [message #664264] Mon, 10 July 2017 10:52 Go to next message
iamaelle
Messages: 1
Registered: July 2017
Junior Member
I update the Match Flag Status on the AR side by updating the line using AR # and customer_trx_line. I want to do the same for the AP side and the unique identifier number for the AP side is Invoice Distribution # however even though I have the AP # and the Invoice Distribution Line #, the match status still does not update.

Is there a restriction that limits me from updating the flag status?

Or is there another unique identifier I can use to update the lines in AP?

Below is the header I use for my file to be executed through single request in Oracle.
AR AP FLAG NEW STATUS INVOICE NUM INVOICE DISTRIBUTION ID

Re: Update Match Flag Status in Invoice Distribution [message #664273 is a reply to message #664264] Mon, 10 July 2017 12:39 Go to previous message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
This appears to be an Oracle Applications question, but there is no useful information in the post, such as:
What is the update statement?
What is the error?
What does a header in a file have anything to do with an update statement?
Previous Topic: GMT Time Stamp
Next Topic: Cast_to_number not working
Goto Forum:
  


Current Time: Thu Mar 28 17:52:38 CDT 2024