[PO] Organization And Location At Requisitions Form, Where Can We Set The Default Value For Those?

Both values are default from the Employee setup. In Purchasing responsibility, navigate Setup -> Personnel -> Employees, click "More ..." button, move to "Assignment" tab, enter it at Location field.

[SYS] FND_CONCURRENT.SET_COMPLETION_STATUS

To set concurrent program completion status, use FND_CONCURRENT.SET_COMPLETION_STATUS in your SQL file. However, will it work if your executable is PL/SQL package? Yes, it will still work but you need to define 2 extra parameters in your procedure (first 2).

e.g.

Procedure XXX (errbuf VARCHAR2(100), retcode INTEGER, ...)

[PO] Matching Setting in Purchase Order Shipment Line

Invoice matching can be set in five different areas of Oracle Purchasing:
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

Above notes are reproduced from Oracle Support Note:225630.1.

[OM] Allocation Error During Transact Move Order

"Error: The material sourcing process failed to create picking suggestions for line 2 of move order number 59641464"

"APP-INV-05297: Invalid transaction and serial control combination"

Encountered the above error message after clicked on "Allocate" button in Transact Move Orders form. Even after I backordered the line, I could not proceed to Pick Release, failed Pick Release.

Root Cause: Item lot reserved for the order line is no more valid.

Action: Unreserve the invalid item lot, pick release, transact move order & ship confirm successfully.

[INV] Pending Transactions Table - MTL_MATERIAL_TRANSACTIONS_TEMP

An excerpt from a good Oracle Support note [ID 294391.1]:

Transaction Mode Number / Description

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');