Creating Workers Oracle Fusion HCM API
Creating Workers in Oracle Fusion HCM via REST API Creating and Managing Workers in Oracle Fusion HCM Using REST APIs Instead of the Guided UI Flow Introduction / Issue Onboarding…
Read MoreUser_Info_Details_Report
Introduction This report displays employee master information such as employee ID, name, person type, position, job grade, manager, contact details, employment status, location, and long-term leave details for HR administration…
Read MoreForecast-Based Component Demand in Fusion SCP
Introduction/ Issue: Developing a custom BI Publisher (BIP) report in Oracle Fusion Supply Planning to provide visibility into component dependent demand based on the Finished Goods Forecast instead of the…
Read MoreQuery to get the details of Invoice and Supplier Payment Method Mismatch in fusion.
WITH FUNCTION f_payment_method_at_supplier ( p_vendor_id IN NUMBER ) RETURN VARCHAR2 IS payment_method VARCHAR2(250); — — This function will tell us payment method from supplier…
Read MoreQuery to get Sales Order in fusion.
SELECT dha.source_order_id AS sourcetransactionidentifier, dha.order_number AS sourcetransactionnumber, dha.source_order_system AS sourcetransactionsystem, dha.transactional_currency_code AS transactionalcurrencycode, TO_CHAR(dha.ordered_date,’YYYY/MM/DD HH24:MI:SS’) AS transactionon, dha.order_type_code AS transactiontypecode, dha.legal_entity_id AS requestinglegalentity, dha.partial_ship_allowed_flag AS partialshipallowedflag, dha.freeze_price_flag AS freezepricing, dha.freeze_shipping_charge_flag…
Read MoreUnderstanding Ledger in Oracle ERP Fusion
Understanding Ledger in Oracle ERP Fusion Introduction / Issue: A recurring gap I see with consultants and even client teams new to Oracle Fusion Financials is a shallow understanding of…
Read MoreOracle Fusion Financials 26B – GL AI Agent Setup Guidance
GL_AI_Agent_26B_Blog Oracle Fusion Financials 26B – GL AI Agent Setup Guidance Introduction / Issue: For Oracle Financials consultants planning to enable and run the GL AI Agent introduced in the…
Read MoreSupplier Calendar Calculation
Supplier Calendar – Clipper -Supplier Test Step 1 : Define ExceptionsNavigation: Setup and maintenance 🡪 Global Search 🡪 Manage Schedule Exceptions 🡪 Create 🡪 Enter the Required Details and Exception…
Read MoreRecovering Deleted Shipment History in Fusion SCP; Target Refresh vs Net Change
Introduction/ Issue: To reload all existing shipment history into Fusion that was deleted when the Load Planning Data from Flat Files process was run in Target mode instead of Net…
Read MoreAssembly and Component Items Demand Shortage Report in Fusion SCP
Introduction/ Issue: Developing a BIP report in Fusion to identify component demand shortages for assembly items and improve supply planning decisions. Why we need to do / Cause of the…
Read More