Sample Document to Use OIC Lookup to pass the username and password from Lookup

 

Sample Document to Use OIC Lookup to pass the username and password from Lookup

 

Usecase : It is not advisable to pass the hardcoding , username and password in OIC integration.

Solution : We need to pass these values need to pass these values

From lookups.

 

Benefit of passing the Values from lookup is that , if some value changes we

need not make changes to OIC code , we can just update the lookup values.

 

And also of the OIC integration is migrated some other instance or if the password we have to change ,

We only need to update the lookup.

 

 

Sample Lookup design in OIC >

 

 

Now to use this in OIC mapping  , goto mapper

Ø Components > Functions > Integratoin Cloud > Lookup Value > Drag and drop to the Mapper

 

 

 

 

Now it will open a setup page

 

Select the Lookup Name

 

 

 

Select source and Target Columns.

 

 

Click Next ,and then next Done Close.

 

 

dvm:lookupValue('FUSION_DATA_SYNC', 'NAME', srcValuePlaceHolder, 'VALUE', '')

 

Update  srcvaluePlaceholder with the username > “BI_USERNAME”

 

It should look as below

dvm:lookupValue ("FUSION_DATA_SYNC", "NAME", "BI_USERNAME", "VALUE", "" )

 

 

 

 

 

Similar to pull password repeat the same step as above.

 

 

dvm:lookupValue('FUSION_DATA_SYNC', 'NAME', srcValuePlaceHolder, 'VALUE', '')

 

Update  srcvaluePlaceholder with the username > “BI_PASSWORD”

 

dvm:lookupValue ("FUSION_DATA_SYNC", "NAME", "BI_PASSWORD", "VALUE", "" )

 

 

 

Now validate and Close the Mapper .

 

And Save the Integration.

 

Now when the Integration runs the username and password will be pulled from lookups.

 

 

Amazing Health Benefits of Cycling

 

The health benefits of cycling

Cycling offers incredible health benefits that can transform your physical and mental well-being. This guide is perfect for fitness beginners, busy professionals, and anyone curious about adding cycling to their routine.

Regular cycling strengthens your heart, helps burn calories, and boosts your mood naturally. We'll explore how pedaling improves your cardiovascular health by lowering blood pressure and reducing heart disease risk. You'll also discover cycling's powerful weight management benefits and learn how this low-impact exercise enhances mental clarity while reducing stress and anxiety.

Ready to learn why millions of people choose cycling as their go-to workout? Let's dive into the science-backed reasons this simple activity delivers such impressive health results.

Cardiovascular Health Improvements Through Cycling

Strengthened Heart Muscle and Improved Blood Circulation

Cycling transforms your heart into a powerhouse of efficiency. When you pedal regularly, your heart muscle grows stronger and pumps blood more effectively with each beat. This increased cardiac strength means your heart doesn't have to work as hard during daily activities, reducing wear and tear over time.

The rhythmic nature of cycling creates an ideal training environment for your cardiovascular system. Your heart rate increases during rides, forcing the muscle to adapt and become more robust. This adaptation process strengthens the left ventricle, the heart's main pumping chamber, allowing it to push more blood through your body with less effort.

Blood circulation receives a dramatic boost during cycling sessions. The repetitive leg movements act like secondary pumps, helping push blood back up to your heart from your lower extremities. This enhanced circulation delivers oxygen and nutrients more efficiently to all your organs and tissues while removing waste products faster.

Regular cyclists often develop an expanded network of capillaries, the tiny blood vessels that connect arteries and veins. This increased capillary density means better oxygen delivery to muscles and organs, improving overall body function and endurance.

Reduced Risk of Heart Disease and Stroke

Cycling creates a protective shield against cardiovascular diseases. Research shows that people who cycle regularly cut their risk of heart disease by up to 50% compared to sedentary individuals. This dramatic reduction comes from multiple factors working together to keep your cardiovascular system healthy.

The activity helps prevent the buildup of arterial plaque, those dangerous fatty deposits that can block blood flow to your heart and brain. By keeping your blood flowing smoothly and your arteries flexible, cycling reduces the chances of blood clots forming that could trigger heart attacks or strokes.

Your body's ability to regulate inflammation also improves with regular cycling. Chronic inflammation plays a major role in developing heart disease, and the anti-inflammatory effects of moderate exercise like cycling help keep this dangerous process in check.

Cycling also enhances your body's natural ability to form collateral circulation – backup blood vessels that can take over if main arteries become blocked. This natural bypass system provides additional protection against heart attacks and strokes.

Lower Blood Pressure and Improved Cholesterol Levels

Blood pressure responds remarkably well to regular cycling. The aerobic nature of this exercise helps your arteries become more flexible and responsive, allowing blood to flow more easily. This reduced resistance means your heart doesn't need to push as hard, naturally lowering both systolic and diastolic blood pressure readings.

The magic happens both during and after your rides. While cycling, your blood vessels dilate to accommodate increased blood flow. Over time, this repeated dilation helps your arteries maintain better flexibility, keeping blood pressure lower even when you're not exercising.

Cholesterol levels see impressive improvements with consistent cycling. Your HDL cholesterol – the "good" kind that helps remove harmful cholesterol from your arteries – increases significantly. At the same time, LDL cholesterol and triglycerides, the problematic fats that contribute to artery blockages, decrease substantially.

The relationship between cycling and cholesterol involves your liver's enhanced ability to process and eliminate excess cholesterol from your bloodstream. Regular cycling also improves your body's sensitivity to insulin, which plays a crucial role in managing both blood sugar and cholesterol levels effectively.

Weight Management and Fat Burning Benefits

High Calorie Burn During Cycling Sessions

Cycling stands out as one of the most effective calorie-burning exercises you can do. A moderate 30-minute bike ride burns approximately 300-400 calories for an average adult, while more intense sessions can torch up to 600-800 calories per hour. The exact number depends on factors like your weight, cycling speed, terrain, and resistance level.

What makes cycling particularly impressive is its scalability. Beginners can start with gentle rides that still burn 200-250 calories in 30 minutes, while experienced cyclists tackling hills or high-intensity intervals can double or triple that burn rate. Mountain biking and spinning classes push calorie expenditure even higher due to the increased resistance and varied intensity levels.

Increased Metabolic Rate for Hours After Exercise

The calorie-burning benefits don't stop when you park your bike. Cycling triggers what exercise scientists call excess post-exercise oxygen consumption (EPOC), commonly known as the "afterburn effect." Your metabolism stays elevated for 2-24 hours after cycling, continuing to burn calories at an accelerated rate.

High-intensity cycling sessions create the most dramatic afterburn effects. When you push yourself during intervals or hill climbs, your body needs extra energy to restore oxygen levels, repair muscle tissue, and clear metabolic waste products. This process can increase your metabolic rate by 15-25% for several hours post-workout.

Even moderate cycling sessions produce measurable metabolic boosts. Your body temperature remains slightly elevated, your heart rate takes time to fully normalize, and cellular repair processes continue working overtime. Regular cyclists often report feeling more energetic throughout the day, partly due to this sustained metabolic enhancement.

Effective Body Fat Reduction and Muscle Toning

Cycling targets body fat reduction through a dual mechanism: direct fat burning during exercise and improved muscle mass that increases baseline metabolism. The rhythmic, sustained nature of cycling makes it particularly effective at accessing fat stores for energy, especially during longer rides exceeding 20-30 minutes.

Your legs, core, and glutes all engage during cycling, creating lean muscle mass while simultaneously burning fat. This combination leads to improved body composition - less fat, more muscle - which creates a toned appearance and boosts your resting metabolic rate.

Research shows that regular cyclists typically maintain lower body fat percentages compared to sedentary individuals. The continuous pedaling motion specifically targets stubborn fat areas like thighs and glutes, while also engaging core muscles for stability and balance.

Sustainable Weight Loss Without Joint Stress

Unlike running or high-impact exercises, cycling provides an incredibly joint-friendly path to weight loss. The bike supports your body weight, eliminating the repetitive stress that can damage knees, hips, and ankles over time. This makes cycling sustainable for people of all ages and fitness levels.

The low-impact nature means you can cycle more frequently and for longer durations without risking injury or excessive fatigue. Many people find they can maintain cycling routines for decades, creating lasting weight management habits that stick.

Cycling also offers incredible variety to prevent boredom and plateaus. You can explore different routes, adjust intensity levels, try indoor cycling classes, or switch between road and mountain biking. This variety keeps you engaged and motivated, which is crucial for long-term weight management success.

Mental Health and Cognitive Enhancement

Reduced Stress Levels and Anxiety Relief

Cycling acts as a natural stress reliever, creating a rhythmic movement that helps your mind shift away from daily worries. When you pedal, your body enters a meditative state where repetitive motion combines with deep breathing to lower cortisol levels - your body's primary stress hormone. This physical activity triggers your parasympathetic nervous system, which is responsible for the "rest and digest" response that directly counters stress.

Regular cyclists often report feeling calmer and more centered after their rides. The outdoor environment enhances this effect, as exposure to nature has been scientifically proven to reduce anxiety symptoms. Fresh air and changing scenery provide mental stimulation that breaks the cycle of anxious thoughts, while the focus required for navigation and balance keeps your mind anchored in the present moment.

Studies show that just 30 minutes of moderate cycling can reduce anxiety levels for up to four hours afterward. This happens because cycling increases the production of GABA, a neurotransmitter that promotes feelings of calm and relaxation.

Enhanced Mood Through Endorphin Release

Cycling triggers a powerful neurochemical response that naturally elevates your mood. As you pedal, your brain releases endorphins - often called "feel-good" chemicals - which create sensations of happiness and euphoria. This biological process is what many cyclists refer to as the "runner's high," though it applies equally to cycling.

The endorphin release begins within 10-15 minutes of moderate cycling and can last for several hours post-exercise. These natural opioids are more potent than many synthetic mood enhancers and come without negative side effects. Your brain also increases production of serotonin and dopamine, neurotransmitters crucial for emotional regulation and feelings of reward and pleasure.

Beyond endorphins, cycling boosts brain-derived neurotrophic factor (BDNF), a protein that supports brain cell growth and protects existing neurons. Higher BDNF levels are associated with improved mood stability and reduced risk of depression. Many mental health professionals now recommend cycling as a complementary treatment for mood disorders, as it can be as effective as some medications for mild to moderate depression.

Improved Sleep Quality and Duration

Regular cycling significantly improves both how quickly you fall asleep and the quality of your rest. Physical exertion from cycling helps regulate your circadian rhythm - your body's internal clock that controls sleep-wake cycles. When you cycle regularly, your body temperature rises during exercise and drops afterward, signaling to your brain that it's time to prepare for sleep.

Cycling reduces the time it takes to fall asleep by approximately 50% and increases deep sleep duration by nearly 25%. Deep sleep is when your body performs critical repair functions and consolidates memories from the day. The physical fatigue from cycling creates a natural desire for rest, while the mental relaxation from reduced stress and anxiety makes it easier to quiet racing thoughts at bedtime.

Morning or afternoon cycling sessions work best for sleep improvement, as evening workouts can be too stimulating close to bedtime. The key is consistency - cyclists who maintain regular riding schedules report the most significant sleep improvements. Better sleep quality creates a positive cycle, as well-rested individuals have more energy for physical activity and better emotional regulation the following day.

Muscular Strength and Joint Health Benefits

Lower Body Muscle Development and Toning

Cycling transforms your legs into powerful machines through consistent engagement of multiple muscle groups. Your quadriceps work overtime during each pedal stroke, particularly when pushing down on the pedals, while your hamstrings activate during the upward pull phase. The glutes fire continuously to stabilize your pelvis and generate power, creating that coveted toned appearance many cyclists develop over time.

The beauty of cycling lies in its progressive resistance training effect. As you tackle hills or increase your cadence, your calves, particularly the gastrocnemius and soleus muscles, adapt by becoming stronger and more defined. Unlike gym workouts that target isolated muscle groups, cycling creates functional strength that translates to real-world activities like climbing stairs or carrying groceries.

Regular cyclists often notice improved muscle endurance alongside strength gains. The repetitive nature of pedaling builds slow-twitch muscle fibers, creating lean, efficient muscles rather than bulky mass. This makes cycling perfect for people seeking toned legs without the intimidating bulk some associate with weight training.

Improved Joint Mobility and Flexibility

The circular pedaling motion creates a natural range-of-motion exercise for your hips, knees, and ankles. Each revolution gently moves these joints through their full range, preventing the stiffness that develops from sedentary lifestyles. Your hip flexors stretch and contract rhythmically, countering the tight hip flexors that plague desk workers and frequent sitters.

Knee joints benefit tremendously from cycling's low-impact nature. The smooth, controlled movement lubricates the joint capsule with synovial fluid, reducing friction and maintaining healthy cartilage. Unlike running or jumping activities that place stress on joints, cycling allows for joint movement without jarring impacts.

Your ankles also gain flexibility through the constant dorsiflexion and plantarflexion required for effective pedaling. This ankle mobility proves crucial for preventing injuries in other activities and maintaining proper walking mechanics as you age.

Enhanced Balance and Coordination Skills

Cycling demands constant micro-adjustments to maintain balance, creating a sophisticated neuromuscular training effect. Your core muscles work continuously to stabilize your torso while your legs power the bike, developing the kind of functional coordination that benefits daily activities.

The proprioceptive benefits extend beyond the bike itself. Regular cyclists develop better spatial awareness and reaction times. Your brain learns to process multiple inputs simultaneously - road conditions, traffic, balance, and pedaling rhythm - creating enhanced cognitive-motor integration.

Mountain biking takes these benefits even further, requiring split-second balance adjustments on uneven terrain. This challenges your stabilizing muscles and reflexes in ways that traditional gym exercises cannot replicate, building real-world applicable coordination skills.

Reduced Risk of Osteoporosis Through Weight-Bearing Activity

While cycling is gentler on joints than running, it still provides enough mechanical stress to stimulate bone formation. The force transmitted through your legs during pedaling, combined with the weight-bearing aspect of supporting your body weight, signals your bones to maintain and build density.

Your spine benefits from the upright or slightly forward-leaned position required for cycling, as the postural muscles work to maintain proper alignment. This creates a weight-bearing stimulus that helps preserve spinal bone density, particularly important for preventing compression fractures later in life.

The hormonal benefits of regular cycling also contribute to bone health. Exercise stimulates the release of growth hormone and other bone-building hormones while reducing cortisol levels that can lead to bone loss. Women, who face accelerated bone loss after menopause, find cycling particularly beneficial for maintaining skeletal strength throughout their lives.

Immune System Strengthening and Disease Prevention

Boosted White Blood Cell Production

Cycling acts as a powerful catalyst for your immune system's defense mechanisms. When you pedal regularly, your body responds by ramping up the production of white blood cells, the frontline soldiers in your body's fight against infections and diseases. Research shows that moderate cycling sessions lasting 30-60 minutes can increase white blood cell count by up to 300% immediately after exercise.

The magic happens through increased blood circulation during cycling. As your heart pumps faster and blood flows more vigorously through your system, immune cells move more efficiently throughout your body. This enhanced circulation helps immune cells detect and eliminate pathogens before they can establish infections.

Regular cyclists experience fewer upper respiratory infections compared to sedentary individuals. Studies indicate that people who cycle for at least 20 minutes, three times per week, report 40% fewer sick days annually. The key lies in consistency - sporadic intense cycling sessions won't provide the same immune benefits as regular moderate activity.

Reduced Risk of Type 2 Diabetes

Cycling serves as an exceptional tool for diabetes prevention through multiple pathways. The rhythmic pedaling motion activates large muscle groups in your legs, which consume glucose for energy and improve insulin sensitivity. This process helps your cells become more responsive to insulin, reducing blood sugar levels naturally.

Regular cycling can lower your risk of developing type 2 diabetes by up to 40%. The exercise helps your muscles act like sponges, absorbing excess glucose from your bloodstream even hours after you've finished riding. This effect, known as the "afterburn," continues working for up to 48 hours post-exercise.

Even if you already have prediabetes, cycling can reverse the condition. A 150-minute weekly cycling routine can reduce hemoglobin A1C levels (a measure of long-term blood sugar control) by 0.6-0.8 percentage points within three months. This improvement often brings blood sugar levels back into the normal range.

Lower Cancer Risk Through Regular Physical Activity

The cancer-fighting benefits of cycling are remarkable and well-documented across multiple cancer types. Regular cyclists show a 45% lower risk of developing colorectal cancer and a 34% reduced risk of lung cancer compared to inactive individuals. The protective effects stem from cycling's ability to boost immune surveillance and reduce chronic inflammation.

Cycling helps regulate hormones linked to cancer development, particularly estrogen and insulin-like growth factor. For women, regular cycling can reduce breast cancer risk by 25-30% by maintaining healthy estrogen levels and body weight. The activity also promotes healthy cell division and DNA repair mechanisms.

The anti-cancer benefits become evident with just 150 minutes of moderate cycling per week. However, longer duration cyclists (those riding 5+ hours weekly) show even greater protection, with some studies reporting up to 60% lower cancer rates across various cancer types.

Improved Lung Function and Respiratory Health

Cycling transforms your respiratory system into a more efficient oxygen-processing machine. Regular cycling increases lung capacity by 10-15% within eight weeks of consistent training. The deep, rhythmic breathing required during cycling strengthens your diaphragm and intercostal muscles, the key players in efficient breathing.

Your lungs develop more alveoli (tiny air sacs where oxygen exchange occurs) through regular cycling. This increased surface area allows for better oxygen absorption and carbon dioxide removal. Cyclists often experience improved breathing efficiency that carries over into daily activities, reducing breathlessness during routine tasks.

The cardiovascular-respiratory partnership strengthens significantly through cycling. As your heart becomes more efficient at pumping blood, your lungs work more effectively to oxygenate that blood. This synergy reduces your resting heart rate and breathing rate while improving your body's ability to handle physical stress.

Enhanced Longevity and Healthy Aging

Regular cycling can add years to your life while adding life to your years. Large-scale studies following participants for decades show that cyclists live an average of 3-5 years longer than non-cyclists. The longevity benefits come from cycling's comprehensive impact on multiple body systems.

Cycling helps maintain telomere length, the protective caps on chromosomes that shorten with age. Cyclists show telomere lengths equivalent to people 9-10 years younger, indicating slower cellular aging. This biological age reversal translates into better physical function, cognitive performance, and disease resistance as you age.

The activity preserves bone density, muscle mass, and joint flexibility - three critical factors for maintaining independence in later years. Older adults who cycle regularly show 40% better balance, 30% stronger bones, and 25% more muscle mass compared to their sedentary peers. These benefits dramatically reduce fall risk and fracture rates, helping maintain quality of life well into advanced age.

q- parameter use to pass the parameter condition at next heirarchical level

 

OrganizationCode =28192 and StructureName='Primary' and ItemNumber='F6-TD-' and Component.EndDateTime =''

Note :In oracle Notes found that the q parameters filtering will not works at components level

So need to use filtering logic at the OIC level .

I have used a IF condition at OIC mapping level 

((string-length (nsmpr10:EndDateTime ) = 0) or (nsmpr10:EndDateTime > fn:current-dateTime()))

SQL to Get dates missing in a table for given date range

 WITH all_dates AS (

    SELECT DATE '2025-01-01' + LEVEL - 1 AS dt

    FROM dual

    CONNECT BY LEVEL <= (DATE '2026-01-01' - DATE '2025-01-01') + 1

),

existing_dates AS (

    SELECT TRUNC(creation_date) AS dt

    FROM  XXCUST.CUSTOM_TL -- your table name

    WHERE creation_date BETWEEN DATE '2025-01-01' AND DATE '2026-01-01'

)

SELECT a.dt AS missing_date

FROM all_dates a

LEFT JOIN existing_dates e

       ON a.dt = e.dt

WHERE e.dt IS NULL

ORDER BY a.dt;

Sample Postman call to expand the Components and filter only active components under a work structures

Requirement is to get the Only active components that means item structures having active components .

 https://{instance-url}/fscmRestApi/resources/11.13.18.05/itemStructures?q=OrganizationCode =28102 and StructureName='Primary' and ItemNumber='FD-0506-TD-' and Component.EndDateTime =''&expand=Component

and also we need to add below custom header -

REST-Framework-Version =4

Sample Request Payload to Create Item Structure in Oracle Fusion 25D.

============Request Payload============== { "OrganizationCode" : "28102", "ItemNumber" : "Item_Main", "StructureName" : "Primary", "EffectivityControl" : 1, "EffectivityControlValue" : "Date", "Component" : [ { "ComponentItemNumber" : "Comp_item1", "ItemSequenceNumber" : 10, "FindNumber" : 1, "Quantity" : 50 } ] } ======================================== Request Url: /fscmRestApi/resources/11.13.18.05/itemStructures ======================================== Operation Name : POST ========================================

OIC Integration steps for Item structures Conversion from One Inventory Org to Other Inv Org.

OIC Integration: BOM and Item Structure Conversion Between Inventory Organizations

In Oracle Fusion Cloud, when businesses expand or reorganize their manufacturing or inventory setups, it often becomes necessary to replicate or convert Item Structures (BOM) from one Inventory Organization to another. Doing this manually can be time-consuming and error-prone. Thankfully, using Oracle Integration Cloud (OIC), we can automate this process efficiently.

---

💡 Use Case Overview

We want to build an OIC integration that will:

• Extract BOM and Item Structure details from a Source Inventory Organization.
• Transform and prepare the data for a Target Inventory Organization.
• Load or create BOMs in the target org using Fusion REST APIs.

Example: Copy BOM structure for an item from INV_ORG_A (Manufacturing Plant A) to INV_ORG_B (Manufacturing Plant B).

---

🔧 Step-by-Step OIC Integration Flow

Step 1: Create a Scheduled Integration

• Open OIC → Integrations → Create → Choose Scheduled Integration.
• Name it: BOM_Structure_Conversion.
• This will allow automation to run periodically or on demand.

Step 2: Get BOM Details from Source Org

Use the Fusion REST API for Item Structures to fetch BOM details.

 GET /fscmRestApi/resources/11.13.18.05/itemStructures ?ItemNumber={itemNumber} &OrganizationCode={SourceOrg} 

Example Response:

{ "ItemNumber": "LAPTOP1001", "OrganizationCode": "INV_ORG_A", "Components": [ {"ComponentItem": "MOTHERBOARD", "Quantity": 1}, {"ComponentItem": "BATTERY", "Quantity": 1} ] }

Step 3: Map Source to Target Organization

Use a Data Mapper in OIC to change the organization context from INV_ORG_A to INV_ORG_B.

 TargetOrg = "INV_ORG_B" 

Also, apply transformations if the target org uses different item codes or UOMs.

Step 4: Create BOM in Target Org

Use the Fusion REST API to create or update BOMs in the target organization.

 POST /fscmRestApi/resources/11.13.18.05/itemStructures 

Sample Request Payload:

{ "ItemNumber": "LAPTOP1001", "OrganizationCode": "INV_ORG_B", "StructureTypeCode": "Primary", "Components": [ {"ComponentItem": "MOTHERBOARD", "Quantity": 1}, {"ComponentItem": "BATTERY", "Quantity": 1} ] }

In OIC, use the REST Adapter to invoke this endpoint, passing the transformed JSON payload.

Step 5: Add Logging and Error Handling

Implement structured logging for traceability:

• Log item number, source org, and target org.
• Log API response status codes and errors.

Add a Scope + Fault Handler in OIC for retries and fault notifications (email or Teams webhook).

Step 6: Validation and Reports

• Use GET API again for the target org to verify successful BOM creation.
• Generate a CSV report of successfully migrated BOMs.
• Send it as an email attachment from OIC.

---

🔗 Common Fusion APIs Used

API	Method	Description
/fscmRestApi/resources/11.13.18.05/itemStructures	GET	Fetch BOM/Structure details
/fscmRestApi/resources/11.13.18.05/itemStructures	POST	Create new BOM in target org
/fscmRestApi/resources/11.13.18.05/itemStructures/{StructureId}	PATCH	Update existing BOM

---

✅ Best Practices

• Use paging and filters while fetching BOM data for large item volumes.
• Maintain a mapping table (e.g., via lookup in OIC or database) for item number and org mapping.
• Implement idempotent logic — skip BOM creation if it already exists.
• Log integration run IDs for audit trail.

---

📊 Sample High-Level Integration Flow Diagram

 [SCHEDULE TRIGGER] ↓ [GET BOM from Source Org via REST Adapter] ↓ [Transform + Map Org Details] ↓ [POST BOM to Target Org via REST Adapter] ↓ [Validate + Log Results + Email Report] 

---

🧩 Summary

This integration helps Oracle Fusion Cloud users automate BOM and item structure replication between inventory organizations using OIC. It eliminates manual effort, ensures BOM consistency, and enables smooth manufacturing transfers across plants.

Using Oracle Integration Cloud’s REST Adapters, transformations, and fault handling, you can easily scale this to handle hundreds of items with audit tracking and notifications.

✨ Tip: You can extend this integration to migrate Work Definitions, Routing, and Cost Structures as well.

Periodic Cost Adjusment In Oracle Fusion Cloud

Periodic Cost Adjustment in Oracle Fusion Cloud — End‑to‑End Guide

By Akhil Sayed • Updated: October 7, 2025 • Cost Management / Inventory

Contents

• What is Periodic Cost Adjustment?
• Why it’s needed
• How it works — process
• Numeric example
• Accounting impact
• Where in Fusion
• Setup & considerations
• Best practices & FAQ

1. What is Periodic Cost Adjustment?

A Periodic Cost Adjustment is a period‑end correction that updates item costs and inventory valuation in Oracle Fusion when final costs become known after initial transaction postings. It’s used in Periodic Average Costing (PAC) or other period‑based costing methods where costs are finalized at period close.

In short: it trues up provisional costs (receipts-based) to actual costs (including invoices, landed costs, FX differences) so financials reflect true inventory value and COGS.

2. Why it’s needed

• Landed cost allocation: freight, duties, insurance allocated to received quantity after invoices arrive.
• Invoice price variance: supplier invoice differs from receipt price.
• FX revaluation: currency fluctuations that affect landed costs.
• Accurate financial reporting: Ensure inventory and COGS are not misstated at period end.

3. How it works — Periodic Costing flow

1. Capture all material transactions for period (receipts, issues, returns).
2. Receive supplier invoices and landed cost adjustments into the system.
3. Run the Periodic Cost Processor (or equivalent process) to compute final item costs for the period.
4. System calculates the variance between provisional and actual costs and creates Periodic Cost Adjustments.
5. Posting: the adjustment journals are generated and posted to GL (after review/approval depending on config).

4. Numeric example

Scenario:

• Received 200 units of Item X at provisional unit price $20 → provisional inventory = $4,000.
• Later, freight invoice of $200 and supplier invoice variance of $100 are received (total extra $300).
• Actual cost = $4,300 → new unit cost = $21.50.

Periodic Cost Adjustment amount: +$300 to inventory valuation (and corresponding variance account) for the period.

5. Accounting impact

Event	Debit	Credit
Periodic cost adjustment (increase)	Inventory Valuation	Cost Variance / Adjustment
Periodic cost adjustment (decrease)	Cost Variance / Adjustment	Inventory Valuation
When invoice posted later	Cost Variance (reverse)	Accounts Payable

Note: exact ledger accounts depend on your chart of accounts and costing setup (inventory valuation accounts, variance accounts, landed cost accruals, etc.).

6. Where to run this in Oracle Fusion

• Cost Management work area — Manage Periodic Cost Adjustments or Periodic Cost Processor.
• Run reports: Periodic Item Cost Report, Inventory Valuation Report, Cost Adjustment Journal.
• Review and approve generated journals before posting to GL (depending on business flow).

7. Setup & configuration considerations

• Enable the appropriate costing method (Periodic Average Costing) for the inventory organization.
• Configure landed cost elements and cost allocations if you use landed cost functionality.
• Define GL accounts for inventory valuation, cost variances, and landed cost accruals.
• Set period close controls: ensure all invoices/receipts for the period are entered before running the periodic processor.
• Decide on automation: schedule processing vs manual run for review control.

8. Best practices & FAQs

Best practices

• Keep a strict cutoff for period transactions and invoices to avoid frequent reopenings.
• Use landed cost automation to capture freight/duties timely.
• Reconcile inventory valuation reports to GL after posting adjustments.
• Document accounting policy for cost variances and reversals.

Frequently asked

Q: Can I reverse periodic cost adjustments?

A: Yes, but reversing usually requires reopening the cost period or running corrective adjustments depending on the system configuration and audit controls.

Q: Are periodic cost adjustments posted to GL?

A: Yes — the system generates adjustment journals that should be reviewed and posted to the General Ledger.

Q: What happens if I miss an invoice after period close?

A: You’ll need to correct via subsequent period adjustments or reopen the period (depending on your control policies). Frequent misses indicate process gaps in invoice capture.

© 2025 — All content original. Written for Oracle EBS / OIC professionals migrating to Oracle Fusion Cloud.

What is Consignment , Consignment Orders and Consignment Receipts in Oracle Fusion

Consignment Process in Oracle Fusion Cloud: Consignment Orders & Receipts (Step‑by‑Step)

By Akhil Sayed • Updated: October 7, 2025 • Oracle Fusion Cloud SCM

Quick links

• What is Consignment?
• Consignment Orders
• Consignment Receipts
• Consumption & Accounting
• Required Setup in Oracle Fusion
• Best Practices & FAQs

1. What is Consignment Inventory?

Consignment inventory is a model where the supplier retains legal ownership of goods stored at the buyer’s site until the buyer consumes them. In Oracle Fusion Cloud, consigned goods are received into inventory but remain on the supplier’s books until consumption triggers ownership transfer and invoicing.

Why companies use consignment: improves cash flow, lowers buyer’s working capital, and shortens replenishment lead times while ensuring availability of critical parts.

2. Consignment Orders (Purchase Order Behavior)

A consignment order is essentially a purchase order line flagged as Consignment. It records the intent to hold supplier-owned stock at buyer locations.

Lifecycle — at a glance

1. Create a consignment agreement with supplier (procurement contract).
2. Create a Purchase Order with consignment lines or a dedicated consignment PO type.
3. Supplier ships and you perform a consignment receipt.
4. Inventory is available as Consigned on‑hand.

System behavior

Action	Result
Create consignment PO	No immediate payable; PO lines marked as consigned
Receive consigned goods	On-hand increases (consigned), no ownership/accounting change
Consume items	Ownership transfers; create consumption advice; invoice posted

3. Consignment Receipts (Receiving Without Ownership Transfer)

Consignment receipt is the inventory receipt transaction that puts supplier-owned stock into a receiving locator or bin while preserving supplier ownership.

How to receive (short)

1. Inventory → Receipts → Receive Expected Shipments or Manage Receiving.
2. Select the consignment PO/ASN and perform the receipt.
3. Confirm quantities and complete the receipt; items become Consigned on-hand.

Tip: Use locator/bin controls to segregate consigned stock for easier reporting and cycle counting.

4. Consumption, Consumption Advice & Accounting

Consumption occurs when a consigned item is issued to production, a sales order, or an internal use. That event triggers the transfer of ownership, the creation of a consumption advice, and eventually supplier invoicing.

Accounting flow (simplified)

// When consigned goods are received
No accounting entry (supplier still owns stock)

// When consumed by buyer
Debit: Inventory (or COGS) — buyer
Credit: Consignment Liability (or Supplier Liability)

// When supplier invoice is received
Debit: Consignment Liability
Credit: Accounts Payable
      

Consumption advice

Oracle can generate consumption advice documents that list consumed items and quantities. These can be sent to the supplier automatically or manually depending on integration setup (B2B, EDI, or email).

5. Required Setup in Oracle Fusion Cloud

1. Enable consigned inventory functionality in Inventory Management (feature availability depends on your Fusion release and configuration).
2. Define supplier and consignment contract terms in Procurement Contracts.
3. Create consignment PO lines (set Consignment flag) or use a specific PO type for consignment.
4. Configure inventory locators/bins and choose an accounting treatment for consigned stock.
5. Set up integrations for consumption advice / invoicing (B2B/EDI or manual process).

If your implementation team needs help, coordinate Procurement, Inventory, and Finance to align accounting and operational controls.

6. Best Practices & FAQs

Best practices

• Keep consignment stock in dedicated locators and enable cycle counting for visibility.
• Agree on clear consumption reporting cadence with suppliers (daily/weekly/monthly).
• Automate consumption advice where possible to avoid invoice disputes.
• Track unit prices and valuation method to ensure correct accounting at the time of consumption.

Q: Does receiving consigned stock create a payable?

A: No — payables are created only after consumption or when an agreed billing event occurs.

Q: Can I return consigned stock to the supplier?

A: Yes — treat it like an inventory transfer back to the supplier and follow your receiving/returns process.

Q: How is consigned stock valued?

A: Valuation typically occurs at consumption by applying the agreed unit price. Ensure your accounting rules and item costing setup reflect this behavior.

© 2025 — Original content. Written for Oracle EBS / OIC professionals looking to migrate or document consignment processes in Oracle Fusion Cloud.

Activate OIC Integrations as programatcally

How to Activate the Latest Version of an OIC Integration Automatically

In Oracle Integration (OIC), each integration can have multiple versions. When deploying updates, you often need to activate the latest version automatically instead of doing it manually. This blog will guide you through creating an OIC integration that uses REST APIs to fetch the latest version of an integration and activate it with just one call.

🔹 Why Automate Activation?

• Speeds up DevOps and CI/CD processes.
• Reduces manual effort and human error.
• Makes deployments repeatable and reliable.

🔹 Key REST APIs Used

Purpose	HTTP Method	Endpoint
Get all versions of an integration	GET	/ic/api/integration/v1/integrations/{integrationId}/versions
Activate a specific version	POST	/ic/api/integration/v1/integrations/{integrationId}/versions/{version}/activate

🔹 Steps to Build the Integration

1. Create a new App-Driven Orchestration Integration
   • Name it ACTIVATE_LATEST_VERSION.
   • Add a REST trigger with /activateLatest (POST method).
2. Call the OIC REST API to Get Versions

   Use the REST Adapter to call the versions API and pass the integrationId (for example: MyIntegration).

3. Extract the Latest Version

   Use an Assign or Mapper step to filter the highest version from the response JSON.

4. Activate the Latest Version

   Use another REST Adapter invoke to call the /activate endpoint with the extracted version.

5. Send Confirmation Response

   Return a response back to the caller with details of the activated version.

🔹 Sample Activation Request

POST https://<OIC_HOST>/ic/api/integration/v1/integrations/MyIntegration/versions/05.01.0000/activate

Authorization: Basic <base64-encoded-credentials>

Content-Type: application/json

  

🔹 Sample Response

{

  "name": "MyIntegration",

  "version": "05.01.0000",

  "status": "ACTIVATED"

}

  

Pro Tip: Instead of hardcoding, make your integration accept integrationId as an input parameter. This way, the same integration can activate the latest version of any OIC integration.

✅ Conclusion

By leveraging OIC REST APIs, you can fully automate the activation of the latest integration version. This approach is highly useful in CI/CD pipelines, automated deployments, and reduces manual dependency in production rollouts. Next time you promote an integration, let OIC activate the latest version for you—automatically!