E1: 34: Supplier Schedule Print - R34450 Always Shows 'Cum Raw Material' on the Header Section of the Report as a Blank Value (Doc ID 2942246.1)

Last updated on APRIL 13, 2023

Applies to:

Symptoms

There is an issue with the Supplier Schedule Page/Level Break Header Group section of the report. Within the Do Section of the event rules the report variable, RV Cumulative Raw Material is calling report variable VA rpt_CumulativeRawMaterialUnits, whereas this variable is actually defined as VA rpt_F4321CumRawMaterialUnits and is being obtained via the F4321 Get Vendor Schedule function within the Do Events of the Report Item Branch Group section.
When creating a Supplier Schedule (R34400) that results in a schedule with an 'M - Raw Material' Time Fence, the Supplier Schedule Print - R34450 prints the 'Cum Raw Material' value in the header section of the report as a blank.

The issue can be duplicated at will using the following steps:

1. P4101 / P41026 – Create a purchased item (Stk Ty = P, Ln Ty = S).
2. P4105 – Define Unit Cost for both Sales/Inventory and Purchasing Cost Methods for the purchased item.
3. P4106 – Define Unit Price for the purchased item.
4. IV - Copy P4310_ZJDE00006 to a different named version, using the following setup:
   Defaults Tab, processing option # 1. Order Type = OB
   Interface tab, processing option # 4. Quantity Update = 1
   Processing tab, processing option # 4. Blanket Releases = Blank.
5. P4310, named version - Create an OB order for the above purchased item; make sure to set the dates on the blanket order far enough into the future.
6. P4321 – Set the Supplier Information and Schedule for the above blanket order:
   Vendor Schedule D/W/M = Weeks;
   Number = 52;
   Frozen Days = 4;
   Fabrication Days = 60;
   Raw Material Days = 85;
   Releasable Days = 35.
7. P43212 – For the Shipment Pattern fill in the Effective From / Thru; Check ‘All Work Days’ option and set ‘Recur Every Weeks (s)’ option to ‘1’.
8. P3460 – Create weekly forecast records for e.g next 3 months.
9. R3483 – Run MRP to generate planning messages.
10. P3411 - Review order - O messages to create multiple OP orders; do not process MRP messages.
11. R34400 – Generate Supplier Schedule.
12. P34301 – Review the Vendor Schedule details and see that R34400 created records for Fence Flag F = frozen, R = Release, L = Fabrication and M = Raw Material.
    For this example all quantities summarized for R and L buckets represent Cumulative Fabricate units and all quantities summarized for R and L and M buckets represent Cumulative Raw Material units.
13. P34301 - Cumulative Info tab on the header of the Supplier Schedule shows: Cum Fabricate (units) = 41.00 and Cum Raw Mat. (units) = 68.00.
14. P4321 – Other Information tab on the Vendor Schedule Master has been updated with Cum Fabricated (units) = 41.0000 and Cum Raw Material (units) = 68.0000.
15. P3411 – Review all MRP messages and noticed that are processed correctly (processed flag Y).
16. IV > P4310 – Create a copy of P4310 ZJDE0001; in the 4-Processing tab change the processing option # 4. Blanket Releases = 2.
17. BV: R34410 – On the R34410 Versions tab, set the P4310 version created at the previous step.
18. R34410 – Run the UBE to create purchase orders for the corresponding MRP messages, released against the existing OB order.
19. P34301 – The Supplier Schedule is now updated with the quantities on the Released QTY bucket. Receipt Info tab on the header of the Supplier Schedule had the ‘Last Rls P.O.’ field updated with the new OP number.
20. P4321 – Other Information tab on the Vendor Schedule Master is also updated with the PO # (e.g. 558) on the Last Release PO field.
21. R34450 – Print the Supplier Schedule and see that the header of the UBE shows the Cum Raw Material as blank. However, the Cum Fabricated value is retrieved correctly from the P4321 = 41.0000.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.