Translate

Thursday, February 20, 2014

Un - Assign Inventory Item From the Organization ORACLE

1. Go to Deletion Groups form.
Inventory: (N) Items > Delete Items
2. Define a deletion group.
3. Save.
4. To simulate the deletion press button Check Group.
5. See a concurrent request is launched, program name is BMCDEL.
6. Review the request log or review the errors in Deletion Groups form per the below steps:
1/ Query on the deletion group
2/ Go to tab Entities to Delete > Results
3/ For any record with Status=Error, press button Errors
7. When you are satisfied, press button Delete Group to delete the items.

Wednesday, February 19, 2014

Oracle SQL Operators Where Class

Operators in The WHERE Clause

The following operators can be used in the WHERE clause:


Operator
Description
=
Equal

<>
Not equal. Note: In some versions of SQL this operator may be written as !=

>
Greater than

<
Less than

>=
Greater than or equal

<=
Less than or equal

BETWEEN
Between an inclusive range

LIKE
Search for a pattern

IN

To specify multiple possible values for a column

Tuesday, February 11, 2014

When attempting to submit a request for the OPM Actual Cost process for the first period, you receive error :

 APP-GMF-86621: No inventory cal/period for this cost cal/period.

When attempting to submit a request for the OPM Actual Cost process for the first period, you receive error :
APP-GMF-86621: No inventory cal/period for this cost cal/period.

For actual costing, costing periods should be in synch with inventory periods as prior period balances and Item Costs are used in calculating the current Actual Cost. 

If they are not in synch - that is, if the Costing and Inventory Period start and end dates do not match - then you will receive the above error message.

Note that this needs to be true not only for the current Period (that is to say, the one for which you are trying to submit the Actual Costing request) but also for the previous Period.

The same message appears if the Inventory Period which equates to the Prior Costing Period has not been set up at all.  This scenario is only likely to arise when you are just setting up your implementation and are running Actual Costing for the first time.

When you are doing initial setup of Actual Costs by creating Item Costs in (for example) the Standard Cost method then copying those Costs to the Actual Cost method, you have to think in terms of this Period being Actual Costing Period 'Minus One' - it will not contain any Actual Cost transactions, only manually-copied Costs and possibly some on-hand balances created using Create or Adjust Immediate transactions.

You MUST NOT run the Actual Cost Processor against this Period, as this will destroy the manually-copied values (because there is no prior-period information).

All you are doing is setting up 'Prior Period Costs' so that when you DO run Actual Costing for the first time (in the next Period, Actual Costing Period 'One'), there are prior-period costs available for the program to use.