This content has been marked as final. Show 2 replies
930231 wrote:I suggest you to log a oracle SR for data fix
PO created by user by doing copy document. The series was 103 so next number came as 104. As discussed with user. PO output too taken. Do not know status of PO. But now in PO summary window PO not able to view. Series shows 103, 105 directly. 104 not shown. Kindly help what has been done by user. Can we retrieve this PO.
Issue is in 11i.
coming to status of PO we can get that from table though
Looks like user has deleted the PO# - 104 once it was autocreated from a requisition.
You can delete a PO which was never approved and is in Incomplete status.
As Oracle follows a sequence, the next PO number was generated as 105.
Edited by: 881211 on 13/05/2012 17:48