BI Publisher Reports for Oracle Applications

BI Publisher Reports for Oracle Applications

Query to get Interesting details about tables

Query to get Interesting details about tables



  select table_name, tablespace_name, num_rows, blocks,
       round((blocks *
              (select value from v$parameter where name = 'db_block_size')
                 )/1000000,1)||'M' as SIZEB
from dba_tables
where table_name in
      ('OE_ORDER_LINES_ALL',
       'OE_ORDER_HEADERS_ALL',
       'OE_PRICE_ADJUSTMENTS',
       'OE_PROCESSING_MSGS',
       'OE_PROCESSING_MSGS_TL',
       'WSH_EXCEPTIONS',
       'WF_ITEM_ACTIVITY_STATUSES',
       'WF_PROCESS_ACTIVITIES',
       'WF_ITEMS')
order by 1;

RMA flow for Drop Ship Orders in Oracle Application.-1

RMA flow for Drop Ship Orders in Oracle Application.-1

This Presentation is 2 Part , please check part 2 too

RMA flow for Drop Ship Orders in Oracle Application.-2

RMA flow for Drop Ship Orders in Oracle Application.-2

This is 2 part presentation , check part -1 at Part-1

How to Define and Progress KIT in Oracle Order Management.

This youtube Post is about How to Define and Progress KIT in Oracle Order Management.

Adding lines in a Closed Order to fulfill business Requirement

Recently someone asked
---
They have order which have 5 lines, 2 lines we shipped and invoiced successfully , remaining 3 lines accidently cancelled and order is also closed.

Now Business has need to Ship and fulfill those 3 lines that got cancelled accidently, business don't want to create New Order.

 

Solution - Though Not supported by Oracle , reason - we need to do an update on OE_ORDER_HEADERS_ALL table.

 

OPTION # 1

Once an Order is Closed it is not advisable to open the Order because Work flow is closed and open Flag = N, so good idea is to let this order closed and create a New Order.

OPTION # 2 

Open the Order by setting open-flag = Y , but do not do any thing with workflow , let it be close ,Now add new lines to the Order , and then progress the newly created lines, at any moment of time , please not try to open the lines that are accidently closed , believe me that will be very messy .

Option #2 is advisable only and only if you don't have header level invoicing , but if you have header level invoicing then do not try to open the Order header . 

Once New lines are shipped and close we need to set the OPEN_FLAG= N at the Order Header Level manually again , as system will not  close the Order header ( reason , workflow is already closed).

 

 

Inter company transaction flow types.

There are two Inter company transaction flow types.

1. Shipping and 
2. Procuring.

A shipping flow is setup between two operating units of type shipping. You use the shipping flow when the shipping operating unit differs from the selling operating unit on the shipping document.

A procuring flow is set up between two operating units of type procuring when the receiving operating unit differs from the procuring operating unit on the receiving document. This type of flow indicates that the operating unit that created the PO differs from the operating unit that receives the PO.

Command to check the architecture of your Window Operating System

Command to check the architecture of your Window Operating System

 wmic os get osarchitecture