Labels

[ALRT] (3) [AR] (2) [BOM] (3) [GL] (2) [GTM] (1) [INV] (18) [MRP] (1) [OM] (27) [PO] (58) [QP] (3) [SYS] (39) [WIP] (4) AGIS (1) OM (1)

Monday, January 24, 2011

[SYS] Given a List of Records (varchar) Returned From a SQL Statement, Which is Ordered First, Which is Ordered Last

Given below SQL,

SELECT
category_concat_segs
FROM apps.mtl_categories_v
WHERE structure_name LIKE 'Purchasing%'
AND disable_date IS NULL
AND category_concat_segs LIKE 'ABC.DEF%'

Return results were,
ABC.DEF1
ABC.DEF2
ABC.DEF3
ABC.DEF4
ABC.DEF5

I want to get only 'ABC.DEF1' & 'ABC.DEF5' from a single SQL statement. These will be used for my Item Category approval rule setup in Approval Group, low range and high range respectively.

Revised SQL below:
SELECT MIN(category_concat_segs), MAX(category_concat_segs)
FROM apps.mtl_categories_v
WHERE structure_name LIKE 'Purchasing%'
AND disable_date IS NULL
AND category_concat_segs LIKE 'ABC.DEF%'

[BOM] How Many Levels of Bills You Defined?

Sample Bills of Material (BOM) structure:
A
|
B
|
C D

Often, this is the frequent asked question. Take above example, Oracle says it has 2 levels, not 3.

[BOM] Delete Groups

I was trying to delete a component from a Bill. When i clicked on Delete button, "Delete Component" popped up and prompted me to enter " Name" and "Description", a button named "New Group" is situated next to the "Name" field. How can i proceed from there?

"Delete Groups", a control built in in BOM module to trace what and when a record has been deleted. In short, each deletion is traceable by the Delete Group name.

To proceed with the deletion, click "New Group", enter the Name (mandatory) and Description (optional), save it. Then, go back to the Navigator, Delete Groups, query out the record by Group Name. On the main screen, you can see your parent item. Click on "Components " button, you can see the component that you want to delete, with status "Pending". There are 2 buttons, namely "Delete Group" and "Check Group ".

As the name spelt, "Check Group" is to check the integrity of your Delete Group, concurrent program "Delete Item Information" will be submitted once you click on that button. View Output, you will see a "Success" message if the check is OK. Component status will change to "Check ok" after that. NO deletion will be performed.

You can skip "Check Group" and proceed direct to "Delete Group". Once clicked, the same concurrent program will be submitted and this time deletion will be performed (different parameter from " Check Group"). Component status will be changed to "Deleted".

The same procedure applied to routing component deletion.

[PO] What Are The Steps Required To Setup An Internal Requisition In Purchasing?

Excellant note. A simple and easy-to-understanding guide from Oracle Support, Note:406312.1.

A quick glance and I leant something new, Receiving for IR can be automated if we set the Receipt Routing to "Direct" in Shipping Networks .