Friday, December 31, 2010
[PO] APP-PO-14566: Category is invalid, or category is invalid for the item
[SYS] Personalize
[PO] Can I Cancel a "In Process" Purchase Requisition (PR)?
[PO] Contract Purchase Agreement (CPA) - Controls at Amount Agreed
[PO] PR that Uses Currency Other Than Functional Currency
[SYS] SQL for Internal Requisition (IR)
pla.line_num,pda.distribution_
pla.quantity_delivered qty_rcvd, nvl(pla.quantity,0)-nvl(pla.
nvl(pla.closed_code,'OPEN') closed_code
from po.po_requisition_headers_all pha, po.po_requisition_lines_all pla, po.po_req_distributions_all pda, apps.mrp_project_v mpv, apps.mtl_system_items msi, gl.gl_code_combinations gl
where pha.type_lookup_code='
and pha.authorization_status='
and pla.destination_organization_
and pla.source_organization_id=103 --source organization, party that supply the item
and pha.requisition_header_id=pla.
and pla.requisition_line_id=pda.
and pda.code_combination_id=gl.
and pla.item_id=msi.inventory_
and pla.destination_organization_
and pda.project_id = mpv.project_id (+) --if project is used
order by req_type,doc_no,line_num,dist_
[PO] Purchase Requisition (PR) - Owner Can Approver
[PO] Cancel Requisition When Cancel PO
[PO] Organization Field at PR Form was Disabled
Thursday, December 30, 2010
[PO] Receving for a Future Date
[PO] Advance Shipment Notice (ASN) - Completed Error
AND asn_type='ASN';
Result: 1 record returned
[INV] Negative Quantity for Inventory? Is it Allowed?
In order to pick release and drive inventory negative, the ct must make their items non-reservable. For reservable items, the order gets backordered when not enough quantity is on hand. For non-reservable items, the orders get updated to status of Staged, and the user enters the source subinventory, revision, lot, and locator in the Shipping Transactions form. Ship confirm allows users to drive inventory negative when the Allow Negative Stock checkbox is checked.
[MRP] Suggested Dock Date for Purchase Order in MRP
[SYS] PO_APPROVALLIST_S1
[PO] Rename Hierarchy, What Will be Affected?
[PO] A Faster Way to Check Approval Assignment
[PO] Disable a Category
[PO] Change a Category Name
Wednesday, December 29, 2010
[PO] No Notification
[INV] Item Attributes: LIST_PRICE_PER_UNIT
[PO] View Action History
[SYS] Personalize HTML page (JSP)
[SYS] To Turn On / Off the Forward-to Person LOV in PR Notification Screen (Using Personalization)
[PO] Segment Validation in Account Range
33-00-000-00-811111-000-00000 to 40-99-999-99-899999-999-99999 $10,000
[INV] Item Attribute: EXPENSE_ACCOUNT
[SYS] Column View Get Reset After Each Scroll Down
[PO] Consumption Advice Order Date
[PO] Delete a Saved Purchase Requisition Line
[PO] PR Status Not Changed After Submitted for Approval
User submitted PR for approval, status did not change to "In Process". Approval limit is OK. Workflow Background Process is running as per normal. I checked and restarted the "PO Document Approval Manager", the PR status still no change after submit.
What could be the problem and what else to check?
[SYS] Effective Date for Responsibilities in Users Form
[PO] APP-PO-14180: The forward-to person is not an on-line user
Tuesday, December 28, 2010
[ALRT] [ALERT MGR] 2 Types of Alert
[ALRT] Event Alert
[SYS] View Output
[PO] Profile Option for PO Auto Create
[INV] Item Attributes: PLANNER_MAKE_BUY_CODE
[SYS] Action Required: Document Manager Failed With Error Number 3
The Document Manager failed with error number 3.
Error Number 3 = Unknown Error.
Contact your system administrator.
Error Messages:
POXDMACTION-100: ORA-00054: resource busy and acq
#################
Findings:
The PR was still in "In Process" status and NOT been forwarded to the next approver. This problem might happen intermittently due to Oracle workflow was too busy to process all the requests.
Go Workflow Administrator -> Administrator Workflow -> Status Monitor, search by Item Key and Type Internal Name ("REQAPPRV" in this case). You will find the workflow completed with error. Retry the workflow and it should completed normal this time.