Oracle Application Blog

Shipment Tracking Number Update using API

procedure 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…

No Revaluate Balance option for Legal entity when user trying to run the Revaluation in Month End

10712_shaik-mohammed-shafi_revaluation-issue

Issue with the Oracle Fusion General Ledger where the Journals are not posted and in unposted status.

10712_shaik-mohammed-shafi

ROUNDING line in Payment Accounting AP

Cancelling AP invoice fix

cancelling-invoice-issue-fix-1

Oracle Fusion query to get the Tax_Reporting_Type_Code_For_a_Tax_Regime

Introduction: This SQL query is fetching the data of Tax reporting type code details by passing the tax regime. Cause of the issue: To find if any of the tax…

Oracle Fusion India_Customer_Trx_GST_Details_Query

Introduction: This SQL query is fetching the data of India customer’s transaction with the company and the customer GST details. Cause of the issue: To find out the customers GST…

MPS/MRP planning attributes

MPS/MRP planning attributes Navigation path: Inventory>Items>Master Items>General Planning (T) Refer to the table below for the setup of each attribute.   Attribute Valid values Purpose Comment Setup Planning Not Select…

ASL Setups

Setup supply chain For more information on supplier base setups, please refer to the Purchasing Training Manual. Approved Supplier List Approved supplier list is a controlled repository of information that…

Restricting Self-Approval in Oracle Fusion

Introduction:    Addressing the self-approval concern for expenses and other documents after setting up a vacation rule in Oracle Fusion. You can prevent self-approval of expenses by selecting the “Prohibit Self-Approval…