Workflow tables in oracle apps

select * from wf_item_types where name = 'BWFINSER'

select * from wf_item_types_tl where name = 'BWFINSER'

select * from wf_items where item_type = 'BWFINSER'

select * from wf_item_attributes  where item_type = 'BWFINSER'

select * from wf_item_attributes_tl where item_type = 'BWFINSER'

select * from wf_activities where item_type = 'BWFINSER'

select * from wf_activities_tl

select * from wf_activity_attributes

select * from wf_activity_attributes_tl

select * from wf_activity_attr_values

select * from wf_messages

select * from wf_notifications where message_type = 'BWFINSER'

select * from wf_notification_Attributes

select * from wf_messages_tl

select * from wf_message_Attributes

select * from wf_message_Attributes_tl

select * from wf_process_Activities

select * from wf_lookup_types_tl

select * from wf_lookups_tl 

Open & Close Period in R12

General Ledger Periods

1. Navigate to General Ledger Super User->Setup->Open/Close, then the Ledger and click find.


2. Now open the required periods by clicking “Open Periods” button,select the required period as Target Period and click Open button.

Payables Period


1. Navigate to Payables Super User or Payable Manager->Accounting->Control Payables Periods , then open the periods by changing the Period Status and click on Save button.

Purchasing Periods

1. Navigate to Purchasing SuperUser->Setup->Financials->Accounting->Control Purchasing Periods , then enter the Fiscal year and click Go button.

(If it prompts for selecting Operating Unit,select it and click Go button.)


2. Then open the periods by changing the Period Status and click on Save button.

Inventory period

1. Navigate to Inventory SuperUser->Accounting Close Cycle->Inventory Accounting Periods and select the Inventory Org from LOV.


2. Select the period to be opened and click on Change Status button.

Register custom table in oracle application R12

Register Table 
procedure register_table
(p_appl_short_name in varchar2, –Custom Application Short Name
p_table_name in varchar2, –Table Name
p_table_type in varchar2, –Table type,Use ’T’ if it is a transaction table & ’S’ for a ”seed data” table
p_next_extent in number default 512,
p_pct_free in number default 10, –Percentage of space in each of the table’s blocks reserved for future updates to the table (1–99)
p_pct_used in number default 70); –Minimum percentage of used space in each data block of the table (1–99)
–The sum of p_pct_free and p_pct_used must be less than 100

Register Column 
procedure register_column
(p_appl_short_name in varchar2, –Custom Application Short Name
p_table_name in varchar2, –Table Name
p_column_name in varchar2, –Column Name
p_column_seq in number, –Sequence number of Column in table
p_column_type in varchar2, –Column Type (’NUMBER’, ’VARCHAR2’, ’DATE’, etc.).
p_column_width in number, –Colum Size,Can use 9 for DATE columns, 38 for NUMBER columns
p_nullable in varchar2, –Use ’N’ if the column is mandatory or ’Y’ if the column allows null values
p_translate in varchar2, –’N’ if the values are not translated (most application columns)
p_precision in number default null, –Number of digits in a number
p_scale in number default null); –Number of digits to the right of the decimal point in a number

Example

create table XXTEST_TEST_TABLE
(
unique_id number,
NAme varchar2(100),
Creation_Date date,
created_by number
)

API for register table 
Begin
ad_dd.REGISTER_TABLE('XXTEST','XXTEST_TEST_TABLE','T',1,10,0);
End;

Commit;

API for register column

EXECUTE ad_dd.REGISTER_COLUMN('XXTEST','XXTEST_TEST_TABLE','UNIQUE_ID',1,'NUMBER',38,'Y','N');

EXECUTE ad_dd.REGISTER_COLUMN('XXTEST','XXTEST_TEST_TABLE','NAME',2,'VARCHAR2',20,'Y','N')

EXECUTE ad_dd.REGISTER_COLUMN('XXTEST','XXTEST_TEST_TABLE','CREATION_DATE',3,'DATE',20,'Y','N')

EXECUTE ad_dd.REGISTER_COLUMN('XXTEST','XXTEST_TEST_TABLE','CREATED_BY',4,'NUMBER',38,'Y','N')

Commit;

Register Primary key in oracle application

execute ad_dd.register_primary_key('XXTEST', 'UNIQE_ID_PK', 'XXTEST_TEST_TABLE','UNIQE_ID_PK', 'S', 'Y','Y');

Commit;

Register Primary key column in oracle application

execute ad_dd.register_primary_key_column('XXTEST', 'UNIQE_ID_PK','XXTEST_TEST_TABLE', 'UNIQUE_ID', 1);

Commit;

How to check table registered in oracle application

Goto-->

Application Developer--> application-->Database-->Table

Search Table by Table name and detail will be shown

API for De-register table from oracle apps

EXECUTE ad_dd.DELETE_TABLE('BTVL', 'BTVL_TEST_TABLE');

COMMIT;

DROP TABLE BTVL_TEST_TABLE