Wednesday, January 19, 2011
[SYS] Security Rule - Block From Entering, What About Viewing?
You can enter only certain range of Cost Center once you set Security Rule up, but you CAN still view the document (e.g. PR Summary) that was created using a Cost Center that is out of you range in Security Rule.
[PO] Position Hierarchy Used for PR/PO Approval
A PR/PO was submitted for approval, how to check which Position Hierarchy user used? From Apps front end, it is impossible. Check it out from backend tables.
Sample codes:
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"
Standard Purchase Order with 3 lines. I changed line 1 quantity. Header status changed to "Requires Reapproval". In normal scenario, I cannot do anymore Receiving activity as the status is not Approved. If my changes involved price and currency, receiving activity will generate accounting entries with wrong amount. A control is needed.
However, for a particular PO, I am able to perform receiving. The PO with "Requires Reapproval" appeared in the LOV when i tried to perform receiving. I can proceed further to next screen. However, the line i changed (line 1) is not appearing. Only the lines that i did not change appeared and allow me to do receiving. Why?
The reason being the PO is an consigned PO, which has consigned item (doubled check it from Shipment). System allows receiving for the unchanged line because receiving activity for consigned PO will NOT generate any accounting entries, no impacts. Furthermore, transaction price does not refer to PO, but BPA.
[SYS] Login Page Filled with User ID Automatically
For normal scenario, you type in the URL for Oracle Apps instance, click Apps Logon Links, then E-Business Home Page, enter your Username andPassword, you will see the HTML (jsp) menus.
To simplify the steps, you first login to HTML menus, click logout, copy the URL from the Address field in your browser. That is the address you use to access the login page, with your Username defaulted.
Tuesday, January 18, 2011
[PO] Exchange Rate for A New Line
I have a PO create months back, exchange rate was captured at the header level. If i add a new po line now, previous captured rate will be applied to the line, shipment and distribution, not today's rate.
Double check the exchange rate on Distributions line, under "More" tab.
[PO] Owner Can Approve
Whether a preparer can approve the document, e.g. PR/PO depends on setup in Setup -> Purchasing -> Document Types, if "Owner Can Approve" flag is check, preparer can approve by himself. Means, preparer just need to click "Approve... " and "OK" button, the document will be approved (assume approval limit is satisfied).
However, if preparer wants to use hierarchy other than default hierarchy, he/she needs to specified the "Forward To" person to himself. PO will be first changed to " Pre-Approved" status before it get approved eventually.
[INV] FRM-40200: Field is protected against update
Tried to query consigned transactions in "Find Material Transactions" form. Choose "Consumption Advice " with value "Error", above error encountered.
"Consumption Advice" field is not selectable, unless Transaction Types field has values " Transfer to Consigned" or "Transfer to Regular".
[PO] Position with Status Blank
Create a new position, leave the Status field blank, save. Oracle considers it as Valid or Invalid. Ans: Valid
[WIP] Main Tables for Work In Process (WIP) Job
WIP_DISCRETE_JOBS_V - work order main info
WIP_REQUIREMENT_OPERATIONS - material and resource requirements
Sample codes:
SELECT MSI.SEGMENT1 AS "PART NO", WDJ.WIP_ENTITY_NAME, WRO.WIP_ENTITY_ID, WRO.OPERATION_SEQ_NUM,
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.QUANTITY_ISSUED>0
AND WRO.ORGANIZATION_ID=1234
AND WRO.ORGANIZATION_ID=WDJ.ORGANIZATION_ID
AND WRO.ORGANIZATION_ID=MSI.ORGANIZATION_ID
AND WRO.INVENTORY_ITEM_ID=MSI.INVENTORY_ITEM_ID
AND WRO.WIP_ENTITY_ID=WDJ.WIP_ENTITY_ID
AND WDJ.STATUS_TYPE=3 --Released
AND MSI.SEGMENT1='myItem'
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
To get started with WIP module, you must first setup the WIP parameters (Setup -> Parameters) and setup at least 1 WIP Accounting Class (Setup -> WIP Accounting Classes).
Subscribe to:
Posts (Atom)