Saturday, January 8, 2011
[PO] Organization And Location At Requisitions Form, Where Can We Set The Default Value For Those?
[SYS] FND_CONCURRENT.SET_COMPLETION_STATUS
[PO] Matching Setting in Purchase Order Shipment Line
In the list below, a setting at any level will override the settings above it.
1. Oracle Purchasing Options
a. Navigate to: Setup > Organizations > Purchasing Options
b. Select Default Alternative Region
2. Supplier Information
a. Navigate to: Supply Base > Suppliers
b. Query on specific supplier
c. Click on Open
d. Select Receiving Alternative Region
3. Line Types
a. Navigate to: Setup > Purchasing > Line Types
b. In the Receipt Required field: Yes = 3-way, No = 2-way
4. Items
a. Navigate to: Items > Master Items
b. Query on specific item
c. Select Purchasing Alternative Region
d. In the Invoice Matching section: Yes = 3-way, No = 2-way
5. Purchase Order Shipments
a. Navigate to: Purchase Orders > Purchase Orders
b. Enter (header and) line information
c. Click on Shipments button
d. Select More Alternative Region
Thursday, January 6, 2011
[OM] Allocation Error During Transact Move Order
[INV] Pending Transactions Table - MTL_MATERIAL_TRANSACTIONS_TEMP
NULL or 1: Online Processing
2: Concurrent Processing
3: Background Processing
8: Internal Processing (Not visible in the pending transactions form)
EXPLANATION
Here is an explanation of each:
NULL or 1: Online Processing
Online processing is used by the Oracle Applications to immediately process records. This does not require that a concurrent program be run. The Transaction Manager does not process transactions marked for online processing.
2: Concurrent Processing
Transactions marked as concurrent transaction mode are processed by a dedicated transaction worker to explicitly process a set of transactions. The Transaction Manager does not process transactions marked for concurrent processing.
3: Background Processing
Interface transactions marked for Background processing will be picked up by the transaction manager polling process and assigned to a transaction worker. These transactions will not be processed unless the transaction manager is running.
8: Internal Processing
Transaction mode 8 is not a mode normally visible to the user as it is used for internal processing. Transactions with this mode are not visible in the Pending transactions form. Transaction_mode of 8 is used internally to identify if records came from the interface table to the pending table or came directly into the pending table.
......
In short, resetting of transaction_mode to 3 will allow Inventory Manager to reprocess the pending records
Sample SQL:
update mtl_material_transactions_temp
set process_flag = 'Y',
lock_flag = 'N',
transaction_mode = 3,
error_code = NULL,
error_explanation = NULL
where process_flag in ('Y','E');
[INV] Reservations Interface Manager
Wednesday, January 5, 2011
[PO] Where to Setup Invoice Matching Option?
[PO] R12 Purchasing Options
Monday, January 3, 2011
[PO] Self-Billing Flag in PO table
[PO] APP-PO-14376: Please enter a GL Date within an open purchasing period
[PO] Can I Setup Only Document Total Rule in Approval Group
[PO] Source Field in Purchase Requisition (PR) Screen Does Not Show "Supplier"
[PO] BPA Price Break - Discount (%) field
[SYS] How to Revert My Start Page?
[PO] Missing Purchase Order (PO) Distribution After RTV - FIXED
SELECT fi.file_id
,filename
,version
FROM apps.ad_files fi, apps.ad_file_versions ve
WHERE filename LIKE 'PAPOUTLB.%'
AND ve.file_id = fi.file_id
AND REPLACE(version, '.','') =
(SELECT MAX(TO_NUMBER(REPLACE(version, '.', '')))
FROM apps.ad_file_versions ven
WHERE ven.file_id = fi.file_id);