Best Of
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
Re: R12.2 : Require versions of developer tools i.e Oracle BI Publisher, Discoverer and Workflow Builder
Hi,
Here is the exact way to search but in summary discoverer version for R12.2.4 (
(11.1.1.7.0,
11.1.1.6.0)
1. Log in to MOS
2. Go to Certification tab
3. Search Product- Oracle E- Business Suite
4. Version- 12.2.4
5. OS- Any
Now when you click on Search it will will give you many numbers of options.
a. OS(5 Items)
b. Apps Server
c. Database
d. Desktop Apps Brower
e. Middle ware.. etc
Thanks
Ankit
ANNOUNCE: OS8.8.85 is Available on MOS!
This is to announce the release of ZFSSA AK Software OS8.8.85 (aka 2013.1 Update 8.85)
OS8.8.85 has been delivered to the external support repository and MOS
It is available on the external MOS portal, ARU # 27977183
Re: Which base version of oracle software do we need to start during migration from X8 to X11
Hi Madhavaraj,
We are currently on ODA X8-2S box. We are running Oracle 19.27 on Linux 8.10
Seems you are already on that version on the X8. You can deploy the latest ODA version on the X11 which is 19.28.
Create a 19.27 dbhome on the X11, configure data guard between the the X8 and X11.
Patch the db on the X11 (standby at this point), swicthover, deconfigure dataguard, run datapatch (odacli update-database has such an option) and job done, you are on the latest db version.
Does it answer your question?
Br,
krisz


