Oracle Work In Process (WIP)

Oracle Work in Process is a complete production management system.

On a balance sheet, work in progress is considered to be an asset because money has been spent towards a completed product. Because the product has not been completed, however, WIP is valued lower. 

Tables:

WIP_DISCRETE_JOBS_V - work order main info

WIP_REQUIREMENT_OPERATIONS - material and resource requirements

SELECT * FROM apps.WIP_DISCRETE_JOBS_V 
WHERE WIP_ENTITY_NAME = '277409'; -- Work Order / Job

SELECT * FROM apps.WIP_REQUIREMENT_OPERATIONS WHERE WIP_ENTITY_ID = 288002;

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

Issue #1 - Item / Component does not show up in the WIP Component Issue screen / LOV
Solution - One of the prerequisites for this is that the item should’ve the ‘BOM Allowed’ flag enabled.

SEPA

The Single Euro Payments Area (SEPA) is a self-regulatory initiative for the European banking industry championed by the European Commission (EC) and the European Central Bank (ECB). SEPA promises to simplify and harmonize the processes related to cross-border payments in the European community, making it easier for citizens to complete financial transactions with less cost and inefficiencies. 

The aim of the SEPA initiative is to improve the efficiency of cross border payments and the economies of scale by developing common standards, procedures, and infrastructure. The SEPA territory currently consists of 33 European countries -- the 28 EU states, together with Iceland, Liechtenstein, Monaco, Norway and Switzerland.

Part of that infrastructure includes two new SEPA instruments that were introduced in 2008:

• SEPA Credit Transfer (SCT) - a Payables transaction in Oracle EBS
• SEPA Core Direct Debit (SDD) - a Receivables transaction in Oracle EBS

The SEPA Cards Framework (SCF) allows competing banks to create new SCF-compliant debit and credit card 

offerings, within the guidelines laid out by the SEPA authorities. 

Within the Oracle E-Business Suite of applications, Oracle Payables (AP), Oracle Receivables (AR), and Oracle Payments (IBY) provide SEPA transaction capabilities.