Oracle Financial Important tables, links, ER Diagram










Comments

Post a Comment

Popular posts from this blog

API Procedure to inactive Items in oracle apps

--API to update the item status. /**** STEP 1) Insert data into pending interface table ****/ insert into mtl_pending_item_status           (inventory_item_id,           organization_id,           status_code,           effective_date,           implemented_date,           pending_flag,           last_update_date,           last_updated_by,           creation_date,           created_by)      values(          6760202,   -- Item Segment           114,   -- Organization Id           'Inactive',  -- status           sysdate,           sysdate,     ...
Read more

Graph Setting in Oracle Report Builder

<rw:graph id="CT_1" src="G_DATE" groups="PDATE" dataValues="CF_WT_AVG_EFFPerG_DATE"> <!-- <?xml version="1.0" ?> <Graph version="3.2.0.22" markerTooltipType="MTT_NONE" markerDisplayed="false" graphType="LINE_VERT_ABS"> <LegendArea visible="false"/> <MarkerText visible="true"> <GraphFont fontColor="#99"/> </MarkerText> <O1TickLabel tickLabelSkipMode="TLS_NOSKIP"/> <PlotArea borderColor="#0" borderTransparent="false"/> <SeriesItems> <Series id="0" color="#0"/> </SeriesItems> <Title text="Efficiency %" visible="true"> <GraphFont size="14" fontColor="#0" underline="true"/> </Title> <Y1Axis scaledLogarithmic="false" logarithmicBase="2.0" axisAut...
Read more