Insights from Oracular Businesses using Oracle—whether on-premise, in the cloud, or both—face constant pressure to adapt. Quarterly Oracle updates require companies to test, validate, and release changes quickly. Manual testing…
Read MoreIntroduction: This blog has the SOAP Webservice details that can be used to update the inactive manager assignments in Oracle Cloud application. Cause of the issue: Business wants to fix…
Read MoreIntroduction: This blog has the SQL query that can be used to pull the data of employees whose manager assignment is inactive even if the manager is active. Cause of…
Read MoreEscheatment of Unclaimed Checks Overview of Escheatment of Unclaimed Checks Escheatment is the process of transferring abandoned or unclaimed property to the state where the owner’s last known address is…
Read MoreIntroduction: In General, BIP reports can be run by an ESS job or from Reports & Analytics. We’d like to demonstrate another way for launching a BIP report on the…
Read MoreUser Submitted concurrent Program “XXFM TBI DEBIT CONTROL” in DEV environment after Clone. Program failure happening with Below Error. Oracle Database 19c (Multitenant) and EBS Application is 12.2.10 running…
Read Moreprocedure xxdm_upd_ship_num_in_orcl(p_delivery_detail_id NUMBER, p_thirsd_party_tracking_number VARCHAR2) is l_index NUMBER; l_msg_return NUMBER; x_return_status VARCHAR2 (1); x_msg_count NUMBER; x_msg_data VARCHAR2 (32767); l_changedattributetabtype wsh_delivery_details_pub.changedattributetabtype; BEGIN fnd_global.APPS_INITIALIZE (0, 21676, 385); — Provide user_id, resp_id and…
Read MorePROCEDURE XDM_SHIP_CONFIRM(p_delivery_id_s NUMBER, p_shipping_method VARCHAR2, p_trip_id number, p_close_trip_flag VARCHAR2) IS –Standard Parameters. p_api_version NUMBER := 1.0; p_init_msg_list VARCHAR2(30); –Parameters for WSH_DELIVERIES_PUB.Delivery_Action. p_action_code VARCHAR2(15); p_delivery_id NUMBER:= p_delivery_id_s; p_delivery_name VARCHAR2(30); p_asg_trip_id NUMBER:=p_trip_id;…
Read MoreTranslations Translation is the process of translating account balances from functional currency to another (reporting or foreign) currency. This process translates balances only. It doesn’t translate individual transactions. While…
Read MoreBalance Forward Billing (BFB) In EBS R11i we call it as consolidated billing In EBS R12 Balance forward billing In fusion Balance forward billing (BFT) we can used for…
Read More