This is the complete error in alert log:
ORA-1632: max # extents 1010 reached in index APPLSYS.SYS_IOT_TOP_246099
The simplest fix to this is to set the max extents to unlimited, which gives you a huge number of extents
ORA-01632 Max No Of Extents Reached In Index APPLSYS.SYS_IOT_TOP_173398 (Doc ID 295039.1)
Xoxo,
Gigi
Problem Description
User try to create PO revision with value lower than previous PO value.
But when try to save the revision, error messages show up: APP-PO-14434: Quantity ordered cannot be less than quantity billed.
While, new qty order is more than qty billed.
What happened and how to solve this?
Data Collection
PO_LINE_LOCATIONS
==================
Quantity : 296875762500409
QUANTITY_BILLED :28.5000000116121
Test Development
CREATE TABLE PO_LINE_LOCATIONS_ALL_BK
AS SELECT * FROM PO_LINE_LOCATIONS_ALL
WHERE LINE_LOCATION_ID=86852
AND ORG_ID = 81
UPDATE PO_LINE_LOCATIONS_ALL
set QUANTITY_BILLED=28.5000000116121
WHERE LINE_LOCATION_ID=86852
AND ORG_ID = 81
Now try the ordered quantity to 296.875762500409 it will allow.
Result
Succeed
xoxo,
Gigi
Error/Uncosted/Pending Material Transactions
Purpose
Below mentioned set of script is specifically used to identify any pending or uncosted transactions which stops the Inventory period closing or Cost Manager activities of costing the transactions.
These scripts are best suited for any Inventory Organization which is using “Average Costing method.”
On the basis of the script output, further analysis can be made which will resolve the errors which will be output from these scripts.
Software Requirements/Prerequisites
These scripts can be used on SQL Developer, SQL*PLUS
Configuring the Script
These scripts can be used on any instance to check whether there are pending and uncosted transactions.
Running the Script
1) This script output will give the number of error transactions that need to be resolved. Without resolving these transactions, cost manager will not cost the transactions which are uncosted. This list will be for all the Inventory Organizations in that legal entity.
Select * from Mtl_material_transactions where costed_flag = ‘E’
2) This script outputs the list of uncosted transactions.
Select count (*) from Mtl_material_transactions where costed_flag = ‘N’
3) This script output gives transactions which are pending for costing . These are pending resource transactions. These transactions also will not get costed unless and until ,errored transactions are costed.
Select * from wip_cost_txn_interface
4) This script outputs the list of pending uncosted transactions.
Select count (*) from wip_cost_txn_interface
5) This script output will generate error code and error explanations for the errored resource transactions. The same can be seen from the Pending Resource Transactions form from the WIP responsibility.
Select * from wip_txn_interface_errors
6) This script output gives the list of transactions for the errored resource transactions which are stuck in the wip interface table.
Select *
from wip_txn_interface_errors
where transaction_id IN ( Select transaction_id from wip_cost_txn_interface)
7) This script should give the details about the errored resource transactions . This will state the Wip_entity_id , organization_id and process_status and process_phase of the concerned transactions.
Select *
from wip_cost_txn_interface
where transaction_id in (Select transaction_id from wip_txn_interface_errors)
8) This script output retrieves the list of errored transactions in the Inventory module at overall level.
Select *
from mtl_material_transactions_temp
where error_code is not null and error_explanation is not null
9) This script outputs the list of pending material transactions.
Select count (*) from mtl_material_transactions_temp
10) Output of diagnostics script, CstCheck.sql (see Note 246467.1) is for diagnosing any cost management related issue. Gives overall setup related information.
11) To know the Cost manager status this script can be used. Output of this script is Request id, phase code and Status code.
SELECT request_id RequestId,
request_date RequestDt,
phase_code Phase,
status_code Status FROM
fnd_concurrent_requests fcr,
fnd_concurrent_programs fcp
WHERE fcp.application_id = 702 AND
fcp.concurrent_program_name = ‘CMCTCM’ AND
fcr.concurrent_program_id = fcp.concurrent_program_id AND
fcr.program_application_id = 702 AND fcr.phase_code ‘C’
Xoxo,
Gigi
Funny Pictures: Over Receipt PO
xoxo,
Gigi
I’m Sorry, I make a mistake
Dear Monsieur S,
I’m deeply apologizing to you, because I made a mistake.
I’m not really carefully check the data in P&L Division, your division, and for that I bravely said it was my fault.
It is a big mistake I made so far. No argument left.
This open apology is a reminder for me to taking care of what I like very carefully in the future.
I really understand that you won’t let it slide easily.
Anyway, with or without your understanding, I am deeply terribly apologizing.
With Regards,
G
Oracle Inventory: Destination Type
Destination Type:
The Destination Type column in the Receipt form and the Receiving Transactions form show where the receipt will need to go next to be processed. When the destination type shows Expense, Shop Floor or Inventory, the transaction being entered will be the final transaction or the deliver transaction needed to complete the receiving process. When the destination type shows receiving then the receipt routing is either Standard or Inspection Required, meaning more than one step is needed before the items are delivered.
Destination Type Values:
Receiving: Value displayed when Receipt Routing is Standard Receipt or Inspection Required. The Receiving Transaction form must be used for goods to be delivered.
Expense: Value displayed for an Expense Item or a One-Time Expense Item. Subinventory, Locator, Lot Number and Serial Number entries are not appropriate, therefore not allowed.
Inventory: Value displayed for an Item which will have quantity tracked in Inventory.
Shop Floor: Value displayed for an Outside Processing Item which will be delivered to the shop floor for completion of a wip job.
Note: the Destination Type can be changed if the following profile is set to Yes: ‘RCV: Allow routing override’
XOXO,
Gigi
Gigi Desmarais
