Mandatory Profile Options in order to setup Oracle iSupplier

Important (Must have) Profile options to setup Oracle iSupplier module 

This article will allow you to have an idea of all the important profile options and their values. 

Go through it and let us know if there are any more details required.

Profile options	Value	Description
RCV: Fail All ASN Lines if One Line Fails	No/Yes Default :No	Indicates whether the creation of ASN/ASBNs in Oracle Internet Supplier Portal will fail all ASN lines if one line Fails.
POS: Limit invoice to single PO	No/Yes Default: No	Indicates whether an Invoice created in Internet Supplier Portal will be limited to the shipments belonging to a single Purchase Order
POS: Invoice Unit Price change for Quantity-Based Matches	Allowable type of price Change.	Whether the user is allowed to change the unit price when creating purchase order-based Invoices.
POS: Allow Invoice Backdating	Yes/No	Whether the use is allowed to backdate the invoice such that the invoice and the purchase Orders have different dates.
POS: Default Promise date acknowledgement	Yes/No	If the promise date is null, whether the promise date defaults to the need-by date after supplier's Acknowledgement.
POS: OSN Hub	Hub name	The name of the pre-defined hub for communication with Oracle Supplier Network. The hub is defined in Oracle XML Gateway.
EDR: E-Records and E-Signatures	No/Yes	Indicates whether E-Signature functionality has been enabled
POS: ASL planning attribute updates from supplier approved by	Buyer's Approval Required Planner's Approval Required No Approval Required	Indicates the person whose approval is required when supplier submits changes via Order Modifiers and Maintain Capacity functionality
POS: ASN Shipment Display Period	Number of days
Default load setting for number of sites allowed to be created during address approval		Limits the number of sites that can be created during a single address approval operation.

How to permanently enable 'Show Line Details' checkbox at sales order line into oracle apps?

If you are performing Order to Cash cycle for Kit items or other configurations, and you want all the Kit components exploded on sales order line, then this article may help you. 

During my solution designing for one of my client, I found that I need to go on sales order line every time and need to check on 'Show Line Details' to get the Components details on sales order line. 

But Oracle is providing one Profile option which can drive the behavior of that checkbox automatically. For further details follow the below testcase. 

Initially, I can see only the Kit item without its components. Because 'Show Line Details' is not checked. 

Now, I will check 'Show line Details' and I have all the components at Line level. 

So, this is how we can have all the components of kit item defaulted on sales order line level.  

But the main point of this article is to share the information of getting this automated for all the sales order. In real world, we are not going to check this flag each and every time manually as its not feasible for CSR team/users. 


Oracle is providing one profile option for that named 'OM: Show Line Details'. You can set it at Site, Responsibility or User level to leverage the functionality. I have setup it at site level and you will get this flag as checked for all the sales orders. 




If you like this blog, kindly follow me to get another exiting features of Oracle applications.

Credit Check functionality in Oracle applications functional

Credit checking feature of Oracle OM provides the ability to check that the customer has sufficient credit available with the organization at the point of order booking ,picking, packing and shipping. Credit check rules, order transaction type, payment terms and credit profiles are the key setup entities that influence the credit check process.

Oracle OM credit checking includes:

• Validating orders and lines against existing credit limits defined in the credit profile.
• Placing credit holds at either the order or line level.
• Sending credit hold notifications to order creator.
• Automatically apply or release order or order line credit holds using credit check processor program.
• Reporting and querying tools to effectively manage your credit processes and ensure credit holds are processed in a timely manner.

Main purpose of Credit checking process is to minimize the financial risk that the organization assumes as a result of day-to-day transactions.

For Detailed setup of this functionality kindly check below video. It has covered all the mandatory setups required to have this functionality. Also, It has one test cycle included into it. 

Consigned Inventory in Oracle Applications Setup & Process

Consigned Inventory is an inventory which is in possession of Customer but the items lies in it is owned by Supplier.

To perform this concept in Oracle Apps, following setups required.

Make new item for consigned inventory, item template is Purchased Item and tick on Use Approved Supplier in Purchasing tab, also enable Consigned Check box in General Planning Tab.  

 

 And then save it and assign the item to organization.

Now we need two subinventories, one for Asset sub inventory which is in possession of Customer and one for Expense in which supplier puts item. Expense subinventory will be placed in Customer Premises but possession of that subinventory will be to Supplier.

For creating subinventory go to Inventory > Setup > Organizations > Subinventories

And then create new subinventory (Asset subinventory).

 

Now define Expense subinventory 

 

At supplier site, we need to setup in self billing section. 

Navigation: Purchasing > Supply Base > Suppliers 

Set Pay On = ‘Use’ and Invoice Summary Level = ‘Pay Site’

  

After doing setup at supplier level we need to create Blanket Purchase Order between Supplier and Customer.

Navigation: Purchasing > Purchase Order > Purchase Orders

 

 Then it will go for Approval. 

After creating BPA, Define consumption transaction rules and selected transfer type as Subinventory Transfer, given weight as 10, Entered Owning Party details, Entered from & To Sub inventory details and item details.

Navigation: Inventory > Setup > Consigned/VMI Consumption

 

In Approved Supplier List, we need to setup for ‘con_01’ for Supplier ‘Manual Supp01’

Navigation: Purchasing > Supply Base > Approved Supplier List

 

 Now go to attributes, Source Document Tab

 

At inventory tab, tick on Consigned from Supplier 

 

Now all setup regarding Consigned Inventory has been done. 

Process: create Standard PO for same supplier and item.

  

Go to shipments tab,

 

Here consigned tab is checked.

Submit for approval that PO.

 

Now receipt the ordered item

 

Receive the items, receive items at CON_EXPENS subinventory.

 

Now items are received and in the CON_EXPENS subinventory which is Expense subinventory, under the possession of Supplier.

Created Consigned Transaction and Selected Transaction Type as “Transfer to Regular “.

Go to Inventory > Transactions > Consigned Transactions

 

Perform the transaction And save it.

Now, Run the concurrent “create consumption advice”

Run the concurrent Pay on Receipt Auto Invoice with a transaction source of “ERS_AND_USE” for our inventory receipt number.