Best Of
Re: How to add new line for the existing po via interface
Hi -
Fine, in your header interface table just insert as 1001 (any unique number) in batch_id column along with other data and then try submitting the program from the request window
While submitting check if the Batch LOV shows this 1001 and then submit the program
Check the results and we will decide accordingly
regards.
Ananth
Re: how to update the existing po lines in oracle (interface)
Hi,
You can also use the following
Business Service Object Web Service to Create and Update Purchase Orders (Doc ID 1573389.1) | |
|---|---|
Technical Brief : Using WebADI Spreadsheets In Buyer Work Center Orders (Doc ID 2039629.1) |
Regards,
Sirisha
Re: how to update the existing po lines in oracle (interface)
Hi,
It is not possible to update the PO in interface. You need to use api to update
PO_CHANGE_API1_S.update_po
Sample code to update
set serveroutput ON;
DECLARE
l_result NUMBER;
l_api_errors PO_API_ERRORS_REC_TYPE;
BEGIN
-- This needs to be changed according to your environment setup.
FND_GLOBAL.apps_initialize ( user_id => XXXX,
resp_id => XXXXX,
resp_appl_id => XXX );
mo_global.init('PO'); -- need for R12
l_result := PO_CHANGE_API1_S.update_po (
X_PO_NUMBER => &po_num,
X_RELEASE_NUMBER => Null,
X_REVISION_NUMBER => &rev_num,
X_LINE_NUMBER => &line_num,
X_SHIPMENT_NUMBER => &shipment_num,
NEW_QUANTITY => 25,
NEW_PRICE => Null,
NEW_PROMISED_DATE => Null,
NEW_NEED_BY_DATE => Null,
LAUNCH_APPROVALS_FLAG => 'N',
UPDATE_SOURCE => 'API',
VERSION => '1.0',
X_OVERRIDE_DATE => Null,
X_API_ERRORS => l_api_errors,
p_BUYER_NAME => Null,
p_secondary_quantity => Null,
p_preferred_grade => Null,
p_org_id => &org_id
);
dbms_output.put_line ('l_result' || l_result);
IF (l_result <> 1) THEN
-- Display the errors
FOR i IN 1..l_api_errors.message_text.COUNT LOOP
dbms_output.put_line ( l_api_errors.message_text(i) );
END LOOP;
END IF;
END;
commit;
Hope this helps
Re: INACTIVE_ACCOUNT_TIME - How often does the database check for inactive accounts
Hi
As soon you unlock account you should be able to login.
If you unlock a user account in Oracle Database, the account will not become automatically locked again unless:
- The user attempts to log in and fails, thereby exceeding the allowed number of failed login attempts as defined by the PASSWORD_LOCK_TIME and FAILED_LOGIN_ATTEMPTS parameters in the user's profile.
Thanks
Rahul Kumar
Re: How to / Consultation Questions on Database Authentication
Re: Query Parameters in API OPC
You would use projection support:
Re: sample code to update status of child work order in EAM
Thank you Srini for immediate response, we got the code and it is working
Re: Cancelling of Bulk AR Data from the previous periods
Hi Bharat,
Understood, we will try your action plan to handle it functionally.
Thank you.
Re: Oracle Linux 10 Guest Operating System OLVM
Hi There
Oracle Linux 10 is supported Oracle Linux KVM guest (so it runs perfectly) and the addition of the OLVM Oracle Linux 10 guest list (just to appear on portal) should be released on OVIRT-ENGINE-4.5.5-1.53 which release if I'm not wrong is imminent.
Ref:
So you can just select Oracle Linux 9 for now until the guest list updated with the release of the ovirt-engine version above
Hope that answers your question.
Nash Oudha

