You can try with Data Loader software ?
This will be a new application which will give the users the facility to mass update the PO dates (and attachments).
Hence we cant use data loader.
Basically the proposed design is as under -
- User uploads the data from an excel into a OAF page.
- From this excel the data is inserted into a staging table.
- Then there will be an Oracle concurrent program (custom) which will read data from the staging table and update into standard tables along with revision increment and approval.
1 person found this helpful
You should be able to update existing PO and automatically increase revision. This is standard revision control for PO document.
This is per standard documentation:
"For the Update action code, the document revision number is increased every time
the unit Price, item Description, UOM, or Expiration Date is updated, or when a
new line is added (unless Archive on Approval is chosen in the Document Types
window and PO: Archive Catalog on Approval is set to No)."
To approve the update, you can pass LAUNCH_APPROVALS_FLAG = 'Y' for the API.
The following notes have some good examples and details of the API:
Vision Demo - How To Use the PO Change API To Update Existing Purchase Orders (Doc ID 1078842.1)
How to use PO_CHANGE_API1_S.update_po to Change Three Lines (Doc ID 1077455.1) -- look at last example for lauch_approval_flag
Is it possible to use the PO_CHANGE_API1_S API for updating the revision only?
I mean without updating any date/price etc.