Best Of
INACTIVE_ACCOUNT_TIME - How often does the database check for inactive accounts
If I unlock a user account but the user does not login immediately, how soon can the account become re-locked by the database?
Re: How to add new line for the existing po via interface
Hi @User_WW4B4
Vision Demo - How To Import Standard Purchase Orders Using the Purchase Document Open Interface PDOI (12.2 and 12.1.3 Enhanced PDOI) (Doc ID 2014101.1)
if still has issue — please validate the table po_interface_errors
How To Diagnose Problems With Importing Standard Purchase Orders (Doc ID 781351.1)
Thanks
Nirmal Kumar N
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