It is caused by a extra Oracle module that we have integration with, GLOBAL TRADE MANAGEMENT (GTM). GTM will do the screening and feedback to EBS that whether this order line has passed the screening rule. If Yes, order line status will changed to "Awaiting Shipping". If Not, order line status will remained as "Awaiting Export Screening", and as a result, you cannot proceed with Pick Release.
Thursday, December 8, 2011
[GTM] R12: Awaiting Export Screening
It is caused by a extra Oracle module that we have integration with, GLOBAL TRADE MANAGEMENT (GTM). GTM will do the screening and feedback to EBS that whether this order line has passed the screening rule. If Yes, order line status will changed to "Awaiting Shipping". If Not, order line status will remained as "Awaiting Export Screening", and as a result, you cannot proceed with Pick Release.
Friday, December 2, 2011
[QP] R12: BACK_CALCULATION_ERROR: QP_PREQ_PUB.BACK_CAL: NO MANUAL ADJ
Fix => Define Discount Modifier, set it to Manual, Modifier Type = Discount, Override flag = Yes. Assign it to the right Qualifier.
[OM] R12: Sales Agreement Activation Date
We can controls how the Sales Agreement get applied (similar to functionality of Qualifier in Price List). At the Main tab, we can defined Item Context, which controls how the Sales Agreement take effects. At the Pricing tab, it can links to Price List, which will get defaulted when Sales Agreement is selected.
Note:
Activation Date in Sales Agreement, it is the effective start date (OE_BLANKET_LINES_ALL.START_
Thursday, November 17, 2011
[SYS] R12: Enable Audit Trail
Step to enable AuditTrail:
(1) AuditTrail->Install
ONT Oracle Order Management Account
(2) AuditTrail->Groups
Application Name: Order Management
Audit Group: XX_ABC_GROUP
Group State: Enabled
...
User Table Name: OE_ORDER_LINES_ALL
(3) AuditTrail->Tables
User Table Name: OE_ORDER_LINES_ALL
Table Name: OE_ORDER_LINES_ALL
Application: Order Management
Column: UNIT_SELLING_PRICE, etc
After completed above steps, run "AuditTrail Update Tables". It will then add additional columns into the table and create a new trigger on it.
Schedule "Audit History Consolidator" to collect the audit data.
Thursday, November 10, 2011
[PO] R12: Sales Order Reference in PR Interface Table
How to trace back the original SO number from this table?
Get GROUP_CODE, which is reference back to the Sales Order header_id.
[QP] R12: Modifier: New Price
Original List Price and Unit Selling Price is $10, a qualified modifier with value of $20. When this modifier applied, we will get Unit Selling Price of $20.
Oracle Pricing Manager
Modifier->Modifier Setup->Modifiers Summary->Override=Yes
Modifier->Modifier Setup->Discount/Charges->Modifier Type=Discount
Modifier->Modifier Setup->Discount/Charges->Application Method=New Price
Wednesday, November 2, 2011
[OM] R12: Intercompany Pricing
e.g.
A & B represent 2 different OUs within same organization.
A sells to B.
B sells to external customer.
B is defined as internal customer for A. A will issue Intercompany AR invoice to B.
We can define interco price list to be tied to the internal customer B.
Customer -> Address -> Business Purposes -> Bill To -> Order Management -> Price List
Tuesday, November 1, 2011
[AR] R12: Customer Name Search
[SYS] R12: Browser Crashed When Both R11i and R12 Runs Concurrently
I opened R12 instance. Then followed by launching R11i applet in the same machine, browser crashed. Both R11i and R12 can't be opened at the same time.
Issue fixed after I turn off "Proxy Server" in IE.
Tools->Internet Options->Connections->LAN settings
Monday, October 31, 2011
[SYS] R12: Profile Option, Enable Advance Pricing for Intercompany Invoice
Note that additional license needs to be purchase from Oracle.
Wednesday, February 16, 2011
Monday, January 24, 2011
[SYS] Given a List of Records (varchar) Returned From a SQL Statement, Which is Ordered First, Which is Ordered Last
[BOM] How Many Levels of Bills You Defined?
[BOM] Delete Groups
[PO] What Are The Steps Required To Setup An Internal Requisition In Purchasing?
Wednesday, January 19, 2011
[SYS] Security Rule - Block From Entering, What About Viewing?
[PO] Position Hierarchy Used for PR/PO Approval
SELECT approval_path_id FROM apps.PO_ACTION_HISTORY WHERE object_id in (SELECT requisition_header_id FROM apps.PO_REQUISITION_HEADERS_
Link approval_path_id to HR.PER_POSITION_STRUCTURES table to get hierarchy name used.
[PO] Receiving for PO with Status "Requires Reapproval"
[SYS] Login Page Filled with User ID Automatically
Tuesday, January 18, 2011
[PO] Exchange Rate for A New Line
[PO] Owner Can Approve
[INV] FRM-40200: Field is protected against update
[PO] Position with Status Blank
[WIP] Main Tables for Work In Process (WIP) Job
WRO.REQUIRED_QUANTITY, WRO.QUANTITY_ISSUED
FROM WIP_REQUIREMENT_OPERATIONS WRO, WIP_DISCRETE_JOBS_V WDJ,
MTL_SYSTEM_ITEMS MSI
WHERE WRO.REQUIRED_QUANTITY-WRO.
AND WRO.ORGANIZATION_ID=1234
AND WRO.ORGANIZATION_ID=WDJ.
AND WRO.ORGANIZATION_ID=MSI.
AND WRO.INVENTORY_ITEM_ID=MSI.
AND WRO.WIP_ENTITY_ID=WDJ.WIP_
AND WDJ.STATUS_TYPE=3 --Released
AND MSI.SEGMENT1='myItem'
[WIP] Before You Start
Wednesday, January 12, 2011
[SYS] Session Timeout Issues
[INV] Pending Transactions
[SYS] Item Cost Table
[INV] Which OU is an Inventory Organization falled Under?
Monday, January 10, 2011
[PO] Item Not Found During Purchase Requisition (PR) Creation
[PO] Backend Field for PR
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);