Not able to see the inventory org while trying to define the shipping parameters

 Not able to see the inventory org while trying to define the shipping parameters 

Oracle Fusion Cloud 

FSM Task : Manage shipping parameters 

Issue : 

search for Inventory org ( LOV is null) 

Resolution 

Check if you have access to the inventory org for the below role

we need to have role : warehouse Manger - context : inventory org and provided inventory org which is missing. 

Error: Value for the NAME, LOAD_REQUEST_ID, or INTERFACE_STATUS attribute is invalid. (QP-2715488)

 Error: 

Value for the NAME, LOAD_REQUEST_ID, or INTERFACE_STATUS attribute is invalid. (QP-2715488)

If you are trying to update the item price/ Item attribute price then use the Batch template

PriceListsImportBatchTemplate.xlsm

the actions supported are as below 

CREATE, UPDATE, or NO-OP. Use No-Op to link a parent entity to a child entity.

how to delete pricing data from the interface table in oracle fusion cloud

 USe below program / ESS job 

Delete Pricing Data from Interface Tables Parameter only option :ORA_ALL_IMPORT

Max number of line on the PR, PO and BPA in oracle fusion

 Max number of line on the PR, PO and BPA in oracle fusion 

suggests :
Requisitions UI: 500
Requisitions using FBDI: 3000

Purchase orders UI: 500
Purchase orders Using Rest API/ Webservice: 200
Purchase orders using FBDI: 3000

Blanket purchase agreements UI: 500
Blanket purchase agreements using FBDI: 10000

Not able to see the EFF attributes on sales order approval

 

Manage Order approvals

Issue : Not able to see the EFF attributes

 

What to do :

BPM work list  or

Manage Task Configurations for Supply Chain Management

If the flex fields setup has been modified recently, Please follow the below steps to synchronize the EFF, such that they are available in the Manage Order Approval Rules task.

1. In the BPM Worklist area, search for SalesOrder, then click ApprovalHumanTask.
2. GoTo General Tab --> Click on pencil icon (edit view), If you have modified your flex field set up, then you will see a warning message with "Start Synchronization" button(see in attached screen shot).
3. Click on "Start Synchronization" button to synchronize the EFF, this will take some time to complete and message will be disappeared.
4. Click on save and then commit, You will now retrieve the attribute in Manage Order Approval Rules.

Auto depletion of the inventory for the sales order interfaced from the POS in oracle fusion

 

Topic : Sales order depletion of inventory without picking and shipping activity

Use case: Oracle cloud Order management is implemented to any Supermarket like Walmart etc. in which all sales happened as POS. and on periodic basis it will be interfaced to the source systems in that case, we can use the below option as already sale is done and only we need to deplete the inventory for books and tracking.

Setups

1.      01. OM opt-in feature enabled> Order management 

Reduce Inventory when a sales order does not require picking and shipping >  Enabled 

02. Manage Order Management Parameters

Process Inventory Transactions Immediately  : Yes

Process Inventory Transaction Lines as a Group  : Yes / No based on customer requirement

Inventory Transaction Date for Order Lines :Current date  based on customer requirement

03.Orchestration process deployment and assignment.

DOO_InventoryTransactionProcess   > deployee

04.   Orchestration process assignment rule

If  Allow inventory Transaction is Yes  

then Process :  DOO_InventoryTransactionProcess

05. Manage Pretransformation Defaulting Rules

if order type :XXXXXX 

then Allow inventory Transaction to Yes

Test: 

On sales order : 

we need below attributes updated 

00. Allow inventory transaction to yes

01. Warehouse 

02. Sub inventory 

03. Stock locator

04. Lot/ serial 

Creating a Value set for the supplier’s name as LOV

 

Creating a Value set for the supplier’s name as LOV for which in DFF we have done restriction to display only 120 characters only:  (Use the Substring function while creating Value set.)

 

The value set BSP_VENDOR_NAME cannot be assigned to the global segment Vendor. (FND-2627)
In application 667 and descriptive flexfield QP_PRICE_LIST_CHARGES_FLEX, value set BSP_VENDOR_NAME cannot be assigned to global segment Vendor which uses column ATTRIBUTE_CHAR1. The assigned value set must have a data type that is compatible with the column data type and its maximum length must be no longer than the column length and its validation type must not be view object.

Issue : Value Column Length:360

Solution:

From Clause : POZ_SUPPLIER_V

value column name: Substr(vendorname,1,120)

If you want to display the inventory orgs as values set please refer below setup

From Clause : INV_ORG_PARAMETERS

value column name: ORGANIZATION_CODE