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.
USe below program / ESS job
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
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.
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 > Enabled02. Manage Order Management Parameters
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
If you want to display the inventory orgs
as values set please refer below setup
Process
of Importing Manufacturers in Oracle cloud
The purpose of this document is to explain the step by step process of Importing Manufacturers in Oracle cloud. As compared to other data elements, Manufacturers cannot be imported by usual File-based Data import (FBDI) functionality or through Import Batches (specific to PDH). In earlier releases Manufacturers were imported through Oracle Sales Cloud Process using “Manage File Import Mappings” and “Manage File Import Activities” task from Setup and Maintenance. However, starting from 21A release, the process has changed and now Import Management workarea is used for bulk import of Manufacturers. Import Management improves definition, error handling, and performance for importing flat files (.CSV). For example, Import Management has drag and drop mapping capabilities and validates the first ten records in your data file before you import to ensure the data meets the import constraints of the various attributes. Following are the steps to bulk import Manufacturers in Oracle Cloud:
Step: 1 Go to Navigator and click on Import Management under
Tools. Here search for Organizations under Import Objects tab. Click on
download button to download the import template.
Step: 2 The downloaded template which is a Comma Separated
Values(.CSV) file has to be populated with the Manufacturer’s data that needs
to be imported. Below is the reference mapping for the required attributes. The
Spreadsheet will contain many other fields which can be removed as it is needed
for the Manufacturer import.
Save the .CSV file once all the data is populated as shown
below in sample screen shot:
Step: 3 Now to import the data, click on “Create Import
Activity” and create a new import. Select object as “Organization” and upload
the saved spreadsheet from the previous step
Click on Next and select “Automatic Mapping”. Validate the
data and then click on submit when ready.
Step: 4 After submitting the process, check the status under
Import Queue tab. Click All Imports and search for the import activity that you
created earlier. Check the Status column for the import activity. The import is
successful if the status displays as Completed. You can drill down on the
import activity to go to the Import Status page which provides the status
details of the import activity
Step: 5 After the process is complete, navigate to Product
Information Management work area and go to “Manage Trading Partner” task to
validate the imported Manufacturers. Click on Edit Trading Partners and search
for the imported Manufacturers
Points to Remember:
• Don't submit
duplicate import jobs for the same import object as they create duplicate
object records.
• Don't import more than 100,000 records in a single import
operation or perform more than five concurrent import activities
Delete Pricing Data from Interface Tables