How to define custom sequence at DFF attributes level - Oracle Fusion

Fusion: Define Custom Sequence with DFF attributes

Goto Home > Select Setup and Maintenance Icon

 

Select Manufacturing and Supply Chain Material Management.

 

    1)      Select the shipping tab from the left panel.

    2)      Select ALL Task from LOV

 

Select ‘Manage Shipping Descriptive Flexfields’

 

Select the Search Button to find all available option.

Select Shipment for Edit.

 

Enter Details as per the screenshots

 

For Add or update Global Segment details

 

Default Value:

select trim(nvl(to_char(max(to_number(attribute1))+1,'00000000'),'10000001')) xx from wsh_new_deliveries where attribute1 is not null

and to_number(attribute1) >= 10000000

and REGEXP_LIKE(trim(attribute1), '^[[:digit:]]+$')

 

Now when you complete ship confirms process, it will automatically generate the sequence and insert into attribute1 value.

(Note: Sometimes due to browser cache issue sequence number will be duplicate)

Workflow PO Approval Error : Notify Preparer of No Approver Found

Workflow PO Approval Error: Notify Preparer of No Approver Found

Step 1: Create PO with following details.

 

Step 2: Add Shipment Information.

Step 3: save the transaction. Now PO Number generated.

 

Step 4: Click on the Approve button to Approve the PO.

Step 5: Login with Sysadmin user for Approve the PO.

                Navigation: Workflow Administrator Responsibility >  Administrator Workflow > Status Monitor

 

Step 6: Workflow seeded error

Error 1: Return PO to submitter

Error 2: Notify Preparer of No Approver Found

 

Step 7: Check PO Summary status for the same PO. Its Incomplete status because of Buyer is not listed in the Approval Group.

 

Step 8: Check the Buyer Position from HRMS responsibility.

 

Go to the Assignment tab by click on the Assignment button.

  

Step 9: Go to purchasing responsibility and check against this position Purchase Approval document type assigned or not.

Against this buyer Position no Document type for Purchase Order Approver available.

Step 10: Assign ‘Approve Standard Purchase Orders’ Document type against this position.

 

Step 11: Now Create new PO with same details, It will successfully complet with Approved status.

    

How to Assign Modified Oracle Custom Report (Data Model & RTF) to Seeded Report Request - Oracle Fusion

How to Assign Modified Oracle Custom Report (Data Model & RTF) to Seeded Report Request

Requirement: Required to assign modified ‘Pick Slip Report’ to Seeded pick slip request.

1  Step 1: Login to Oracle Fusion > Navigator > Reports and Analytics

    Step 2: Navigate to :  All Folders > Shared Folders > Supply Chain Management > Warehouse Operations > Pick Slips > Pick Slip Report

    Step 3: Click on the Report and Click Edit. A new Window opens. Attach the new custom Data Model.

    Step 4: Click on edit again and it will download the RTF or we can add a new layout and make it default layout.

    Step 5: Make new RTF as the default layout                

    Step 6: Make the necessary changes to the RTF and upload it to the same report.

   

    Step 7: Now you can able to use modified report by using seeded request.